File: /home/cafsindia/refimac_cafsjobs_com/add_details.php
<?php
// Turn off all error reporting
error_reporting(0);
include('dbconnect.php');
include('sms.php');
//session_start();
$user=$_SESSION['clid'];
$perm=$_SESSION['cper'];
$mid=$_REQUEST['mid'];
$smid=$_REQUEST['smid'];
$pid=$_REQUEST['pid'];
$type=$_REQUEST['type'];
//Call Registartion
if($pid=="2_1_1")
{
// add or update your customer
if($type=="1")
{
$sqlcust_check=mysql_query("select CUSTOMER_CODE from customer where CUSTOMER_CODE='".$_POST['CUSTOMER_CODE']."'");
if(mysql_num_rows($sqlcust_check)==0)
{
$qu2=mysql_query("select CUSTOMER_CODE as custcode from customer order by CUSTOMER_CODE desc limit 0,1");
$rrows=mysql_fetch_assoc($qu2);
$custcode_str=$rrows['custcode'];
//$str = '::f:o:';
$str = ltrim($custcode_str, 'C');
$n2 = ltrim($str, '0');
//$n2
//echo $n2;
$n2++;
if($n2>0&&$n2<=9) $cust_code="C00000".$n2;
elseif($n2>9&&$n2<=99) $cust_code="C0000".$n2;
elseif($n2>99&&$n2<=999) $cust_code="C000".$n2;
elseif($n2>999&&$n2<=9999) $cust_code="C00".$n2;
elseif($n2>9999&&$n2<=99999) $cust_code="C0".$n2;
elseif($n2>99999&&$n2<=999999) $cust_code="C".$n2;
$sqlcustinsertupdate="insert into customer (CUSTOMER_CODE,CUSTOMER_NAME,CUSTOMER_ADDRESS,CUSTOMER_AREA,CUSTOMER_SURROUND_AREA,CUSTOMER_CITY,CUSTOMER_PINCODE,CUSTOMER_PHONE,CUSTOMER_MOBILE,CUSTOMER_CONTACT_PERSON,CUSTOMER_UPDATE,created_by,created_datetime,email,remarks) values ('".$cust_code."','".$_POST['CUSTOMER_NAME']."','".$_POST['CUSTOMER_ADDRESS']."','".$_POST['CUSTOMER_AREA']."','".$_POST['CUSTOMER_SURROUND_AREA']."','".$_POST['CUSTOMER_CITY']."','".$_POST['CUSTOMER_PINCODE']."','".$_POST['CUSTOMER_PHONE']."','".$_POST['CUSTOMER_MOBILE']."','".$_POST['CUSTOMER_CONTACT_PERSON']."','1','$user','".date("Y-m-d H:i:s")."','".$_POST['email']."','".$_POST['remarks']."')";
//echo $sqlcustinsertupdate; die;
}
else
{
$cust_code=$_POST['CUSTOMER_CODE'];
$sqlcustinsertupdate="update customer set CUSTOMER_NAME='".$_POST['CUSTOMER_NAME']."',CUSTOMER_ADDRESS='".$_POST['CUSTOMER_ADDRESS']."',CUSTOMER_AREA='".$_POST['CUSTOMER_AREA']."',CUSTOMER_SURROUND_AREA='".$_POST['CUSTOMER_SURROUND_AREA']."',CUSTOMER_CITY='".$_POST['CUSTOMER_CITY']."',CUSTOMER_PINCODE='".$_POST['CUSTOMER_PINCODE']."',CUSTOMER_PHONE='".$_POST['CUSTOMER_PHONE']."',CUSTOMER_MOBILE='".$_POST['CUSTOMER_MOBILE']."',CUSTOMER_CONTACT_PERSON='".$_POST['CUSTOMER_CONTACT_PERSON']."',email='".$_POST['email']."',remarks='".$_POST['remarks']."' where CUSTOMER_CODE='".$_POST['CUSTOMER_CODE']."'";
//echo $sqlcustinsertupdate;
}
//echo $sqlcustinsertupdate; die;
if(mysql_query($sqlcustinsertupdate)==1)
{
echo "1|".$cust_code;
}
else
{
echo "2|".$cust_code;
}
}
//add or update your compalint number
if($type=="2")
{
$sql_check=mysql_query("select complaint_no from serviceapp_callreg where complaint_no='".$_POST['complaint_no']."'");
if(mysql_num_rows($sql_check)==0)
{
$qu2=mysql_query("select COUNT(*) as total from serviceapp_callreg where complaint_date='".date("Y-m-d")."' ");
$rrows=mysql_fetch_assoc($qu2);
$total=$rrows['total'];
$n1 = $total;
//$n2
//echo $n2;
$n1++;
$sort_name="REF";
$year=date("ymd");
$complaint_no="$sort_name$year";
//echo $complaint_no;
if($n1>=0&&$n1<=9) $complaint_no.="000".$n1;
elseif($n1>9&&$n1<=99) $complaint_no.="00".$n1;
elseif($n1>99&&$n1<=999) $complaint_no.="0".$n1;
elseif($n1>999&&$n1<=9999) $complaint_no.=$n1;
$time_now=time(date('h')+5,date('i')+30,date('s'));
$time=date('h:i:s A',$time_now);
$sqlcompinsertupdate="insert into serviceapp_callreg (cust_code,CUSTOMER_NAME,CUSTOMER_ADDRESS,CUSTOMER_AREA,CUSTOMER_SURROUND_AREA,CUSTOMER_CITY,CUSTOMER_PINCODE,CUSTOMER_PHONE,CUSTOMER_MOBILE,CUSTOMER_CONTACT_PERSON,complaint_no,complaint_date,complaint_time,call_type,brand_name,product,fault_report,location,service_req_datetime,tech_name,remarks,created_by,created_date,status) values ('".$_POST['CUSTOMER_CODE']."','".$_POST['CUSTOMER_NAME']."','".$_POST['CUSTOMER_ADDRESS']."','".$_POST['CUSTOMER_AREA']."','".$_POST['CUSTOMER_SURROUND_AREA']."','".$_POST['CUSTOMER_CITY']."','".$_POST['CUSTOMER_PINCODE']."','".$_POST['CUSTOMER_PHONE']."','".$_POST['CUSTOMER_MOBILE']."','".$_POST['CUSTOMER_CONTACT_PERSON']."','".$complaint_no."','".date('Y-m-d')."','".$time."','".$_POST['call_type']."','".$_POST['brand_name']."','".$_POST['cust_product']."','".$_POST['fault_report']."','".$_POST['location']."','".$_POST['service_req_datetime']."','".$_POST['tech_name']."','".$_POST['comp_remarks']."','$user','".date("Y-m-d H:i:s")."','1')";
//echo $sqlcompinsertupdate; die;
if($perm=="service")
{
sms('REFMAC',$_POST['CUSTOMER_MOBILE'],'Dear Customer, your Service No. '.$complaint_no.' is registered.Your service will be attended in 24 to 48Hrs.');
}
else{
sms('REFMAC',$_POST['CUSTOMER_MOBILE'],'Dear Customer, your Service Call No. '.$complaint_no.' is registered.Your complaint will be attended in 24 to 48Hrs.');
}
$sqltech="SELECT EMP_MOBILE FROM employee WHERE EMP_ID ='".$_POST['tech_name']."'";
//echo $sqltech;
$qutech=mysql_query($sqltech);
$rtech=mysql_fetch_array($qutech);
//echo 'Service Call No.'.$complaint_no.'Address:'.$_POST['CUSTOMER_ADDRESS'].'cell:'.$_POST['CUSTOMER_MOBILE'];
//echo $perm."dd"; die;
if($perm=="service")
{
sms('REFMAC',$rtech['EMP_MOBILE'],'Service No.'.$complaint_no.'Address:'.$_POST['CUSTOMER_NAME'].','.$_POST['CUSTOMER_ADDRESS'].','.$_POST['CUSTOMER_AREA'].'cell:'.$_POST['CUSTOMER_MOBILE']);
}
else{
sms('REFMAC',$rtech['EMP_MOBILE'],'Service Call No.'.$complaint_no.'Address:'.$_POST['CUSTOMER_NAME'].','.$_POST['CUSTOMER_ADDRESS'].','.$_POST['CUSTOMER_AREA'].'cell:'.$_POST['CUSTOMER_MOBILE']);
}
}
else
{
$complaint_no=$_POST['complaint_no'];
$sqlcompinsertupdate="update serviceapp_callreg set CUSTOMER_NAME='".$_POST['CUSTOMER_NAME']."',CUSTOMER_ADDRESS='".$_POST['CUSTOMER_ADDRESS']."',CUSTOMER_AREA='".$_POST['CUSTOMER_AREA']."',CUSTOMER_SURROUND_AREA='".$_POST['CUSTOMER_SURROUND_AREA']."',CUSTOMER_CITY='".$_POST['CUSTOMER_CITY']."',CUSTOMER_PINCODE='".$_POST['CUSTOMER_PINCODE']."',CUSTOMER_PHONE='".$_POST['CUSTOMER_PHONE']."',CUSTOMER_MOBILE='".$_POST['CUSTOMER_MOBILE']."',CUSTOMER_CONTACT_PERSON='".$_POST['CUSTOMER_CONTACT_PERSON']."',call_type='".$_POST['call_type']."',brand_name='".$_POST['brand_name']."',product='".$_POST['cust_product']."',fault_report='".$_POST['fault_report']."',location='".$_POST['location']."',service_req_datetime='".$_POST['service_req_datetime']."',tech_name='".$_POST['tech_name']."',remarks='".$_POST['comp_remarks']."',updated_by='".$user."',updated_date='".date("Y-m-d H:i:s")."' where complaint_no='".$_POST['complaint_no']."'";
//echo $sqlcompinsertupdate; die;
}
// echo $sqlcompinsertupdate; die;
if(mysql_query($sqlcompinsertupdate)==1)
{
$sqlcustinsertupdate="update customer set CUSTOMER_NAME='".$_POST['CUSTOMER_NAME']."',CUSTOMER_ADDRESS='".$_POST['CUSTOMER_ADDRESS']."',CUSTOMER_AREA='".$_POST['CUSTOMER_AREA']."',CUSTOMER_SURROUND_AREA='".$_POST['CUSTOMER_SURROUND_AREA']."',CUSTOMER_CITY='".$_POST['CUSTOMER_CITY']."',CUSTOMER_PINCODE='".$_POST['CUSTOMER_PINCODE']."',CUSTOMER_PHONE='".$_POST['CUSTOMER_PHONE']."',CUSTOMER_MOBILE='".$_POST['CUSTOMER_MOBILE']."',CUSTOMER_CONTACT_PERSON='".$_POST['CUSTOMER_CONTACT_PERSON']."' where CUSTOMER_CODE='".$_POST['CUSTOMER_CODE']."'";
mysql_query($sqlcustinsertupdate);
echo "1|".$complaint_no."|".$_POST['call_type'];
}
else
{
echo "2|".$complaint_no."|".$_POST['call_type'];
}
}
//add or update your machine info.
if($type=="3")
{
//print $_POST['sales_ID']; die;
$sql_check=mysql_query("SELECT SALES_ID,SERVICEMODE_ID,INSTALLATION_DATE FROM sales where sales_ID='".$_POST['sales_ID']."' order by MATURITY_DATE desc limit 0,1");
//echo "SELECT SALES_ID,SERVICEMODE_ID FROM sales where sales_ID='".$_POST['sales_ID']."' order by MATURITY_DATE desc limit 0,1";
//$rows_mac=mysql_num_rows($sql_check);
//echo $rows_mac;
//die;
if($_POST['mac_model_id']=='0' || $_POST['mac_model_id']=='') { $mac_model_id=$_POST['mac_model'];} else { $mac_model_id=$_POST['mac_model_id']; }
$qu_sql_check=mysql_fetch_array($sql_check);
if(mysql_num_rows($sql_check)==0)
{
$sqlmacinsertupdate="INSERT INTO sales(CUSTOMER_CODE, MODEL_ID, SERVICEMODE_ID, LOCATION, COMPRESSORNO, INSTALLATION_DATE, MATURITY_DATE, INVOICE_DATE, AMOUNT, REMARKS, INVOICE_NO, NO_OF_SERVICES, CAPACITY, WARRENTY, MAKE_ID, PURCHASE_ID, COMPLETED,comp_wrty,amc_report) VALUES ('".$_POST['custcode']."','".$mac_model_id."','".$_POST['mac_service_mode']."','".$_POST['mac_location']."','".$_POST['mac_compressor_sno']."','".date("Y-m-d", strtotime($_POST['mac_installdate']))."','".date("Y-m-d", strtotime($_POST['mac_maturitydate']))."','".date("Y-m-d", strtotime($_POST['mac_invoice_date']))."','".$_POST['mac_amount']."','".$_POST['mac_remarks']."','".$_POST['mac_invoice_no']."','".$_POST['mac_service_year']."','".$_POST['mac_capacity']."','".$_POST['mac_wrty']."','".$_POST['mac_brand_name']."','".$_POST['PURCHASE_ID']."','0','".$_POST['comp_wrty']."','".$_POST['amcfilepath']."')";
//echo $sqlmacinsertupdate; die;
if(mysql_query($sqlmacinsertupdate)==1)
{
$sales_id=mysql_insert_id();
$totaldays=365*$_POST['mac_wrty'];
$service_count=$_POST['mac_service_year']*$_POST['mac_wrty'];
$seperate_days=$totaldays/$service_count;
$service_date="";
$month="";
$year="";
for($i=1;$i<=$service_count;$i++)
{
$seperate_days1=$seperate_days*$i;
$service_date = date('Y-m-d', strtotime(date("Y-m-d", strtotime($_POST['mac_installdate'])). ' + '.round($seperate_days1,0).' days'));
$service_date_array=explode('-',$service_date);
$month = $service_date_array[1];
$year = $service_date_array[0];
$sqlserviceinsertupdate="insert into service (SALES_ID,EMPLOYEE_ID,MONTH,YEAR,LIST_INDEX,COMPLETED,servicedate) values('".$sales_id."','0','".$month."','".$year."','".$i."','0','".$service_date."')";
mysql_query($sqlserviceinsertupdate);
//echo $sqlserviceinsertupdate; die;
$service_date="";
$month="";
$year="";
}
$sql_purchase="update purchase set PURCHASE_DISPLAY='1' where PURCHASE_ID='".$_POST['PURCHASE_ID']."'";
mysql_query($sql_purchase);
echo "1|".$sales_id;
}
}
else
{
if($_POST['mac_model']!="")
{
$mac_model_id=$_POST['mac_model'];
}
else
{
$mac_model_id=$_POST['mac_model_id'];
}
$sqlmacinsertupdate1 ="Update sales set CUSTOMER_CODE='".$_POST['custcode']."',MODEL_ID='".$mac_model_id."',SERVICEMODE_ID='".$_POST['mac_service_mode']."',LOCATION='".$_POST['mac_location']."',COMPRESSORNO='".$_POST['mac_compressor_sno']."',INSTALLATION_DATE='".date("Y-m-d", strtotime($_POST['mac_installdate']))."',MATURITY_DATE='".date("Y-m-d", strtotime($_POST['mac_maturitydate']))."',INVOICE_DATE='".date("Y-m-d", strtotime($_POST['mac_invoice_date']))."',AMOUNT='".$_POST['mac_amount']."',REMARKS='".$_POST['mac_remarks']."',INVOICE_NO='".$_POST['mac_invoice_no']."',NO_OF_SERVICES='".$_POST['mac_service_year']."',CAPACITY='".$_POST['mac_capacity']."',WARRENTY='".$_POST['mac_wrty']."',MAKE_ID='".$_POST['mac_brand_name']."',PURCHASE_ID='".$_POST['PURCHASE_ID']."',comp_wrty='".$_POST['comp_wrty']."',amc_report='".$_POST['servicefilepath']."' where sales_ID='".$_POST['sales_ID']."'";
//echo $sqlmacinsertupdate1; die;
//echo "df".$qu_sql_check['SERVICEMODE_ID']; die;
if(mysql_query($sqlmacinsertupdate1)==1)
{
if(date("Y-m-d", strtotime($_POST['mac_installdate']))!= $qu_sql_check['INSTALLATION_DATE'])
{
$sales_id=$_POST['sales_ID'];
$totaldays=365*$_POST['mac_wrty'];
$service_count=$_POST['mac_service_year']*$_POST['mac_wrty'];
$seperate_days=$totaldays/$service_count;
$service_date="";
$month="";
$year="";
for($i=1;$i<=$service_count;$i++)
{
$seperate_days1=$seperate_days*$i;
$service_date = date('Y-m-d', strtotime(date("Y-m-d", strtotime($_POST['mac_installdate'])). ' + '.round($seperate_days1,0).' days'));
$service_date_array=explode('-',$service_date);
$month = $service_date_array[1];
$year = $service_date_array[0];
$sqlserviceinsertupdate="insert into service (SALES_ID,EMPLOYEE_ID,MONTH,YEAR,LIST_INDEX,COMPLETED,servicedate) values('".$sales_id."','0','".$month."','".$year."','".$i."','0','".$service_date."')";
// echo $sqlserviceinsertupdate;
mysql_query($sqlserviceinsertupdate);
//echo $sqlserviceinsertupdate;
//$service_date="";
$month="";
$year="";
}
}
echo "1|".$sales_id;
}
}
}
if($type=="4")
{
$sql="update service set servicefileupload='".$_POST['servicefilepath']."',SERIALNO='".$_POST['mac_serial_no']."',EMPLOYEE_ID='".$_POST['tech_name']."',SLIPNO='".$_POST['slip_no']."',COMMENTS='".$_POST['COMMENTS']."',DATE='".date('Y-m-d',strtotime($_POST['dateofcompletion']))."',COMPLETED='Y' where SALES_ID='".$_POST['txtservicesalesid']."' and YEAR='".$_POST['txtservicedate']."' and MONTH='".$_POST['txtservicemonth']."'";
//echo $sql;
if(mysql_query($sql)==1)
{
$sqlm="select customer_mobile from customer inner join sales on customer.CUSTOMER_CODE=sales.CUSTOMER_CODE where sales.SALES_ID='".$_POST['txtservicesalesid']."'";
$quc=mysql_query($sqlm);
$rc=mysql_fetch_array($quc);
sms('REFMAC',$rc['customer_mobile'],'Dear Customer, our team completed your routine service on'.date('Y-m-d',strtotime($_POST['dateofcompletion'])).' , If any quries, pls call 044-24542626');
echo "1|".$cust_code;
}
else
{
echo "2|".$cust_code;
}
}
if($type=="5")
{
$sales_id=$_REQUEST['servicevaluedate'];
$service_date = date('Y-m-d',strtotime($_REQUEST['mac_addservicedate']));
$service_date_array=explode('-',$service_date);
$month = $service_date_array[1];
$year = $service_date_array[0];
$sql="insert into service (SALES_ID,EMPLOYEE_ID,MONTH,YEAR,LIST_INDEX,COMPLETED,servicedate,status) values('".$sales_id."','0','".$month."','".$year."','0','N','".$service_date."','0')";
// echo $sql; die;
if(mysql_query($sql)==1)
{
echo "1|".$sales_id;
}
else
{
echo "2|".$sales_id;
}
}
if($type=="6")
{
$sales_id=$_REQUEST['salesid'];
$custcode=$_REQUEST['custcode'];
$sql="update service set status='2',deleted_by='$user',deleted_date='".date("Y-m-d H:i:s")."' where SALES_ID='".$sales_id."' and MONTH='".$_REQUEST['month']."' and YEAR='".$_REQUEST['year']."' ";
//echo $sql; die;
if(mysql_query($sql)==1)
{
echo "1|".$sales_id."|".$custcode;
}
else
{
echo "2|".$sales_id."|".$custcode;
}
}
if($type=="7")
{
$sales_id=$_REQUEST['salesid'];
$custcode=$_REQUEST['custcode'];
$sql_s="select status from sales where SALES_ID='".$sales_id."' ";
$qu_s=mysql_query($sql_s);
$r_s=mysql_fetch_array($qu_s);
if($r_s["status"]==0)
{
$sql="update sales set status='2',deleted_by='$user',deleted_date='".date("Y-m-d H:i:s")."' where SALES_ID='".$sales_id."'";
}
else
{
$sql="update sales set status='0',deleted_by='$user',deleted_date='".date("Y-m-d H:i:s")."' where SALES_ID='".$sales_id."'";
}
//echo $sql; die;
if(mysql_query($sql)==1)
{
$qu_select=mysql_query("select PURCHASE_ID from sales where SALES_ID='".$sales_id."'");
$r=mysql_fetch_array($qu_select);
if($r_s["status"]==0)
{
mysql_query("update purchase set PURCHASE_DISPLAY='0' where PURCHASE_ID='".$r['PURCHASE_ID']."'");
}
else
{
mysql_query("update purchase set PURCHASE_DISPLAY='1' where PURCHASE_ID='".$r['PURCHASE_ID']."'");
}
echo "1|".$sales_id."|".$custcode;
}
else
{
echo "2|".$sales_id."|".$custcode;
}
}
}
//Call Completion
elseif($pid=="2_1_3")
{
if($type=="1")
{
//print_r($_POST); die;
$sqlcust_check=mysql_query("select comp_id from serviceapp_callcomp where reg_id='".$_POST['reg_id']."'");
if(mysql_num_rows($sqlcust_check)==0)
{
$sqlcompinsertupdate="insert into serviceapp_callcomp (reg_id,call_type,mac_id,acc_frm_dealer,acc_frm_cust,acc_frm_refimac,acc_frm_techtaken,acc_frm_grandtotal,spar_coper_pipe,spare_stand,spare_gas,call_status,pending_reason,visit_date_time,completion_date_time,service_report_upload,invoice_upload,complaint_remarks,created_by,created_datetime,status) values ('".$_POST['reg_id']."','".$_POST['call_type']."','".$_POST['selectsaleid']."','".$_POST['amtfromdealer']."','".$_POST['amtfromcustomer']."','".$_POST['amtfromrefmimac']."','".$_POST['amttakentech']."','".$_POST['grandtotal']."','".$_POST['spar_coper_pipe']."','".$_POST['spare_stand']."','".$_POST['spare_gas']."','".$_POST['call_status']."','".$_POST['pending_reason']."','".$_POST['visit_date_time']."','".$_POST['completion_date_time']."','".$_POST['hid_service_upload']."','".$_POST['hid_dealer_upload']."','".$_POST['complaint_remarks']."','$user','".date("Y-m-d H:i:s")."','Y')";
//echo $sqlcustinsertupdate; die;
$reg_id=$_POST['reg_id'];
$callupdatestatus="";
if($_POST['call_status']=="completed")
$callupdatestatus="2";
if($_POST['call_status']=="pending")
$callupdatestatus="3";
if($_POST['call_status']=="canceled")
$callupdatestatus="4";
//echo $sqlcustinsertupdate;
$reg_id=$_POST['reg_id'];
}
else
{
//$cust_code=$_POST['CUSTOMER_CODE'];
$sqlcompinsertupdate="update serviceapp_callcomp set call_type='".$_POST['call_type']."',mac_id='".$_POST['selectsaleid']."',acc_frm_dealer='".$_POST['amtfromdealer']."',acc_frm_cust='".$_POST['amtfromcustomer']."',acc_frm_refimac='".$_POST['amtfromrefmimac']."',acc_frm_techtaken='".$_POST['amttakentech']."',acc_frm_grandtotal='".$_POST['grandtotal']."',spar_coper_pipe='".$_POST['spar_coper_pipe']."',spare_stand='".$_POST['spare_stand']."',spare_gas='".$_POST['spare_gas']."',call_status='".$_POST['call_status']."',pending_reason='".$_POST['pending_reason']."',visit_date_time='".$_POST['visit_date_time']."',completion_date_time='".$_POST['completion_date_time']."',service_report_upload='".$_POST['hid_service_upload']."',invoice_upload='".$_POST['hid_dealer_upload']."',complaint_remarks='".$_POST['complaint_remarks']."' where reg_id='".$_POST['reg_id']."' and comp_id='".$_POST['comp_id']."'";
$callupdatestatus="";
if($_POST['call_status']=="completed")
$callupdatestatus="2";
if($_POST['call_status']=="pending")
$callupdatestatus="3";
if($_POST['call_status']=="canceled")
$callupdatestatus="4";
//echo $sqlcustinsertupdate;
$reg_id=$_POST['reg_id'];
mysql_query("update serviceapp_callreg set status='".$callupdatestatus."' where reg_id='".$_POST['reg_id']."'");
}
//echo $sqlcompinsertupdate; die;
if(mysql_query($sqlcompinsertupdate)==1)
{
mysql_query("update serviceapp_callreg set status='".$callupdatestatus."' where reg_id='".$reg_id."'");
//sms('REFMAC',$_POST['CUSTOMER_MOBILE'],'Dear Customer, your Service Call No. '.$complaint_no.' is registered.Your complaint will be attended in 24 to 48Hrs.');
$sql_mob="select CUSTOMER_MOBILE from customer WHERE `CUSTOMER_code` = '".$_POST['custcode']."'";
$qu_mob=mysql_query($sql_mob);
$r_mob=mysql_fetch_array($qu_mob);
// echo $r_mob['CUSTOMER_MOBILE']; die;
if($perm=="service" && $callupdatestatus=="2")
{
sms('REFMAC',$r_mob['CUSTOMER_MOBILE'],'Your Service No. '.$_POST['searchtext'].' is completed. If not satisfied, pls call 044-24542626');
}
if( $callupdatestatus=="3")
{
sms('REFMAC',$r_mob['CUSTOMER_MOBILE'],'Your Service Call No. '.$_POST['searchtext'].' is completed. If not satisfied, pls call 044-24542626');
}
echo "1|".$reg_id;
}
else
{
echo "2|".$reg_id;
}
}
}
// amc log update
elseif($pid=="2_3_1")
{
if($type=="1")
{
$create_date=date('Y-m-d');
$amc_date=$_POST['amc_date'];
$amc_ids=$_POST['amc_ids'];
$amc_status=$_POST['amc_status'];
$amc_comments=$_POST['amc_comments'];
//echo "select amc_ids serviceapp_amclog where amc_ids='".$amc_ids."' and created_date='".$amc_date."'"; die;
$sql_check=mysql_query("select amc_ids from serviceapp_amclog where amc_ids='".$amc_ids."' and amc_date like '%".$amc_date."%' created_date='".$create_date."'");
$row=mysql_num_rows($sql_check);
if($row==0)
{
$sql="insert into serviceapp_amclog (amc_date,amc_ids,amc_status,amc_comments,created_by,created_date) values('".$amc_date."','".$amc_ids."','".$amc_status."','".$amc_comments."','$user','".date("Y-m-d H:i:s")."')";
}
else
{
$sql="update serviceapp_amclog set amc_status='".$amc_status."',amc_comments='".$amc_comments."' where amc_ids='".$amc_ids."' and created_date='".$create_date."'";
}
if(mysql_query($sql)==1)
{
echo "1|".$amc_ids;
}
else
{
echo "2|".$amc_ids;
}
}
}
//Page Master
elseif($pid=="6_1_5")
{
$menu=$_POST['menu'];
$menu1=$_POST['menu1'];
$submenu=$_POST['submenu'];
$submenu1=$_POST['submenu1'];
$page_name=$_POST['page_name'];
$but_add=$_POST['but_add'];
$but_upd=$_POST['but_upd'];
$but_del=$_POST['but_del'];
$but_view=$_POST['but_view'];
$but_admin=$_POST['but_admin'];
$refer=$_POST['refer'];
$ap_id=$_POST['ap_id'];
$remarks=$_POST['remarks'];
$open_date=date("Y-m-d",strtotime($_POST['open_date']));
if($menu=="Other") $menu_name=$menu1;else $menu_name=$menu;
if($submenu=="Other") $submenu_name=$submenu1;else $submenu_name=$submenu;
$ava_trans=$but_add."|".$but_upd."|".$but_del."|".$but_view."|".$but_admin;
$time_now=time(date('h')+5,date('i')+30,date('s'));
$time=date('h:i:s A',$time_now);
$from1=date("d-M-Y");
$update_time=$from1.", ".$time;
$sql="insert into serviceapp_pages (menu_name, submenu_name, page_name, ava_trans, refer_name, ap_id, remarks, update_by, update_date, status) values ('".$menu_name."','".$submenu_name."','".$page_name."','".$ava_trans."','".$refer."','".$ap_id."','".$remarks."','".$user."','".date("Y-m-d")."','Y')";
//echo $sql;
if(mysql_query($sql)==1)
{
header("Location:landing.php?mid=$mid&smid=$smid&pid=$pid&nav=1");
}
else
{
//echo mysql_error();
header("Location:landing.php?mid=$mid&smid=$smid&pid=$pid&nav=2");
}
}
//User Creation
elseif($pid=="6_1_2")
{
$user_name=$_POST['user_name'];
$password=$_POST['password'];
$permission=$_POST['permission'];
$img_auth=$_POST['img_auth'];
//$permission1=$_POST['permission1'];
if($_POST['permission']=="Others") $perm=$_POST['permission1']; else $perm=$_POST['permission'];
$pids=$_POST['pids'];
$pid1="";
$trans="";
foreach($pids as $key=>$value)
{
//Collect the Page Ids
if($pid1!="") $pid1=$pid1.",".$value; else $pid1=$value;
//Collect the Page Transactions
$con1="opt".$value;
$t1=$_POST[$con1];
if(count($t1)>0)
{
foreach($t1 as $key1=>$value1)
{
if($trans!="") $trans=$trans.",".$value1; else $trans=$value1;
}
}
$con2="opt".$value."1";
$t2=$_POST[$con2];
if(count($t2)>0)
{
foreach($t2 as $key1=>$value1)
{
if($trans!="") $trans=$trans.",".$value1; else $trans=$value1;
}
}
}
//echo $pid1;
$time_now=time(date('h')+5,date('i')+30,date('s'));
$time=date('h:i:s A',$time_now);
$from1=date("d-M-Y");
$update_time=$from1.", ".$time;
$sql="insert into serviceapp_login (user_name, password, mid, sid, pid, trans, status, per, hidden, update_user, update_date, update_time) values ('".$user_name."','".$password."','".$mids."','".$sids."','".$pid1."','".$trans."','Allowed','".$perm."','N','".$user."','".date("Y-m-d")."','".$update_time."')";
//echo $sql; die;
if(mysql_query($sql)==1)
{
header("Location:landing.php?mid=$mid&smid=$smid&pid=$pid&nav=1");
}
else
{
//echo mysql_error();
header("Location:landing.php?mid=$mid&smid=$smid&pid=$pid&nav=2");
}
}
//Access Level Creation
elseif($pid=="6_1_1")
{
$per1=$_POST['permission'];
$pids=$_POST['pids'];
$pid1="";
$trans="";
foreach($pids as $key=>$value)
{
//Collect the Page Ids
if($pid1!="") $pid1=$pid1.",".$value; else $pid1=$value;
//Collect the Page Transactions
$con1="opt".$value;
$t1=$_POST[$con1];
if(count($t1)>0)
{
foreach($t1 as $key1=>$value1)
{
if($trans!="") $trans=$trans.",".$value1; else $trans=$value1;
}
}
$con2="opt".$value."1";
$t2=$_POST[$con2];
if(count($t2)>0)
{
foreach($t2 as $key1=>$value1)
{
if($trans!="") $trans=$trans.",".$value1; else $trans=$value1;
}
}
}
//echo $pid1;
$time_now=time(date('h')+5,date('i')+30,date('s'));
$time=date('h:i:s A',$time_now);
$from1=date("d-M-Y");
$update_time=$from1.", ".$time;
$sql="insert into serviceapp_levels (level_name, pid, trans, update_by, update_time, status) values ('".$per1."','".$pid1."','".$trans."','".$user."','".$update_time."','Y')";
//echo $sql;
if(mysql_query($sql)==1)
{
header("Location:landing.php?mid=$mid&smid=$smid&pid=$pid&nav=1");
}
else
{
//echo mysql_error();
header("Location:landing.php?mid=$mid&smid=$smid&pid=$pid&nav=2");
}
}
//Employee Master
elseif($pid=="7_1_1")
{
//echo "hai"; die;
$emp_code=$_POST['EMP_CODE'];
$EMP_NAME=$_POST['EMP_NAME'];
$EMP_MOBILE=$_POST['EMP_MOBILE'];
$EMP_DOJ=date("Y-m-d", strtotime($_POST['EMP_DOJ']));
//echo "select EMP_CODE from employee where EMP_CODE='".$emp_code."'"; die;
$sql_check=mysql_query("select EMP_CODE from employee where EMP_CODE='".$emp_code."'");
if(mysql_num_rows($sql_check)==0)
{
$qu2=mysql_query("select COUNT(*) as total from employee ");
$rrows=mysql_fetch_assoc($qu2);
$total=$rrows['total'];
$n1 = $total;
//$n2
//echo $n2;
$n1++;
$sort_name="E";
$emp_code="$sort_name";
//echo $complaint_no;
//E000001
if($n1>=0&&$n1<=9) $emp_code.="00000".$n1;
elseif($n1>9&&$n1<=99) $emp_code.="0000".$n1;
elseif($n1>99&&$n1<=999) $emp_code.="000".$n1;
elseif($n1>999&&$n1<=9999) $emp_code.="00".$n1;
elseif($n1>9999&&$n1<=99999) $emp_code.="0".$n1;
elseif($n1>99999&&$n1<=999999) $emp_code.=$n1;
$time_now=time(date('h')+5,date('i')+30,date('s'));
$time=date('h:i:s A',$time_now);
$sql="insert into employee (EMP_CODE,EMP_NAME,EMP_MOBILE,EMP_DOJ,EMP_UPDATE,created_by,created_date) values ('".$emp_code."','".$EMP_NAME."','".$EMP_MOBILE."','".$EMP_DOJ."','1','".$user."','".date("Y-m-d H:i:s")."')";
//echo $sql; die;
}
else
{
$sql="update employee set EMP_NAME='".$EMP_NAME."',EMP_MOBILE='".$EMP_MOBILE."',EMP_DOJ='".$EMP_DOJ."',updated_by='".$user."',updated_date='".date("Y-m-d H:i:s")."' where EMP_CODE='".$emp_code."'";
}
//echo $sql; die;
if(mysql_query($sql)==1)
{
header("Location:landing.php?mid=$mid&smid=$smid&pid=$pid&nav=1");
}
else
{
//echo mysql_error();
header("Location:landing.php?mid=$mid&smid=$smid&pid=$pid&nav=2");
}
}
//Customer Master
elseif($pid=="7_1_2")
{
$sql="select * from etaapp_employee";
$qu=mysql_query($sql);
$n1=mysql_num_rows($qu);
$n1++;
if($n1>=1 && $n1<=9)
$emp_id="ETA000".$n1;
elseif($n1>=10 && $n1<=99)
$emp_id="ETA00".$n1;
elseif($n1>=100 && $n1<=999)
$emp_id="ETA0".$n1;
elseif($n1>=1000 && $n1<=9999)
$emp_id="ETA".$n1;
$emp_name=$_POST['emp_name'];
$region=$_POST['oper_incharge'];
$branch=$_POST['store_incharge'];
$dob=date("Y-m-d",strtotime($_POST['dob']));
$doj=date("Y-m-d",strtotime($_POST['doj']));
$department=$_POST['department'];
$designation=$_POST['designation'];
$address=$_POST['address'];
$area_name=$_POST['area_name'];
$pincode=$_POST['pincode'];
$state_name=$_POST['state_name'];
$mobile=$_POST['mobile'];
$email_id=$_POST['email_id'];
$norms=$_POST['norms'];
$bike_status=$_POST['bike_status'];
$group_leader=$_POST['group_leader'];
$emp_status=$_POST['emp_status'];
$sms_status=$_POST['sms_status'];
$time_now=time(date('h')+5,date('i')+30,date('s'));
$time=date('h:i:s A',$time_now);
$from1=date("d-M-Y");
$update_time=$from1.", ".$time;
$sql="insert into etaapp_employee (emp_id, emp_name, region_name, branch_name, dob, doj, department, designation, address, area_name, pincode, state_name, mobile, email_id, norms, bike_status, group_leader, act_status, sms_status, update_by, update_time, status) values ('".$emp_id."','".$emp_name."','".$region_name."','".$branch_name."','".$dob."','".$doj."','".$department."','".$designation."','".$address."','".$area_name."','".$pincode."','".$state_name."','".$mobile."','".$email_id."','".$norms."','".$bike_status."','".$group_leader."','".$act_status."','".$sms_status."','".$user."','".$update_time."','Y')";
//echo $sql;
if(mysql_query($sql)==1)
{
header("Location:landing.php?mid=$mid&smid=$smid&pid=$pid&nav=1");
}
else
{
//echo mysql_error();
header("Location:landing.php?mid=$mid&smid=$smid&pid=$pid&nav=2");
}
}
//Area Master
elseif($pid=="7_1_3")
{
$AREA_ID=$_POST['AREA_ID'];
$AREA_NAME=$_POST['AREA_NAME'];
$sql_check=mysql_query("select AREA_ID from area where AREA_ID='".$AREA_ID."'");
if(mysql_num_rows($sql_check)==0)
{
$time_now=time(date('h')+5,date('i')+30,date('s'));
$time=date('h:i:s A',$time_now);
$sql="insert into area (AREA_NAME,AREA_UPDATE,created_by,created_date) values ('".$AREA_NAME."','1','".$user."','".date("Y-m-d H:i:s")."')";
//echo $sql;
}
else
{
$sql="update area set AREA_NAME='".$AREA_NAME."',updated_by='".$user."',updated_date='".date("Y-m-d H:i:s")."' where AREA_ID='".$AREA_ID."'";
}
//echo $sql; die;
if(mysql_query($sql)==1)
{
header("Location:landing.php?mid=$mid&smid=$smid&pid=$pid&nav=1");
}
else
{
//echo mysql_error();
header("Location:landing.php?mid=$mid&smid=$smid&pid=$pid&nav=2");
}
}
//Model Master
elseif($pid=="7_1_4")
{
$MODEL_ID=$_POST['MODEL_ID'];
$MODEL_NAME=$_POST['MODEL_NAME'];
$MAKE_ID=$_POST['MAKE_ID'];
$sql_check=mysql_query("select MODEL_ID from model where MODEL_ID='".$MODEL_ID."'");
if(mysql_num_rows($sql_check)==0)
{
$time_now=time(date('h')+5,date('i')+30,date('s'));
$time=date('h:i:s A',$time_now);
$sql="insert into model (MODEL_NAME,MAKE_ID,created_by,created_date,status) values ('".$MODEL_NAME."','".$MAKE_ID."','".$user."','".date("Y-m-d H:i:s")."','1')";
//echo $sql;
}
else
{
$sql="update model set MODEL_NAME='".$MODEL_NAME."',MAKE_ID='".$MAKE_ID."',updated_by='".$user."',updated_date='".date("Y-m-d H:i:s")."' where MODEL_ID='".$MODEL_ID."'";
}
//echo $sql; die;
if(mysql_query($sql)==1)
{
header("Location:landing.php?mid=$mid&smid=$smid&pid=$pid&nav=1");
}
else
{
//echo mysql_error();
header("Location:landing.php?mid=$mid&smid=$smid&pid=$pid&nav=2");
}
}
//Brand Master
elseif($pid=="7_1_5")
{
$MAKE_ID=$_POST['MAKE_ID'];
$MAKE_NAME=$_POST['MAKE_NAME'];
$sql_check=mysql_query("select MAKE_ID from make where MAKE_ID='".$MAKE_ID."'");
if(mysql_num_rows($sql_check)==0)
{
$time_now=time(date('h')+5,date('i')+30,date('s'));
$time=date('h:i:s A',$time_now);
$sql="insert into make (MAKE_NAME,created_by,created_date,status) values ('".$MAKE_NAME."','".$user."','".date("Y-m-d H:i:s")."','1')";
//echo $sql; die;
}
else
{
$sql="update make set MAKE_NAME='".$MAKE_NAME."',updated_by='".$user."',updated_date='".date("Y-m-d H:i:s")."' where MAKE_ID='".$MAKE_ID."'";
}
//echo $sql; die;
if(mysql_query($sql)==1)
{
header("Location:landing.php?mid=$mid&smid=$smid&pid=$pid&nav=1");
}
else
{
//echo mysql_error();
header("Location:landing.php?mid=$mid&smid=$smid&pid=$pid&nav=2");
}
}
//Purchase Serial No Upload Details
elseif($pid=="7_1_6")
{
$opt=$_REQUEST['opt'];
//Upload to Temp Table
if($opt==1)
{
$total_rec=0;
//Upload Bult Data deom Excel Format
//require_once 'Excel/reader.php';
require_once 'Excel/excel_reader2.php';
// ExcelFile($filename, $encoding);
$data = new Spreadsheet_Excel_Reader();
// Set output Encoding.
$data->setOutputEncoding('CP1251');
//Upload Excel File
function findexts ($filename)
{
$filename = strtolower($filename);
$exts = split("[/\\.]", $filename);
$n = count($exts)-1;
$exts = $exts[$n];
return $exts;
}
$target_path = "Excel/SAP_Upload";
$entry_date=date("d-m-Y, H:i:s");
//Get the Extension
//$ext = findexts($_FILES['upfile']['name']) ;
$filename=$_FILES['uploadfile']['name'];
//echo $filename;
$base1=basename($filename);
//echo $base1;
$exts = explode(".", $base1);
$target = $target.".".$exts[1];
$target_path = $target_path.$target;
//echo $target_path;
//$file_name= $_FILES["uploadfile"]["name"];
$file_name="Excel/".$_FILES["uploadfile"]["name"];
// echo $file_name;
if(move_uploaded_file($_FILES["uploadfile"]["tmp_name"],"Excel/".$_FILES["uploadfile"]["name"]))
{
//Open and Access Excel File
$data->read(dirname(__FILE__)."/".$file_name);
error_reporting(E_ALL ^ E_NOTICE);
$full_data="";
for ($i = 1; $i <= $data->sheets[0]['numRows']; $i++) {
$data_line="";
for ($j = 1; $j <= $data->sheets[0]['numCols']; $j++) {
//echo "\"".$data->sheets[0]['cells'][$i][$j]."\",";
$data_line=$data_line.$data->sheets[0]['cells'][$i][$j]."|";
}
$full_data=$full_data.$data_line."^";
}
//delete previous Orderdata from the Temp Table
$qu1=mysql_query("delete from serviceapp_tpurchase where update_by='".$user."'");
//Split Each Line in full data
//get
$line_split=explode("^",$full_data);
foreach($line_split as $value)
{
$data_split=explode("|",$value);
$data1="";
if(trim($data_split[0])!="Purchase No")
{
//$amount_split=explode(",",$data_split[6]);
//$amount1=$amount_split[0].$amount_split[1];
//$date_split=explode("/",$data_split[1]);
//$order_date=$date_split[0]."-".$date_split[1]."-".$date_split[2];
if(trim($data_split[3])!="")
{
$remove[] = "'";
$sql_model_sss="select sss_model from serviceapp_apx where apx_model='".str_replace( $remove, "", trim($data_split[3]))."' and status=1";
//echo $sql_model_sss;
$qu_model_sss=mysql_query($sql_model_sss);
$m_val_sss=mysql_fetch_array($qu_model_sss);
$sql_model_id="select MODEL_ID as modelid from model where MODEL_NAME='".$m_val_sss['sss_model']."' and status=1";
//echo $sql_model_id;
$qu_model_id=mysql_query($sql_model_id);
$m_val=mysql_fetch_array($qu_model_id);
$date=explode('/',str_replace( $remove, "", trim($data_split[1])));
//echo $date[2].'-'.$date[1].'-'.$date[0]; die;
//echo $m_val['modelid']; die;
$sql="insert into serviceapp_tpurchase (PURCHASE_INVOICENUMBER,PURCHASE_DATE,PURCHASE_SERIALNUMBER,PURCHASE_MODEL_ID,PURCHASE_DISPLAY,update_by,update_time,status) values ('".str_replace( $remove, "", trim($data_split[0]))."','".$date[2].'-'.$date[1].'-'.$date[0]."','".str_replace( $remove, "", trim($data_split[2]))."','".$m_val['modelid']."','1','".$user."','".$entry_date."','Y')";
//echo $sql; die;
$qu=mysql_query($sql);
$total_rec++;
}
}
}
header("Location:landing.php?mid=$mid&smid=$smid&pid=$pid&nav=1&total=$total_rec&con=1");
}
else
{
header("Location:landing.php?mid=$mid&smid=$smid&pid=$pid&nav=2");
}
header("Location:landing.php?mid=$mid&smid=$smid&pid=$pid&nav=1&total=$total_rec&con=4");
}
//Upload to Original Table
elseif($opt==2)
{
$_SESSION['$items']="";
//Updated as per total Table record count
$total_rec=0;
$rej_rec=0;
$sql1="select * from serviceapp_tpurchase where update_by='".$user."' and status='Y'";
$qu1=mysql_query($sql1);
while($r1=mysql_fetch_array($qu1))
{
$sql2="select PURCHASE_SERIALNUMBER from purchase where PURCHASE_MODEL_ID='".$r1['PURCHASE_MODEL_ID']."' and PURCHASE_SERIALNUMBER='".$r1['PURCHASE_SERIALNUMBER']."' and (status='Y' or status IS NULL)";
$qu2=mysql_query($sql2);
if(mysql_num_rows($qu2)==0)
{
$entry_date=date("d-m-Y, H:i:s");
$sql="insert into purchase (PURCHASE_INVOICENUMBER,PURCHASE_DATE,PURCHASE_SERIALNUMBER,PURCHASE_MODEL_ID,PURCHASE_DISPLAY,update_by,update_time,status) values ('".$r1['PURCHASE_INVOICENUMBER']."','".$r1['PURCHASE_DATE']."','".$r1['PURCHASE_SERIALNUMBER']."','".$r1['PURCHASE_MODEL_ID']."','0','".$user."','".$entry_date."','Y')";
//echo $sql; die;
$qu=mysql_query($sql);
$total_rec++;
}
else
{
$rej_rec++;
$items.=$r1['PURCHASE_INVOICENUMBER'].'-'.$r1['PURCHASE_SERIALNUMBER']."-".$r1['PURCHASE_DATE']."^";
}
$_SESSION['$items']=$items;
}
header("Location:landing.php?mid=$mid&smid=$smid&pid=$pid&nav=3&total=$total_rec&rej=$rej_rec&con=4");
}
}
//Tax Master
elseif($pid=="7_1_7")
{
$tax_id=$_POST['tax_id'];
$from_date=$_POST['from_date'];
$to_date=$_POST['to_date'];
$to_date=$_POST['to_date'];
$tax_val=$_POST['tax_val'];
$sql_check=mysql_query("select tax_id from serviceapp_tax where tax_id='".$tax_id."'");
if(mysql_num_rows($sql_check)==0)
{
$time_now=time(date('h')+5,date('i')+30,date('s'));
$time=date('h:i:s A',$time_now);
$sql="insert into serviceapp_tax (from_date,to_date,tax_val,created_by,created_date,status) values ('".$from_date."','".$to_date."','".$tax_val."','".$user."','".date("Y-m-d H:i:s")."','1')";
//echo $sql; die;
}
else
{
$sql="update serviceapp_tax set from_date='".$from_date."',to_date='".$to_date."',tax_val='".$tax_val."',updated_date='".date("Y-m-d H:i:s")."',updated_by='".$user."' where tax_id='".$tax_id."'";
}
//echo $sql; die;
if(mysql_query($sql)==1)
{
header("Location:landing.php?mid=$mid&smid=$smid&pid=$pid&nav=1");
}
else
{
//echo mysql_error();
header("Location:landing.php?mid=$mid&smid=$smid&pid=$pid&nav=2");
}
}
//sales Serial No Upload Details
elseif($pid=="7_1_8")
{
$opt=$_REQUEST['opt'];
//Upload to Temp Table
if($opt==1)
{
$total_rec=0;
//Upload Bult Data deom Excel Format
//require_once 'Excel/reader.php';
require_once 'Excel/excel_reader2.php';
// ExcelFile($filename, $encoding);
$data = new Spreadsheet_Excel_Reader();
// Set output Encoding.
$data->setOutputEncoding('CP1251');
//Upload Excel File
function findexts ($filename)
{
$filename = strtolower($filename);
$exts = split("[/\\.]", $filename);
$n = count($exts)-1;
$exts = $exts[$n];
return $exts;
}
$target_path = "Excel/Sales_Upload";
$entry_date=date("d-m-Y, H:i:s");
//Get the Extension
//$ext = findexts($_FILES['upfile']['name']) ;
$filename=$_FILES['uploadfile']['name'];
//echo $filename;
$base1=basename($filename);
//echo $base1;
$exts = explode(".", $base1);
$target = $target.".".$exts[1];
$target_path = $target_path.$target;
//echo $target_path;
//$file_name= $_FILES["uploadfile"]["name"];
$file_name="Excel/".$_FILES["uploadfile"]["name"];
if(move_uploaded_file($_FILES["uploadfile"]["tmp_name"],"Excel/".$_FILES["uploadfile"]["name"]))
{
//Open and Access Excel File
$data->read($file_name);
error_reporting(E_ALL ^ E_NOTICE);
$full_data="";
for ($i = 1; $i <= $data->sheets[0]['numRows']; $i++) {
$data_line="";
for ($j = 1; $j <= $data->sheets[0]['numCols']; $j++) {
//echo "\"".$data->sheets[0]['cells'][$i][$j]."\",";
$data_line=$data_line.$data->sheets[0]['cells'][$i][$j]."|";
}
$full_data=$full_data.$data_line."^";
}
//delete previous Orderdata from the Temp Table
$qu1=mysql_query("delete from serviceapp_tsales where update_by='".$user."'");
//Split Each Line in full data
//get
$_SESSION['sales']="";
$line_split=explode("^",$full_data);
foreach($line_split as $value)
{
$data_split=explode("|",$value);
$data1="";
if(trim($data_split[0])!="sales_INVOICENUMBER")
{
//$amount_split=explode(",",$data_split[6]);
//$amount1=$amount_split[0].$amount_split[1];
//$date_split=explode("/",$data_split[1]);
//$order_date=$date_split[0]."-".$date_split[1]."-".$date_split[2];
if(trim($data_split[4])!="")
{
$remove[] = "'";
$sql_model="select sss_model,(select MODEL_ID from model where MODEL_NAME=sss_model and status=1 limit 0,1) as modelid from serviceapp_apx where apx_model='".str_replace( $remove, "", trim($data_split[4]))."' and status=1";
//echo $sql_model; die;
$qu_model=mysql_query($sql_model);
$m_val=mysql_fetch_array($qu_model);
$date=explode('/',str_replace( $remove, "", trim($data_split[1])));
$sql="insert into serviceapp_tsales (sales_INVOICENUMBER, sales_DATE, sales_SERIALNUMBER, sales_MODEL_ID, sales_customer, update_by, update_time, status) values ('".str_replace( $remove, "", trim($data_split[0]))."','".$date[2].'-'.$date[1].'-'.$date[0]."','".str_replace( $remove, "", trim($data_split[2]))."','".$m_val['modelid']."','".str_replace( $remove, "", trim($data_split[3]))."','".$user."','".$entry_date."','Y')";
//echo $sql; die;
//$qu=mysql_query($sql);
if(mysql_query($sql)==1)
{
$total_rec++;
}
else
{
// echo "select sss_model,(select MODEL_ID from model where MODEL_NAME=sss_model and status=1 limit 0,1) as modelid from serviceapp_apx where apx_model='".str_replace( $remove, "", trim($data_split[4]))."' and status=1";
$sales.= str_replace( $remove, "", trim($data_split[0])).'-'.str_replace( $remove, "", trim($data_split[2])).'-'.str_replace( $remove, "", trim($data_split[4])).",";
}
}
}
}
$_SESSION['sales']=$sales;
//header("Location:landing.php?mid=$mid&smid=$smid&pid=$pid&nav=1&total=$total_rec&con=1");
}
else
{
header("Location:landing.php?mid=$mid&smid=$smid&pid=$pid&nav=2");
}
header("Location:landing.php?mid=$mid&smid=$smid&pid=$pid&nav=1&total=$total_rec&con=4");
}
//Upload to Original Table
elseif($opt==2)
{
//$items = array();
//Updated as per total Table record count
$_SESSION['items']="";
$total_rec=0;
$rej_rec=0;
$sql1="select * from serviceapp_tsales where update_by='".$user."' and status='Y'";
$qu1=mysql_query($sql1);
while($r1=mysql_fetch_array($qu1))
{
$sql2="select PURCHASE_SERIALNUMBER from purchase where PURCHASE_SERIALNUMBER='".$r1['sales_SERIALNUMBER']."' and PURCHASE_MODEL_ID='".$r1['sales_MODEL_ID']."'";
$qu2=mysql_query($sql2);
if(mysql_num_rows($qu2)>=1)
{
$entry_date=date("d-m-Y, H:i:s");
$sql="update purchase set sales_invoiceno='".$r1['sales_INVOICENUMBER']."',sales_date='".$r1['sales_DATE']."',client_name='".$r1['sales_customer']."',sales_createddate='".$entry_date."',sales_updatedby='".$user."' where PURCHASE_SERIALNUMBER='".$r1['sales_SERIALNUMBER']."' and PURCHASE_MODEL_ID='".$r1['sales_MODEL_ID']."'";
//echo $sql;
$qu=mysql_query($sql);
$total_rec++;
}
else
{
$rej_rec++;
//echo $r1['sales_INVOICENUMBER'];
$items.=$r1['sales_INVOICENUMBER']."-".$r1['sales_SERIALNUMBER'].",";
}
$_SESSION['items']=$items;
}
header("Location:landing.php?mid=$mid&smid=$smid&pid=$pid&nav=3&total=$total_rec&rej=$rej_rec&con=4");
}
}
elseif($pid=="7_1_9")
{
if($type==1)
{
$current_date=date('Y-m-d');
$Purchase_invoiceno=$_POST['PURCHASE_INVOICENUMBER'];
$Purchase_date=$_POST['PURCHASE_DATE'];
$Purchase_serialno=$_POST['PURCHASE_SERIALNUMBER'];
$Purchase_model_id=$_POST['PURCHASE_MODEL_ID'];
$date = date('Y-m-d H:i:s');
$Purchase_display=$_POST['PURCHASE_DISPLAY'];
$sales_invoiceno=$_POST['sales_invoiceno'];
$sales_date=$_POST['sales_date'];
$client_name=$_POST['client_name'];
if($_POST['PURCHASE_ID']==0)
{
$sql="INSERT into purchase (PURCHASE_INVOICENUMBER,PURCHASE_DATE,PURCHASE_SERIALNUMBER,PURCHASE_MODEL_ID,PURCHASE_DISPLAY,sales_invoiceno,sales_date,client_name) VALUES ('$Purchase_invoiceno','".date('Y-m-d',strtotime(trim($Purchase_date)))."','$Purchase_serialno','$Purchase_model_id','0','$sales_invoiceno','".date('Y-m-d',strtotime(trim($sales_date)))."','$client_name') ";
//echo $sql; die;
}
else
{
$sql="update purchase set PURCHASE_INVOICENUMBER='".trim($Purchase_invoiceno)."', PURCHASE_DATE='".date('Y-m-d',strtotime(trim($Purchase_date)))."', PURCHASE_SERIALNUMBER='".trim($Purchase_serialno)."', PURCHASE_MODEL_ID='".trim($Purchase_model_id)."',update_time='".date("Y-m-d H:i:s")."', sales_invoiceno='".trim($sales_invoiceno)."', sales_date='".date('Y-m-d',strtotime(trim($sales_date)))."', client_name='".trim($client_name)."' where PURCHASE_ID='".trim($_POST['PURCHASE_ID'])."'";
//echo $sql;die;
}
if(mysql_query($sql)==1)
{
echo "1|".trim($Purchase_invoiceno);
}
else
{
echo "2|";
}
}
if($type==2)
{
$Purchase_invoiceno=$_POST['purchaseinvoice'];
$sql="update purchase set status='N' where PURCHASE_INVOICENUMBER='".trim($Purchase_invoiceno)."'";
//echo $sql;die;
if(mysql_query($sql)==1)
{
echo "1|".trim($Purchase_invoiceno);
}
else
{
echo "2|";
}
}
}
elseif($pid=="7_1_10")
{
//echo "hai"; die;
$apx_modelid=$_POST['apx_modelid'];
$apx_model=$_POST['apx_model'];
$sss_model=$_POST['sss_model'];
//echo "select EMP_CODE from employee where EMP_CODE='".$emp_code."'"; die;
$sql_check=mysql_query("select apx_modelid from serviceapp_apx where apx_modelid='".$apx_modelid."'");
if(mysql_num_rows($sql_check)==0)
{
$sql="insert into serviceapp_apx (apx_model,sss_model,status) values ('".$apx_model."','".$sss_model."','1')";
// echo $sql; die;
}
else
{
$sql="update serviceapp_apx set apx_model='".$apx_model."',sss_model='".$sss_model."' where apx_modelid='".$apx_modelid."'";
}
//echo $sql; die;
if(mysql_query($sql)==1)
{
header("Location:landing.php?mid=$mid&smid=$smid&pid=$pid&nav=1");
}
else
{
//echo mysql_error();
header("Location:landing.php?mid=$mid&smid=$smid&pid=$pid&nav=2");
}
}
elseif($pid=="7_1_11")
{
//$employee_id=$_POST['employee_id'];
$model_name=$_POST['model_name'];
$MAKE_ID=$_POST['MAKE_ID'];
$product_name=$_POST['product_name'];
$tonage=$_POST['tonage'];
$lamount=$_POST['lamount'];
$excomp=$_POST['excomp'];
$comp=$_POST['comp'];
$wlamount=$_POST['wlamount'];
$wexamount=$_POST['wexamount'];
$time_now=time(date('h')+5,date('i')+30,date('s'));
$time=date('Y-m-d h:i:s',$time_now);
$sql="insert into amc_model_list (model_no, make, product, tonage, lamount, excomp, comp, wlamount, wexamount,inserted_by,inserted_date,status) values ('".$model_name."','".$MAKE_ID."','".$product_name."','".$tonage."','".$lamount."','".$excomp."','".$comp."','".$wlamount."','".$wexamount."','".$user."','".$time."','Y')";
//echo $sql; die;
if(mysql_query($sql)==1)
{
//echo"success";
header("Location:landing.php?mid=$mid&smid=$smid&pid=$pid&nav=1");
}
else
{
//echo"failure";
header("Location:landing.php?mid=$mid&smid=$smid&pid=$pid&nav=2");
}
}
?>