UPDATE user SET loginip = "" WHERE lastactivetime < "2025-03-03 21:26:06";
UPDATE user SET loginip = "::1", lastactivetime = "2025-03-04 00:56:06", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('productController.php', '2025-03-04 00:56:06', '1', 'showbarcode', '::1', '', 'DESKTOP','https://localhost/erp/controllers/productController.php?do=showbarcode');
UPDATE user SET loginip = "" WHERE lastactivetime < "2025-03-03 21:35:00";
UPDATE user SET loginip = "::1", lastactivetime = "2025-03-04 01:05:00", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('productController.php', '2025-03-04 01:05:00', '1', '', '::1', '', 'DESKTOP','https://localhost/erp/controllers/productController.php');
UPDATE user SET loginip = "" WHERE lastactivetime < "2025-03-03 21:35:06";
UPDATE user SET loginip = "::1", lastactivetime = "2025-03-04 01:05:06", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('sellbillController.php', '2025-03-04 01:05:06', '1', 'addsellBill', '::1', '', 'DESKTOP','https://localhost/erp/controllers/sellbillController.php?do=addsellBill&billnameid=3');
UPDATE user SET loginip = "" WHERE lastactivetime < "2025-03-03 21:35:14";
UPDATE user SET loginip = "::1", lastactivetime = "2025-03-04 01:05:14", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('productController.php', '2025-03-04 01:05:14', '1', '', '::1', '', 'DESKTOP','https://localhost/erp/controllers/productController.php');
UPDATE user SET loginip = "" WHERE lastactivetime < "2025-03-03 21:35:19";
UPDATE user SET loginip = "::1", lastactivetime = "2025-03-04 01:05:20", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('productCatController.php', '2025-03-04 01:05:20', '1', '', '::1', '', 'DESKTOP','https://localhost/erp/controllers/productCatController.php');
UPDATE user SET loginip = "" WHERE lastactivetime < "2025-03-03 21:35:30";
UPDATE user SET loginip = "::1", lastactivetime = "2025-03-04 01:05:30", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('productCatController.php', '2025-03-04 01:05:30', '1', 'add2', '::1', '', 'DESKTOP','https://localhost/erp/controllers/productCatController.php?do=add2');
INSERT INTO productcat (productCatName, productCatDate, productCatDescription, productCatParent, userId, conditions, selldiscount, buydiscount, discounttype,isOptic , buytotal , buyhalf , buypart ,buypricereal,opticServices,logo,inMenu,stopNegativeSale,catExcelid,webApiId,obygyInvestigationCatId,price4,price5,price6,price7,price8) VALUES ('شروال','2025-03-04','','0', '1','0', '0', '0', '-1', '0', '0', '0', '0','0','','.','0','0','0','0','0','0','0','0','0','0');
INSERT INTO onlinetempcategory (catid, edited, sysdate, userid)
                VALUES (2, 1,'2025-03-04 01:05:31',1)
                ON DUPLICATE KEY UPDATE catid = 2, edited = 1, sysdate = '2025-03-04 01:05:31', userid = 1;
UPDATE user SET loginip = "" WHERE lastactivetime < "2025-03-03 21:35:31";
UPDATE user SET loginip = "::1", lastactivetime = "2025-03-04 01:05:31", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('productCatController.php', '2025-03-04 01:05:31', '1', 'sucess', '::1', '', 'DESKTOP','https://localhost/erp/controllers/productCatController.php?do=sucess');
UPDATE user SET loginip = "" WHERE lastactivetime < "2025-03-03 21:35:33";
UPDATE user SET loginip = "::1", lastactivetime = "2025-03-04 01:05:33", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('productCatController.php', '2025-03-04 01:05:33', '1', 'show', '::1', '', 'DESKTOP','https://localhost/erp/controllers/productCatController.php?do=show');
UPDATE user SET loginip = "" WHERE lastactivetime < "2025-03-03 21:35:34";
UPDATE user SET loginip = "::1", lastactivetime = "2025-03-04 01:05:34", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('productCatController.php', '2025-03-04 01:05:34', '1', '', '::1', '', 'DESKTOP','https://localhost/erp/controllers/productCatController.php');
UPDATE user SET loginip = "" WHERE lastactivetime < "2025-03-03 21:35:41";
UPDATE user SET loginip = "::1", lastactivetime = "2025-03-04 01:05:41", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('productCatController.php', '2025-03-04 01:05:41', '1', 'add2', '::1', '', 'DESKTOP','https://localhost/erp/controllers/productCatController.php?do=add2');
INSERT INTO productcat (productCatName, productCatDate, productCatDescription, productCatParent, userId, conditions, selldiscount, buydiscount, discounttype,isOptic , buytotal , buyhalf , buypart ,buypricereal,opticServices,logo,inMenu,stopNegativeSale,catExcelid,webApiId,obygyInvestigationCatId,price4,price5,price6,price7,price8) VALUES ('قميص','2025-03-04','','0', '1','0', '0', '0', '-1', '0', '0', '0', '0','0','','.','0','0','0','0','0','0','0','0','0','0');
INSERT INTO onlinetempcategory (catid, edited, sysdate, userid)
                VALUES (3, 1,'2025-03-04 01:05:41',1)
                ON DUPLICATE KEY UPDATE catid = 3, edited = 1, sysdate = '2025-03-04 01:05:41', userid = 1;
UPDATE user SET loginip = "" WHERE lastactivetime < "2025-03-03 21:35:41";
UPDATE user SET loginip = "::1", lastactivetime = "2025-03-04 01:05:41", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('productCatController.php', '2025-03-04 01:05:41', '1', 'sucess', '::1', '', 'DESKTOP','https://localhost/erp/controllers/productCatController.php?do=sucess');
UPDATE user SET loginip = "" WHERE lastactivetime < "2025-03-03 21:35:43";
UPDATE user SET loginip = "::1", lastactivetime = "2025-03-04 01:05:43", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('productCatController.php', '2025-03-04 01:05:43', '1', 'show', '::1', '', 'DESKTOP','https://localhost/erp/controllers/productCatController.php?do=show');
UPDATE user SET loginip = "" WHERE lastactivetime < "2025-03-03 21:35:46";
UPDATE user SET loginip = "::1", lastactivetime = "2025-03-04 01:05:46", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('productCatController.php', '2025-03-04 01:05:46', '1', '', '::1', '', 'DESKTOP','https://localhost/erp/controllers/productCatController.php');
UPDATE user SET loginip = "" WHERE lastactivetime < "2025-03-03 21:35:51";
UPDATE user SET loginip = "::1", lastactivetime = "2025-03-04 01:05:51", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('productCatController.php', '2025-03-04 01:05:51', '1', 'add2', '::1', '', 'DESKTOP','https://localhost/erp/controllers/productCatController.php?do=add2');
INSERT INTO productcat (productCatName, productCatDate, productCatDescription, productCatParent, userId, conditions, selldiscount, buydiscount, discounttype,isOptic , buytotal , buyhalf , buypart ,buypricereal,opticServices,logo,inMenu,stopNegativeSale,catExcelid,webApiId,obygyInvestigationCatId,price4,price5,price6,price7,price8) VALUES ('تيشرت ','2025-03-04','','0', '1','0', '0', '0', '-1', '0', '0', '0', '0','0','','.','0','0','0','0','0','0','0','0','0','0');
INSERT INTO onlinetempcategory (catid, edited, sysdate, userid)
                VALUES (4, 1,'2025-03-04 01:05:52',1)
                ON DUPLICATE KEY UPDATE catid = 4, edited = 1, sysdate = '2025-03-04 01:05:52', userid = 1;
