-- ALTER TABLE elarabygt4it_erp.accountmovement AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.accountmovementkind AUTO_INCREMENT = 4;
-- ALTER TABLE elarabygt4it_erp.accountstree AUTO_INCREMENT = 419;
-- ALTER TABLE elarabygt4it_erp.accountstreefromprog AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.accountstreesetting AUTO_INCREMENT = 7;
-- ALTER TABLE elarabygt4it_erp.assets AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.assetssale AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.assetscat AUTO_INCREMENT = 25;
-- ALTER TABLE elarabygt4it_erp.bank AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.bankaccount AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.billname AUTO_INCREMENT = 7;
-- ALTER TABLE elarabygt4it_erp.billoperation AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.billproperty AUTO_INCREMENT = 130;
-- ALTER TABLE elarabygt4it_erp.bills AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.billsbuy AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.billsettings AUTO_INCREMENT = 1196;
-- ALTER TABLE elarabygt4it_erp.billsproducts AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.billsproductsbuy AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.billsreturn AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.billsreturnproducts AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.billtemplate AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.billtemplatedetail AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.bind AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.bindsettlement AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.boarding AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.branch AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.buyandruternbill AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.buyandruternbillcurr AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.buyandruternbilldetail AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.buybill AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.buybillcurr AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.buybilldetail AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.buybilldetailoffer AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.buybilloffer AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.buypriceshistorybook AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.capital AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.cashtransfer AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.checkcontroller AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.checkdeposit AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.checkwithdrawal AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.claimdebts AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.claimreturnsellbills AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.claims AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.claimsclientbills AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.claimsellbills AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.claimstypeclients AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.client AUTO_INCREMENT = 2;
-- ALTER TABLE elarabygt4it_erp.clientarea AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.clientdebtchange AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.clientpaymentreceiptt AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.clientproductreview AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.clinic AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.collectedparcodestemp AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.commentclient AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.costcenter AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.costcenterdetail AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.country AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.coupons AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.currency AUTO_INCREMENT = 2;
-- ALTER TABLE elarabygt4it_erp.dailyentry AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.dailyentrycreditor AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.dailyentrydebtor AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.damagedproduct AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.datedchecked AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.discountcontrol AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.doctorkashf AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.ebillsetting AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.eclientsetting AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.employee AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.employeeattendance AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.employeeattendancesystem AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.employeeclosedaygroupstatus AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.employeeclosedayhistory AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.employeeclosedaystatus AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.employeeclosedaysubgroupstatus AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.employeedoctor AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.employeedoctordebtandpay AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.employeedoctordebtchange AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.employeegroup AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.employeepersonnel AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.employeesubgroup AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.entryproductspurchased AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.expenseexchange AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.expenses AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.expensestype AUTO_INCREMENT = 65;
-- ALTER TABLE elarabygt4it_erp.goverarea AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.government AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.impotencetreatmentsuppliersave AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.income AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.incometype AUTO_INCREMENT = 8;
-- ALTER TABLE elarabygt4it_erp.insurancecompanies AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.kashf AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.kempiala AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.lastbillidspricesupdated AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.lastbillidsquickprofit AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.maccontrol AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.maintenancecases AUTO_INCREMENT = 5;
-- ALTER TABLE elarabygt4it_erp.maintenancecenters AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.maintenancecomments AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.maintenancecompanies AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.maintenancepolicys AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.maintenanceprocedures AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.maintenances AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.manufacuresetting AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.menuurl AUTO_INCREMENT = 31;
-- ALTER TABLE elarabygt4it_erp.movementmanage AUTO_INCREMENT = 10;
-- ALTER TABLE elarabygt4it_erp.movementmanagedeleted AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.m_check AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.m_comreceipt AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.m_comreceiptdetail AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.m_comreceiptimage AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.m_externalmaintenance AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.m_finishingpayed AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.m_handedreport AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.m_initialmaintenance AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.m_initialmaintenancedetail AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.m_insurance AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.m_maintenancereceipt AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.m_maintenancereceiptfinish AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.m_producthistory AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.m_stage AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.m_stageproperity AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.newdbbackup AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.newdbname AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.notics AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.offerpricebill AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.offerpricebillprop AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.offerpricecondition AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.onlinestoresetting AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.onlinestoremainsetting AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.onlinetempcategory AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.onlinetemporder AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.onlinetemporderclient AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.onlinetemporderproduct AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.onlinetempproduct AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.onlinetempstoredetail AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.onlinetempstorereport AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.otherrequest AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.otherstoremovement AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.pages AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.partner AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.partnertransferbetween AUTO_INCREMENT = 25;
-- ALTER TABLE elarabygt4it_erp.partnerwithdrawal AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.paymentmethods AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.paymentnetworks AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.playstationcard AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.playstationclientcard AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.playstationclientcardpayhistory AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.policy AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.product AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.productcat AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.productcatunit AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.productingredients AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.productionexecution AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.productionexecutionoutput AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.productionexecutionproduct AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.productionexecutionwaste AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.productionorder AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.productionout AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.productionoutdetails AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.productionoutmany AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.productionoutmanyinproducts AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.productionoutmanyoutproducts AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.productionrate AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.productionrateproduct AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.productrecieve AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.productrequests AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.productserial AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.productsetting AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.producttemp AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.producttempunit AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.productunit AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.product_images AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.programsettings AUTO_INCREMENT = 2;
-- ALTER TABLE elarabygt4it_erp.project AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.projectexchmaterial AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.projectexchmaterialdetail AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.projectexchmaterialdetailreturn AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.projectexchmaterialreturn AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.projectkind AUTO_INCREMENT = 4;
-- ALTER TABLE elarabygt4it_erp.properties AUTO_INCREMENT = 792;
-- ALTER TABLE elarabygt4it_erp.quickprofitclient AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.quickprofitday AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.quickprofitgeneral AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.quickprofitproduct AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.quickprofitstore AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.religions AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.relusergroupproperties AUTO_INCREMENT = 3896;
-- ALTER TABLE elarabygt4it_erp.rentbill AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.rentbillprop AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.rentproduct AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.rentstore AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.representativecompany AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.restauranthall AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.restaurantkitchenprint AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.restaurantorder AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.restaurantorderdeliverydetails AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.restaurantorderdetails AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.restaurantplaystation AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.restaurantplaystationplay AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.restaurantprinter AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.restaurantrawdestruction AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.restauranttable AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.returnbuybill AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.returnbuybillcurr AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.returnbuybilldetail AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.returnsellbill AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.returnsellbillcurr AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.returnsellbilldetail AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.returnsellbillreview AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.richproperity AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.salaryreport AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.saudielectronicinvoice AUTO_INCREMENT = 2;
-- ALTER TABLE elarabygt4it_erp.save AUTO_INCREMENT = 2;
-- ALTER TABLE elarabygt4it_erp.savedaily AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.sellandruternbilldetail AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.sellbill AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.sellbillallsavepayments AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.sellbillandreturnreview AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.sellbillandrutern AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.sellbillandruterncurr AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.sellbillcurr AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.sellbilldetail AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.sellbilldetailoffer AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.sellbilldetailorder AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.sellbilldetailtax AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.sellbillimage AUTO_INCREMENT = 9;
-- ALTER TABLE elarabygt4it_erp.sellbilloffer AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.sellbillorder AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.sellbillreview AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.settingoperation AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.shippercompanies AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.simplemanufacturesetting AUTO_INCREMENT = 2;
-- ALTER TABLE elarabygt4it_erp.sizecolor AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.sizecolorstoredetail AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.sliders AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.soldserialproduct AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.sparepart AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.sparepartstore AUTO_INCREMENT = 2;
-- ALTER TABLE elarabygt4it_erp.sparepartstoredetails AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.sparepartstorereport AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.stage AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.stagestep AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.stock_import_logs AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.store AUTO_INCREMENT = 2;
-- ALTER TABLE elarabygt4it_erp.storedetail AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.storemovement AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.storereport AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.studentabsences AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.studentaddsubjectdetails AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.studentaddsubjects AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.students AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.studentsetting AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.studentsexams AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.studentsexamsval AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.studentspaymentsystems AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.studentspays AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.studentsubjectgroupdays AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.studentsubjectgroups AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.studentsubjects AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.suppay AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.supplier AUTO_INCREMENT = 2;
-- ALTER TABLE elarabygt4it_erp.supplierdebtchange AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.supplieropen AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.supplieropendebtchange AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.supplieropenexchangeorclosing AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.tamweenbill AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.tamweenclientdetail AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.tamweenda3mstatus AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.tamweenremainstatus AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.taskorder AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.taskorderproducts AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.taskscases AUTO_INCREMENT = 6;
-- ALTER TABLE elarabygt4it_erp.temreturnsellbill AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.temreturnsellbilldetail AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.temsellandruternbilldetail AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.temsellbill AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.temsellbillandrutern AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.temsellbilldetail AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.toworkshoporder AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.toworkshoporderbill AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.transferbtweenbankaccount AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.transfermoney AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.unit AUTO_INCREMENT = 2;
-- ALTER TABLE elarabygt4it_erp.user AUTO_INCREMENT = 2;
-- ALTER TABLE elarabygt4it_erp.usergroup AUTO_INCREMENT = 5;
-- ALTER TABLE elarabygt4it_erp.usergroupadmin AUTO_INCREMENT = 1029;
-- ALTER TABLE elarabygt4it_erp.vatpayment AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.wishlist AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.workshop AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.workstation AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.workstationassets AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.workstationworker AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.typeclient AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.typesimpotencetreatment AUTO_INCREMENT = 4;
-- ALTER TABLE elarabygt4it_erp.typesupplier AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.premium AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.premiumclient AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.premiumautomatic AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.premiuminstallments AUTO_INCREMENT = 24;
-- ALTER TABLE elarabygt4it_erp.faida AUTO_INCREMENT = 2;
-- ALTER TABLE elarabygt4it_erp.faidaproduct AUTO_INCREMENT = 3;
-- ALTER TABLE elarabygt4it_erp.faidadirector AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.resturantcategory AUTO_INCREMENT = 4;
-- ALTER TABLE elarabygt4it_erp.languages AUTO_INCREMENT = 3;
-- ALTER TABLE elarabygt4it_erp.youtube_link AUTO_INCREMENT = 290;
-- ALTER TABLE elarabygt4it_erp.transferclientaccounts AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.knownways AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.sellbillpayed AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.sellbillstatus AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.saveclose AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.charities AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.beneficiaries AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.beneficiaries_family AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.beneficiaries_eco AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.disease AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.area AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.subvention AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.subventionpay AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.onlinecat AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.onlineproductcat AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.searchfilters AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.savetype AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.storemovement_main AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.charitysearchlog AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.charitiescenter AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.ads AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.billprinter AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.billprint AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.importcontract AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.carfile AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.cartracking AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.shippingfile AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.dollarearnings AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.carreviewer AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.carreview AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.cars AUTO_INCREMENT = 1;
-- ALTER TABLE elarabygt4it_erp.savestock AUTO_INCREMENT = 2;
-- ALTER TABLE elarabygt4it_erp.qrerpuserpass AUTO_INCREMENT = 2;
-- ALTER TABLE elarabygt4it_erp.availableparcode AUTO_INCREMENT = 100001;
update user set blockedByLimits = 0;
INSERT IGNORE INTO relusergroupproperties (usergroupid, propertyid, propertyvalue, theorder)
                SELECT -1,propertyid , 0,0
                from properties; -- id=0
