connected
sfa_source_connDB Connected
-- Input month --12
-- Input year --2025
--currentMonth--12set innodb_lock_wait_timeout = 100;
--affected rows--0
---- Start Time ---2025-12-06 10:33:39
--yearmonth--122025
--FileName--/var/www/html/Brinton/scripts/data/client/Primarydata122025.csvFile exists
---- Start Time ---2025-12-06 10:33:39
---- End Time ---2025-12-06 10:33:39
--affected rows--0
---- Start Time ---2025-12-06 10:33:39TRUNCATE TABLE primary_invoice_upload_2;
---- End Time ---2025-12-06 10:33:42
--affected rows--0
---- Start Time ---2025-12-06 10:33:42
---- current date ---2025-12-06load data LOCAL infile '/var/www/html/Brinton/scripts/data/client/Primarydata122025.csv' into table primary_invoice_upload_2 fields terminated by ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY ' ' IGNORE 1 LINES (territorycode,Party,Party_Code,Party_GST_NO,HeadQtr,Party_Group,State_Name,Zone,CDays,Type,Division,Location,Doc_No,datevar,Month,Year,Product,Product_Brand,Product_Code,HSN_CODE,Batch_No,Mfg_Date,Exp_Date,Pack,MRP,Rate,Qty,Free,Gross_Amt,Disc,Amount,Free_Amt,CN,Tax_percent,Tax,Tax1,Net,Collection_Amt,Collection_Date,Days,CN_Division,Taxable_Sale,Tax_on_Sale,Taxable_Free,Tax_on_Free);
---- End Time ---2025-12-06 10:33:42
--affected rows--3
Primary Sales Cron 10% processing completed.
---- Start Time ---2025-12-06 10:33:42UPDATE primary_invoice_upload_2 SET Division = 'CELESTA' WHERE Division = 'FALCONS';DELETE from primary_invoice_upload_2 WHERE Division IN ('HOHNER','OTC');
---- Start Time ---2025-12-06 10:33:42UPDATE primary_invoice_upload_2 SET territorycode = TRIM(territorycode), Party = TRIM(Party), Party_Code = TRIM(Party_Code), Party_GST_NO = TRIM(Party_GST_NO), HeadQtr = TRIM(HeadQtr), Party_Group = TRIM(Party_Group), State_Name = TRIM(State_Name), Zone = TRIM(Zone), CDays = TRIM(CDays), Type = TRIM(Type), Division = TRIM(Division), Location = TRIM(Location), Doc_No = TRIM(Doc_No), Date = TRIM(Date), Month = TRIM(Month), Year = TRIM(Year), Product = TRIM(Product), Product_Brand = TRIM(Product_Brand), HSN_CODE = TRIM(HSN_CODE), Product_Code = TRIM(Product_Code), Batch_No = TRIM(Batch_No), Mfg_Date = TRIM(Mfg_Date), Exp_Date = TRIM(Exp_Date), Pack = TRIM(Pack), MRP = TRIM(MRP), Rate = TRIM(Rate), Qty = TRIM(Qty), Free = TRIM(Free), Gross_Amt = TRIM(Gross_Amt), Disc = TRIM(Disc), Amount = TRIM(Amount), Free_Amt = TRIM(Free_Amt), CN = TRIM(CN), Tax_percent = TRIM(Tax_percent), Tax = TRIM(Tax), Tax1 = TRIM(Tax1), Net = TRIM(Net), Collection_Amt = TRIM(Collection_Amt), Collection_Date = TRIM(Collection_Date), Days = TRIM(Days), CN_Division = TRIM(CN_Division), Taxable_Sale = TRIM(Taxable_Sale), Tax_on_Sale = TRIM(Tax_on_Sale), Taxable_Free = TRIM(Taxable_Free), Tax_on_Free = TRIM(Tax_on_Free)
---- End Time ---2025-12-06 10:33:42
--affected rows--0
---- Start Time ---2025-12-06 10:33:42UPDATE primary_invoice_upload_2 SET remarks='', flag=0, stockist2territoryflag=0, divisionid=0, stockistid=0, productid=0, stateid=0, zoneid=0
---- End Time ---2025-12-06 10:33:42
--affected rows--3
---- Start Time ---2025-12-06 10:33:42UPDATE primary_invoice_upload_2 SET flag=1, remarks=CONCAT_WS(' | ', remarks, 'Error: Party Name given empty') WHERE Party = '' OR Party IS NULL
---- End Time ---2025-12-06 10:33:42
--affected rows--0
---- Start Time ---2025-12-06 10:33:42UPDATE primary_invoice_upload_2 SET flag=1, remarks=CONCAT_WS(' | ', remarks, 'Error: Party Code given empty') WHERE Party_Code = '' OR Party_Code IS NULL
---- End Time ---2025-12-06 10:33:42
--affected rows--0
---- Start Time ---2025-12-06 10:33:42UPDATE primary_invoice_upload_2 SET flag=1, remarks=CONCAT_WS(' | ', remarks, 'Error: State Name given empty') WHERE State_Name = '' OR State_Name IS NULL
---- End Time ---2025-12-06 10:33:42
--affected rows--0
---- Start Time ---2025-12-06 10:33:42UPDATE primary_invoice_upload_2 SET flag=1, remarks=CONCAT_WS(' | ', remarks, 'Error: Zone Name given empty') WHERE (Zone = '' OR Zone IS NULL) AND Division NOT IN ('Cardinal', 'Condor', 'HOHNER OTC')
---- End Time ---2025-12-06 10:33:42
--affected rows--0
---- Start Time ---2025-12-06 10:33:42UPDATE primary_invoice_upload_2 SET flag=1, remarks=CONCAT_WS(' | ', remarks, 'Error: Type given empty') WHERE Type = '' OR Type IS NULL
---- End Time ---2025-12-06 10:33:42
--affected rows--0
---- Start Time ---2025-12-06 10:33:42UPDATE primary_invoice_upload_2 SET flag=1, remarks=CONCAT_WS(' | ', remarks, 'Error: Division Name given empty') WHERE Division = '' OR Division IS NULL
---- End Time ---2025-12-06 10:33:42
--affected rows--0
---- Start Time ---2025-12-06 10:33:42UPDATE primary_invoice_upload_2 SET flag=1, remarks=CONCAT_WS(' | ', remarks, 'Error: Doc_No given empty') WHERE (Doc_No = '' OR Doc_No IS NULL) AND Division NOT IN ('Cardinal', 'Condor', 'HOHNER OTC')
---- End Time ---2025-12-06 10:33:42
--affected rows--0
---- Start Time ---2025-12-06 10:33:42UPDATE primary_invoice_upload_2 SET flag =1,remarks=CONCAT_WS(' | ',remarks,'Error:Date given empty or Date format is given wrong.Kindly give date in YYYY-MM-DD format') WHERE Date = '0000-00-00' or Date is NULL
---- End Time ---2025-12-06 10:33:42
--affected rows--0
---- Start Time ---2025-12-06 10:33:42UPDATE primary_invoice_upload_2 SET flag =1,remarks=CONCAT_WS(' | ',remarks,'Error:Month given empty') WHERE Month = '' or Month is NULL
---- End Time ---2025-12-06 10:33:42
--affected rows--0
---- Start Time ---2025-12-06 10:33:42UPDATE primary_invoice_upload_2 SET flag =1,remarks=CONCAT_WS(' | ',remarks,'Error:Year given empty') WHERE Year = '' or Year is NULL
---- End Time ---2025-12-06 10:33:42
--affected rows--0
---- Start Time ---2025-12-06 10:33:42UPDATE primary_invoice_upload_2 SET flag =1,remarks=CONCAT_WS(' | ',remarks,'Error:Product Name given empty') WHERE Product = '' or Product is NULL
---- End Time ---2025-12-06 10:33:42
--affected rows--0
---- Start Time ---2025-12-06 10:33:42UPDATE primary_invoice_upload_2 SET flag =1,remarks=CONCAT_WS(' | ',remarks,'Error:Product Code given empty') WHERE Product_Code = '' or Product_Code is NULL
---- End Time ---2025-12-06 10:33:42
--affected rows--0
---- Start Time ---2025-12-06 10:33:42UPDATE primary_invoice_upload_2 SET flag =1,remarks=CONCAT_WS(' | ',remarks,'Error:Batch_No given empty') WHERE (Batch_No = '' or Batch_No is NULL) AND Division NOT IN ('Cardinal','Condor','HOHNER OTC')
---- End Time ---2025-12-06 10:33:42
--affected rows--0
---- Start Time ---2025-12-06 10:33:42UPDATE primary_invoice_upload_2 SET flag =1,remarks=CONCAT_WS(' | ',remarks,'Error:MRP given empty') WHERE (MRP = '' or MRP is NULL) AND Division NOT IN ('Cardinal','Condor','HOHNER OTC')
---- End Time ---2025-12-06 10:33:42
--affected rows--0
---- Start Time ---2025-12-06 10:33:42UPDATE primary_invoice_upload_2 SET flag =1,remarks=CONCAT_WS(' | ',remarks,'Error:Rate given empty') WHERE Rate = '' or Rate is NULL
---- End Time ---2025-12-06 10:33:42
--affected rows--0
---- Start Time ---2025-12-06 10:33:42UPDATE primary_invoice_upload_2, division SET primary_invoice_upload_2.divisionid = division.divisionid WHERE division.name = primary_invoice_upload_2.Division;
---- End Time ---2025-12-06 10:33:42
--affected rows--3
---- Start Time ---2025-12-06 10:33:42UPDATE primary_invoice_upload_2 SET flag = 1, remarks = CONCAT_WS(' | ', remarks, 'Error:Division not present in system') WHERE divisionid = 0;
---- End Time ---2025-12-06 10:33:42
--affected rows--0
Primary Sales Cron 20% processing completed.
---- Start Time ---2025-12-06 10:33:42UPDATE primary_invoice_upload_2, state SET primary_invoice_upload_2.stateid = state.stateid WHERE primary_invoice_upload_2.State_Name = state.statename;
---- End Time ---2025-12-06 10:33:42
--affected rows--3
---- Start Time ---2025-12-06 10:33:42UPDATE primary_invoice_upload_2 SET flag = 1, remarks = CONCAT_WS(' | ', remarks, 'Error:State name not present in system') WHERE stateid = 0;
---- End Time ---2025-12-06 10:33:42
--affected rows--0string(2) "12"
---- Start Time ---2025-12-06 10:33:42UPDATE primary_invoice_upload_2 SET flag = 1, remarks = CONCAT_WS(' | ', remarks, 'Error:Selected month is not matching with the file') WHERE Month != 12;
---- End Time ---2025-12-06 10:33:42
--affected rows--3
Primary Sales Cron 30% processing completed.
---- Start Time ---2025-12-06 10:33:42UPDATE primary_invoice_upload_2 SET flag = 1, remarks = CONCAT_WS(' | ', remarks, 'Error:Selected year is not matching with the file') WHERE Year != '2025';
---- End Time ---2025-12-06 10:33:42
--affected rows--0
---- Start Time ---2025-12-06 10:33:42UPDATE primary_invoice_upload_2 INNER JOIN stckcontactmaster ON primary_invoice_upload_2.Party_Code = stckcontactmaster.stockistcode SET stockistid = stckcontactmaster.masterid WHERE Party_Code = stockistcode AND stckcontactmaster.del = 0;
---- End Time ---2025-12-06 10:33:42
--affected rows--3
---- Start Time ---2025-12-06 10:33:42UPDATE primary_invoice_upload_2 SET flag = 1, remarks = CONCAT_WS(' | ', remarks, 'Error:Party_Code does not exist') WHERE stockistid = 0;
---- End Time ---2025-12-06 10:33:42
--affected rows--0UPDATE primary_invoice_upload_2 INNER JOIN stockist2territory ON primary_invoice_upload_2.divisionid = stockist2territory.division AND primary_invoice_upload_2.stockistid = stockist2territory.masterid AND stockist2territory.deleted = 0 SET primary_invoice_upload_2.territorycode = stockist2territory.territorycode
---- End Time ---2025-12-06 10:33:43
--affected rows--3
---- Start Time ---2025-12-06 10:33:43UPDATE primary_invoice_upload_2 SET flag=1, remarks=CONCAT_WS(' | ', remarks, 'Error: Territory Code given empty') WHERE territorycode = '' OR territorycode IS NULL
---- End Time ---2025-12-06 10:33:43
--affected rows--0
Primary Sales Cron 40% processing completed.
---- Start Time ---2025-12-06 10:33:43UPDATE primary_invoice_upload_2 INNER JOIN stockist2territory ON primary_invoice_upload_2.territorycode = stockist2territory.territorycode AND primary_invoice_upload_2.divisionid = stockist2territory.division AND primary_invoice_upload_2.stockistid = stockist2territory.masterid AND stockist2territory.deleted = 0 INNER JOIN patches ON stockist2territory.territorycode = patches.patchsapcode AND stockist2territory.division = patches.division AND patches.patch_deleted = 0 INNER JOIN users ON patches.patchid = users.patch AND users.deleted = 0 INNER JOIN user2role ON users.id = user2role.userid INNER JOIN role2profile ON user2role.roleid = role2profile.roleid SET stockist2territoryflag = 1 WHERE role2profile.profileid = 5;
---- End Time ---2025-12-06 10:33:43
--affected rows--3
---- Start Time ---2025-12-06 10:33:43UPDATE primary_invoice_upload_2 SET flag = 1, remarks = CONCAT_WS(' | ', remarks, 'Error:Stockist doesnt exist for that MR Territory') WHERE stockist2territoryflag = 0;
---- End Time ---2025-12-06 10:33:43
--affected rows--0
---- Start Time ---2025-12-06 10:33:43UPDATE primary_invoice_upload_2 INNER JOIN stockist2territory ON primary_invoice_upload_2.stockistid = stockist2territory.masterid AND primary_invoice_upload_2.divisionid = stockist2territory.division SET flag = 1, remarks = CONCAT_WS(' | ', remarks, 'Error: Stockist does not exist for territory | Stockist associated to Territory code:', stockist2territory.territorycode) WHERE primary_invoice_upload_2.territorycode <> stockist2territory.territorycode AND stockist2territory.deleted = 0;
---- End Time ---2025-12-06 10:33:43
--affected rows--0
Primary Sales Cron 50% processing completed.
---- Start Time ---2025-12-06 10:33:43UPDATE primary_invoice_upload_2 INNER JOIN products ON primary_invoice_upload_2.Product_Code = products.productcode SET primary_invoice_upload_2.productid = products.productid WHERE Product_Code = productcode AND primary_invoice_upload_2.divisionid = products.division AND products.deleted = 0 AND products.productcategory ='R';
---- End Time ---2025-12-06 10:33:43
--affected rows--3
---- Start Time ---2025-12-06 10:33:43UPDATE primary_invoice_upload_2 SET flag = 1, remarks = CONCAT_WS(' | ', remarks, 'Error:Product_CODE does not exist') WHERE productid = 0;
---- End Time ---2025-12-06 10:33:43
--affected rows--0UPDATE primary_invoice_upload_2 INNER JOIN products ON primary_invoice_upload_2.productid= products.productid AND products.deleted=0 INNER JOIN productbrandtype ON products.productbrandtype = productbrandtype.productbrandtypeid SET primary_invoice_upload_2.Product_Brand = productbrandtype.productbrandtype
---- End Time ---2025-12-06 10:33:43
--affected rows--3
---- Start Time ---2025-12-06 10:33:43UPDATE primary_invoice_upload_2 SET flag =1,remarks=CONCAT_WS(' | ',remarks,'Error:Product Brand given empty') WHERE (Product_Brand = '' or Product_Brand is NULL) AND Division NOT IN ('Cardinal','Condor','HOHNER OTC')
---- End Time ---2025-12-06 10:33:43
--affected rows--0
---- Start Time ---2025-12-06 10:33:43INSERT INTO primary_sales_data_test SELECT territorycode AS territory_code, Party AS stockistname, Party_Code AS stockistcode, HeadQtr AS head_qtr, Party_Group AS party_group, State_Name AS state, Zone AS zone, Type AS type, Division AS division, Location AS location, Doc_No AS doc_no, Date AS date, '' AS month_type, Product AS product_name, Product_Code AS product_code, Product_Brand AS product_brand, HSN_CODE AS hsn_code, Batch_No AS product_batch_no, Mfg_Date AS mfg_date, Exp_Date AS exp_date, Pack AS pack, MRP AS mrp, Rate AS rate, Qty AS qty, Free AS free, Gross_Amt AS gross_amt, Disc AS disc, Amount AS amount, Free_Amt AS free_amt, CN AS CN, Tax_percent AS tax_percentage, Tax AS tax, Tax1 AS tax1, Net AS net, Collection_Amt AS collection_amt, collection_date AS collection_date, Days AS days, CN_Division AS cn_division, Taxable_Sale AS taxable_sale, Tax_on_Sale AS tax_on_sale, Taxable_Free AS taxable_free, Tax_on_Free AS tax_on_free, '' AS type1, divisionid AS divisionid, stockistid AS stockistid, productid AS productid, stateid AS stateid, zoneid AS zoneid, NOW() AS created_on, 0 AS deleted, Month AS Month, Year AS Year, 0 AS flags, 0 AS isales FROM primary_invoice_upload_2 WHERE flag = 0
---- End Time ---2025-12-06 10:33:43
--affected rows--0
Primary Sales Cron 60% processing completed.
---- Start Time ---2025-12-06 10:33:43UPDATE primary_sales_data_test SET flags = 1 WHERE type = 'BREAKAGE EXPIRY' AND month = '12' AND year = '2025';
---- End Time ---2025-12-06 10:33:43
--affected rows--0
---- Start Time ---2025-12-06 10:33:43UPDATE primary_sales_data_test SET flags = 2 WHERE type = 'GOODS RETURN' AND month = '12' AND year = '2025';
---- End Time ---2025-12-06 10:33:43
--affected rows--0
---- Start Time ---2025-12-06 10:33:43UPDATE primary_sales_data_test SET flags = 3 WHERE type IN ('Cheque', 'Cheque On Delivery', 'Neft/Rtgs', 'DD', 'NEW PRODUCT') AND month = '12' AND year = '2025';
---- End Time ---2025-12-06 10:33:43
--affected rows--0
Primary Sales Cron 70% processing completed.
---- Start Time ---2025-12-06 10:33:43UPDATE primary_sales_data_test SET isales = 1 WHERE party_group = 'ISALE' AND month = '12' AND year = '2025';
---- End Time ---2025-12-06 10:33:43
--affected rows--0
---- Start Time ---2025-12-06 10:33:43UPDATE primary_sales_data_test SET flags = 4 WHERE type IN ('RATE DIFF') AND month = '12' AND year = '2025';
---- End Time ---2025-12-06 10:33:43
--affected rows--0
Primary Sales Cron 80% processing completed.
Fatal error: Uncaught mysqli_sql_exception: Can't create/write to file '/var/www/html/Brinton/scripts/salesErrorLog/salesErrorLog_2025_12_06_10_33_43.csv' (OS errno 2 - No such file or directory) in /var/www/html/Brinton/scripts/primary_sync_v2.php:652 Stack trace: #0 /var/www/html/Brinton/scripts/primary_sync_v2.php(652): mysqli_query() #1 /var/www/html/Brinton/scripts/primary_sync_v2.php(552): processErrorLog() #2 {main} thrown in /var/www/html/Brinton/scripts/primary_sync_v2.php on line 652