UPDATE user SET loginip = "" WHERE lastactivetime < "2025-03-03 21:35:52";
UPDATE user SET loginip = "::1", lastactivetime = "2025-03-04 01:05:52", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('productCatController.php', '2025-03-04 01:05:52', '1', 'sucess', '::1', '', 'DESKTOP','https://localhost/erp/controllers/productCatController.php?do=sucess');
UPDATE user SET loginip = "" WHERE lastactivetime < "2025-03-03 21:35:54";
UPDATE user SET loginip = "::1", lastactivetime = "2025-03-04 01:05:54", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('productCatController.php', '2025-03-04 01:05:54', '1', 'show', '::1', '', 'DESKTOP','https://localhost/erp/controllers/productCatController.php?do=show');
UPDATE user SET loginip = "" WHERE lastactivetime < "2025-03-03 21:35:55";
UPDATE user SET loginip = "::1", lastactivetime = "2025-03-04 01:05:55", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('productCatController.php', '2025-03-04 01:05:55', '1', '', '::1', '', 'DESKTOP','https://localhost/erp/controllers/productCatController.php');
UPDATE user SET loginip = "" WHERE lastactivetime < "2025-03-03 21:36:04";
UPDATE user SET loginip = "::1", lastactivetime = "2025-03-04 01:06:04", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('productCatController.php', '2025-03-04 01:06:04', '1', 'add2', '::1', '', 'DESKTOP','https://localhost/erp/controllers/productCatController.php?do=add2');
INSERT INTO productcat (productCatName, productCatDate, productCatDescription, productCatParent, userId, conditions, selldiscount, buydiscount, discounttype,isOptic , buytotal , buyhalf , buypart ,buypricereal,opticServices,logo,inMenu,stopNegativeSale,catExcelid,webApiId,obygyInvestigationCatId,price4,price5,price6,price7,price8) VALUES ('شورت','2025-03-04','','0', '1','0', '0', '0', '-1', '0', '0', '0', '0','0','','.','0','0','0','0','0','0','0','0','0','0');
INSERT INTO onlinetempcategory (catid, edited, sysdate, userid)
                VALUES (5, 1,'2025-03-04 01:06:04',1)
                ON DUPLICATE KEY UPDATE catid = 5, edited = 1, sysdate = '2025-03-04 01:06:04', userid = 1;
UPDATE user SET loginip = "" WHERE lastactivetime < "2025-03-03 21:36:05";
UPDATE user SET loginip = "::1", lastactivetime = "2025-03-04 01:06:05", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('productCatController.php', '2025-03-04 01:06:05', '1', 'sucess', '::1', '', 'DESKTOP','https://localhost/erp/controllers/productCatController.php?do=sucess');
UPDATE user SET loginip = "" WHERE lastactivetime < "2025-03-03 21:36:06";
UPDATE user SET loginip = "::1", lastactivetime = "2025-03-04 01:06:07", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('productCatController.php', '2025-03-04 01:06:07', '1', 'show', '::1', '', 'DESKTOP','https://localhost/erp/controllers/productCatController.php?do=show');
UPDATE user SET loginip = "" WHERE lastactivetime < "2025-03-03 21:36:24";
UPDATE user SET loginip = "::1", lastactivetime = "2025-03-04 01:06:24", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('productController.php', '2025-03-04 01:06:24', '1', '', '::1', '', 'DESKTOP','https://localhost/erp/controllers/productController.php');
UPDATE user SET loginip = "" WHERE lastactivetime < "2025-03-03 21:41:54";
UPDATE user SET loginip = "::1", lastactivetime = "2025-03-04 01:11:54", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('productController.php', '2025-03-04 01:11:54', '1', 'add', '::1', '', 'DESKTOP','https://localhost/erp/controllers/productController.php?do=add');
BEGIN;
INSERT INTO product (productName, productDescription, productCatId, productBuyPrice, productSellAllPrice, productSellUnitPrice, productSellHalfPrice, productDate, conditions, userId, limitamount, parcode,type, expireDate, dailyentryId,isService,isOptic,lastbuyprice,lastbuyprice_withDiscount,meanbuyprice,meanbuyprice_withDiscount , productbuypricereal , buypricereal_precentage , buytotal_precentage , buyhalf_precentage , buypart_precentage,logo,inMenu,obygyDetectionId,hasSizeAndColor,overAllAveragePrice,reviewType,online,updatebyuser,proExcelid,proExcelParcode,webApiId,runquery,weightedDiscount,sortby,obygyInvestigationId,TypeOfBarcodeInTax,itemsymbol,barcodeInTax,productNameE,partNumber,vehicleType,company,weight,origin,hscode,power,ProductionDate,expiry,procode,lastbuyprice_withTax,meanbuyprice_withTax,price4,price5,price6,price7,price8,clientid,grantduration,onlinepro,minappearonline,selladdpercent,selldiscountpercent,buydiscountpercent,onlinecatid,sellpercenttype,searchfiltersid,lastbuyprice_withDiscountAndTax) VALUES ('قميص مستورد 2','','3','200','250', '250','250', '2025-03-04', '0', '1', '0', '', '0', '0', '0', '0', '0', '200','200','200','200','200','0','25','0','0','.','0','0','0','200','0','','','0','0','0','','0','0','0','GS1','','','','0','0','0','0','','0','0','','0','','200','200','0','0','0','0','0','0','0','0','0','0','0','0','-1','0','','200');
UPDATE product SET productName = 'قميص مستورد 2', productDescription = '', productCatId = '3', productBuyPrice = '200', productSellAllPrice = '250', productSellUnitPrice = '250', productSellHalfPrice = '250', productDate = '2025-03-04', conditions = '0', userId = '1', limitamount = '0', parcode = '00010',type ='0', expireDate = '0' , dailyentryId = '0',isService = '0',isOptic = '0',lastbuyprice = '200',lastbuyprice_withDiscount = '200',meanbuyprice = '200',meanbuyprice_withDiscount = '200' , productbuypricereal = '200' , buypricereal_precentage = '0' , buytotal_precentage = '25' , buyhalf_precentage = '0' , buypart_precentage = '0',logo = '.',inMenu='0', obygyDetectionId = '0',hasSizeAndColor = '0',overAllAveragePrice='200',logo1 = '',logo2 = '',logo3 = '',logo4 = '',logo5 = '',logo6 = '',logo7 = '',reviewType =null , online = '' , updatebyuser = '',webApiId='0',weightedDiscount='0',sortby=null,TypeOfBarcodeInTax='GS1',itemsymbol='',barcodeInTax='',productNameE='',partNumber='0',vehicleType='0',company='0',weight='0',origin='',hscode='0',power='0',ProductionDate='',expiry='0',procode='',lastbuyprice_withTax='200',meanbuyprice_withTax='200',price4='0',price5='0',price6='0',price7='0',price8='0',clientid='0',grantduration='0',onlinepro='0',minappearonline='0',selladdpercent='0',selldiscountpercent='0',buydiscountpercent='0',onlinecatid='-1',sellpercenttype='0',searchfiltersid='',lastbuyprice_withDiscountAndTax='200'  WHERE productId = '10';
INSERT INTO productunit (unitid, productid, productnumber, productunitdate, userid, conditions,proUnitParcode,proUnitSellAllPrice,proUnitSellHalfPrice,proUnitSellUnitPrice,proUnitBuyPrice,unitInTax,proUnitPrice4,proUnitPrice5,proUnitPrice6,proUnitPrice7,proUnitPrice8) VALUES ('1', '10', '1', '2025-03-04', '1', '0','0001001','250','250','250','200','','0','0','0','0','0');
INSERT INTO storedetail (productid, storeid, productquantity, userid, storedetaildate) VALUES ('10', '1', '0', '1', '2025-03-04');
INSERT INTO storereport (productid, storeid, productquantity, storereporttype, storereportmodelid, processname, tablename, productbefore, productafter, userid, storereportdate,sizeid,colorid) VALUES ('10', '1', '0', '0', '10', 'إضافة منتج', 'productController.php', '0', '0', '1', '2025-03-04','0','0');
INSERT INTO onlinetempproduct (productid, edited, sysdate, userid)
                VALUES (10, 1,'2025-03-04 01:11:55',1)
                ON DUPLICATE KEY UPDATE productid = 10, edited = 1, sysdate = '2025-03-04 01:11:55', userid = 1;