INSERT IGNORE INTO usergroupadmin (propertyid, isallowed)
                SELECT propertyid , propertydefault
                from properties; -- id=0
UPDATE programsettings SET companyname = 'GT4', address = 'القاهرة - المقطم - شارع 9 ', specializtion = 'برمجيات - مواقع انترنت - تطبيقات موبايل', phone = '0111007088', faxnumber = '', email = 'mousa_maged@hotmail.com', website = '', logo = '3f52022081b9a1a89c6f3246463c2d62.jpg', roundnumbers = '1', saveprinting = '1', deptprinting = '1', printingpapersize = '0', userid = '1', showPreviousPrice = '0', parcode = '0', priceing = '0', lastprice = '0', searchvalue = '2',clientsearchvalue = '2', updateproductprice = '0', allowfinsldelete = '0', updateclientprice = '0', `partition` = '0', taxcard = '123456789123', commercialregistration = '1234', costcenter = '1', clinic = '1', workshop = '1', transport = '1', manufacturing = '1', masterCopy = '0' , dailyentrydate = '2020-04-18' ,updatefiledate = '2026-09-24',workerbetweenstores = '1',workshoptimeout = '24',drivertimeout = '3',currancy = 'جنيه',serial='57a85883346811cbf7076a51c5bd887a2e96bf2df777a95668d34a3537aceedfe3f238b684c96d789642405e6f69293dbb311716d957a5ac40fe5570cf297eaf',allowdateedit = '0', clientcode = '1' ,clientserial = '1',timezone = 'Africa/Cairo' , expiredate ='1' , production ='1' , description='1' , service ='0' , date='1' , limitamount = '0' , measuringunit = '1' , print_amount = '0' , billid = '0' , precentages = '1' , realprice = '1' ,delegate_seller = '0' , storeserial = '1' ,clientfieldrequired ='0' , clientcodname='0' , colortype = '0' , nakdyOnly = '0' , nakdyKashf = '0' , discount_pres_direct = '0' , general_discount = '0' , sells_return = '0' ,scunitname ='0',vatValue = '0.00',syncstructure = '1',showPrevPrices = '0',isOpticProg='1',reportsPlusHours = '2' , showM5zon = '1',restaurantStoreId = '1',restuarantPrintTimeout = '8',sumSameProductForStore = '0', editAllPrice = '0', isCafe = '0' ,isRestaurent = '0' ,productDays = '0',thereIsRestTax = '0',restTaxVal = '0',restPrintLang = '0',taxNameFlag = '0',parcodeDigits = '5' ,specializedParcodeDigits = '7', clientDefaultDebtLimit = '10000' , clientDefaultDebtLimitControl = '0',usedParcode = '1' ,productbycodeimage = '' ,commentClient='تعليق على العميل ',Inventoryevaluation='last_discount',Profitevaluation='last_discount' , delivery='0',premiums = '1',operationnumEdit = '0',noOfDecimalPlaces = '2',unReviewBills = '0', unReviewBillsPass = '123',billReviewNote = '',tamweenBakery = '0',three_months = '0',six_months = '0',twelve_months = '0',eighteen_months = '0',twentyfour_months = '0',thirty_months = '0',sixthirty_months = '0',fortytwo_months = '0',fortyeight_months = '0',mandobCollectionRatio='0',takeAwayClient = '0',restaurantServiceOn = ',0,0,0,',earlyrepayment = '0',visaPay = '0',headerPrint='38e56bc84e0c8adff190ee376e986bbd.png',headerPrintSand='',printSand='0',makeDailyEntry='1',clientShowTawla='0',billRest='1',suppIsClientToo='0',isCarBill='0',expensesproduct='1',projectshownew='1',showparcode='0',changeBuyPriceChangeSellInBuyBillCtrl = '0',changeBuyPriceChangeSellInProductCtrl = '0',inventoryvaluation = '1',showBillCollectionSearch='0',incomeclient='1',showserial='1',editservice='1',showCurrency='0',qrerp='1',valueadded='0',qrcodesh='0',printfoot='',sellorder='0',numberprint='0',valueaddedbuy='0',simpleAddClientInBill='0',licenseNo='',maintenance='0',showPrevDiscount='0',vatvalueqr='0.13043479',imgprinthide='0',parcodeprinttype = 'C128A',parcodeprintwidth='160',parcodeprinttextsize='14',parcodeprintCurr='L.E',sizecolorDigits='3',searchBarcodeInBill='0',allowMobileLogin='0',lanAllowType='0',wanAllowType='0',sendBillToRestaurant='0',obgyPharmacyGroups='',updateProUnitPricesOnPriceUpdate='0',ebill='0',valueaddeddiscount='0',clientdetail='1',showPrevPricesRet='0',showPrevDiscountRet='0',eunitInTax='',showStoreToDetail='0',showBuyPriceAtProductddl='0',specialexpenses='1',ratioshow='0',defaultUnitPriceAtBill='0',rulers='0',quantitynew='0',showBillOperationSearch='0',obygyFolder='',clientsell='0',
                preorderperiod='0',useListPrice='0',ebillclient='0',importproduct='0',realestateunits='0',expensesupplier='0',changeOrderproduct='0',searchlimit='0',typebill='',roundnumbersbilltotal='0',noOfDecimalPlacesBillTotal='0',dailyEntryCostprice='last_discount',storeRecieveType='0',clientPhoneReq='0',addServiceToBill='0',realestatedev='1',showprice4='0',showprice5='0',showprice6='0',showprice7='0',showprice8='0',showpriceall='1',showpricehalf='1',showpriceunit='1',showbillstatus='0',showbilldeliverydate='0',enablequantityfractions='1',addclienttoproduct='0',closingcustomeraccount='0',serial2='',
                shownameE='0',showprocode='0',showpartnumber='0',showtype='0',showcompany='0',showweight='0',showorigin='0',showhscode='0',showexpire='0',showgrantduration='0',showonline='0',showminappear='0',showonlinecat='0',showsellpercentage='0',showbuydiscount='0',preparingStore='0',sellordername='0',showsearchfilter='0',unitPriceAtsalesreport='0',medExCat='0',laterNakdiClientId='0',headerPrint12Right='',headerPrint12Left='',halfPriceStart='0',allPriceStart='0',checkretsellclient='1',webApiId='0',noBillEditTillPay='0',showDataOfficialContract='0',showprice9='0',showprice10='0',showprice11='0',showprice12='0',showprice13='0',serial3='83b7fcbc8ec5f6680b38c85c5097af3b8f9e24beb34e300c92da2aed73200ef3508d6b04b93e1301b69bf990665657d386b98aa70faa9951dfc2289ed943c6cd',associatedtags='0',commentClientChasis='0',dollarExType='0',saudielectronicinvoice='0',saudielectronicinvoclient='0',productDiscount='0'
                ,reviewRecords='',reviewRecordsLastDate='0000-00-00',showepayrestaurant='0',showSellAllPriceInStoreDetail='0' WHERE programsettingsid = '1';
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 10:57:53";
UPDATE user SET loginip = "197.193.5.247", lastactivetime = "2026-09-25 14:27:53", deviceType = "MOBILE" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('index.php', '2026-09-25 14:27:53', '1', '', '197.193.5.247', '', 'MOBILE','https://elaraby.gt4it.com/erp/controllers/index.php'); -- id=10
UPDATE programsettings SET companyname = 'GT4', address = 'القاهرة - المقطم - شارع 9 ', specializtion = 'برمجيات - مواقع انترنت - تطبيقات موبايل', phone = '0111007088', faxnumber = '', email = 'mousa_maged@hotmail.com', website = '', logo = '3f52022081b9a1a89c6f3246463c2d62.jpg', roundnumbers = '1', saveprinting = '1', deptprinting = '1', printingpapersize = '0', userid = '1', showPreviousPrice = '0', parcode = '0', priceing = '0', lastprice = '0', searchvalue = '2',clientsearchvalue = '2', updateproductprice = '0', allowfinsldelete = '0', updateclientprice = '0', `partition` = '0', taxcard = '123456789123', commercialregistration = '1234', costcenter = '1', clinic = '1', workshop = '1', transport = '1', manufacturing = '1', masterCopy = '0' , dailyentrydate = '2020-04-18' ,updatefiledate = '2026-09-25',workerbetweenstores = '1',workshoptimeout = '24',drivertimeout = '3',currancy = 'جنيه',serial='57a85883346811cbf7076a51c5bd887a2e96bf2df777a95668d34a3537aceedfe3f238b684c96d789642405e6f69293dbb311716d957a5ac40fe5570cf297eaf',allowdateedit = '0', clientcode = '1' ,clientserial = '1',timezone = 'Africa/Cairo' , expiredate ='1' , production ='1' , description='1' , service ='0' , date='1' , limitamount = '0' , measuringunit = '1' , print_amount = '0' , billid = '0' , precentages = '1' , realprice = '1' ,delegate_seller = '0' , storeserial = '1' ,clientfieldrequired ='0' , clientcodname='0' , colortype = '0' , nakdyOnly = '0' , nakdyKashf = '0' , discount_pres_direct = '0' , general_discount = '0' , sells_return = '0' ,scunitname ='0',vatValue = '0.00',syncstructure = '1',showPrevPrices = '0',isOpticProg='1',reportsPlusHours = '2' , showM5zon = '1',restaurantStoreId = '1',restuarantPrintTimeout = '8',sumSameProductForStore = '0', editAllPrice = '0', isCafe = '0' ,isRestaurent = '0' ,productDays = '0',thereIsRestTax = '0',restTaxVal = '0',restPrintLang = '0',taxNameFlag = '0',parcodeDigits = '5' ,specializedParcodeDigits = '7', clientDefaultDebtLimit = '10000' , clientDefaultDebtLimitControl = '0',usedParcode = '1' ,productbycodeimage = '' ,commentClient='تعليق على العميل ',Inventoryevaluation='last_discount',Profitevaluation='last_discount' , delivery='0',premiums = '1',operationnumEdit = '0',noOfDecimalPlaces = '2',unReviewBills = '0', unReviewBillsPass = '123',billReviewNote = '',tamweenBakery = '0',three_months = '0',six_months = '0',twelve_months = '0',eighteen_months = '0',twentyfour_months = '0',thirty_months = '0',sixthirty_months = '0',fortytwo_months = '0',fortyeight_months = '0',mandobCollectionRatio='0',takeAwayClient = '0',restaurantServiceOn = ',0,0,0,',earlyrepayment = '0',visaPay = '0',headerPrint='38e56bc84e0c8adff190ee376e986bbd.png',headerPrintSand='',printSand='0',makeDailyEntry='1',clientShowTawla='0',billRest='1',suppIsClientToo='0',isCarBill='0',expensesproduct='1',projectshownew='1',showparcode='0',changeBuyPriceChangeSellInBuyBillCtrl = '0',changeBuyPriceChangeSellInProductCtrl = '0',inventoryvaluation = '1',showBillCollectionSearch='0',incomeclient='1',showserial='1',editservice='1',showCurrency='0',qrerp='1',valueadded='0',qrcodesh='0',printfoot='',sellorder='0',numberprint='0',valueaddedbuy='0',simpleAddClientInBill='0',licenseNo='',maintenance='0',showPrevDiscount='0',vatvalueqr='0.13043479',imgprinthide='0',parcodeprinttype = 'C128A',parcodeprintwidth='160',parcodeprinttextsize='14',parcodeprintCurr='L.E',sizecolorDigits='3',searchBarcodeInBill='0',allowMobileLogin='0',lanAllowType='0',wanAllowType='0',sendBillToRestaurant='0',obgyPharmacyGroups='',updateProUnitPricesOnPriceUpdate='0',ebill='0',valueaddeddiscount='0',clientdetail='1',showPrevPricesRet='0',showPrevDiscountRet='0',eunitInTax='',showStoreToDetail='0',showBuyPriceAtProductddl='0',specialexpenses='1',ratioshow='0',defaultUnitPriceAtBill='0',rulers='0',quantitynew='0',showBillOperationSearch='0',obygyFolder='',clientsell='0',
                preorderperiod='0',useListPrice='0',ebillclient='0',importproduct='0',realestateunits='0',expensesupplier='0',changeOrderproduct='0',searchlimit='0',typebill='',roundnumbersbilltotal='0',noOfDecimalPlacesBillTotal='0',dailyEntryCostprice='last_discount',storeRecieveType='0',clientPhoneReq='0',addServiceToBill='0',realestatedev='1',showprice4='0',showprice5='0',showprice6='0',showprice7='0',showprice8='0',showpriceall='1',showpricehalf='1',showpriceunit='1',showbillstatus='0',showbilldeliverydate='0',enablequantityfractions='1',addclienttoproduct='0',closingcustomeraccount='0',serial2='',
                shownameE='0',showprocode='0',showpartnumber='0',showtype='0',showcompany='0',showweight='0',showorigin='0',showhscode='0',showexpire='0',showgrantduration='0',showonline='0',showminappear='0',showonlinecat='0',showsellpercentage='0',showbuydiscount='0',preparingStore='0',sellordername='0',showsearchfilter='0',unitPriceAtsalesreport='0',medExCat='0',laterNakdiClientId='0',headerPrint12Right='',headerPrint12Left='',halfPriceStart='0',allPriceStart='0',checkretsellclient='1',webApiId='0',noBillEditTillPay='0',showDataOfficialContract='0',showprice9='0',showprice10='0',showprice11='0',showprice12='0',showprice13='0',serial3='83b7fcbc8ec5f6680b38c85c5097af3b8f9e24beb34e300c92da2aed73200ef3508d6b04b93e1301b69bf990665657d386b98aa70faa9951dfc2289ed943c6cd',associatedtags='0',commentClientChasis='0',dollarExType='0',saudielectronicinvoice='0',saudielectronicinvoclient='0',productDiscount='0'
                ,reviewRecords='',reviewRecordsLastDate='0000-00-00',showepayrestaurant='0',showSellAllPriceInStoreDetail='0' WHERE programsettingsid = '1';
