"") { $where .= " and team='".$_REQUEST['s_mtype']."'"; } if($_REQUEST['s_se']>0) { $where .= " and sale_employee_code<=0 "; } if($_REQUEST['s_sale_employee_code']>0) { $where .= " and sale_employee_code='".$_REQUEST['s_sale_employee_code']."'"; } if($_REQUEST['s_status_c']>0) { $where .= " and customer_calling_status='".$_REQUEST['s_status_c']."'"; } if($_REQUEST['s_sms']<>"") { $where .= " and sms='".$_REQUEST['s_sms']."'"; } */ //$where .= " and userid='".$_SESSION['admin_code']."'"; $q = "SELECT c.*,cc.member_code,name,mobile FROM ".TABLE_NAME." c,customer cc WHERE (c.date >='".date("Y-m-d",strtotime($_REQUEST['s_date_from']))."' and c.date<='".date("Y-m-d",strtotime($_REQUEST['s_date_to']))."') $where and cc.code=c.userid ORDER BY c.date "; /* if($_REQUEST['page']>=1) $_SESSION['page'] = $_REQUEST['page']; if($_REQUEST['page']=='undefined') $_SESSION['page'] = 1; //Paging New Script // $p = paging_prepare($q,$_SESSION['page']); $p['task'] = 'CustomersDetails'; $p['div'] = 'main_result_div'; $p['response_file'] = 'response_index'; $q .= " LIMIT ".$p['Page_Start'].",".$p['Per_Page']." "; //end of Pageing */ $qr = mysql_query($q) or die('Error: '.mysql_error()); ?> >

Cust ID	Name	Mobile	Date	Remarks	Credit	Debit	Balance
Prevours Balance Up to
					0 ){ $total += $rows['amt']; $te += $rows['amt']; echo number_format($rows['amt'],2);}else echo '--'; ?>
Total :

Pagination Finish } break; case 'add_edit': { $i =3; $key = array_keys($_REQUEST); $n = count($_REQUEST); while($i<=($n)) { $s = $s."&".$key[$i]."=".$_REQUEST[$key[$i]].""; $i++; } require_once("index.class.php"); $objpl=new General(); $objpl->add_edit(fetch_details(TABLE_NAME,'code',$_REQUEST['id']),$_REQUEST); } break; case 'save_key': { $data=$_POST; /*echo '

';
			print_r($data);echo '

'; */ if(!check_duplicate(TABLE_NAME,'mobile',trim($data['mobile']),$data['id'],'code',"")) { echo '1|0|Error : Duplicate Mobile Number!!'; return; } $n = count($data); $i = 1; $key = array_keys($data); $j=1; while($i<=($n)) { if($key[$i]<>"id" AND $key[$i]<>"photoimg" AND $key[$i]<>"id" AND $key[$i]<>"upload_pic" AND $key[$i]<>"task2" AND $key[$i]<>"task_n" AND $key[$i]<>"task" AND $key[$i]<>"picture" AND $key[$i]<>"status" AND $key[$i]<>"" AND $key[$i]<>"code" AND $key[$i]<>"group_specification" AND $key[$i]<>"menu_category" AND substr($key[$i],0,5)<>"cat__" AND substr($key[$i],0,4)<>"mce_") { if($j==1) { $s = " SET $key[$i] = '".trim($data[$key[$i]])."' "; $j=2; } else $s = $s.",$key[$i] = '".mysql_real_escape_string(trim($data[$key[$i]]))."' "; } $i++; } $s = $s.",admin_id = '".$_SESSION['admin_code']."' "; if($data['task2']=="Add") { // $s = $s.",sort_id = '".(find_sort_id_max_gn("customers")+10)."' "; $s = "INSERT INTO ".TABLE_NAME." ".$s; } else { $s = "UPDATE TABLE_NAME ".$s; $s = $s." WHERE code='".$data['id']."'"; } echo $s; if(mysql_query($s)) { $id= mysql_insert_id(); if($data['id']>0) $id = $data['id']; if($data['picture']<>"") { $sql = "Select * from raw_pictures where code = '".$data['picture']."'"; $res = mysql_query($sql); $rows = mysql_fetch_assoc($res); $pic = $rows['image']; $iid = $rows['code']; copy('../ajaximage/uploads/'.$pic,'../../../ref_doc/'.$pic); unlink('../ajaximage/uploads/'.$pic); $sql33 = " Update ".TABLE_NAME." SET ref_doc='".$pic."' where code = '".$id."' "; mysql_query($sql33); //echo $sql33; $sql = "Delete FROM raw_pictures where code = '".$iid."' or date <= '".date("Y-m-d",strtotime("-2 Days"))."'"; mysql_query($sql); $new_col[] = 'ref_doc'; $new_val[] = $pic; } if($data['task2']=="Add") echo '1|1|Record Inserted successfully!!'; else echo '1|1|Record Updated successfully!!'; } else echo '1|0|Error : in Updation!!'; } break; case 'delete_row': { //print_r($_REQUEST); if($_REQUEST['id']>0) { if(check_menu_permissions($_SESSION['task_check'],'o_delete')>0 and $_REQUEST['id']>0) { $sql = "update ".TABLE_NAME." SET last_status='4' WHERE code='".$_REQUEST['id']."'"; if(mysql_query($sql)) { $col_i = "user_code"; ; $val_i = "'".$_SESSION['admin_code']."'"; $id = $_REQUEST['id']; $sql = "Select * from ".TABLE_NAME." where code='".$id."'"; $res = mysql_query($sql); $i==0; $rows = mysql_fetch_assoc($res); while ($i < mysql_num_fields($res)) { $fieldName = mysql_field_name($res, $i); //$type_f = pg_field_type($res, $i); if($fieldName<>"date" or $fieldName<>"last_status" or trim($rows[$fieldName])<>"") { if(strlen($rows[$fieldName])>0) { $col_i .= ",".$fieldName.""; $val_i .= ",'".$rows[$fieldName]."'"; } } $i++; } $col_i .= ",action"; ; $val_i .= ",'".display_feild('master_status','status_name','code',4)."'"; /*$new_col[] = 'code'; $new_val[] = $id;*/ $s = "INSERT INTO general_log (".$col_i.") values(".$val_i.")"; mysql_query($s); echo 'Sent for Approval!!'; return true; } else { echo 'Error : in Updation!!'; return true; } } } echo 'Error : Can\'t Delete record!!'; } break; }; } ?>