UPDATE product SET productName = 'قميص مستورد 2', productDescription = '', productCatId = '3', productBuyPrice = '200.00', productSellAllPrice = '250.00', productSellUnitPrice = '250.00', productSellHalfPrice = '250.00', productDate = '2025-03-04', conditions = '0', userId = '1', limitamount = '0', parcode = '00010',type ='0', expireDate = '0' , dailyentryId = '0',isService = '0',isOptic = '0',lastbuyprice = '200',lastbuyprice_withDiscount = '200',meanbuyprice = '200',meanbuyprice_withDiscount = '200' , productbuypricereal = '200' , buypricereal_precentage = '0' , buytotal_precentage = '25' , buyhalf_precentage = '0' , buypart_precentage = '0',logo = '.',inMenu='0', obygyDetectionId = '0',hasSizeAndColor = '0',overAllAveragePrice='200',logo1 = '',logo2 = '',logo3 = '',logo4 = '',logo5 = '',logo6 = '',logo7 = '',reviewType =null , online = '' , updatebyuser = '',webApiId='0',weightedDiscount='0',sortby=null,TypeOfBarcodeInTax='GS1',itemsymbol='',barcodeInTax='',productNameE='',partNumber='0',vehicleType='0',company='0',weight='0',origin='',hscode='0',power='0',ProductionDate='',expiry='0',procode='',lastbuyprice_withTax='200',meanbuyprice_withTax='200',price4='0',price5='0',price6='0',price7='0',price8='0',clientid='0',grantduration='0',onlinepro='0',minappearonline='0',selladdpercent='0',selldiscountpercent='0',buydiscountpercent='0',onlinecatid='-1',sellpercenttype='0',searchfiltersid='',lastbuyprice_withDiscountAndTax='200'  WHERE productId = '10';
INSERT INTO product (productName, productDescription, productCatId, productBuyPrice, productSellAllPrice, productSellUnitPrice, productSellHalfPrice, productDate, conditions, userId, limitamount, parcode,type, expireDate, dailyentryId,isService,isOptic,lastbuyprice,lastbuyprice_withDiscount,meanbuyprice,meanbuyprice_withDiscount , productbuypricereal , buypricereal_precentage , buytotal_precentage , buyhalf_precentage , buypart_precentage,logo,inMenu,obygyDetectionId,hasSizeAndColor,overAllAveragePrice,reviewType,online,updatebyuser,proExcelid,proExcelParcode,webApiId,runquery,weightedDiscount,sortby,obygyInvestigationId,TypeOfBarcodeInTax,itemsymbol,barcodeInTax,productNameE,partNumber,vehicleType,company,weight,origin,hscode,power,ProductionDate,expiry,procode,lastbuyprice_withTax,meanbuyprice_withTax,price4,price5,price6,price7,price8,clientid,grantduration,onlinepro,minappearonline,selladdpercent,selldiscountpercent,buydiscountpercent,onlinecatid,sellpercenttype,searchfiltersid,lastbuyprice_withDiscountAndTax) VALUES ('قميص مستورد 3','','3','255','350', '350','350', '2025-03-04', '0', '1', '0', '', '0', '0', '0', '0', '0', '255','255','255','255','255','0','37.25','0','0','.','0','0','0','255','0','','','0','0','0','','0','0','0','GS1','','','','0','0','0','0','','0','0','','0','','255','255','0','0','0','0','0','0','0','1','0','0','0','0','0','0','','255');
UPDATE product SET productName = 'قميص مستورد 3', productDescription = '', productCatId = '3', productBuyPrice = '255', productSellAllPrice = '350', productSellUnitPrice = '350', productSellHalfPrice = '350', productDate = '2025-03-04', conditions = '0', userId = '1', limitamount = '0', parcode = '00011',type ='0', expireDate = '0' , dailyentryId = '0',isService = '0',isOptic = '0',lastbuyprice = '255',lastbuyprice_withDiscount = '255',meanbuyprice = '255',meanbuyprice_withDiscount = '255' , productbuypricereal = '255' , buypricereal_precentage = '0' , buytotal_precentage = '37.25' , buyhalf_precentage = '0' , buypart_precentage = '0',logo = '.',inMenu='0', obygyDetectionId = '0',hasSizeAndColor = '0',overAllAveragePrice='255',logo1 = '',logo2 = '',logo3 = '',logo4 = '',logo5 = '',logo6 = '',logo7 = '',reviewType =null , online = '' , updatebyuser = '',webApiId='0',weightedDiscount='0',sortby=null,TypeOfBarcodeInTax='GS1',itemsymbol='',barcodeInTax='',productNameE='',partNumber='0',vehicleType='0',company='0',weight='0',origin='',hscode='0',power='0',ProductionDate='',expiry='0',procode='',lastbuyprice_withTax='255',meanbuyprice_withTax='255',price4='0',price5='0',price6='0',price7='0',price8='0',clientid='0',grantduration='0',onlinepro='1',minappearonline='0',selladdpercent='0',selldiscountpercent='0',buydiscountpercent='0',onlinecatid='0',sellpercenttype='0',searchfiltersid='',lastbuyprice_withDiscountAndTax='255'  WHERE productId = '11';
INSERT INTO productunit (unitid, productid, productnumber, productunitdate, userid, conditions,proUnitParcode,proUnitSellAllPrice,proUnitSellHalfPrice,proUnitSellUnitPrice,proUnitBuyPrice,unitInTax,proUnitPrice4,proUnitPrice5,proUnitPrice6,proUnitPrice7,proUnitPrice8) VALUES ('1', '11', '1', '2025-03-04', '1', '0','0001101','350','350','350','255','','0','0','0','0','0');
INSERT INTO storedetail (productid, storeid, productquantity, userid, storedetaildate) VALUES ('11', '1', '0', '1', '2025-03-04');
INSERT INTO storereport (productid, storeid, productquantity, storereporttype, storereportmodelid, processname, tablename, productbefore, productafter, userid, storereportdate,sizeid,colorid) VALUES ('11', '1', '0', '0', '11', 'إضافة منتج', 'productController.php', '0', '0', '1', '2025-03-04','0','0');
INSERT INTO onlinetempproduct (productid, edited, sysdate, userid)
                VALUES (11, 1,'2025-03-04 01:11:57',1)
                ON DUPLICATE KEY UPDATE productid = 11, edited = 1, sysdate = '2025-03-04 01:11:57', userid = 1;