UPDATE product SET lastbuyprice=productBuyPrice,lastbuyprice_withDiscount=productBuyPrice,meanbuyprice=productBuyPrice,meanbuyprice_withDiscount=productBuyPrice where lastbuyprice is null;
UPDATE product
                JOIN (
                       select productingredients.productId
                              ,sum(productnumber * quantity * productBuyPrice) as productBuyPrice
                              ,sum(productnumber * quantity * lastbuyprice) as lastbuyprice
                              ,sum(productnumber * quantity * lastbuyprice_withDiscount) as lastbuyprice_withDiscount
                              ,sum(productnumber * quantity * meanbuyprice) as meanbuyprice
                              ,sum(productnumber * quantity * meanbuyprice_withDiscount) as meanbuyprice_withDiscount
                              ,sum(productnumber * quantity * overAllAveragePrice) as overAllAveragePrice
                      from product
                      join productingredients on product.productId = productingredients.ingridientId
                      join productunit on productunit.productunitid = productingredients.unitId
                      group by productingredients.productId
                    ) as ingridientPrice ON ingridientPrice.productId =  product.productId
                SET product.productBuyPrice = ingridientPrice.productBuyPrice,
                        product.lastbuyprice = ingridientPrice.lastbuyprice,
                    product.lastbuyprice_withDiscount = ingridientPrice.lastbuyprice_withDiscount,
                    product.meanbuyprice = ingridientPrice.meanbuyprice,
                    product.meanbuyprice_withDiscount = ingridientPrice.meanbuyprice_withDiscount,
                    product.overAllAveragePrice = ingridientPrice.overAllAveragePrice;
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 10:57:53";
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('playStationCardController.php', '2026-09-25 14:27:53', '1', 'handleExpiredCards', '51.89.20.165', '', 'DESKTOP','https://elaraby.gt4it.com/erp/controllers/playStationCardController.php?do=handleExpiredCards'); -- id=11
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 10:58:12";
UPDATE user SET loginip = "197.193.5.247", lastactivetime = "2026-09-25 14:28:12", deviceType = "MOBILE" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('usergroupController.php', '2026-09-25 14:28:12', '1', 'show', '197.193.5.247', '', 'MOBILE','https://elaraby.gt4it.com/erp/controllers/usergroupController.php?do=show'); -- id=12
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 10:58:16";
UPDATE user SET loginip = "197.193.5.247", lastactivetime = "2026-09-25 14:28:16", deviceType = "MOBILE" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('usergroupController.php', '2026-09-25 14:28:16', '1', 'edit', '197.193.5.247', '', 'MOBILE','https://elaraby.gt4it.com/erp/controllers/usergroupController.php?do=edit&id=1'); -- id=13
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 10:58:36";
UPDATE user SET loginip = "197.193.5.247", lastactivetime = "2026-09-25 14:28:36", deviceType = "MOBILE" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('usergroupController.php', '2026-09-25 14:28:36', '1', 'update', '197.193.5.247', '', 'MOBILE','https://elaraby.gt4it.com/erp/controllers/usergroupController.php?do=update'); -- id=14
UPDATE usergroup SET storenegative=0 WHERE usergroupid = 1;
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 10:58:37";
UPDATE user SET loginip = "197.193.5.247", lastactivetime = "2026-09-25 14:28:37", deviceType = "MOBILE" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('usergroupController.php', '2026-09-25 14:28:37', '1', 'sucess', '197.193.5.247', '', 'MOBILE','https://elaraby.gt4it.com/erp/controllers/usergroupController.php?do=sucess'); -- id=15
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 10:58:38";
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 10:58:39";
UPDATE user SET loginip = "197.193.5.247", lastactivetime = "2026-09-25 14:28:39", deviceType = "MOBILE" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('usergroupController.php', '2026-09-25 14:28:39', '1', 'show', '197.193.5.247', '', 'MOBILE','https://elaraby.gt4it.com/erp/controllers/usergroupController.php?do=show'); -- id=16
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 10:58:55";
UPDATE user SET loginip = "197.193.5.247", lastactivetime = "2026-09-25 14:28:55", deviceType = "MOBILE" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('productCatController.php', '2026-09-25 14:28:55', '1', '', '197.193.5.247', '', 'MOBILE','https://elaraby.gt4it.com/erp/controllers/productCatController.php'); -- id=17
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 11:39:49";
update user set blockedByLimits = 0;
INSERT IGNORE INTO relusergroupproperties (usergroupid, propertyid, propertyvalue, theorder)
                SELECT -1,propertyid , 0,0
                from properties; -- id=0
