UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-24 13:33:46";
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-24 15:34:28";
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` = 'D', taxcard = '123456789123', commercialregistration = '1234', costcenter = '1', clinic = '1', workshop = '1', transport = '1', manufacturing = '1', masterCopy = '0' , dailyentrydate = '2020-04-18' ,updatefiledate = '2024-02-13',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='',showepayrestaurant='0',showSellAllPriceInStoreDetail='0' WHERE programsettingsid = '1';
update user set blockedByLimits = 0;
INSERT INTO relusergroupproperties (usergroupid, propertyid, propertyvalue, theorder) VALUES (1, 511, 1,0),(1, 512, 0,0),(1, 513, 0,0),(1, 514, 0,0),(1, 515, 0,0),(1, 516, 0,0),(1, 517, 0,0),(1, 518, 0,0),(1, 519, 0,0),(1, 520, 0,0),(1, 521, 0,0),(1, 522, 1,0),(1, 523, 0,0),(1, 524, 0,0),(1, 525, 0,0),(1, 526, 0,0),(1, 527, 1,0),(1, 528, 1,0),(1, 529, 1,0),(1, 530, 0,0),(1, 531, 0,0),(1, 532, 0,0),(1, 533, 0,0),(1, 534, 1,0),(1, 535, 1,0),(1, 536, 1,0),(1, 537, 1,0),(1, 538, 1,0),(1, 539, 1,0),(1, 540, 0,0),(1, 541, 0,0),(1, 542, 0,0),(1, 543, 1,0),(1, 544, 0,0),(1, 545, 0,0),(1, 546, 0,0),(1, 547, 0,0),(1, 548, 0,0),(1, 549, 1,0),(1, 550, 0,0),(1, 551, 0,0),(1, 552, 0,0),(1, 553, 0,0),(1, 554, 0,0),(1, 555, 0,0),(1, 556, 0,0),(1, 557, 0,0),(1, 558, 0,0),(1, 559, 0,0),(1, 560, 0,0),(1, 561, 0,0),(1, 562, 0,0),(1, 563, 0,0),(1, 564, 0,0),(1, 565, 0,0),(1, 566, 0,0),(1, 567, 0,0),(1, 568, 0,0),(1, 569, 0,0),(1, 570, 1,0),(1, 571, 1,0),(1, 572, 1,0),(1, 573, 1,0),(1, 574, 1,0),(1, 575, 1,0),(1, 576, 1,0),(1, 577, 1,0),(1, 578, 1,0),(1, 579, 0,0),(1, 580, 0,0),(1, 581, 0,0),(1, 582, 0,0),(1, 583, 0,0),(1, 584, 0,0),(1, 585, 1,0),(1, 586, 1,0),(1, 587, 0,0),(1, 588, 1,0),(1, 589, 1,0),(1, 590, 1,0),(1, 591, 1,0),(1, 592, 1,0),(1, 593, 1,0),(1, 594, 1,0),(1, 595, 0,0),(1, 596, 0,0),(1, 597, 0,0),(1, 598, 0,0),(1, 599, 0,0),(1, 600, 0,0),(1, 601, 0,0),(1, 602, 0,0),(1, 603, 1,0),(1, 604, 1,0),(1, 605, 1,0),(1, 606, 1,0),(1, 607, 1,0),(1, 608, 1,0),(1, 609, 1,0),(1, 610, 1,0),(1, 611, 0,0),(1, 612, 1,0),(1, 613, 1,0),(1, 614, 1,0),(1, 615, 1,0),(1, 616, 0,0),(1, 617, 0,0),(1, 618, 0,0),(1, 619, 1,0),(1, 620, 1,0),(1, 621, 1,0),(1, 622, 1,0),(1, 623, 1,0),(1, 624, 1,0),(1, 625, 0,0),(1, 626, 0,0),(1, 627, 1,0),(1, 628, 1,0),(1, 629, 1,0),(1, 630, 0,0),(1, 631, 1,0),(1, 632, 0,0),(1, 633, 0,0),(1, 634, 0,0),(1, 635, 0,0),(1, 636, 1,0),(1, 637, 1,0),(1, 638, 1,0),(1, 639, 1,0),(1, 640, 0,0),(1, 641, 1,0),(1, 642, 1,0),(1, 643, 1,0),(1, 644, 1,0),(1, 645, 1,0),(1, 646, 1,0),(1, 647, 1,0),(1, 648, 1,0),(1, 649, 1,0),(1, 650, 1,0),(1, 651, 1,0),(1, 652, 1,0),(1, 653, 1,0),(1, 654, 1,0),(1, 655, 1,0),(1, 656, 1,0),(1, 657, 1,0),(1, 658, 1,0),(1, 659, 1,0),(1, 660, 1,0),(1, 661, 1,0),(1, 662, 1,0),(1, 663, 1,0),(1, 664, 1,0),(1, 665, 1,0),(1, 666, 1,0),(1, 667, 1,0),(1, 668, 1,0),(1, 669, 1,0),(1, 670, 1,0),(1, 671, 1,0),(1, 672, 1,0),(1, 673, 1,0),(1, 674, 1,0),(1, 675, 1,0),(1, 676, 1,0),(1, 677, 1,0),(1, 678, 1,0),(1, 679, 1,0),(1, 680, 1,0),(1, 681, 1,0),(1, 682, 1,0),(1, 683, 1,0),(1, 684, 1,0),(1, 685, 1,0),(1, 686, 1,0),(1, 687, 1,0),(1, 688, 1,0),(1, 689, 1,0),(1, 690, 1,0),(1, 691, 1,0),(1, 692, 1,0),(1, 693, 1,0),(1, 694, 1,0),(1, 695, 1,0),(1, 696, 1,0),(1, 697, 1,0),(1, 698, 1,0),(1, 699, 1,0),(1, 700, 1,0),(1, 701, 1,0),(1, 702, 1,0),(1, 703, 1,0),(1, 704, 1,0),(1, 705, 1,0),(1, 706, 1,0),(1, 707, 1,0),(1, 708, 1,0),(1, 709, 1,0),(1, 710, 1,0),(1, 711, 1,0),(1, 712, 1,0),(1, 713, 1,0),(1, 714, 1,0),(1, 715, 1,0),(1, 716, 1,0),(1, 717, 1,0),(1, 718, 1,0),(1, 719, 1,0),(1, 720, 1,0),(1, 721, 1,0),(1, 722, 1,0),(1, 723, 1,0),(1, 724, 1,0),(1, 725, 1,0),(1, 726, 1,0),(1, 727, 1,0),(1, 728, 1,0),(1, 729, 1,0),(1, 730, 1,0),(1, 731, 1,0),(1, 732, 1,0),(1, 733, 1,0),(1, 734, 1,0),(1, 735, 1,0),(1, 736, 1,0),(1, 737, 1,0),(1, 738, 1,0),(1, 739, 1,0),(1, 740, 1,0),(1, 741, 1,0),(1, 742, 1,0),(1, 743, 1,0),(1, 744, 1,0),(1, 745, 1,0),(1, 746, 1,0),(1, 747, 1,0),(1, 748, 1,0),(1, 749, 1,0),(1, 750, 1,0),(1, 751, 1,0),(1, 752, 1,0),(1, 753, 1,0),(1, 754, 1,0),(1, 755, 1,0),(1, 756, 1,0),(1, 757, 1,0),(1, 758, 1,0),(1, 759, 1,0),(1, 760, 1,0),(1, 761, 1,0),(1, 762, 1,0),(1, 763, 1,0),(1, 764, 1,0),(1, 765, 1,0),(1, 766, 1,0),(1, 767, 1,0),(1, 768, 1,0),(1, 769, 1,0),(1, 770, 1,0),(1, 771, 1,0),(1, 772, 1,0),(1, 773, 1,0),(1, 774, 1,0),(1, 775, 1,0),(1, 776, 1,0),(1, 777, 1,0),(1, 778, 1,0),(1, 779, 1,0),(1, 780, 1,0),(1, 781, 1,0),(1, 782, 1,0),(1, 783, 1,0),(1, 784, 1,0),(1, 785, 1,0),(1, 786, 1,0),(1, 787, 1,0),(1, 788, 1,0),(1, 789, 1,0),(1, 790, 1,0),(1, 791, 1,0),(2, 511, 1,0),(2, 512, 0,0),(2, 513, 0,0),(2, 514, 0,0),(2, 515, 0,0),(2, 516, 0,0),(2, 517, 0,0),(2, 518, 0,0),(2, 519, 0,0),(2, 520, 0,0),(2, 521, 0,0),(2, 522, 1,0),(2, 523, 0,0),(2, 524, 0,0),(2, 525, 0,0),(2, 526, 0,0),(2, 527, 1,0),(2, 528, 1,0),(2, 529, 1,0),(2, 530, 0,0),(2, 531, 0,0),(2, 532, 0,0),(2, 533, 0,0),(2, 534, 1,0),(2, 535, 1,0),(2, 536, 1,0),(2, 537, 1,0),(2, 538, 1,0),(2, 539, 1,0),(2, 540, 0,0),(2, 541, 0,0),(2, 542, 0,0),(2, 543, 1,0),(2, 544, 0,0),(2, 545, 0,0),(2, 546, 0,0),(2, 547, 0,0),(2, 548, 0,0),(2, 549, 1,0),(2, 550, 0,0),(2, 551, 0,0),(2, 552, 0,0),(2, 553, 0,0),(2, 554, 0,0),(2, 555, 0,0),(2, 556, 0,0),(2, 557, 0,0),(2, 558, 0,0),(2, 559, 0,0),(2, 560, 0,0),(2, 561, 0,0),(2, 562, 0,0),(2, 563, 0,0),(2, 564, 0,0),(2, 565, 0,0),(2, 566, 0,0),(2, 567, 0,0),(2, 568, 0,0),(2, 569, 0,0),(2, 570, 1,0),(2, 571, 1,0),(2, 572, 1,0),(2, 573, 1,0),(2, 574, 1,0),(2, 575, 1,0),(2, 576, 1,0),(2, 577, 1,0),(2, 578, 1,0),(2, 579, 0,0),(2, 580, 0,0),(2, 581, 0,0),(2, 582, 0,0),(2, 583, 0,0),(2, 584, 0,0),(2, 585, 1,0),(2, 586, 1,0),(2, 587, 0,0),(2, 588, 1,0),(2, 589, 1,0),(2, 590, 1,0),(2, 591, 1,0),(2, 592, 1,0),(2, 593, 1,0),(2, 594, 1,0),(2, 595, 0,0),(2, 596, 0,0),(2, 597, 0,0),(2, 598, 0,0),(2, 599, 0,0),(2, 600, 0,0),(2, 601, 0,0),(2, 602, 0,0),(2, 603, 1,0),(2, 604, 1,0),(2, 605, 1,0),(2, 606, 1,0),(2, 607, 1,0),(2, 608, 1,0),(2, 609, 1,0),(2, 610, 1,0),(2, 611, 0,0),(2, 612, 1,0),(2, 613, 1,0),(2, 614, 1,0),(2, 615, 1,0),(2, 616, 0,0),(2, 617, 0,0),(2, 618, 0,0),(2, 619, 1,0),(2, 620, 1,0),(2, 621, 1,0),(2, 622, 1,0),(2, 623, 1,0),(2, 624, 1,0),(2, 625, 0,0),(2, 626, 0,0),(2, 627, 1,0),(2, 628, 1,0),(2, 629, 1,0),(2, 630, 0,0),(2, 631, 1,0),(2, 632, 0,0),(2, 633, 0,0),(2, 634, 0,0),(2, 635, 0,0),(2, 636, 1,0),(2, 637, 1,0),(2, 638, 1,0),(2, 639, 1,0),(2, 640, 0,0),(2, 641, 1,0),(2, 642, 1,0),(2, 643, 1,0),(2, 644, 1,0),(2, 645, 1,0),(2, 646, 1,0),(2, 647, 1,0),(2, 648, 1,0),(2, 649, 1,0),(2, 650, 1,0),(2, 651, 1,0),(2, 652, 1,0),(2, 653, 1,0),(2, 654, 1,0),(2, 655, 1,0),(2, 656, 1,0),(2, 657, 1,0),(2, 658, 1,0),(2, 659, 1,0),(2, 660, 1,0),(2, 661, 1,0),(2, 662, 1,0),(2, 663, 1,0),(2, 664, 1,0),(2, 665, 1,0),(2, 666, 1,0),(2, 667, 1,0),(2, 668, 1,0),(2, 669, 1,0),(2, 670, 1,0),(2, 671, 1,0),(2, 672, 1,0),(2, 673, 1,0),(2, 674, 1,0),(2, 675, 1,0),(2, 676, 1,0),(2, 677, 1,0),(2, 678, 1,0),(2, 679, 1,0),(2, 680, 1,0),(2, 681, 1,0),(2, 682, 1,0),(2, 683, 1,0),(2, 684, 1,0),(2, 685, 1,0),(2, 686, 1,0),(2, 687, 1,0),(2, 688, 1,0),(2, 689, 1,0),(2, 690, 1,0),(2, 691, 1,0),(2, 692, 1,0),(2, 693, 1,0),(2, 694, 1,0),(2, 695, 1,0),(2, 696, 1,0),(2, 697, 1,0),(2, 698, 1,0),(2, 699, 1,0),(2, 700, 1,0),(2, 701, 1,0),(2, 702, 1,0),(2, 703, 1,0),(2, 704, 1,0),(2, 705, 1,0),(2, 706, 1,0),(2, 707, 1,0),(2, 708, 1,0),(2, 709, 1,0),(2, 710, 1,0),(2, 711, 1,0),(2, 712, 1,0),(2, 713, 1,0),(2, 714, 1,0),(2, 715, 1,0),(2, 716, 1,0),(2, 717, 1,0),(2, 718, 1,0),(2, 719, 1,0),(2, 720, 1,0),(2, 721, 1,0),(2, 722, 1,0),(2, 723, 1,0),(2, 724, 1,0),(2, 725, 1,0),(2, 726, 1,0),(2, 727, 1,0),(2, 728, 1,0),(2, 729, 1,0),(2, 730, 1,0),(2, 731, 1,0),(2, 732, 1,0),(2, 733, 1,0),(2, 734, 1,0),(2, 735, 1,0),(2, 736, 1,0),(2, 737, 1,0),(2, 738, 1,0),(2, 739, 1,0),(2, 740, 1,0),(2, 741, 1,0),(2, 742, 1,0),(2, 743, 1,0),(2, 744, 1,0),(2, 745, 1,0),(2, 746, 1,0),(2, 747, 1,0),(2, 748, 1,0),(2, 749, 1,0),(2, 750, 1,0),(2, 751, 1,0),(2, 752, 1,0),(2, 753, 1,0),(2, 754, 1,0),(2, 755, 1,0),(2, 756, 1,0),(2, 757, 1,0),(2, 758, 1,0),(2, 759, 1,0),(2, 760, 1,0),(2, 761, 1,0),(2, 762, 1,0),(2, 763, 1,0),(2, 764, 1,0),(2, 765, 1,0),(2, 766, 1,0),(2, 767, 1,0),(2, 768, 1,0),(2, 769, 1,0),(2, 770, 1,0),(2, 771, 1,0),(2, 772, 1,0),(2, 773, 1,0),(2, 774, 1,0),(2, 775, 1,0),(2, 776, 1,0),(2, 777, 1,0),(2, 778, 1,0),(2, 779, 1,0),(2, 780, 1,0),(2, 781, 1,0),(2, 782, 1,0),(2, 783, 1,0),(2, 784, 1,0),(2, 785, 1,0),(2, 786, 1,0),(2, 787, 1,0),(2, 788, 1,0),(2, 789, 1,0),(2, 790, 1,0),(2, 791, 1,0),(3, 511, 1,0),(3, 512, 0,0),(3, 513, 0,0),(3, 514, 0,0),(3, 515, 0,0),(3, 516, 0,0),(3, 517, 0,0),(3, 518, 0,0),(3, 519, 0,0),(3, 520, 0,0),(3, 521, 0,0),(3, 522, 1,0),(3, 523, 0,0),(3, 524, 0,0),(3, 525, 0,0),(3, 526, 0,0),(3, 527, 1,0),(3, 528, 1,0),(3, 529, 1,0),(3, 530, 0,0),(3, 531, 0,0),(3, 532, 0,0),(3, 533, 0,0),(3, 534, 1,0),(3, 535, 1,0),(3, 536, 1,0),(3, 537, 1,0),(3, 538, 1,0),(3, 539, 1,0),(3, 540, 0,0),(3, 541, 0,0),(3, 542, 0,0),(3, 543, 1,0),(3, 544, 0,0),(3, 545, 0,0),(3, 546, 0,0),(3, 547, 0,0),(3, 548, 0,0),(3, 549, 1,0),(3, 550, 0,0),(3, 551, 0,0),(3, 552, 0,0),(3, 553, 0,0),(3, 554, 0,0),(3, 555, 0,0),(3, 556, 0,0),(3, 557, 0,0),(3, 558, 0,0),(3, 559, 0,0),(3, 560, 0,0),(3, 561, 0,0),(3, 562, 0,0),(3, 563, 0,0),(3, 564, 0,0),(3, 565, 0,0),(3, 566, 0,0),(3, 567, 0,0),(3, 568, 0,0),(3, 569, 0,0),(3, 570, 1,0),(3, 571, 1,0),(3, 572, 1,0),(3, 573, 1,0),(3, 574, 1,0),(3, 575, 1,0),(3, 576, 1,0),(3, 577, 1,0),(3, 578, 1,0),(3, 579, 0,0),(3, 580, 0,0),(3, 581, 0,0),(3, 582, 0,0),(3, 583, 0,0),(3, 584, 0,0),(3, 585, 1,0),(3, 586, 1,0),(3, 587, 0,0),(3, 588, 1,0),(3, 589, 1,0),(3, 590, 1,0),(3, 591, 1,0),(3, 592, 1,0),(3, 593, 1,0),(3, 594, 1,0),(3, 595, 0,0),(3, 596, 0,0),(3, 597, 0,0),(3, 598, 0,0),(3, 599, 0,0),(3, 600, 0,0),(3, 601, 0,0),(3, 602, 0,0),(3, 603, 1,0),(3, 604, 1,0),(3, 605, 1,0),(3, 606, 1,0),(3, 607, 1,0),(3, 608, 1,0),(3, 609, 1,0),(3, 610, 1,0),(3, 611, 0,0),(3, 612, 1,0),(3, 613, 1,0),(3, 614, 1,0),(3, 615, 1,0),(3, 616, 0,0),(3, 617, 0,0),(3, 618, 0,0),(3, 619, 1,0),(3, 620, 1,0),(3, 621, 1,0),(3, 622, 1,0),(3, 623, 1,0),(3, 624, 1,0),(3, 625, 0,0),(3, 626, 0,0),(3, 627, 1,0),(3, 628, 1,0),(3, 629, 1,0),(3, 630, 0,0),(3, 631, 1,0),(3, 632, 0,0),(3, 633, 0,0),(3, 634, 0,0),(3, 635, 0,0),(3, 636, 1,0),(3, 637, 1,0),(3, 638, 1,0),(3, 639, 1,0),(3, 640, 0,0),(3, 641, 1,0),(3, 642, 1,0),(3, 643, 1,0),(3, 644, 1,0),(3, 645, 1,0),(3, 646, 1,0),(3, 647, 1,0),(3, 648, 1,0),(3, 649, 1,0),(3, 650, 1,0),(3, 651, 1,0),(3, 652, 1,0),(3, 653, 1,0),(3, 654, 1,0),(3, 655, 1,0),(3, 656, 1,0),(3, 657, 1,0),(3, 658, 1,0),(3, 659, 1,0),(3, 660, 1,0),(3, 661, 1,0),(3, 662, 1,0),(3, 663, 1,0),(3, 664, 1,0),(3, 665, 1,0),(3, 666, 1,0),(3, 667, 1,0),(3, 668, 1,0),(3, 669, 1,0),(3, 670, 1,0),(3, 671, 1,0),(3, 672, 1,0),(3, 673, 1,0),(3, 674, 1,0),(3, 675, 1,0),(3, 676, 1,0),(3, 677, 1,0),(3, 678, 1,0),(3, 679, 1,0),(3, 680, 1,0),(3, 681, 1,0),(3, 682, 1,0),(3, 683, 1,0),(3, 684, 1,0),(3, 685, 1,0),(3, 686, 1,0),(3, 687, 1,0),(3, 688, 1,0),(3, 689, 1,0),(3, 690, 1,0),(3, 691, 1,0),(3, 692, 1,0),(3, 693, 1,0),(3, 694, 1,0),(3, 695, 1,0),(3, 696, 1,0),(3, 697, 1,0),(3, 698, 1,0),(3, 699, 1,0),(3, 700, 1,0),(3, 701, 1,0),(3, 702, 1,0),(3, 703, 1,0),(3, 704, 1,0),(3, 705, 1,0),(3, 706, 1,0),(3, 707, 1,0),(3, 708, 1,0),(3, 709, 1,0),(3, 710, 1,0),(3, 711, 1,0),(3, 712, 1,0),(3, 713, 1,0),(3, 714, 1,0),(3, 715, 1,0),(3, 716, 1,0),(3, 717, 1,0),(3, 718, 1,0),(3, 719, 1,0),(3, 720, 1,0),(3, 721, 1,0),(3, 722, 1,0),(3, 723, 1,0),(3, 724, 1,0),(3, 725, 1,0),(3, 726, 1,0),(3, 727, 1,0),(3, 728, 1,0),(3, 729, 1,0),(3, 730, 1,0),(3, 731, 1,0),(3, 732, 1,0),(3, 733, 1,0),(3, 734, 1,0),(3, 735, 1,0),(3, 736, 1,0),(3, 737, 1,0),(3, 738, 1,0),(3, 739, 1,0),(3, 740, 1,0),(3, 741, 1,0),(3, 742, 1,0),(3, 743, 1,0),(3, 744, 1,0),(3, 745, 1,0),(3, 746, 1,0),(3, 747, 1,0),(3, 748, 1,0),(3, 749, 1,0),(3, 750, 1,0),(3, 751, 1,0),(3, 752, 1,0),(3, 753, 1,0),(3, 754, 1,0),(3, 755, 1,0),(3, 756, 1,0),(3, 757, 1,0),(3, 758, 1,0),(3, 759, 1,0),(3, 760, 1,0),(3, 761, 1,0),(3, 762, 1,0),(3, 763, 1,0),(3, 764, 1,0),(3, 765, 1,0),(3, 766, 1,0),(3, 767, 1,0),(3, 768, 1,0),(3, 769, 1,0),(3, 770, 1,0),(3, 771, 1,0),(3, 772, 1,0),(3, 773, 1,0),(3, 774, 1,0),(3, 775, 1,0),(3, 776, 1,0),(3, 777, 1,0),(3, 778, 1,0),(3, 779, 1,0),(3, 780, 1,0),(3, 781, 1,0),(3, 782, 1,0),(3, 783, 1,0),(3, 784, 1,0),(3, 785, 1,0),(3, 786, 1,0),(3, 787, 1,0),(3, 788, 1,0),(3, 789, 1,0),(3, 790, 1,0),(3, 791, 1,0),(4, 511, 1,0),(4, 512, 0,0),(4, 513, 0,0),(4, 514, 0,0),(4, 515, 0,0),(4, 516, 0,0),(4, 517, 0,0),(4, 518, 0,0),(4, 519, 0,0),(4, 520, 0,0),(4, 521, 0,0),(4, 522, 1,0),(4, 523, 0,0),(4, 524, 0,0),(4, 525, 0,0),(4, 526, 0,0),(4, 527, 1,0),(4, 528, 1,0),(4, 529, 1,0),(4, 530, 0,0),(4, 531, 0,0),(4, 532, 0,0),(4, 533, 0,0),(4, 534, 1,0),(4, 535, 1,0),(4, 536, 1,0),(4, 537, 1,0),(4, 538, 1,0),(4, 539, 1,0),(4, 540, 0,0),(4, 541, 0,0),(4, 542, 0,0),(4, 543, 1,0),(4, 544, 0,0),(4, 545, 0,0),(4, 546, 0,0),(4, 547, 0,0),(4, 548, 0,0),(4, 549, 1,0),(4, 550, 0,0),(4, 551, 0,0),(4, 552, 0,0),(4, 553, 0,0),(4, 554, 0,0),(4, 555, 0,0),(4, 556, 0,0),(4, 557, 0,0),(4, 558, 0,0),(4, 559, 0,0),(4, 560, 0,0),(4, 561, 0,0),(4, 562, 0,0),(4, 563, 0,0),(4, 564, 0,0),(4, 565, 0,0),(4, 566, 0,0),(4, 567, 0,0),(4, 568, 0,0),(4, 569, 0,0),(4, 570, 1,0),(4, 571, 1,0),(4, 572, 1,0),(4, 573, 1,0),(4, 574, 1,0),(4, 575, 1,0),(4, 576, 1,0),(4, 577, 1,0),(4, 578, 1,0),(4, 579, 0,0),(4, 580, 0,0),(4, 581, 0,0),(4, 582, 0,0),(4, 583, 0,0),(4, 584, 0,0),(4, 585, 1,0),(4, 586, 1,0),(4, 587, 0,0),(4, 588, 1,0),(4, 589, 1,0),(4, 590, 1,0),(4, 591, 1,0),(4, 592, 1,0),(4, 593, 1,0),(4, 594, 1,0),(4, 595, 0,0),(4, 596, 0,0),(4, 597, 0,0),(4, 598, 0,0),(4, 599, 0,0),(4, 600, 0,0),(4, 601, 0,0),(4, 602, 0,0),(4, 603, 1,0),(4, 604, 1,0),(4, 605, 1,0),(4, 606, 1,0),(4, 607, 1,0),(4, 608, 1,0),(4, 609, 1,0),(4, 610, 1,0),(4, 611, 0,0),(4, 612, 1,0),(4, 613, 1,0),(4, 614, 1,0),(4, 615, 1,0),(4, 616, 0,0),(4, 617, 0,0),(4, 618, 0,0),(4, 619, 1,0),(4, 620, 1,0),(4, 621, 1,0),(4, 622, 1,0),(4, 623, 1,0),(4, 624, 1,0),(4, 625, 0,0),(4, 626, 0,0),(4, 627, 1,0),(4, 628, 1,0),(4, 629, 1,0),(4, 630, 0,0),(4, 631, 1,0),(4, 632, 0,0),(4, 633, 0,0),(4, 634, 0,0),(4, 635, 0,0),(4, 636, 1,0),(4, 637, 1,0),(4, 638, 1,0),(4, 639, 1,0),(4, 640, 0,0),(4, 641, 1,0),(4, 642, 1,0),(4, 643, 1,0),(4, 644, 1,0),(4, 645, 1,0),(4, 646, 1,0),(4, 647, 1,0),(4, 648, 1,0),(4, 649, 1,0),(4, 650, 1,0),(4, 651, 1,0),(4, 652, 1,0),(4, 653, 1,0),(4, 654, 1,0),(4, 655, 1,0),(4, 656, 1,0),(4, 657, 1,0),(4, 658, 1,0),(4, 659, 1,0),(4, 660, 1,0),(4, 661, 1,0),(4, 662, 1,0),(4, 663, 1,0),(4, 664, 1,0),(4, 665, 1,0),(4, 666, 1,0),(4, 667, 1,0),(4, 668, 1,0),(4, 669, 1,0),(4, 670, 1,0),(4, 671, 1,0),(4, 672, 1,0),(4, 673, 1,0),(4, 674, 1,0),(4, 675, 1,0),(4, 676, 1,0),(4, 677, 1,0),(4, 678, 1,0),(4, 679, 1,0),(4, 680, 1,0),(4, 681, 1,0),(4, 682, 1,0),(4, 683, 1,0),(4, 684, 1,0),(4, 685, 1,0),(4, 686, 1,0),(4, 687, 1,0),(4, 688, 1,0),(4, 689, 1,0),(4, 690, 1,0),(4, 691, 1,0),(4, 692, 1,0),(4, 693, 1,0),(4, 694, 1,0),(4, 695, 1,0),(4, 696, 1,0),(4, 697, 1,0),(4, 698, 1,0),(4, 699, 1,0),(4, 700, 1,0),(4, 701, 1,0),(4, 702, 1,0),(4, 703, 1,0),(4, 704, 1,0),(4, 705, 1,0),(4, 706, 1,0),(4, 707, 1,0),(4, 708, 1,0),(4, 709, 1,0),(4, 710, 1,0),(4, 711, 1,0),(4, 712, 1,0),(4, 713, 1,0),(4, 714, 1,0),(4, 715, 1,0),(4, 716, 1,0),(4, 717, 1,0),(4, 718, 1,0),(4, 719, 1,0),(4, 720, 1,0),(4, 721, 1,0),(4, 722, 1,0),(4, 723, 1,0),(4, 724, 1,0),(4, 725, 1,0),(4, 726, 1,0),(4, 727, 1,0),(4, 728, 1,0),(4, 729, 1,0),(4, 730, 1,0),(4, 731, 1,0),(4, 732, 1,0),(4, 733, 1,0),(4, 734, 1,0),(4, 735, 1,0),(4, 736, 1,0),(4, 737, 1,0),(4, 738, 1,0),(4, 739, 1,0),(4, 740, 1,0),(4, 741, 1,0),(4, 742, 1,0),(4, 743, 1,0),(4, 744, 1,0),(4, 745, 1,0),(4, 746, 1,0),(4, 747, 1,0),(4, 748, 1,0),(4, 749, 1,0),(4, 750, 1,0),(4, 751, 1,0),(4, 752, 1,0),(4, 753, 1,0),(4, 754, 1,0),(4, 755, 1,0),(4, 756, 1,0),(4, 757, 1,0),(4, 758, 1,0),(4, 759, 1,0),(4, 760, 1,0),(4, 761, 1,0),(4, 762, 1,0),(4, 763, 1,0),(4, 764, 1,0),(4, 765, 1,0),(4, 766, 1,0),(4, 767, 1,0),(4, 768, 1,0),(4, 769, 1,0),(4, 770, 1,0),(4, 771, 1,0),(4, 772, 1,0),(4, 773, 1,0),(4, 774, 1,0),(4, 775, 1,0),(4, 776, 1,0),(4, 777, 1,0),(4, 778, 1,0),(4, 779, 1,0),(4, 780, 1,0),(4, 781, 1,0),(4, 782, 1,0),(4, 783, 1,0),(4, 784, 1,0),(4, 785, 1,0),(4, 786, 1,0),(4, 787, 1,0),(4, 788, 1,0),(4, 789, 1,0),(4, 790, 1,0),(4, 791, 1,0); -- id=2256
INSERT IGNORE INTO relusergroupproperties (usergroupid, propertyid, propertyvalue, theorder)
                SELECT -1,propertyid , 0,0
                from properties; -- id=3380
INSERT IGNORE INTO usergroupadmin (propertyid, isallowed)
                SELECT propertyid , propertydefault
                from properties; -- id=1
UPDATE usergroupadmin
                INNER JOIN relusergroupproperties ON (usergroupadmin.propertyid = relusergroupproperties.propertyid and relusergroupproperties.usergroupid = 1)
                SET usergroupadmin.isallowed = relusergroupproperties.propertyvalue;
INSERT INTO user (username, password, usergroupid, employeename, currentdate, conditions, saveid,userstoreid ,awardrate,searchinonesave, branchId,question, answer,blockedByLimits,directSaveBills,userstoreidDef,empid,obygyDoctorId,lang,viewclients,viewbills,storeSupervisor,storeSupervisorStores,projectids,bankids,saveids,searchinonestorebalance,storeids,webApiId,closeSavid,charityids,laterNakdiUserIds,awardrategomla,awardratehalf,dellaternakdipayed,accountids) VALUES ('admin', 'manager', '1', 'admin', '2026-09-24', '0', '1', '0' ,'0' ,'0','0','what is my question','how','0','0','1','0','0','','1','1','1','1','0','0','0','1','0','0','0','','','0','0','0',''); -- id=1
INSERT INTO user (userid, username, password, usergroupid, employeename, currentdate, conditions, saveid,userstoreid ,awardrate,searchinonesave, branchId,question, answer,blockedByLimits,loginip,lastactivetime,directSaveBills,userstoreidDef,storeSupervisor,storeSupervisorStores,awardrategomla,awardratehalf,dellaternakdipayed) VALUES ('-1', 'GT4', '456', '-1', 'GT4', '2026-09-24', '0', '1' ,'0' ,'0','0','0','what is','my company is GT4','0','197.193.5.247','2026-09-24 19:06:01','0','0','1','1','0','0','0'); -- id=18446744073709551615
INSERT INTO billsettings (`billnameid`, `billpropertyid`, `billsettingsvalue`) VALUES (1, 105, 0),(1, 106, 0),(1, 107, 0),(1, 108, 0),(1, 109, 0),(1, 110, 0),(1, 111, 0),(1, 112, 0),(1, 113, 0),(1, 114, 0),(1, 115, 0),(1, 116, 0),(1, 117, 0),(1, 118, 0),(1, 119, 0),(1, 120, 0),(1, 121, 0),(1, 122, 0),(1, 123, 0),(1, 124, 0),(1, 125, 0),(1, 126, 0),(1, 127, 0),(1, 128, 0),(1, 129, 0); -- id=1093
INSERT INTO billsettings (`billnameid`, `billpropertyid`, `billsettingsvalue`) VALUES (3, 107, 0),(3, 109, 0),(3, 110, 0),(3, 111, 0),(3, 117, 0),(3, 118, 0),(3, 119, 0),(3, 120, 0),(3, 121, 0),(3, 122, 0),(3, 123, 0),(3, 124, 0),(3, 125, 0),(3, 126, 0),(3, 127, 0),(3, 128, 0),(3, 129, 0); -- id=1118
INSERT INTO billsettings (`billnameid`, `billpropertyid`, `billsettingsvalue`) VALUES (4, 106, 0),(4, 107, 0),(4, 108, 0),(4, 109, 0),(4, 110, 0),(4, 111, 0),(4, 112, 0),(4, 117, 0),(4, 118, 0),(4, 119, 0),(4, 120, 0),(4, 121, 0),(4, 122, 0),(4, 123, 0),(4, 124, 0),(4, 125, 0),(4, 126, 0),(4, 127, 0),(4, 128, 0),(4, 129, 0); -- id=1135
INSERT INTO billsettings (`billnameid`, `billpropertyid`, `billsettingsvalue`) VALUES (5, 106, 0),(5, 107, 0),(5, 108, 0),(5, 109, 0),(5, 110, 0),(5, 111, 0),(5, 112, 0),(5, 117, 0),(5, 118, 0),(5, 119, 0),(5, 120, 0),(5, 121, 0),(5, 122, 0),(5, 123, 0),(5, 124, 0),(5, 125, 0),(5, 126, 0),(5, 127, 0),(5, 128, 0),(5, 129, 0); -- id=1155
INSERT INTO billsettings (`billnameid`, `billpropertyid`, `billsettingsvalue`) VALUES (6, 105, 0),(6, 106, 0),(6, 107, 0),(6, 108, 0),(6, 109, 0),(6, 110, 0),(6, 111, 0),(6, 112, 0),(6, 117, 0),(6, 118, 0),(6, 119, 0),(6, 120, 0),(6, 121, 0),(6, 122, 0),(6, 123, 0),(6, 124, 0),(6, 125, 0),(6, 126, 0),(6, 127, 0),(6, 128, 0),(6, 129, 0); -- id=1175
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 = '2024-02-13',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 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 = '2024-02-13',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-24 15:37:05";
UPDATE user SET loginip = "197.193.5.247", lastactivetime = "2026-09-24 19:07:05", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('index.php', '2026-09-24 19:07:05', '1', '', '197.193.5.247', '', 'DESKTOP','https://elaraby.gt4it.com/erp/controllers/index.php'); -- id=1
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-24 15:37:57";
UPDATE user SET loginip = "197.193.5.247", lastactivetime = "2026-09-24 19:07:57", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('index.php', '2026-09-24 19:07:57', '1', '', '197.193.5.247', '', 'DESKTOP','https://elaraby.gt4it.com/erp/controllers/index.php'); -- id=2
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-24 16:40:24";
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 = '2024-02-13',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-24 16:40:31";
UPDATE user SET loginip = "197.193.5.247", lastactivetime = "2026-09-24 20:10:32", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('index.php', '2026-09-24 20:10:32', '1', '', '197.193.5.247', '', 'DESKTOP','https://elaraby.gt4it.com/erp/controllers/index.php'); -- id=3
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';
INSERT INTO simplemanufacturesetting (storeid, reducestoreamount,productsproductionequation,orderclient,taskOrderName,lowOutPriceAlert) VALUES ('1', '1', '0','0','0','0'); -- id=1
INSERT INTO currency (name, symbol, conversionFactor, conditions, userid, sysDate,otherconversionFactor) VALUES ('جنيه', 'EGP', '1', '0', '1', '2026-09-24 20:10:32','1'); -- id=1
INSERT INTO save (saveid, savename, savecurrentvalue, savedetails, savedate, conditions, userid,treeId) VALUES ('1', 'الخزنة الرئيسية', '0', '', '2026-09-24', '0', '1','383'); -- id=1
INSERT INTO unit (unitName, unitSymbol, unitDescription, unitDate, conditions, userId) VALUES ('قطعة', '', '', '2026-09-24', '0', '1'); -- id=1
INSERT INTO store (storeId, storeName, storeDate, storeDescription, conditions, userId,treeId,treeIdBetween) VALUES ('1', 'المخزن الرئيسي', '2026-09-24', "المخزن الرئيسي", '0', '1','382','51'); -- id=1
INSERT INTO sparepartstore (sparepartstoreId, storeName, storeDate, storeDescription, conditions, userId) VALUES ('1', 'مخزن قطع الغيار', '2026-09-24', 'مخزن قطع الغيار', '0', '1'); -- id=1
INSERT INTO supplier (supplierid, suppliername, supplieraddress, supplierphone, suppliercurrentDebt, supplierdetails, conditions, userid, supplierdate) VALUES ('1', 'مباشر', '', '', '0', 'مباشر', '0', '1', '2026-09-24'); -- id=1
INSERT INTO client (clientname, clientaddress, clientphone, clientmobile, clientdebt, clientdetails, conditions, clientdate, userid,clientareaid,clientcode,dailyentryid ,rondomtxt,clientStoreIds,obygyPatientId,debtLimit,typeclientid,priceTypeId,card_number,file_faida,specialDiscount,specialDiscountVal,file,addDate,mandobCollectRatio,webApiId,clientRFID,linkedSupplierId,postponeDays,studentid,taxnumber,password,clientTypeForTree,treeId,husbandNameObgy,txtNameE,facility,delegate,txtemail,commercial,valtaxnumber,clientaddress2,country,delegateid,datecustomeraccount,taxfile,fileimg,webStoreType,clientaddress3,tagids,email_verified,email_otp,email_otp_expiry) VALUES ('نقدي' , '', '', '', '0', 'نقدي', '0', '2026-09-24', '1', '1','','0','','-10','0','0','','0','0','','0','0','','','0','0','','0','0','0','','','0','384','','','','','','','','','','0','','','','0','','','0','0',''); -- id=1
UPDATE product SET lastbuyprice=productBuyPrice,lastbuyprice_withDiscount=productBuyPrice,meanbuyprice=productBuyPrice,meanbuyprice_withDiscount=productBuyPrice where lastbuyprice is null;
CALL generateParcodes (99999);
DELETE availableparcode FROM availableparcode
                join product on product.parcode = availableparcode.value;
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-24 16:40:34";
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('playStationCardController.php', '2026-09-24 20:10:34', '1', 'handleExpiredCards', '51.89.20.165', '', 'DESKTOP','https://elaraby.gt4it.com/erp/controllers/playStationCardController.php?do=handleExpiredCards'); -- id=4
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-24 16:40:52";
UPDATE user SET loginip = "197.193.5.247", lastactivetime = "2026-09-24 20:10:52", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('usergroupController.php', '2026-09-24 20:10:52', '1', 'show', '197.193.5.247', '', 'DESKTOP','https://elaraby.gt4it.com/erp/controllers/usergroupController.php?do=show'); -- id=5
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-24 16:40:55";
UPDATE user SET loginip = "197.193.5.247", lastactivetime = "2026-09-24 20:10:55", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('usergroupController.php', '2026-09-24 20:10:55', '1', 'edit', '197.193.5.247', '', 'DESKTOP','https://elaraby.gt4it.com/erp/controllers/usergroupController.php?do=edit&id=1'); -- id=6
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-24 16:41:14";
UPDATE user SET loginip = "197.193.5.247", lastactivetime = "2026-09-24 20:11:14", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('usergroupController.php', '2026-09-24 20:11:14', '1', 'update', '197.193.5.247', '', 'DESKTOP','https://elaraby.gt4it.com/erp/controllers/usergroupController.php?do=update'); -- id=7
UPDATE relusergroupproperties SET usergroupid = '1', propertyid = '632', propertyvalue = '1',theorder = '0' WHERE relusergrouppropertiesid = '2377';
UPDATE relusergroupproperties SET usergroupid = '1', propertyid = '640', propertyvalue = '1',theorder = '0' WHERE relusergrouppropertiesid = '2385';
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-24 16:41:15";
UPDATE user SET loginip = "197.193.5.247", lastactivetime = "2026-09-24 20:11:15", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('usergroupController.php', '2026-09-24 20:11:15', '1', 'sucess', '197.193.5.247', '', 'DESKTOP','https://elaraby.gt4it.com/erp/controllers/usergroupController.php?do=sucess'); -- id=8
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-24 16:41:16";
UPDATE user SET loginip = "197.193.5.247", lastactivetime = "2026-09-24 20:11:16", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('usergroupController.php', '2026-09-24 20:11:16', '1', 'show', '197.193.5.247', '', 'DESKTOP','https://elaraby.gt4it.com/erp/controllers/usergroupController.php?do=show'); -- id=9
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 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-24 17:16:24";
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-24 17:27:47";
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-09-24 17:28:12";
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-24 18:23:25";