UPDATE product SET productName = 'قميص مستورد 3', productDescription = '', productCatId = '3', productBuyPrice = '255.00', productSellAllPrice = '350.00', productSellUnitPrice = '350.00', productSellHalfPrice = '350.00', productDate = '2025-03-04', conditions = '0', userId = '1', limitamount = '0', parcode = '00011',type ='0', expireDate = '0' , dailyentryId = '0',isService = '0',isOptic = '0',lastbuyprice = '255',lastbuyprice_withDiscount = '255',meanbuyprice = '255',meanbuyprice_withDiscount = '255' , productbuypricereal = '255' , buypricereal_precentage = '0' , buytotal_precentage = '37.25' , buyhalf_precentage = '0' , buypart_precentage = '0',logo = '.',inMenu='0', obygyDetectionId = '0',hasSizeAndColor = '0',overAllAveragePrice='255',logo1 = '',logo2 = '',logo3 = '',logo4 = '',logo5 = '',logo6 = '',logo7 = '',reviewType =null , online = '' , updatebyuser = '',webApiId='0',weightedDiscount='0',sortby=null,TypeOfBarcodeInTax='GS1',itemsymbol='',barcodeInTax='',productNameE='',partNumber='0',vehicleType='0',company='0',weight='0',origin='',hscode='0',power='0',ProductionDate='',expiry='0',procode='',lastbuyprice_withTax='255',meanbuyprice_withTax='255',price4='0',price5='0',price6='0',price7='0',price8='0',clientid='0',grantduration='0',onlinepro='1',minappearonline='0',selladdpercent='0',selldiscountpercent='0',buydiscountpercent='0',onlinecatid='0',sellpercenttype='0',searchfiltersid='',lastbuyprice_withDiscountAndTax='255'  WHERE productId = '11';
INSERT INTO product (productName, productDescription, productCatId, productBuyPrice, productSellAllPrice, productSellUnitPrice, productSellHalfPrice, productDate, conditions, userId, limitamount, parcode,type, expireDate, dailyentryId,isService,isOptic,lastbuyprice,lastbuyprice_withDiscount,meanbuyprice,meanbuyprice_withDiscount , productbuypricereal , buypricereal_precentage , buytotal_precentage , buyhalf_precentage , buypart_precentage,logo,inMenu,obygyDetectionId,hasSizeAndColor,overAllAveragePrice,reviewType,online,updatebyuser,proExcelid,proExcelParcode,webApiId,runquery,weightedDiscount,sortby,obygyInvestigationId,TypeOfBarcodeInTax,itemsymbol,barcodeInTax,productNameE,partNumber,vehicleType,company,weight,origin,hscode,power,ProductionDate,expiry,procode,lastbuyprice_withTax,meanbuyprice_withTax,price4,price5,price6,price7,price8,clientid,grantduration,onlinepro,minappearonline,selladdpercent,selldiscountpercent,buydiscountpercent,onlinecatid,sellpercenttype,searchfiltersid,lastbuyprice_withDiscountAndTax) VALUES ('تيشرت au ','','3','120','150', '150','150', '2025-03-04', '0', '1', '0', '', '0', '0', '0', '0', '0', '120','120','120','120','120','0','25','0','0','.','0','0','0','120','0','','','0','0','0','','0','0','0','GS1','','','','0','0','0','0','','0','0','','0','','120','120','0','0','0','0','0','0','0','1','0','0','0','0','0','0','','120');
UPDATE product SET productName = 'تيشرت au ', productDescription = '', productCatId = '3', productBuyPrice = '120', productSellAllPrice = '150', productSellUnitPrice = '150', productSellHalfPrice = '150', productDate = '2025-03-04', conditions = '0', userId = '1', limitamount = '0', parcode = '00012',type ='0', expireDate = '0' , dailyentryId = '0',isService = '0',isOptic = '0',lastbuyprice = '120',lastbuyprice_withDiscount = '120',meanbuyprice = '120',meanbuyprice_withDiscount = '120' , productbuypricereal = '120' , buypricereal_precentage = '0' , buytotal_precentage = '25' , buyhalf_precentage = '0' , buypart_precentage = '0',logo = '.',inMenu='0', obygyDetectionId = '0',hasSizeAndColor = '0',overAllAveragePrice='120',logo1 = '',logo2 = '',logo3 = '',logo4 = '',logo5 = '',logo6 = '',logo7 = '',reviewType =null , online = '' , updatebyuser = '',webApiId='0',weightedDiscount='0',sortby=null,TypeOfBarcodeInTax='GS1',itemsymbol='',barcodeInTax='',productNameE='',partNumber='0',vehicleType='0',company='0',weight='0',origin='',hscode='0',power='0',ProductionDate='',expiry='0',procode='',lastbuyprice_withTax='120',meanbuyprice_withTax='120',price4='0',price5='0',price6='0',price7='0',price8='0',clientid='0',grantduration='0',onlinepro='1',minappearonline='0',selladdpercent='0',selldiscountpercent='0',buydiscountpercent='0',onlinecatid='0',sellpercenttype='0',searchfiltersid='',lastbuyprice_withDiscountAndTax='120'  WHERE productId = '12';
INSERT INTO productunit (unitid, productid, productnumber, productunitdate, userid, conditions,proUnitParcode,proUnitSellAllPrice,proUnitSellHalfPrice,proUnitSellUnitPrice,proUnitBuyPrice,unitInTax,proUnitPrice4,proUnitPrice5,proUnitPrice6,proUnitPrice7,proUnitPrice8) VALUES ('1', '12', '1', '2025-03-04', '1', '0','0001201','150','150','150','120','','0','0','0','0','0');
INSERT INTO storedetail (productid, storeid, productquantity, userid, storedetaildate) VALUES ('12', '1', '0', '1', '2025-03-04');
INSERT INTO storereport (productid, storeid, productquantity, storereporttype, storereportmodelid, processname, tablename, productbefore, productafter, userid, storereportdate,sizeid,colorid) VALUES ('12', '1', '0', '0', '12', 'إضافة منتج', 'productController.php', '0', '0', '1', '2025-03-04','0','0');
INSERT INTO onlinetempproduct (productid, edited, sysdate, userid)
                VALUES (12, 1,'2025-03-04 01:11:58',1)
                ON DUPLICATE KEY UPDATE productid = 12, edited = 1, sysdate = '2025-03-04 01:11:58', userid = 1;
UPDATE product SET productName = 'تيشرت au ', productDescription = '', productCatId = '3', productBuyPrice = '120.00', productSellAllPrice = '150.00', productSellUnitPrice = '150.00', productSellHalfPrice = '150.00', productDate = '2025-03-04', conditions = '0', userId = '1', limitamount = '0', parcode = '00012',type ='0', expireDate = '0' , dailyentryId = '0',isService = '0',isOptic = '0',lastbuyprice = '120',lastbuyprice_withDiscount = '120',meanbuyprice = '120',meanbuyprice_withDiscount = '120' , productbuypricereal = '120' , buypricereal_precentage = '0' , buytotal_precentage = '25' , buyhalf_precentage = '0' , buypart_precentage = '0',logo = '.',inMenu='0', obygyDetectionId = '0',hasSizeAndColor = '0',overAllAveragePrice='120',logo1 = '',logo2 = '',logo3 = '',logo4 = '',logo5 = '',logo6 = '',logo7 = '',reviewType =null , online = '' , updatebyuser = '',webApiId='0',weightedDiscount='0',sortby=null,TypeOfBarcodeInTax='GS1',itemsymbol='',barcodeInTax='',productNameE='',partNumber='0',vehicleType='0',company='0',weight='0',origin='',hscode='0',power='0',ProductionDate='',expiry='0',procode='',lastbuyprice_withTax='120',meanbuyprice_withTax='120',price4='0',price5='0',price6='0',price7='0',price8='0',clientid='0',grantduration='0',onlinepro='1',minappearonline='0',selladdpercent='0',selldiscountpercent='0',buydiscountpercent='0',onlinecatid='0',sellpercenttype='0',searchfiltersid='',lastbuyprice_withDiscountAndTax='120'  WHERE productId = '12';
INSERT INTO product (productName, productDescription, productCatId, productBuyPrice, productSellAllPrice, productSellUnitPrice, productSellHalfPrice, productDate, conditions, userId, limitamount, parcode,type, expireDate, dailyentryId,isService,isOptic,lastbuyprice,lastbuyprice_withDiscount,meanbuyprice,meanbuyprice_withDiscount , productbuypricereal , buypricereal_precentage , buytotal_precentage , buyhalf_precentage , buypart_precentage,logo,inMenu,obygyDetectionId,hasSizeAndColor,overAllAveragePrice,reviewType,online,updatebyuser,proExcelid,proExcelParcode,webApiId,runquery,weightedDiscount,sortby,obygyInvestigationId,TypeOfBarcodeInTax,itemsymbol,barcodeInTax,productNameE,partNumber,vehicleType,company,weight,origin,hscode,power,ProductionDate,expiry,procode,lastbuyprice_withTax,meanbuyprice_withTax,price4,price5,price6,price7,price8,clientid,grantduration,onlinepro,minappearonline,selladdpercent,selldiscountpercent,buydiscountpercent,onlinecatid,sellpercenttype,searchfiltersid,lastbuyprice_withDiscountAndTax) VALUES ('تيشرت تايسون ','','3','160','200', '200','200', '2025-03-04', '0', '1', '0', '', '0', '0', '0', '0', '0', '160','160','160','160','160','0','25','0','0','.','0','0','0','160','0','','','0','0','0','','0','0','0','GS1','','','','0','0','0','0','','0','0','','0','','160','160','0','0','0','0','0','0','0','1','0','0','0','0','0','0','','160');
UPDATE product SET productName = 'تيشرت تايسون ', productDescription = '', productCatId = '3', productBuyPrice = '160', productSellAllPrice = '200', productSellUnitPrice = '200', productSellHalfPrice = '200', productDate = '2025-03-04', conditions = '0', userId = '1', limitamount = '0', parcode = '00013',type ='0', expireDate = '0' , dailyentryId = '0',isService = '0',isOptic = '0',lastbuyprice = '160',lastbuyprice_withDiscount = '160',meanbuyprice = '160',meanbuyprice_withDiscount = '160' , productbuypricereal = '160' , buypricereal_precentage = '0' , buytotal_precentage = '25' , buyhalf_precentage = '0' , buypart_precentage = '0',logo = '.',inMenu='0', obygyDetectionId = '0',hasSizeAndColor = '0',overAllAveragePrice='160',logo1 = '',logo2 = '',logo3 = '',logo4 = '',logo5 = '',logo6 = '',logo7 = '',reviewType =null , online = '' , updatebyuser = '',webApiId='0',weightedDiscount='0',sortby=null,TypeOfBarcodeInTax='GS1',itemsymbol='',barcodeInTax='',productNameE='',partNumber='0',vehicleType='0',company='0',weight='0',origin='',hscode='0',power='0',ProductionDate='',expiry='0',procode='',lastbuyprice_withTax='160',meanbuyprice_withTax='160',price4='0',price5='0',price6='0',price7='0',price8='0',clientid='0',grantduration='0',onlinepro='1',minappearonline='0',selladdpercent='0',selldiscountpercent='0',buydiscountpercent='0',onlinecatid='0',sellpercenttype='0',searchfiltersid='',lastbuyprice_withDiscountAndTax='160'  WHERE productId = '13';
INSERT INTO productunit (unitid, productid, productnumber, productunitdate, userid, conditions,proUnitParcode,proUnitSellAllPrice,proUnitSellHalfPrice,proUnitSellUnitPrice,proUnitBuyPrice,unitInTax,proUnitPrice4,proUnitPrice5,proUnitPrice6,proUnitPrice7,proUnitPrice8) VALUES ('1', '13', '1', '2025-03-04', '1', '0','0001301','200','200','200','160','','0','0','0','0','0');
INSERT INTO storedetail (productid, storeid, productquantity, userid, storedetaildate) VALUES ('13', '1', '0', '1', '2025-03-04');
INSERT INTO storereport (productid, storeid, productquantity, storereporttype, storereportmodelid, processname, tablename, productbefore, productafter, userid, storereportdate,sizeid,colorid) VALUES ('13', '1', '0', '0', '13', 'إضافة منتج', 'productController.php', '0', '0', '1', '2025-03-04','0','0');
INSERT INTO onlinetempproduct (productid, edited, sysdate, userid)
                VALUES (13, 1,'2025-03-04 01:11:59',1)
                ON DUPLICATE KEY UPDATE productid = 13, edited = 1, sysdate = '2025-03-04 01:11:59', userid = 1;