INSERT IGNORE INTO usergroupadmin (propertyid, isallowed)
                SELECT propertyid , propertydefault
                from properties; -- id=0
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 11:50:22";
UPDATE user SET loginip = "154.177.109.91", lastactivetime = "2026-09-25 15:20:22", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('index.php', '2026-09-25 15:20:22', '1', '', '154.177.109.91', '', 'DESKTOP','https://elaraby.gt4it.com/erp/controllers/index.php'); -- id=18
UPDATE product SET lastbuyprice=productBuyPrice,lastbuyprice_withDiscount=productBuyPrice,meanbuyprice=productBuyPrice,meanbuyprice_withDiscount=productBuyPrice where lastbuyprice is null;
UPDATE product
                JOIN (
                       select productingredients.productId
                              ,sum(productnumber * quantity * productBuyPrice) as productBuyPrice
                              ,sum(productnumber * quantity * lastbuyprice) as lastbuyprice
                              ,sum(productnumber * quantity * lastbuyprice_withDiscount) as lastbuyprice_withDiscount
                              ,sum(productnumber * quantity * meanbuyprice) as meanbuyprice
                              ,sum(productnumber * quantity * meanbuyprice_withDiscount) as meanbuyprice_withDiscount
                              ,sum(productnumber * quantity * overAllAveragePrice) as overAllAveragePrice
                      from product
                      join productingredients on product.productId = productingredients.ingridientId
                      join productunit on productunit.productunitid = productingredients.unitId
                      group by productingredients.productId
                    ) as ingridientPrice ON ingridientPrice.productId =  product.productId
                SET product.productBuyPrice = ingridientPrice.productBuyPrice,
                        product.lastbuyprice = ingridientPrice.lastbuyprice,
                    product.lastbuyprice_withDiscount = ingridientPrice.lastbuyprice_withDiscount,
                    product.meanbuyprice = ingridientPrice.meanbuyprice,
                    product.meanbuyprice_withDiscount = ingridientPrice.meanbuyprice_withDiscount,
                    product.overAllAveragePrice = ingridientPrice.overAllAveragePrice;
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 11:50:22";
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('playStationCardController.php', '2026-09-25 15:20:22', '1', 'handleExpiredCards', '51.89.20.165', '', 'DESKTOP','https://elaraby.gt4it.com/erp/controllers/playStationCardController.php?do=handleExpiredCards'); -- id=19
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 11:51:34";
UPDATE user SET loginip = "154.177.109.91", lastactivetime = "2026-09-25 15:21:34", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('productController.php', '2026-09-25 15:21:34', '1', 'show', '154.177.109.91', '', 'DESKTOP','https://elaraby.gt4it.com/erp/controllers/productController.php?do=show'); -- id=20
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 11:51:42";
UPDATE user SET loginip = "154.177.109.91", lastactivetime = "2026-09-25 15:21:42", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('productCatController.php', '2026-09-25 15:21:42', '1', '', '154.177.109.91', '', 'DESKTOP','https://elaraby.gt4it.com/erp/controllers/productCatController.php'); -- id=21
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 11:51:50";
UPDATE user SET loginip = "154.177.109.91", lastactivetime = "2026-09-25 15:21:50", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('productController.php', '2026-09-25 15:21:50', '1', '', '154.177.109.91', '', 'DESKTOP','https://elaraby.gt4it.com/erp/controllers/productController.php'); -- id=22
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 11:52:09";
UPDATE user SET loginip = "154.177.109.91", lastactivetime = "2026-09-25 15:22:09", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('productCatController.php', '2026-09-25 15:22:09', '1', '', '154.177.109.91', '', 'DESKTOP','https://elaraby.gt4it.com/erp/controllers/productCatController.php'); -- id=23
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 11:53:29";
UPDATE user SET loginip = "154.177.109.91", lastactivetime = "2026-09-25 15:23:29", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('productCatController.php', '2026-09-25 15:23:29', '1', 'add2', '154.177.109.91', '', 'DESKTOP','https://elaraby.gt4it.com/erp/controllers/productCatController.php?do=add2'); -- id=24
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,price9,price10,price11,price12,price13) VALUES ('جينز','2026-09-25','','0', '1','0', '0', '0', '-1', '0', '0', '0', '0','0','','.','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0'); -- id=1
INSERT INTO onlinetempcategory (catid, edited, sysdate, userid)
                VALUES (1, 1,'2026-09-25 15:23:29',1)
                ON DUPLICATE KEY UPDATE catid = 1, edited = 1, sysdate = '2026-09-25 15:23:29', userid = 1; -- id=1
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 11:53:30";
UPDATE user SET loginip = "154.177.109.91", lastactivetime = "2026-09-25 15:23:30", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('productCatController.php', '2026-09-25 15:23:30', '1', 'sucess', '154.177.109.91', '', 'DESKTOP','https://elaraby.gt4it.com/erp/controllers/productCatController.php?do=sucess'); -- id=25
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 11:53:31";
UPDATE user SET loginip = "154.177.109.91", lastactivetime = "2026-09-25 15:23:31", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('productCatController.php', '2026-09-25 15:23:31', '1', 'show', '154.177.109.91', '', 'DESKTOP','https://elaraby.gt4it.com/erp/controllers/productCatController.php?do=show'); -- id=26
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 11:53:38";
UPDATE user SET loginip = "154.177.109.91", lastactivetime = "2026-09-25 15:23:38", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('productCatController.php', '2026-09-25 15:23:38', '1', '', '154.177.109.91', '', 'DESKTOP','https://elaraby.gt4it.com/erp/controllers/productCatController.php'); -- id=27
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 11:53:54";
UPDATE user SET loginip = "154.177.109.91", lastactivetime = "2026-09-25 15:23:54", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('sellbillController.php', '2026-09-25 15:23:54', '1', 'addsellBill', '154.177.109.91', '', 'DESKTOP','https://elaraby.gt4it.com/erp/controllers/sellbillController.php?do=addsellBill&billnameid=3'); -- id=28
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 11:53:59";
UPDATE user SET loginip = "154.177.109.91", lastactivetime = "2026-09-25 15:23:59", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('productCatController.php', '2026-09-25 15:23:59', '1', '', '154.177.109.91', '', 'DESKTOP','https://elaraby.gt4it.com/erp/controllers/productCatController.php'); -- id=29
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 11:54:01";
UPDATE user SET loginip = "154.177.109.91", lastactivetime = "2026-09-25 15:24:01", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('productController.php', '2026-09-25 15:24:01', '1', '', '154.177.109.91', '', 'DESKTOP','https://elaraby.gt4it.com/erp/controllers/productController.php'); -- id=30
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 11:54:13";
UPDATE user SET loginip = "154.177.109.91", lastactivetime = "2026-09-25 15:24:13", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('productCatController.php', '2026-09-25 15:24:13', '1', '', '154.177.109.91', '', 'DESKTOP','https://elaraby.gt4it.com/erp/controllers/productCatController.php'); -- id=31
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 11:54:30";
UPDATE user SET loginip = "154.177.109.91", lastactivetime = "2026-09-25 15:24:30", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('productCatController.php', '2026-09-25 15:24:30', '1', 'add2', '154.177.109.91', '', 'DESKTOP','https://elaraby.gt4it.com/erp/controllers/productCatController.php?do=add2'); -- id=32
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,price9,price10,price11,price12,price13) VALUES ('كافاني','2026-09-25','','1', '1','0', '0', '0', '-1', '0', '0', '0', '0','0','','.','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0'); -- id=2
INSERT INTO onlinetempcategory (catid, edited, sysdate, userid)
                VALUES (2, 1,'2026-09-25 15:24:30',1)
                ON DUPLICATE KEY UPDATE catid = 2, edited = 1, sysdate = '2026-09-25 15:24:30', userid = 1; -- id=2
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 11:54:30";
UPDATE user SET loginip = "154.177.109.91", lastactivetime = "2026-09-25 15:24:30", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('productCatController.php', '2026-09-25 15:24:30', '1', 'sucess', '154.177.109.91', '', 'DESKTOP','https://elaraby.gt4it.com/erp/controllers/productCatController.php?do=sucess'); -- id=33
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 11:54:32";
UPDATE user SET loginip = "154.177.109.91", lastactivetime = "2026-09-25 15:24:32", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('productCatController.php', '2026-09-25 15:24:32', '1', 'show', '154.177.109.91', '', 'DESKTOP','https://elaraby.gt4it.com/erp/controllers/productCatController.php?do=show'); -- id=34
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 11:54:34";
UPDATE user SET loginip = "154.177.109.91", lastactivetime = "2026-09-25 15:24:34", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('productController.php', '2026-09-25 15:24:34', '1', '', '154.177.109.91', '', 'DESKTOP','https://elaraby.gt4it.com/erp/controllers/productController.php'); -- id=35
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 11:56:37";
UPDATE user SET loginip = "154.177.109.91", lastactivetime = "2026-09-25 15:26:37", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('transfermoneyController.php', '2026-09-25 15:26:37', '1', '', '154.177.109.91', '', 'DESKTOP','https://elaraby.gt4it.com/erp/controllers/transfermoneyController.php'); -- id=36
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 11:56:47";
UPDATE user SET loginip = "154.177.109.91", lastactivetime = "2026-09-25 15:26:47", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('productController.php', '2026-09-25 15:26:47', '1', '', '154.177.109.91', '', 'DESKTOP','https://elaraby.gt4it.com/erp/controllers/productController.php'); -- id=37
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 11:57:03";
UPDATE user SET loginip = "154.177.109.91", lastactivetime = "2026-09-25 15:27:03", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('productController.php', '2026-09-25 15:27:03', '1', '', '154.177.109.91', '', 'DESKTOP','https://elaraby.gt4it.com/erp/controllers/productController.php'); -- id=38
update user set blockedByLimits = 0;
INSERT IGNORE INTO relusergroupproperties (usergroupid, propertyid, propertyvalue, theorder)
                SELECT -1,propertyid , 0,0
                from properties; -- id=0