UPDATE product SET productName = 'تيشرت تايسون ', productDescription = '', productCatId = '3', productBuyPrice = '160.00', productSellAllPrice = '200.00', productSellUnitPrice = '200.00', productSellHalfPrice = '200.00', productDate = '2025-03-04', conditions = '0', userId = '1', limitamount = '0', parcode = '00013',type ='0', expireDate = '0' , dailyentryId = '0',isService = '0',isOptic = '0',lastbuyprice = '160',lastbuyprice_withDiscount = '160',meanbuyprice = '160',meanbuyprice_withDiscount = '160' , productbuypricereal = '160' , buypricereal_precentage = '0' , buytotal_precentage = '25' , buyhalf_precentage = '0' , buypart_precentage = '0',logo = '.',inMenu='0', obygyDetectionId = '0',hasSizeAndColor = '0',overAllAveragePrice='160',logo1 = '',logo2 = '',logo3 = '',logo4 = '',logo5 = '',logo6 = '',logo7 = '',reviewType =null , online = '' , updatebyuser = '',webApiId='0',weightedDiscount='0',sortby=null,TypeOfBarcodeInTax='GS1',itemsymbol='',barcodeInTax='',productNameE='',partNumber='0',vehicleType='0',company='0',weight='0',origin='',hscode='0',power='0',ProductionDate='',expiry='0',procode='',lastbuyprice_withTax='160',meanbuyprice_withTax='160',price4='0',price5='0',price6='0',price7='0',price8='0',clientid='0',grantduration='0',onlinepro='1',minappearonline='0',selladdpercent='0',selldiscountpercent='0',buydiscountpercent='0',onlinecatid='0',sellpercenttype='0',searchfiltersid='',lastbuyprice_withDiscountAndTax='160'  WHERE productId = '13';
INSERT INTO product (productName, productDescription, productCatId, productBuyPrice, productSellAllPrice, productSellUnitPrice, productSellHalfPrice, productDate, conditions, userId, limitamount, parcode,type, expireDate, dailyentryId,isService,isOptic,lastbuyprice,lastbuyprice_withDiscount,meanbuyprice,meanbuyprice_withDiscount , productbuypricereal , buypricereal_precentage , buytotal_precentage , buyhalf_precentage , buypart_precentage,logo,inMenu,obygyDetectionId,hasSizeAndColor,overAllAveragePrice,reviewType,online,updatebyuser,proExcelid,proExcelParcode,webApiId,runquery,weightedDiscount,sortby,obygyInvestigationId,TypeOfBarcodeInTax,itemsymbol,barcodeInTax,productNameE,partNumber,vehicleType,company,weight,origin,hscode,power,ProductionDate,expiry,procode,lastbuyprice_withTax,meanbuyprice_withTax,price4,price5,price6,price7,price8,clientid,grantduration,onlinepro,minappearonline,selladdpercent,selldiscountpercent,buydiscountpercent,onlinecatid,sellpercenttype,searchfiltersid,lastbuyprice_withDiscountAndTax) VALUES ('تيشرت عرض 250','','3','178','250', '250','250', '2025-03-04', '0', '1', '0', '', '0', '0', '0', '0', '0', '178','178','178','178','178','0','40.45','0','0','.','0','0','0','178','0','','','0','0','0','','0','0','0','GS1','','','','0','0','0','0','','0','0','','0','','178','178','0','0','0','0','0','0','0','1','0','0','0','0','0','0','','178');
UPDATE product SET productName = 'تيشرت عرض 250', productDescription = '', productCatId = '3', productBuyPrice = '178', productSellAllPrice = '250', productSellUnitPrice = '250', productSellHalfPrice = '250', productDate = '2025-03-04', conditions = '0', userId = '1', limitamount = '0', parcode = '00014',type ='0', expireDate = '0' , dailyentryId = '0',isService = '0',isOptic = '0',lastbuyprice = '178',lastbuyprice_withDiscount = '178',meanbuyprice = '178',meanbuyprice_withDiscount = '178' , productbuypricereal = '178' , buypricereal_precentage = '0' , buytotal_precentage = '40.45' , buyhalf_precentage = '0' , buypart_precentage = '0',logo = '.',inMenu='0', obygyDetectionId = '0',hasSizeAndColor = '0',overAllAveragePrice='178',logo1 = '',logo2 = '',logo3 = '',logo4 = '',logo5 = '',logo6 = '',logo7 = '',reviewType =null , online = '' , updatebyuser = '',webApiId='0',weightedDiscount='0',sortby=null,TypeOfBarcodeInTax='GS1',itemsymbol='',barcodeInTax='',productNameE='',partNumber='0',vehicleType='0',company='0',weight='0',origin='',hscode='0',power='0',ProductionDate='',expiry='0',procode='',lastbuyprice_withTax='178',meanbuyprice_withTax='178',price4='0',price5='0',price6='0',price7='0',price8='0',clientid='0',grantduration='0',onlinepro='1',minappearonline='0',selladdpercent='0',selldiscountpercent='0',buydiscountpercent='0',onlinecatid='0',sellpercenttype='0',searchfiltersid='',lastbuyprice_withDiscountAndTax='178'  WHERE productId = '14';
INSERT INTO productunit (unitid, productid, productnumber, productunitdate, userid, conditions,proUnitParcode,proUnitSellAllPrice,proUnitSellHalfPrice,proUnitSellUnitPrice,proUnitBuyPrice,unitInTax,proUnitPrice4,proUnitPrice5,proUnitPrice6,proUnitPrice7,proUnitPrice8) VALUES ('1', '14', '1', '2025-03-04', '1', '0','0001401','250','250','250','178','','0','0','0','0','0');
INSERT INTO storedetail (productid, storeid, productquantity, userid, storedetaildate) VALUES ('14', '1', '0', '1', '2025-03-04');
INSERT INTO storereport (productid, storeid, productquantity, storereporttype, storereportmodelid, processname, tablename, productbefore, productafter, userid, storereportdate,sizeid,colorid) VALUES ('14', '1', '0', '0', '14', 'إضافة منتج', 'productController.php', '0', '0', '1', '2025-03-04','0','0');
INSERT INTO onlinetempproduct (productid, edited, sysdate, userid)
                VALUES (14, 1,'2025-03-04 01:12:00',1)
                ON DUPLICATE KEY UPDATE productid = 14, edited = 1, sysdate = '2025-03-04 01:12:00', userid = 1;
UPDATE product SET productName = 'تيشرت عرض 250', productDescription = '', productCatId = '3', productBuyPrice = '178.00', productSellAllPrice = '250.00', productSellUnitPrice = '250.00', productSellHalfPrice = '250.00', productDate = '2025-03-04', conditions = '0', userId = '1', limitamount = '0', parcode = '00014',type ='0', expireDate = '0' , dailyentryId = '0',isService = '0',isOptic = '0',lastbuyprice = '178',lastbuyprice_withDiscount = '178',meanbuyprice = '178',meanbuyprice_withDiscount = '178' , productbuypricereal = '178' , buypricereal_precentage = '0' , buytotal_precentage = '40.45' , buyhalf_precentage = '0' , buypart_precentage = '0',logo = '.',inMenu='0', obygyDetectionId = '0',hasSizeAndColor = '0',overAllAveragePrice='178',logo1 = '',logo2 = '',logo3 = '',logo4 = '',logo5 = '',logo6 = '',logo7 = '',reviewType =null , online = '' , updatebyuser = '',webApiId='0',weightedDiscount='0',sortby=null,TypeOfBarcodeInTax='GS1',itemsymbol='',barcodeInTax='',productNameE='',partNumber='0',vehicleType='0',company='0',weight='0',origin='',hscode='0',power='0',ProductionDate='',expiry='0',procode='',lastbuyprice_withTax='178',meanbuyprice_withTax='178',price4='0',price5='0',price6='0',price7='0',price8='0',clientid='0',grantduration='0',onlinepro='1',minappearonline='0',selladdpercent='0',selldiscountpercent='0',buydiscountpercent='0',onlinecatid='0',sellpercenttype='0',searchfiltersid='',lastbuyprice_withDiscountAndTax='178'  WHERE productId = '14';
INSERT INTO product (productName, productDescription, productCatId, productBuyPrice, productSellAllPrice, productSellUnitPrice, productSellHalfPrice, productDate, conditions, userId, limitamount, parcode,type, expireDate, dailyentryId,isService,isOptic,lastbuyprice,lastbuyprice_withDiscount,meanbuyprice,meanbuyprice_withDiscount , productbuypricereal , buypricereal_precentage , buytotal_precentage , buyhalf_precentage , buypart_precentage,logo,inMenu,obygyDetectionId,hasSizeAndColor,overAllAveragePrice,reviewType,online,updatebyuser,proExcelid,proExcelParcode,webApiId,runquery,weightedDiscount,sortby,obygyInvestigationId,TypeOfBarcodeInTax,itemsymbol,barcodeInTax,productNameE,partNumber,vehicleType,company,weight,origin,hscode,power,ProductionDate,expiry,procode,lastbuyprice_withTax,meanbuyprice_withTax,price4,price5,price6,price7,price8,clientid,grantduration,onlinepro,minappearonline,selladdpercent,selldiscountpercent,buydiscountpercent,onlinecatid,sellpercenttype,searchfiltersid,lastbuyprice_withDiscountAndTax) VALUES ('تيشرت عرض 350              ','','3','255','350', '350','350', '2025-03-04', '0', '1', '0', '', '0', '0', '0', '0', '0', '255','255','255','255','255','0','37.25','0','0','.','0','0','0','255','0','','','0','0','0','','0','0','0','GS1','','','','0','0','0','0','','0','0','','0','','255','255','0','0','0','0','0','0','0','1','0','0','0','0','0','0','','255');
UPDATE product SET productName = 'تيشرت عرض 350              ', productDescription = '', productCatId = '3', productBuyPrice = '255', productSellAllPrice = '350', productSellUnitPrice = '350', productSellHalfPrice = '350', productDate = '2025-03-04', conditions = '0', userId = '1', limitamount = '0', parcode = '00015',type ='0', expireDate = '0' , dailyentryId = '0',isService = '0',isOptic = '0',lastbuyprice = '255',lastbuyprice_withDiscount = '255',meanbuyprice = '255',meanbuyprice_withDiscount = '255' , productbuypricereal = '255' , buypricereal_precentage = '0' , buytotal_precentage = '37.25' , buyhalf_precentage = '0' , buypart_precentage = '0',logo = '.',inMenu='0', obygyDetectionId = '0',hasSizeAndColor = '0',overAllAveragePrice='255',logo1 = '',logo2 = '',logo3 = '',logo4 = '',logo5 = '',logo6 = '',logo7 = '',reviewType =null , online = '' , updatebyuser = '',webApiId='0',weightedDiscount='0',sortby=null,TypeOfBarcodeInTax='GS1',itemsymbol='',barcodeInTax='',productNameE='',partNumber='0',vehicleType='0',company='0',weight='0',origin='',hscode='0',power='0',ProductionDate='',expiry='0',procode='',lastbuyprice_withTax='255',meanbuyprice_withTax='255',price4='0',price5='0',price6='0',price7='0',price8='0',clientid='0',grantduration='0',onlinepro='1',minappearonline='0',selladdpercent='0',selldiscountpercent='0',buydiscountpercent='0',onlinecatid='0',sellpercenttype='0',searchfiltersid='',lastbuyprice_withDiscountAndTax='255'  WHERE productId = '15';
INSERT INTO productunit (unitid, productid, productnumber, productunitdate, userid, conditions,proUnitParcode,proUnitSellAllPrice,proUnitSellHalfPrice,proUnitSellUnitPrice,proUnitBuyPrice,unitInTax,proUnitPrice4,proUnitPrice5,proUnitPrice6,proUnitPrice7,proUnitPrice8) VALUES ('1', '15', '1', '2025-03-04', '1', '0','0001501','350','350','350','255','','0','0','0','0','0');
INSERT INTO storedetail (productid, storeid, productquantity, userid, storedetaildate) VALUES ('15', '1', '0', '1', '2025-03-04');
INSERT INTO storereport (productid, storeid, productquantity, storereporttype, storereportmodelid, processname, tablename, productbefore, productafter, userid, storereportdate,sizeid,colorid) VALUES ('15', '1', '0', '0', '15', 'إضافة منتج', 'productController.php', '0', '0', '1', '2025-03-04','0','0');
INSERT INTO onlinetempproduct (productid, edited, sysdate, userid)
                VALUES (15, 1,'2025-03-04 01:12:00',1)
                ON DUPLICATE KEY UPDATE productid = 15, edited = 1, sysdate = '2025-03-04 01:12:00', userid = 1;