INSERT IGNORE INTO usergroupadmin (propertyid, isallowed)
                SELECT propertyid , propertydefault
                from properties; -- id=0
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 15:52:39";
UPDATE user SET loginip = "197.193.5.247", lastactivetime = "2026-09-25 19:22:39", deviceType = "MOBILE" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('index.php', '2026-09-25 19:22:39', '1', '', '197.193.5.247', '', 'MOBILE','https://elaraby.gt4it.com/erp/controllers/index.php'); -- id=39
UPDATE product SET lastbuyprice=productBuyPrice,lastbuyprice_withDiscount=productBuyPrice,meanbuyprice=productBuyPrice,meanbuyprice_withDiscount=productBuyPrice where lastbuyprice is null;
UPDATE product
                JOIN (
                       select productingredients.productId
                              ,sum(productnumber * quantity * productBuyPrice) as productBuyPrice
                              ,sum(productnumber * quantity * lastbuyprice) as lastbuyprice
                              ,sum(productnumber * quantity * lastbuyprice_withDiscount) as lastbuyprice_withDiscount
                              ,sum(productnumber * quantity * meanbuyprice) as meanbuyprice
                              ,sum(productnumber * quantity * meanbuyprice_withDiscount) as meanbuyprice_withDiscount
                              ,sum(productnumber * quantity * overAllAveragePrice) as overAllAveragePrice
                      from product
                      join productingredients on product.productId = productingredients.ingridientId
                      join productunit on productunit.productunitid = productingredients.unitId
                      group by productingredients.productId
                    ) as ingridientPrice ON ingridientPrice.productId =  product.productId
                SET product.productBuyPrice = ingridientPrice.productBuyPrice,
                        product.lastbuyprice = ingridientPrice.lastbuyprice,
                    product.lastbuyprice_withDiscount = ingridientPrice.lastbuyprice_withDiscount,
                    product.meanbuyprice = ingridientPrice.meanbuyprice,
                    product.meanbuyprice_withDiscount = ingridientPrice.meanbuyprice_withDiscount,
                    product.overAllAveragePrice = ingridientPrice.overAllAveragePrice;
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 15:52:39";
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('playStationCardController.php', '2026-09-25 19:22:39', '1', 'handleExpiredCards', '51.89.20.165', '', 'DESKTOP','https://elaraby.gt4it.com/erp/controllers/playStationCardController.php?do=handleExpiredCards'); -- id=40
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 15:52:54";
UPDATE user SET loginip = "197.193.5.247", lastactivetime = "2026-09-25 19:22:54", deviceType = "MOBILE" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('productController.php', '2026-09-25 19:22:54', '1', '', '197.193.5.247', '', 'MOBILE','https://elaraby.gt4it.com/erp/controllers/productController.php'); -- id=41
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 15:53:14";
UPDATE user SET loginip = "197.193.5.247", lastactivetime = "2026-09-25 19:23:14", deviceType = "MOBILE" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('storedetailController.php', '2026-09-25 19:23:14', '1', '', '197.193.5.247', '', 'MOBILE','https://elaraby.gt4it.com/erp/controllers/storedetailController.php'); -- id=42
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 15:53:31";
UPDATE user SET loginip = "197.193.5.247", lastactivetime = "2026-09-25 19:23:31", deviceType = "MOBILE" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('storedetailController.php', '2026-09-25 19:23:31', '1', 'show', '197.193.5.247', '', 'MOBILE','https://elaraby.gt4it.com/erp/controllers/storedetailController.php?do=show'); -- id=43
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 16:16:07";
update user set blockedByLimits = 0;
INSERT IGNORE INTO relusergroupproperties (usergroupid, propertyid, propertyvalue, theorder)
                SELECT -1,propertyid , 0,0
                from properties; -- id=0