UPDATE product SET productName = 'تيشرت عرض 350              ', productDescription = '', productCatId = '3', productBuyPrice = '255.00', productSellAllPrice = '350.00', productSellUnitPrice = '350.00', productSellHalfPrice = '350.00', productDate = '2025-03-04', conditions = '0', userId = '1', limitamount = '0', parcode = '00015',type ='0', expireDate = '0' , dailyentryId = '0',isService = '0',isOptic = '0',lastbuyprice = '255',lastbuyprice_withDiscount = '255',meanbuyprice = '255',meanbuyprice_withDiscount = '255' , productbuypricereal = '255' , buypricereal_precentage = '0' , buytotal_precentage = '37.25' , buyhalf_precentage = '0' , buypart_precentage = '0',logo = '.',inMenu='0', obygyDetectionId = '0',hasSizeAndColor = '0',overAllAveragePrice='255',logo1 = '',logo2 = '',logo3 = '',logo4 = '',logo5 = '',logo6 = '',logo7 = '',reviewType =null , online = '' , updatebyuser = '',webApiId='0',weightedDiscount='0',sortby=null,TypeOfBarcodeInTax='GS1',itemsymbol='',barcodeInTax='',productNameE='',partNumber='0',vehicleType='0',company='0',weight='0',origin='',hscode='0',power='0',ProductionDate='',expiry='0',procode='',lastbuyprice_withTax='255',meanbuyprice_withTax='255',price4='0',price5='0',price6='0',price7='0',price8='0',clientid='0',grantduration='0',onlinepro='1',minappearonline='0',selladdpercent='0',selldiscountpercent='0',buydiscountpercent='0',onlinecatid='0',sellpercenttype='0',searchfiltersid='',lastbuyprice_withDiscountAndTax='255'  WHERE productId = '15';
COMMIT;
UPDATE user SET loginip = "" WHERE lastactivetime < "2025-03-03 21:42:02";
UPDATE user SET loginip = "::1", lastactivetime = "2025-03-04 01:12:02", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('productController.php', '2025-03-04 01:12:02', '1', '', '::1', '', 'DESKTOP','https://localhost/erp/controllers/productController.php');
UPDATE user SET loginip = "" WHERE lastactivetime < "2025-03-03 21:42:03";
UPDATE user SET loginip = "::1", lastactivetime = "2025-03-04 01:12:03", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('productController.php', '2025-03-04 01:12:03', '1', '', '::1', '', 'DESKTOP','https://localhost/erp/controllers/productController.php');
UPDATE user SET loginip = "" WHERE lastactivetime < "2025-03-03 21:42:25";
UPDATE user SET loginip = "::1", lastactivetime = "2025-03-04 01:12:25", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('productController.php', '2025-03-04 01:12:25', '1', 'add', '::1', '', 'DESKTOP','https://localhost/erp/controllers/productController.php?do=add');
BEGIN;
INSERT INTO product (productName, productDescription, productCatId, productBuyPrice, productSellAllPrice, productSellUnitPrice, productSellHalfPrice, productDate, conditions, userId, limitamount, parcode,type, expireDate, dailyentryId,isService,isOptic,lastbuyprice,lastbuyprice_withDiscount,meanbuyprice,meanbuyprice_withDiscount , productbuypricereal , buypricereal_precentage , buytotal_precentage , buyhalf_precentage , buypart_precentage,logo,inMenu,obygyDetectionId,hasSizeAndColor,overAllAveragePrice,reviewType,online,updatebyuser,proExcelid,proExcelParcode,webApiId,runquery,weightedDiscount,sortby,obygyInvestigationId,TypeOfBarcodeInTax,itemsymbol,barcodeInTax,productNameE,partNumber,vehicleType,company,weight,origin,hscode,power,ProductionDate,expiry,procode,lastbuyprice_withTax,meanbuyprice_withTax,price4,price5,price6,price7,price8,clientid,grantduration,onlinepro,minappearonline,selladdpercent,selldiscountpercent,buydiscountpercent,onlinecatid,sellpercenttype,searchfiltersid,lastbuyprice_withDiscountAndTax) VALUES ('تيشرت بسكوته ','','4','65','100', '100','100', '2025-03-04', '0', '1', '0', '', '0', '0', '0', '0', '0', '65','65','65','65','65','0','53.85','0','0','.','0','0','0','65','0','','','0','0','0','','0','0','0','GS1','','','','0','0','0','0','','0','0','','0','','65','65','0','0','0','0','0','0','0','0','0','0','0','0','-1','0','','65');
UPDATE product SET productName = 'تيشرت بسكوته ', productDescription = '', productCatId = '4', productBuyPrice = '65', productSellAllPrice = '100', productSellUnitPrice = '100', productSellHalfPrice = '100', productDate = '2025-03-04', conditions = '0', userId = '1', limitamount = '0', parcode = '00016',type ='0', expireDate = '0' , dailyentryId = '0',isService = '0',isOptic = '0',lastbuyprice = '65',lastbuyprice_withDiscount = '65',meanbuyprice = '65',meanbuyprice_withDiscount = '65' , productbuypricereal = '65' , buypricereal_precentage = '0' , buytotal_precentage = '53.85' , buyhalf_precentage = '0' , buypart_precentage = '0',logo = '.',inMenu='0', obygyDetectionId = '0',hasSizeAndColor = '0',overAllAveragePrice='65',logo1 = '',logo2 = '',logo3 = '',logo4 = '',logo5 = '',logo6 = '',logo7 = '',reviewType =null , online = '' , updatebyuser = '',webApiId='0',weightedDiscount='0',sortby=null,TypeOfBarcodeInTax='GS1',itemsymbol='',barcodeInTax='',productNameE='',partNumber='0',vehicleType='0',company='0',weight='0',origin='',hscode='0',power='0',ProductionDate='',expiry='0',procode='',lastbuyprice_withTax='65',meanbuyprice_withTax='65',price4='0',price5='0',price6='0',price7='0',price8='0',clientid='0',grantduration='0',onlinepro='0',minappearonline='0',selladdpercent='0',selldiscountpercent='0',buydiscountpercent='0',onlinecatid='-1',sellpercenttype='0',searchfiltersid='',lastbuyprice_withDiscountAndTax='65'  WHERE productId = '16';
INSERT INTO productunit (unitid, productid, productnumber, productunitdate, userid, conditions,proUnitParcode,proUnitSellAllPrice,proUnitSellHalfPrice,proUnitSellUnitPrice,proUnitBuyPrice,unitInTax,proUnitPrice4,proUnitPrice5,proUnitPrice6,proUnitPrice7,proUnitPrice8) VALUES ('1', '16', '1', '2025-03-04', '1', '0','0001601','100','100','100','65','','0','0','0','0','0');
INSERT INTO storedetail (productid, storeid, productquantity, userid, storedetaildate) VALUES ('16', '1', '0', '1', '2025-03-04');
INSERT INTO storereport (productid, storeid, productquantity, storereporttype, storereportmodelid, processname, tablename, productbefore, productafter, userid, storereportdate,sizeid,colorid) VALUES ('16', '1', '0', '0', '16', 'إضافة منتج', 'productController.php', '0', '0', '1', '2025-03-04','0','0');
INSERT INTO onlinetempproduct (productid, edited, sysdate, userid)
                VALUES (16, 1,'2025-03-04 01:12:26',1)
                ON DUPLICATE KEY UPDATE productid = 16, edited = 1, sysdate = '2025-03-04 01:12:26', userid = 1;