INSERT IGNORE INTO usergroupadmin (propertyid, isallowed)
                SELECT propertyid , propertydefault
                from properties; -- id=0
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 17:20:50";
UPDATE user SET loginip = "197.193.5.247", lastactivetime = "2026-09-25 20:50:50", deviceType = "MOBILE" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('index.php', '2026-09-25 20:50:50', '1', '', '197.193.5.247', '', 'MOBILE','https://elaraby.gt4it.com/erp/controllers/index.php'); -- id=44
UPDATE product SET lastbuyprice=productBuyPrice,lastbuyprice_withDiscount=productBuyPrice,meanbuyprice=productBuyPrice,meanbuyprice_withDiscount=productBuyPrice where lastbuyprice is null;
UPDATE product
                JOIN (
                       select productingredients.productId
                              ,sum(productnumber * quantity * productBuyPrice) as productBuyPrice
                              ,sum(productnumber * quantity * lastbuyprice) as lastbuyprice
                              ,sum(productnumber * quantity * lastbuyprice_withDiscount) as lastbuyprice_withDiscount
                              ,sum(productnumber * quantity * meanbuyprice) as meanbuyprice
                              ,sum(productnumber * quantity * meanbuyprice_withDiscount) as meanbuyprice_withDiscount
                              ,sum(productnumber * quantity * overAllAveragePrice) as overAllAveragePrice
                      from product
                      join productingredients on product.productId = productingredients.ingridientId
                      join productunit on productunit.productunitid = productingredients.unitId
                      group by productingredients.productId
                    ) as ingridientPrice ON ingridientPrice.productId =  product.productId
                SET product.productBuyPrice = ingridientPrice.productBuyPrice,
                        product.lastbuyprice = ingridientPrice.lastbuyprice,
                    product.lastbuyprice_withDiscount = ingridientPrice.lastbuyprice_withDiscount,
                    product.meanbuyprice = ingridientPrice.meanbuyprice,
                    product.meanbuyprice_withDiscount = ingridientPrice.meanbuyprice_withDiscount,
                    product.overAllAveragePrice = ingridientPrice.overAllAveragePrice;
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 17:20:50";
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('playStationCardController.php', '2026-09-25 20:50:50', '1', 'handleExpiredCards', '51.89.20.165', '', 'DESKTOP','https://elaraby.gt4it.com/erp/controllers/playStationCardController.php?do=handleExpiredCards'); -- id=45
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 17:20:52";
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 17:21:03";
UPDATE user SET loginip = "197.193.5.247", lastactivetime = "2026-09-25 20:51:03", deviceType = "MOBILE" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('productController.php', '2026-09-25 20:51:03', '1', '', '197.193.5.247', '', 'MOBILE','https://elaraby.gt4it.com/erp/controllers/productController.php'); -- id=46
update user set blockedByLimits = 0;
INSERT IGNORE INTO relusergroupproperties (usergroupid, propertyid, propertyvalue, theorder)
                SELECT -1,propertyid , 0,0
                from properties; -- id=0
INSERT IGNORE INTO usergroupadmin (propertyid, isallowed)
                SELECT propertyid , propertydefault
                from properties; -- id=0
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 18:23:38";
UPDATE user SET loginip = "197.193.5.247", lastactivetime = "2026-09-25 21:53:38", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('index.php', '2026-09-25 21:53:38', '1', '', '197.193.5.247', '', 'DESKTOP','https://elaraby.gt4it.com/erp/controllers/index.php'); -- id=47
UPDATE product SET lastbuyprice=productBuyPrice,lastbuyprice_withDiscount=productBuyPrice,meanbuyprice=productBuyPrice,meanbuyprice_withDiscount=productBuyPrice where lastbuyprice is null;
UPDATE product
                JOIN (
                       select productingredients.productId
                              ,sum(productnumber * quantity * productBuyPrice) as productBuyPrice
                              ,sum(productnumber * quantity * lastbuyprice) as lastbuyprice
                              ,sum(productnumber * quantity * lastbuyprice_withDiscount) as lastbuyprice_withDiscount
                              ,sum(productnumber * quantity * meanbuyprice) as meanbuyprice
                              ,sum(productnumber * quantity * meanbuyprice_withDiscount) as meanbuyprice_withDiscount
                              ,sum(productnumber * quantity * overAllAveragePrice) as overAllAveragePrice
                      from product
                      join productingredients on product.productId = productingredients.ingridientId
                      join productunit on productunit.productunitid = productingredients.unitId
                      group by productingredients.productId
                    ) as ingridientPrice ON ingridientPrice.productId =  product.productId
                SET product.productBuyPrice = ingridientPrice.productBuyPrice,
                        product.lastbuyprice = ingridientPrice.lastbuyprice,
                    product.lastbuyprice_withDiscount = ingridientPrice.lastbuyprice_withDiscount,
                    product.meanbuyprice = ingridientPrice.meanbuyprice,
                    product.meanbuyprice_withDiscount = ingridientPrice.meanbuyprice_withDiscount,
                    product.overAllAveragePrice = ingridientPrice.overAllAveragePrice;
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 18:23:38";
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('playStationCardController.php', '2026-09-25 21:53:38', '1', 'handleExpiredCards', '51.89.20.165', '', 'DESKTOP','https://elaraby.gt4it.com/erp/controllers/playStationCardController.php?do=handleExpiredCards'); -- id=48
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 18:23:49";
UPDATE user SET loginip = "197.193.5.247", lastactivetime = "2026-09-25 21:53:49", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('usergroupController.php', '2026-09-25 21:53:49', '1', 'show', '197.193.5.247', '', 'DESKTOP','https://elaraby.gt4it.com/erp/controllers/usergroupController.php?do=show'); -- id=49
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 18:23:53";
UPDATE user SET loginip = "197.193.5.247", lastactivetime = "2026-09-25 21:53:53", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('usergroupController.php', '2026-09-25 21:53:53', '1', 'edit', '197.193.5.247', '', 'DESKTOP','https://elaraby.gt4it.com/erp/controllers/usergroupController.php?do=edit&id=3'); -- id=50
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 18:24:15";
UPDATE user SET loginip = "197.193.5.247", lastactivetime = "2026-09-25 21:54:15", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('usergroupController.php', '2026-09-25 21:54:15', '1', 'update', '197.193.5.247', '', 'DESKTOP','https://elaraby.gt4it.com/erp/controllers/usergroupController.php?do=update'); -- id=51
UPDATE usergroup SET storenegative=0 WHERE usergroupid = 3;
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 18:24:15";
UPDATE user SET loginip = "197.193.5.247", lastactivetime = "2026-09-25 21:54:15", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('usergroupController.php', '2026-09-25 21:54:15', '1', 'sucess', '197.193.5.247', '', 'DESKTOP','https://elaraby.gt4it.com/erp/controllers/usergroupController.php?do=sucess'); -- id=52
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 18:24:21";
UPDATE user SET loginip = "197.193.5.247", lastactivetime = "2026-09-25 21:54:21", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('usergroupController.php', '2026-09-25 21:54:21', '1', 'show', '197.193.5.247', '', 'DESKTOP','https://elaraby.gt4it.com/erp/controllers/usergroupController.php?do=show'); -- id=53
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 18:24:29";
UPDATE user SET loginip = "197.193.5.247", lastactivetime = "2026-09-25 21:54:29", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('billsettingsController.php', '2026-09-25 21:54:29', '1', 'show', '197.193.5.247', '', 'DESKTOP','https://elaraby.gt4it.com/erp/controllers/billsettingsController.php?do=show'); -- id=54
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 18:24:33";
UPDATE user SET loginip = "197.193.5.247", lastactivetime = "2026-09-25 21:54:33", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('billsettingsController.php', '2026-09-25 21:54:33', '1', 'edit', '197.193.5.247', '', 'DESKTOP','https://elaraby.gt4it.com/erp/controllers/billsettingsController.php?do=edit&id=1'); -- id=55
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 18:25:13";
UPDATE user SET loginip = "197.193.5.247", lastactivetime = "2026-09-25 21:55:13", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('billsettingsController.php', '2026-09-25 21:55:13', '1', 'update', '197.193.5.247', '', 'DESKTOP','https://elaraby.gt4it.com/erp/controllers/billsettingsController.php?do=update'); -- id=56
UPDATE billname SET name = 'فاتورة مشتريات', userid = '1', conditions = '0', billnamedate = '2026-09-25', billtype = '1' , billtype2 = '0' ,ordertype = '0' ,saveeffect = '0',productAndQuantityOnly = '0' ,posFlag = '0',posCode = '0',posType = '0',posWeightPrice = '0',checkDigit = '0',goodsReceiptApproval = '',parcodeType = '0',defVisaAccount = '0',defVisaAccountSelect = '0',isBankAccountTransfer = '0',taxOfDiscountVal='0',taxOfDiscountPrint='1',extraDiscountPlace='0',extraDiscountFixed = '0',extraDiscountPer='0',storeeffect='0',taxname='ضريبه القيمة المضافة'  WHERE billnameid = '1';
UPDATE billsettings SET billnameid = '1', billpropertyid = '1', billsettingsvalue = '1' WHERE billsettingsid = '1';
UPDATE billsettings SET billnameid = '1', billpropertyid = '2', billsettingsvalue = '0' WHERE billsettingsid = '2';
UPDATE billsettings SET billnameid = '1', billpropertyid = '3', billsettingsvalue = '0' WHERE billsettingsid = '3';
UPDATE billsettings SET billnameid = '1', billpropertyid = '4', billsettingsvalue = '1' WHERE billsettingsid = '4';
UPDATE billsettings SET billnameid = '1', billpropertyid = '5', billsettingsvalue = '1' WHERE billsettingsid = '5';
UPDATE billsettings SET billnameid = '1', billpropertyid = '6', billsettingsvalue = '0' WHERE billsettingsid = '6';
UPDATE billsettings SET billnameid = '1', billpropertyid = '7', billsettingsvalue = '0' WHERE billsettingsid = '7';
UPDATE billsettings SET billnameid = '1', billpropertyid = '8', billsettingsvalue = '1' WHERE billsettingsid = '8';
UPDATE billsettings SET billnameid = '1', billpropertyid = '9', billsettingsvalue = '1' WHERE billsettingsid = '9';
UPDATE billsettings SET billnameid = '1', billpropertyid = '10', billsettingsvalue = '0' WHERE billsettingsid = '10';
UPDATE billsettings SET billnameid = '1', billpropertyid = '11', billsettingsvalue = '1' WHERE billsettingsid = '11';
UPDATE billsettings SET billnameid = '1', billpropertyid = '12', billsettingsvalue = '1' WHERE billsettingsid = '12';
UPDATE billsettings SET billnameid = '1', billpropertyid = '13', billsettingsvalue = '0' WHERE billsettingsid = '13';
UPDATE billsettings SET billnameid = '1', billpropertyid = '15', billsettingsvalue = '0' WHERE billsettingsid = '14';
UPDATE billsettings SET billnameid = '1', billpropertyid = '16', billsettingsvalue = '0' WHERE billsettingsid = '119';
UPDATE billsettings SET billnameid = '1', billpropertyid = '17', billsettingsvalue = '0' WHERE billsettingsid = '120';
UPDATE billsettings SET billnameid = '1', billpropertyid = '18', billsettingsvalue = '0' WHERE billsettingsid = '121';
UPDATE billsettings SET billnameid = '1', billpropertyid = '20', billsettingsvalue = '1' WHERE billsettingsid = '123';
UPDATE billsettings SET billnameid = '1', billpropertyid = '21', billsettingsvalue = '1' WHERE billsettingsid = '124';
UPDATE billsettings SET billnameid = '1', billpropertyid = '22', billsettingsvalue = '1' WHERE billsettingsid = '125';
UPDATE billsettings SET billnameid = '1', billpropertyid = '23', billsettingsvalue = '0' WHERE billsettingsid = '126';
UPDATE billsettings SET billnameid = '1', billpropertyid = '24', billsettingsvalue = '0' WHERE billsettingsid = '127';
UPDATE billsettings SET billnameid = '1', billpropertyid = '25', billsettingsvalue = '0' WHERE billsettingsid = '128';
UPDATE billsettings SET billnameid = '1', billpropertyid = '26', billsettingsvalue = '0' WHERE billsettingsid = '129';
UPDATE billsettings SET billnameid = '1', billpropertyid = '29', billsettingsvalue = '1' WHERE billsettingsid = '242';
UPDATE billsettings SET billnameid = '1', billpropertyid = '30', billsettingsvalue = '0' WHERE billsettingsid = '248';
UPDATE billsettings SET billnameid = '1', billpropertyid = '31', billsettingsvalue = '0' WHERE billsettingsid = '249';
UPDATE billsettings SET billnameid = '1', billpropertyid = '32', billsettingsvalue = '0' WHERE billsettingsid = '250';
UPDATE billsettings SET billnameid = '1', billpropertyid = '33', billsettingsvalue = '0' WHERE billsettingsid = '251';
UPDATE billsettings SET billnameid = '1', billpropertyid = '34', billsettingsvalue = '0' WHERE billsettingsid = '303';
UPDATE billsettings SET billnameid = '1', billpropertyid = '35', billsettingsvalue = '0' WHERE billsettingsid = '304';
UPDATE billsettings SET billnameid = '1', billpropertyid = '36', billsettingsvalue = '0' WHERE billsettingsid = '305';
UPDATE billsettings SET billnameid = '1', billpropertyid = '37', billsettingsvalue = '0' WHERE billsettingsid = '324';
UPDATE billsettings SET billnameid = '1', billpropertyid = '38', billsettingsvalue = '0' WHERE billsettingsid = '331';
UPDATE billsettings SET billnameid = '1', billpropertyid = '39', billsettingsvalue = '1' WHERE billsettingsid = '338';
UPDATE billsettings SET billnameid = '1', billpropertyid = '40', billsettingsvalue = '1' WHERE billsettingsid = '345';
UPDATE billsettings SET billnameid = '1', billpropertyid = '41', billsettingsvalue = '0' WHERE billsettingsid = '352';
UPDATE billsettings SET billnameid = '1', billpropertyid = '42', billsettingsvalue = '0' WHERE billsettingsid = '359';
UPDATE billsettings SET billnameid = '1', billpropertyid = '43', billsettingsvalue = '0' WHERE billsettingsid = '366';
UPDATE billsettings SET billnameid = '1', billpropertyid = '44', billsettingsvalue = '1' WHERE billsettingsid = '373';
UPDATE billsettings SET billnameid = '1', billpropertyid = '45', billsettingsvalue = '0' WHERE billsettingsid = '380';
UPDATE billsettings SET billnameid = '1', billpropertyid = '46', billsettingsvalue = '0' WHERE billsettingsid = '387';
UPDATE billsettings SET billnameid = '1', billpropertyid = '47', billsettingsvalue = '2' WHERE billsettingsid = '394';
UPDATE billsettings SET billnameid = '1', billpropertyid = '48', billsettingsvalue = '1' WHERE billsettingsid = '401';
UPDATE billsettings SET billnameid = '1', billpropertyid = '49', billsettingsvalue = '1' WHERE billsettingsid = '655';
UPDATE billsettings SET billnameid = '1', billpropertyid = '50', billsettingsvalue = '0' WHERE billsettingsid = '656';
UPDATE billsettings SET billnameid = '1', billpropertyid = '51', billsettingsvalue = '1' WHERE billsettingsid = '657';
UPDATE billsettings SET billnameid = '1', billpropertyid = '52', billsettingsvalue = '0' WHERE billsettingsid = '658';
UPDATE billsettings SET billnameid = '1', billpropertyid = '53', billsettingsvalue = '0' WHERE billsettingsid = '659';
UPDATE billsettings SET billnameid = '1', billpropertyid = '54', billsettingsvalue = '0' WHERE billsettingsid = '665';
UPDATE billsettings SET billnameid = '1', billpropertyid = '56', billsettingsvalue = '0' WHERE billsettingsid = '686';
UPDATE billsettings SET billnameid = '1', billpropertyid = '57', billsettingsvalue = '0' WHERE billsettingsid = '699';
UPDATE billsettings SET billnameid = '1', billpropertyid = '58', billsettingsvalue = '0' WHERE billsettingsid = '702';
UPDATE billsettings SET billnameid = '1', billpropertyid = '59', billsettingsvalue = '0' WHERE billsettingsid = '749';
UPDATE billsettings SET billnameid = '1', billpropertyid = '60', billsettingsvalue = '0' WHERE billsettingsid = '761';
UPDATE billsettings SET billnameid = '1', billpropertyid = '61', billsettingsvalue = '0' WHERE billsettingsid = '762';
UPDATE billsettings SET billnameid = '1', billpropertyid = '62', billsettingsvalue = '0' WHERE billsettingsid = '785';
UPDATE billsettings SET billnameid = '1', billpropertyid = '63', billsettingsvalue = '1' WHERE billsettingsid = '788';
UPDATE billsettings SET billnameid = '1', billpropertyid = '64', billsettingsvalue = '0' WHERE billsettingsid = '798';
UPDATE billsettings SET billnameid = '1', billpropertyid = '65', billsettingsvalue = '1' WHERE billsettingsid = '871';
UPDATE billsettings SET billnameid = '1', billpropertyid = '66', billsettingsvalue = '0' WHERE billsettingsid = '873';
UPDATE billsettings SET billnameid = '1', billpropertyid = '67', billsettingsvalue = '0' WHERE billsettingsid = '874';
UPDATE billsettings SET billnameid = '1', billpropertyid = '68', billsettingsvalue = '0' WHERE billsettingsid = '887';
UPDATE billsettings SET billnameid = '1', billpropertyid = '69', billsettingsvalue = '0' WHERE billsettingsid = '890';
UPDATE billsettings SET billnameid = '1', billpropertyid = '71', billsettingsvalue = '0' WHERE billsettingsid = '892';
UPDATE billsettings SET billnameid = '1', billpropertyid = '72', billsettingsvalue = '0' WHERE billsettingsid = '893';
UPDATE billsettings SET billnameid = '1', billpropertyid = '73', billsettingsvalue = '1' WHERE billsettingsid = '894';
UPDATE billsettings SET billnameid = '1', billpropertyid = '74', billsettingsvalue = '0' WHERE billsettingsid = '895';
UPDATE billsettings SET billnameid = '1', billpropertyid = '75', billsettingsvalue = '0' WHERE billsettingsid = '896';
UPDATE billsettings SET billnameid = '1', billpropertyid = '76', billsettingsvalue = '0' WHERE billsettingsid = '897';
UPDATE billsettings SET billnameid = '1', billpropertyid = '77', billsettingsvalue = '0' WHERE billsettingsid = '930';
UPDATE billsettings SET billnameid = '1', billpropertyid = '78', billsettingsvalue = '0' WHERE billsettingsid = '931';
UPDATE billsettings SET billnameid = '1', billpropertyid = '79', billsettingsvalue = '0' WHERE billsettingsid = '932';
UPDATE billsettings SET billnameid = '1', billpropertyid = '80', billsettingsvalue = '0' WHERE billsettingsid = '933';
UPDATE billsettings SET billnameid = '1', billpropertyid = '81', billsettingsvalue = '0' WHERE billsettingsid = '934';
UPDATE billsettings SET billnameid = '1', billpropertyid = '82', billsettingsvalue = '1' WHERE billsettingsid = '935';
UPDATE billsettings SET billnameid = '1', billpropertyid = '83', billsettingsvalue = '0' WHERE billsettingsid = '960';
UPDATE billsettings SET billnameid = '1', billpropertyid = '84', billsettingsvalue = '0' WHERE billsettingsid = '965';
UPDATE billsettings SET billnameid = '1', billpropertyid = '85', billsettingsvalue = '0' WHERE billsettingsid = '970';
UPDATE billsettings SET billnameid = '1', billpropertyid = '86', billsettingsvalue = '0' WHERE billsettingsid = '971';
UPDATE billsettings SET billnameid = '1', billpropertyid = '87', billsettingsvalue = '0' WHERE billsettingsid = '972';
UPDATE billsettings SET billnameid = '1', billpropertyid = '88', billsettingsvalue = '0' WHERE billsettingsid = '973';
UPDATE billsettings SET billnameid = '1', billpropertyid = '89', billsettingsvalue = '0' WHERE billsettingsid = '1000';
UPDATE billsettings SET billnameid = '1', billpropertyid = '90', billsettingsvalue = '0' WHERE billsettingsid = '1001';
UPDATE billsettings SET billnameid = '1', billpropertyid = '91', billsettingsvalue = '1' WHERE billsettingsid = '1002';
UPDATE billsettings SET billnameid = '1', billpropertyid = '92', billsettingsvalue = '0' WHERE billsettingsid = '1003';
UPDATE billsettings SET billnameid = '1', billpropertyid = '93', billsettingsvalue = '0' WHERE billsettingsid = '1004';
UPDATE billsettings SET billnameid = '1', billpropertyid = '94', billsettingsvalue = '0' WHERE billsettingsid = '1005';
UPDATE billsettings SET billnameid = '1', billpropertyid = '95', billsettingsvalue = '1' WHERE billsettingsid = '1006';
UPDATE billsettings SET billnameid = '1', billpropertyid = '96', billsettingsvalue = '0' WHERE billsettingsid = '1007';
UPDATE billsettings SET billnameid = '1', billpropertyid = '97', billsettingsvalue = '1' WHERE billsettingsid = '1008';
UPDATE billsettings SET billnameid = '1', billpropertyid = '98', billsettingsvalue = '1' WHERE billsettingsid = '1009';
UPDATE billsettings SET billnameid = '1', billpropertyid = '99', billsettingsvalue = '0' WHERE billsettingsid = '1036';
UPDATE billsettings SET billnameid = '1', billpropertyid = '100', billsettingsvalue = '1' WHERE billsettingsid = '1030';
UPDATE billsettings SET billnameid = '1', billpropertyid = '101', billsettingsvalue = '0' WHERE billsettingsid = '1037';
UPDATE billsettings SET billnameid = '1', billpropertyid = '102', billsettingsvalue = '0' WHERE billsettingsid = '1038';
UPDATE billsettings SET billnameid = '1', billpropertyid = '103', billsettingsvalue = '0' WHERE billsettingsid = '1039';
UPDATE billsettings SET billnameid = '1', billpropertyid = '104', billsettingsvalue = '0' WHERE billsettingsid = '1040';
UPDATE billsettings SET billnameid = '1', billpropertyid = '105', billsettingsvalue = '0' WHERE billsettingsid = '1093';
UPDATE billsettings SET billnameid = '1', billpropertyid = '106', billsettingsvalue = '0' WHERE billsettingsid = '1094';
UPDATE billsettings SET billnameid = '1', billpropertyid = '107', billsettingsvalue = '0' WHERE billsettingsid = '1095';
UPDATE billsettings SET billnameid = '1', billpropertyid = '108', billsettingsvalue = '0' WHERE billsettingsid = '1096';
UPDATE billsettings SET billnameid = '1', billpropertyid = '109', billsettingsvalue = '0' WHERE billsettingsid = '1097';
UPDATE billsettings SET billnameid = '1', billpropertyid = '110', billsettingsvalue = '0' WHERE billsettingsid = '1098';
UPDATE billsettings SET billnameid = '1', billpropertyid = '111', billsettingsvalue = '0' WHERE billsettingsid = '1099';
UPDATE billsettings SET billnameid = '1', billpropertyid = '112', billsettingsvalue = '0' WHERE billsettingsid = '1100';
UPDATE billsettings SET billnameid = '1', billpropertyid = '113', billsettingsvalue = '0' WHERE billsettingsid = '1101';
UPDATE billsettings SET billnameid = '1', billpropertyid = '114', billsettingsvalue = '0' WHERE billsettingsid = '1102';
UPDATE billsettings SET billnameid = '1', billpropertyid = '115', billsettingsvalue = '0' WHERE billsettingsid = '1103';
UPDATE billsettings SET billnameid = '1', billpropertyid = '116', billsettingsvalue = '0' WHERE billsettingsid = '1104';
UPDATE billsettings SET billnameid = '1', billpropertyid = '117', billsettingsvalue = '0' WHERE billsettingsid = '1105';
UPDATE billsettings SET billnameid = '1', billpropertyid = '118', billsettingsvalue = '0' WHERE billsettingsid = '1106';
UPDATE billsettings SET billnameid = '1', billpropertyid = '119', billsettingsvalue = '0' WHERE billsettingsid = '1107';
UPDATE billsettings SET billnameid = '1', billpropertyid = '120', billsettingsvalue = '0' WHERE billsettingsid = '1108';
UPDATE billsettings SET billnameid = '1', billpropertyid = '121', billsettingsvalue = '0' WHERE billsettingsid = '1109';
UPDATE billsettings SET billnameid = '1', billpropertyid = '122', billsettingsvalue = '0' WHERE billsettingsid = '1110';
UPDATE billsettings SET billnameid = '1', billpropertyid = '123', billsettingsvalue = '0' WHERE billsettingsid = '1111';
UPDATE billsettings SET billnameid = '1', billpropertyid = '124', billsettingsvalue = '0' WHERE billsettingsid = '1112';
UPDATE billsettings SET billnameid = '1', billpropertyid = '125', billsettingsvalue = '0' WHERE billsettingsid = '1113';
UPDATE billsettings SET billnameid = '1', billpropertyid = '126', billsettingsvalue = '0' WHERE billsettingsid = '1114';
UPDATE billsettings SET billnameid = '1', billpropertyid = '127', billsettingsvalue = '0' WHERE billsettingsid = '1115';
UPDATE billsettings SET billnameid = '1', billpropertyid = '128', billsettingsvalue = '0' WHERE billsettingsid = '1116';
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 18:25:14";
UPDATE user SET loginip = "197.193.5.247", lastactivetime = "2026-09-25 21:55:14", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('billsettingsController.php', '2026-09-25 21:55:14', '1', 'sucess', '197.193.5.247', '', 'DESKTOP','https://elaraby.gt4it.com/erp/controllers/billsettingsController.php?do=sucess'); -- id=57
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-25 18:25:15";
UPDATE user SET loginip = "197.193.5.247", lastactivetime = "2026-09-25 21:55:15", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('billsettingsController.php', '2026-09-25 21:55:15', '1', 'show', '197.193.5.247', '', 'DESKTOP','https://elaraby.gt4it.com/erp/controllers/billsettingsController.php?do=show'); -- id=58