UPDATE product SET productName = 'تيشرت بسكوته ', productDescription = '', productCatId = '4', productBuyPrice = '65.00', productSellAllPrice = '100.00', productSellUnitPrice = '100.00', productSellHalfPrice = '100.00', productDate = '2025-03-04', conditions = '0', userId = '1', limitamount = '0', parcode = '00016',type ='0', expireDate = '0' , dailyentryId = '0',isService = '0',isOptic = '0',lastbuyprice = '65',lastbuyprice_withDiscount = '65',meanbuyprice = '65',meanbuyprice_withDiscount = '65' , productbuypricereal = '65' , buypricereal_precentage = '0' , buytotal_precentage = '53.85' , buyhalf_precentage = '0' , buypart_precentage = '0',logo = '.',inMenu='0', obygyDetectionId = '0',hasSizeAndColor = '0',overAllAveragePrice='65',logo1 = '',logo2 = '',logo3 = '',logo4 = '',logo5 = '',logo6 = '',logo7 = '',reviewType =null , online = '' , updatebyuser = '',webApiId='0',weightedDiscount='0',sortby=null,TypeOfBarcodeInTax='GS1',itemsymbol='',barcodeInTax='',productNameE='',partNumber='0',vehicleType='0',company='0',weight='0',origin='',hscode='0',power='0',ProductionDate='',expiry='0',procode='',lastbuyprice_withTax='65',meanbuyprice_withTax='65',price4='0',price5='0',price6='0',price7='0',price8='0',clientid='0',grantduration='0',onlinepro='0',minappearonline='0',selladdpercent='0',selldiscountpercent='0',buydiscountpercent='0',onlinecatid='-1',sellpercenttype='0',searchfiltersid='',lastbuyprice_withDiscountAndTax='65'  WHERE productId = '16';
COMMIT;
UPDATE user SET loginip = "" WHERE lastactivetime < "2025-03-03 21:42:28";
UPDATE user SET loginip = "::1", lastactivetime = "2025-03-04 01:12:28", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('productController.php', '2025-03-04 01:12:28', '1', '', '::1', '', 'DESKTOP','https://localhost/erp/controllers/productController.php');
UPDATE user SET loginip = "" WHERE lastactivetime < "2025-03-03 21:43:55";
UPDATE user SET loginip = "::1", lastactivetime = "2025-03-04 01:13:55", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('productController.php', '2025-03-04 01:13:55', '1', '', '::1', '', 'DESKTOP','https://localhost/erp/controllers/productController.php');
UPDATE user SET loginip = "" WHERE lastactivetime < "2025-03-03 21:47:07";
UPDATE user SET loginip = "::1", lastactivetime = "2025-03-04 01:17:07", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('productController.php', '2025-03-04 01:17:07', '1', 'add', '::1', '', 'DESKTOP','https://localhost/erp/controllers/productController.php?do=add');
BEGIN;
INSERT INTO product (productName, productDescription, productCatId, productBuyPrice, productSellAllPrice, productSellUnitPrice, productSellHalfPrice, productDate, conditions, userId, limitamount, parcode,type, expireDate, dailyentryId,isService,isOptic,lastbuyprice,lastbuyprice_withDiscount,meanbuyprice,meanbuyprice_withDiscount , productbuypricereal , buypricereal_precentage , buytotal_precentage , buyhalf_precentage , buypart_precentage,logo,inMenu,obygyDetectionId,hasSizeAndColor,overAllAveragePrice,reviewType,online,updatebyuser,proExcelid,proExcelParcode,webApiId,runquery,weightedDiscount,sortby,obygyInvestigationId,TypeOfBarcodeInTax,itemsymbol,barcodeInTax,productNameE,partNumber,vehicleType,company,weight,origin,hscode,power,ProductionDate,expiry,procode,lastbuyprice_withTax,meanbuyprice_withTax,price4,price5,price6,price7,price8,clientid,grantduration,onlinepro,minappearonline,selladdpercent,selldiscountpercent,buydiscountpercent,onlinecatid,sellpercenttype,searchfiltersid,lastbuyprice_withDiscountAndTax) VALUES ('قميص عرض 1','','3','95','150', '150','150', '2025-03-04', '0', '1', '0', '', '0', '0', '0', '0', '0', '95','95','95','95','95','0','57.89','0','0','.','0','0','0','95','0','','','0','0','0','','0','0','0','GS1','','','','0','0','0','0','','0','0','','0','','95','95','0','0','0','0','0','0','0','0','0','0','0','0','-1','0','','95');
UPDATE product SET productName = 'قميص عرض 1', productDescription = '', productCatId = '3', productBuyPrice = '95', productSellAllPrice = '150', productSellUnitPrice = '150', productSellHalfPrice = '150', productDate = '2025-03-04', conditions = '0', userId = '1', limitamount = '0', parcode = '00017',type ='0', expireDate = '0' , dailyentryId = '0',isService = '0',isOptic = '0',lastbuyprice = '95',lastbuyprice_withDiscount = '95',meanbuyprice = '95',meanbuyprice_withDiscount = '95' , productbuypricereal = '95' , buypricereal_precentage = '0' , buytotal_precentage = '57.89' , buyhalf_precentage = '0' , buypart_precentage = '0',logo = '.',inMenu='0', obygyDetectionId = '0',hasSizeAndColor = '0',overAllAveragePrice='95',logo1 = '',logo2 = '',logo3 = '',logo4 = '',logo5 = '',logo6 = '',logo7 = '',reviewType =null , online = '' , updatebyuser = '',webApiId='0',weightedDiscount='0',sortby=null,TypeOfBarcodeInTax='GS1',itemsymbol='',barcodeInTax='',productNameE='',partNumber='0',vehicleType='0',company='0',weight='0',origin='',hscode='0',power='0',ProductionDate='',expiry='0',procode='',lastbuyprice_withTax='95',meanbuyprice_withTax='95',price4='0',price5='0',price6='0',price7='0',price8='0',clientid='0',grantduration='0',onlinepro='0',minappearonline='0',selladdpercent='0',selldiscountpercent='0',buydiscountpercent='0',onlinecatid='-1',sellpercenttype='0',searchfiltersid='',lastbuyprice_withDiscountAndTax='95'  WHERE productId = '17';
INSERT INTO productunit (unitid, productid, productnumber, productunitdate, userid, conditions,proUnitParcode,proUnitSellAllPrice,proUnitSellHalfPrice,proUnitSellUnitPrice,proUnitBuyPrice,unitInTax,proUnitPrice4,proUnitPrice5,proUnitPrice6,proUnitPrice7,proUnitPrice8) VALUES ('1', '17', '1', '2025-03-04', '1', '0','0001701','150','150','150','95','','0','0','0','0','0');
INSERT INTO storedetail (productid, storeid, productquantity, userid, storedetaildate) VALUES ('17', '1', '0', '1', '2025-03-04');
INSERT INTO storereport (productid, storeid, productquantity, storereporttype, storereportmodelid, processname, tablename, productbefore, productafter, userid, storereportdate,sizeid,colorid) VALUES ('17', '1', '0', '0', '17', 'إضافة منتج', 'productController.php', '0', '0', '1', '2025-03-04','0','0');
INSERT INTO onlinetempproduct (productid, edited, sysdate, userid)
                VALUES (17, 1,'2025-03-04 01:17:08',1)
                ON DUPLICATE KEY UPDATE productid = 17, edited = 1, sysdate = '2025-03-04 01:17:08', userid = 1;
UPDATE product SET productName = 'قميص عرض 1', productDescription = '', productCatId = '3', productBuyPrice = '95.00', productSellAllPrice = '150.00', productSellUnitPrice = '150.00', productSellHalfPrice = '150.00', productDate = '2025-03-04', conditions = '0', userId = '1', limitamount = '0', parcode = '00017',type ='0', expireDate = '0' , dailyentryId = '0',isService = '0',isOptic = '0',lastbuyprice = '95',lastbuyprice_withDiscount = '95',meanbuyprice = '95',meanbuyprice_withDiscount = '95' , productbuypricereal = '95' , buypricereal_precentage = '0' , buytotal_precentage = '57.89' , buyhalf_precentage = '0' , buypart_precentage = '0',logo = '.',inMenu='0', obygyDetectionId = '0',hasSizeAndColor = '0',overAllAveragePrice='95',logo1 = '',logo2 = '',logo3 = '',logo4 = '',logo5 = '',logo6 = '',logo7 = '',reviewType =null , online = '' , updatebyuser = '',webApiId='0',weightedDiscount='0',sortby=null,TypeOfBarcodeInTax='GS1',itemsymbol='',barcodeInTax='',productNameE='',partNumber='0',vehicleType='0',company='0',weight='0',origin='',hscode='0',power='0',ProductionDate='',expiry='0',procode='',lastbuyprice_withTax='95',meanbuyprice_withTax='95',price4='0',price5='0',price6='0',price7='0',price8='0',clientid='0',grantduration='0',onlinepro='0',minappearonline='0',selladdpercent='0',selldiscountpercent='0',buydiscountpercent='0',onlinecatid='-1',sellpercenttype='0',searchfiltersid='',lastbuyprice_withDiscountAndTax='95'  WHERE productId = '17';
COMMIT;
UPDATE user SET loginip = "" WHERE lastactivetime < "2025-03-03 21:47:10";
UPDATE user SET loginip = "::1", lastactivetime = "2025-03-04 01:17:10", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('productController.php', '2025-03-04 01:17:10', '1', '', '::1', '', 'DESKTOP','https://localhost/erp/controllers/productController.php');
UPDATE user SET loginip = "" WHERE lastactivetime < "2025-03-03 21:47:12";
UPDATE user SET loginip = "::1", lastactivetime = "2025-03-04 01:17:12", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('sellbillController.php', '2025-03-04 01:17:12', '1', 'showDetail', '::1', '', 'DESKTOP','https://localhost/erp/controllers/sellbillController.php?do=showDetail&sellbillid=1');
