INSERT INTO `storereport` VALUES
(5733,96,2,19.000,1,1957,'تحويل منتجات من المخزن','storemovementController.php',-11.000,-30.000,1,'2026-04-12',0,0,0),
(5734,96,7,19.000,0,1957,'تحويل منتجات إلى المخزن','storemovementController.php',-647.000,-628.000,1,'2026-04-12',0,0,0),
(5735,98,2,16.000,1,1958,'تحويل منتجات من المخزن','storemovementController.php',-14.000,-30.000,1,'2026-04-12',0,0,0),
(5736,98,7,16.000,0,1958,'تحويل منتجات إلى المخزن','storemovementController.php',24.000,40.000,1,'2026-04-12',0,0,0),
(5737,97,2,41.000,1,1959,'تحويل منتجات من المخزن','storemovementController.php',-194.000,-235.000,1,'2026-04-12',0,0,0),
(5738,97,7,41.000,0,1959,'تحويل منتجات إلى المخزن','storemovementController.php',-243.000,-202.000,1,'2026-04-12',0,0,0),
(5739,6,2,4.000,1,1960,'تحويل منتجات من المخزن','storemovementController.php',-67.000,-71.000,1,'2026-04-12',0,0,0),
(5740,6,7,4.000,0,1960,'تحويل منتجات إلى المخزن','storemovementController.php',142.000,146.000,1,'2026-04-12',0,0,0),
(5741,8,2,2.000,1,1961,'تحويل منتجات من المخزن','storemovementController.php',-93.000,-95.000,1,'2026-04-12',0,0,0),
(5742,8,7,2.000,0,1961,'تحويل منتجات إلى المخزن','storemovementController.php',412.000,414.000,1,'2026-04-12',0,0,0),
(5743,18,2,2.000,1,1962,'تحويل منتجات من المخزن','storemovementController.php',-154.000,-156.000,1,'2026-04-12',0,0,0),
(5744,18,7,2.000,0,1962,'تحويل منتجات إلى المخزن','storemovementController.php',209.000,211.000,1,'2026-04-12',0,0,0),
(5745,69,7,1001.000,0,229,'اضاÙة Ùاتورة مشتريات','buyBillController.php',0.000,1001.000,1,'2026-04-12',0,0,0),
(5746,16,7,813.000,1,1963,'تحويل منتجات من المخزن','storemovementController.php',2226.000,1413.000,1,'2026-04-12',0,0,0),
(5747,16,1,813.000,0,1963,'تحويل منتجات إلى المخزن','storemovementController.php',14047.000,14860.000,1,'2026-04-12',0,0,0),
(5748,69,7,1000.000,1,1964,'تحويل منتجات من المخزن','storemovementController.php',1001.000,1.000,1,'2026-04-12',0,0,0),
(5749,69,1,1000.000,0,1964,'تحويل منتجات إلى المخزن','storemovementController.php',0.000,1000.000,1,'2026-04-12',0,0,0),
(5750,237,2,27.000,0,230,'اضاÙة Ùاتورة مشتريات','buyBillController.php',0.000,27.000,1,'2026-04-12',0,0,0),
(5751,237,2,26.000,1,1965,'تحويل منتجات من المخزن','storemovementController.php',27.000,1.000,1,'2026-04-12',0,0,0),
(5752,237,7,26.000,0,1965,'تحويل منتجات إلى المخزن','storemovementController.php',0.000,26.000,1,'2026-04-12',0,0,0),
(5753,92,2,48.000,1,1966,'تحويل منتجات من المخزن','storemovementController.php',32.000,-16.000,1,'2026-04-12',0,0,0),
(5754,92,7,48.000,0,1966,'تحويل منتجات إلى المخزن','storemovementController.php',38.000,86.000,1,'2026-04-12',0,0,0),
(5755,91,2,28.000,1,1967,'تحويل منتجات من المخزن','storemovementController.php',-115.000,-143.000,1,'2026-04-12',0,0,0),
(5756,91,7,28.000,0,1967,'تحويل منتجات إلى المخزن','storemovementController.php',116.000,144.000,1,'2026-04-12',0,0,0),
(5757,93,2,64.000,1,1968,'تحويل منتجات من المخزن','storemovementController.php',-42.000,-106.000,1,'2026-04-12',0,0,0),
(5758,93,7,64.000,0,1968,'تحويل منتجات إلى المخزن','storemovementController.php',43.000,107.000,1,'2026-04-12',0,0,0),
(5759,35,2,2.000,1,1969,'تحويل منتجات من المخزن','storemovementController.php',-5.000,-7.000,1,'2026-04-12',0,0,0),
(5760,35,7,2.000,0,1969,'تحويل منتجات إلى المخزن','storemovementController.php',6.000,8.000,1,'2026-04-12',0,0,0),
(5761,282,1,0.000,0,282,'إضاÙة منتج','productController.php',0.000,0.000,1,'2026-04-12',0,0,0),
(5762,283,1,0.000,0,283,'إضاÙة منتج','productController.php',0.000,0.000,1,'2026-04-12',0,0,0),
(5763,284,1,0.000,0,284,'إضاÙة منتج','productController.php',0.000,0.000,1,'2026-04-12',0,0,0),
(5764,285,1,0.000,0,285,'إضاÙة منتج','productController.php',0.000,0.000,1,'2026-04-12',0,0,0),
(5765,286,1,0.000,0,286,'إضاÙة منتج','productController.php',0.000,0.000,1,'2026-04-12',0,0,0),
(5766,282,7,3.000,0,231,'اضاÙة Ùاتورة مشتريات','buyBillController.php',0.000,3.000,1,'2026-04-12',0,0,0),
(5767,283,7,3.000,0,231,'اضاÙة Ùاتورة مشتريات','buyBillController.php',0.000,3.000,1,'2026-04-12',0,0,0),
(5768,284,7,5.000,0,231,'اضاÙة Ùاتورة مشتريات','buyBillController.php',0.000,5.000,1,'2026-04-12',0,0,0),
(5769,285,7,11.000,0,231,'اضاÙة Ùاتورة مشتريات','buyBillController.php',0.000,11.000,1,'2026-04-12',0,0,0),
(5770,286,7,11.000,0,231,'اضاÙة Ùاتورة مشتريات','buyBillController.php',0.000,11.000,1,'2026-04-12',0,0,0),
(5771,145,7,14.000,1,1970,'تحويل منتجات من المخزن','storemovementController.php',280.000,266.000,1,'2026-04-12',0,0,0),
(5772,145,1,14.000,0,1970,'تحويل منتجات إلى المخزن','storemovementController.php',163.000,177.000,1,'2026-04-12',0,0,0),
(5773,150,7,55.000,1,1971,'تحويل منتجات من المخزن','storemovementController.php',189.000,134.000,1,'2026-04-12',0,0,0),
(5774,150,1,55.000,0,1971,'تحويل منتجات إلى المخزن','storemovementController.php',10.000,65.000,1,'2026-04-12',0,0,0),
(5775,282,7,3.000,1,1972,'تحويل منتجات من المخزن','storemovementController.php',3.000,0.000,1,'2026-04-12',0,0,0),
(5776,282,1,3.000,0,1972,'تحويل منتجات إلى المخزن','storemovementController.php',0.000,3.000,1,'2026-04-12',0,0,0),
(5777,283,7,12.000,1,1973,'تحويل منتجات من المخزن','storemovementController.php',3.000,-9.000,1,'2026-04-12',0,0,0),
(5778,283,1,12.000,0,1973,'تحويل منتجات إلى المخزن','storemovementController.php',0.000,12.000,1,'2026-04-12',0,0,0),
(5779,284,7,5.000,1,1974,'تحويل منتجات من المخزن','storemovementController.php',5.000,0.000,1,'2026-04-12',0,0,0),
(5780,284,1,5.000,0,1974,'تحويل منتجات إلى المخزن','storemovementController.php',0.000,5.000,1,'2026-04-12',0,0,0),
(5781,285,7,11.000,1,1975,'تحويل منتجات من المخزن','storemovementController.php',11.000,0.000,1,'2026-04-12',0,0,0),
(5782,285,1,11.000,0,1975,'تحويل منتجات إلى المخزن','storemovementController.php',0.000,11.000,1,'2026-04-12',0,0,0),
(5783,286,7,11.000,1,1976,'تحويل منتجات من المخزن','storemovementController.php',11.000,0.000,1,'2026-04-12',0,0,0),
(5784,286,1,11.000,0,1976,'تحويل منتجات إلى المخزن','storemovementController.php',0.000,11.000,1,'2026-04-12',0,0,0),
(5785,287,1,0.000,0,287,'إضاÙة منتج','productController.php',0.000,0.000,1,'2026-04-12',0,0,0),
(5786,288,1,0.000,0,288,'إضاÙة منتج','productController.php',0.000,0.000,1,'2026-04-12',0,0,0),
(5787,287,7,1.000,0,232,'اضاÙة Ùاتورة مشتريات','buyBillController.php',0.000,1.000,1,'2026-04-12',0,0,0),
(5788,288,7,10.000,0,232,'اضاÙة Ùاتورة مشتريات','buyBillController.php',0.000,10.000,1,'2026-04-12',0,0,0),
(5789,287,7,1.000,1,1977,'تحويل منتجات من المخزن','storemovementController.php',1.000,0.000,1,'2026-04-12',0,0,0),
(5790,287,1,1.000,0,1977,'تحويل منتجات إلى المخزن','storemovementController.php',0.000,1.000,1,'2026-04-12',0,0,0),
(5791,288,7,10.000,1,1978,'تحويل منتجات من المخزن','storemovementController.php',10.000,0.000,1,'2026-04-12',0,0,0),
(5792,288,1,10.000,0,1978,'تحويل منتجات إلى المخزن','storemovementController.php',0.000,10.000,1,'2026-04-12',0,0,0),
(5793,17,7,2.000,1,1979,'تحويل منتجات من المخزن','storemovementController.php',543.000,541.000,1,'2026-04-12',0,0,0),
(5794,17,1,2.000,0,1979,'تحويل منتجات إلى المخزن','storemovementController.php',301.000,303.000,1,'2026-04-12',0,0,0),
(5795,89,7,48.000,1,1980,'تحويل منتجات من المخزن','storemovementController.php',346.000,298.000,1,'2026-04-12',0,0,0),
(5796,89,1,48.000,0,1980,'تحويل منتجات إلى المخزن','storemovementController.php',932.000,980.000,1,'2026-04-12',0,0,0),
(5797,90,7,286.000,1,1981,'تحويل منتجات من المخزن','storemovementController.php',230.000,-56.000,1,'2026-04-12',0,0,0),
(5798,90,1,286.000,0,1981,'تحويل منتجات إلى المخزن','storemovementController.php',256.000,542.000,1,'2026-04-12',0,0,0),
(5799,91,7,65.000,1,1982,'تحويل منتجات من المخزن','storemovementController.php',144.000,79.000,1,'2026-04-12',0,0,0),
(5800,91,1,65.000,0,1982,'تحويل منتجات إلى المخزن','storemovementController.php',2176.000,2241.000,1,'2026-04-12',0,0,0),
(5801,27,7,500.000,1,1983,'تحويل منتجات من المخزن','storemovementController.php',-123.000,-623.000,1,'2026-04-12',0,0,0),
(5802,27,1,500.000,0,1983,'تحويل منتجات إلى المخزن','storemovementController.php',6467.000,6967.000,1,'2026-04-12',0,0,0),
(5803,109,7,300.000,1,1984,'تحويل منتجات من المخزن','storemovementController.php',2868.000,2568.000,1,'2026-04-12',0,0,0),
(5804,109,1,300.000,0,1984,'تحويل منتجات إلى المخزن','storemovementController.php',5118.000,5418.000,1,'2026-04-12',0,0,0),
(5805,102,7,18.000,1,1985,'تحويل منتجات من المخزن','storemovementController.php',145.000,127.000,1,'2026-04-12',0,0,0),
(5806,102,1,18.000,0,1985,'تحويل منتجات إلى المخزن','storemovementController.php',0.000,18.000,1,'2026-04-12',0,0,0),
(5807,16,7,908.000,1,1986,'تحويل منتجات من المخزن','storemovementController.php',1413.000,505.000,1,'2026-04-12',0,0,0),
(5808,16,1,908.000,0,1986,'تحويل منتجات إلى المخزن','storemovementController.php',14860.000,15768.000,1,'2026-04-12',0,0,0),
(5809,49,7,94.000,1,1987,'تحويل منتجات من المخزن','storemovementController.php',110.000,16.000,1,'2026-04-12',0,0,0),
(5810,49,1,94.000,0,1987,'تحويل منتجات إلى المخزن','storemovementController.php',-65.000,29.000,1,'2026-04-12',0,0,0),
(5811,24,7,175.000,1,1988,'تحويل منتجات من المخزن','storemovementController.php',378.000,203.000,1,'2026-04-12',0,0,0),
(5812,24,1,175.000,0,1988,'تحويل منتجات إلى المخزن','storemovementController.php',71.000,246.000,1,'2026-04-12',0,0,0),
(5813,15,7,362.000,1,1989,'تحويل منتجات من المخزن','storemovementController.php',1782.000,1420.000,1,'2026-04-12',0,0,0),
(5814,15,1,362.000,0,1989,'تحويل منتجات إلى المخزن','storemovementController.php',1756.000,2118.000,1,'2026-04-12',0,0,0),
(5815,223,7,75.000,1,1990,'تحويل منتجات من المخزن','storemovementController.php',146.000,71.000,1,'2026-04-12',0,0,0),
(5816,223,1,75.000,0,1990,'تحويل منتجات إلى المخزن','storemovementController.php',836.000,911.000,1,'2026-04-12',0,0,0),
(5817,15,7,615.000,1,1991,'تحويل منتجات من المخزن','storemovementController.php',1420.000,805.000,1,'2026-04-12',0,0,0),
(5818,15,1,615.000,0,1991,'تحويل منتجات إلى المخزن','storemovementController.php',2118.000,2733.000,1,'2026-04-12',0,0,0),
(5819,223,7,133.000,1,1992,'تحويل منتجات من المخزن','storemovementController.php',71.000,-62.000,1,'2026-04-12',0,0,0),
(5820,223,1,133.000,0,1992,'تحويل منتجات إلى المخزن','storemovementController.php',911.000,1044.000,1,'2026-04-12',0,0,0),
(5821,1,7,505.000,1,1993,'تحويل منتجات من المخزن','storemovementController.php',686.000,181.000,1,'2026-04-12',0,0,0),
(5822,1,1,505.000,0,1993,'تحويل منتجات إلى المخزن','storemovementController.php',4121.000,4626.000,1,'2026-04-12',0,0,0),
(5823,2,7,219.000,1,1994,'تحويل منتجات من المخزن','storemovementController.php',786.000,567.000,1,'2026-04-12',0,0,0),
(5824,2,1,219.000,0,1994,'تحويل منتجات إلى المخزن','storemovementController.php',4898.000,5117.000,1,'2026-04-12',0,0,0),
(5825,13,7,827.000,1,1995,'تحويل منتجات من المخزن','storemovementController.php',3498.000,2671.000,1,'2026-04-12',0,0,0),
(5826,13,1,827.000,0,1995,'تحويل منتجات إلى المخزن','storemovementController.php',11979.000,12806.000,1,'2026-04-12',0,0,0),
(5827,109,7,125.000,1,1996,'تحويل منتجات من المخزن','storemovementController.php',2568.000,2443.000,1,'2026-04-12',0,0,0),
(5828,109,1,125.000,0,1996,'تحويل منتجات إلى المخزن','storemovementController.php',5418.000,5543.000,1,'2026-04-12',0,0,0),
(5829,266,1,12.000,0,233,'اضاÙة Ùاتورة مشتريات','buyBillController.php',0.000,12.000,1,'2026-04-13',0,0,0),
(5830,142,1,19.000,1,1997,'تحويل منتجات من المخزن','storemovementController.php',132.000,113.000,1,'2026-04-13',0,0,0),
(5831,142,7,19.000,0,1997,'تحويل منتجات إلى المخزن','storemovementController.php',29.000,48.000,1,'2026-04-13',0,0,0),
(5832,143,1,30.000,1,1998,'تحويل منتجات من المخزن','storemovementController.php',89.000,59.000,1,'2026-04-13',0,0,0),
(5833,143,7,30.000,0,1998,'تحويل منتجات إلى المخزن','storemovementController.php',202.000,232.000,1,'2026-04-13',0,0,0),
(5834,266,1,12.000,1,1999,'تحويل منتجات من المخزن','storemovementController.php',12.000,0.000,1,'2026-04-13',0,0,0),
(5835,266,7,12.000,0,1999,'تحويل منتجات إلى المخزن','storemovementController.php',0.000,12.000,1,'2026-04-13',0,0,0),
(5836,13,7,426.000,1,2000,'تحويل منتجات من المخزن','storemovementController.php',2671.000,2245.000,1,'2026-04-13',0,0,0),
(5837,13,1,426.000,0,2000,'تحويل منتجات إلى المخزن','storemovementController.php',12806.000,13232.000,1,'2026-04-13',0,0,0),
(5838,142,1,1.000,1,2001,'تحويل منتجات من المخزن','storemovementController.php',113.000,112.000,1,'2026-04-13',0,0,0),
(5839,142,7,1.000,0,2001,'تحويل منتجات إلى المخزن','storemovementController.php',48.000,49.000,1,'2026-04-13',0,0,0),
(5840,145,1,1.000,1,2002,'تحويل منتجات من المخزن','storemovementController.php',177.000,176.000,1,'2026-04-13',0,0,0),
(5841,145,7,1.000,0,2002,'تحويل منتجات إلى المخزن','storemovementController.php',266.000,267.000,1,'2026-04-13',0,0,0),
(5842,141,1,1.000,1,2003,'تحويل منتجات من المخزن','storemovementController.php',20.000,19.000,1,'2026-04-13',0,0,0),
(5843,141,7,1.000,0,2003,'تحويل منتجات إلى المخزن','storemovementController.php',130.000,131.000,1,'2026-04-13',0,0,0),
(5844,143,1,1.000,1,2004,'تحويل منتجات من المخزن','storemovementController.php',59.000,58.000,1,'2026-04-13',0,0,0),
(5845,143,7,1.000,0,2004,'تحويل منتجات إلى المخزن','storemovementController.php',232.000,233.000,1,'2026-04-13',0,0,0),
(5846,140,1,1.000,0,234,'اضاÙة Ùاتورة مشتريات','buyBillController.php',0.000,1.000,1,'2026-04-13',0,0,0),
(5847,269,1,1.000,0,235,'اضاÙة Ùاتورة مشتريات','buyBillController.php',0.000,1.000,1,'2026-04-13',0,0,0),
(5848,136,1,15.000,1,2005,'تحويل منتجات من المخزن','storemovementController.php',24.000,9.000,1,'2026-04-13',0,0,0),
(5849,136,7,15.000,0,2005,'تحويل منتجات إلى المخزن','storemovementController.php',6.000,21.000,1,'2026-04-13',0,0,0),
(5850,138,1,16.000,1,2006,'تحويل منتجات من المخزن','storemovementController.php',14.000,-2.000,1,'2026-04-13',0,0,0),
(5851,138,7,16.000,0,2006,'تحويل منتجات إلى المخزن','storemovementController.php',28.000,44.000,1,'2026-04-13',0,0,0),
(5852,139,1,15.000,1,2007,'تحويل منتجات من المخزن','storemovementController.php',-1.000,-16.000,1,'2026-04-13',0,0,0),
(5853,139,7,15.000,0,2007,'تحويل منتجات إلى المخزن','storemovementController.php',26.000,41.000,1,'2026-04-13',0,0,0),
(5854,140,1,1.000,1,2008,'تحويل منتجات من المخزن','storemovementController.php',1.000,0.000,1,'2026-04-13',0,0,0),
(5855,140,7,1.000,0,2008,'تحويل منتجات إلى المخزن','storemovementController.php',56.000,57.000,1,'2026-04-13',0,0,0),
(5856,269,1,1.000,1,2009,'تحويل منتجات من المخزن','storemovementController.php',1.000,0.000,1,'2026-04-13',0,0,0),
(5857,269,7,1.000,0,2009,'تحويل منتجات إلى المخزن','storemovementController.php',0.000,1.000,1,'2026-04-13',0,0,0),
(5858,26,7,2131.000,1,2010,'تحويل منتجات من المخزن','storemovementController.php',992.000,-1139.000,1,'2026-04-13',0,0,0),
(5859,26,1,2131.000,0,2010,'تحويل منتجات إلى المخزن','storemovementController.php',6186.000,8317.000,1,'2026-04-13',0,0,0),
(5860,27,7,1600.000,1,2011,'تحويل منتجات من المخزن','storemovementController.php',-623.000,-2223.000,1,'2026-04-13',0,0,0),
(5861,27,1,1600.000,0,2011,'تحويل منتجات إلى المخزن','storemovementController.php',6967.000,8567.000,1,'2026-04-13',0,0,0),
(5862,91,7,88.000,1,2012,'تحويل منتجات من المخزن','storemovementController.php',79.000,-9.000,1,'2026-04-13',0,0,0),
(5863,91,1,88.000,0,2012,'تحويل منتجات إلى المخزن','storemovementController.php',2241.000,2329.000,1,'2026-04-13',0,0,0),
(5864,90,7,22.000,1,2013,'تحويل منتجات من المخزن','storemovementController.php',-56.000,-78.000,1,'2026-04-13',0,0,0),
(5865,90,1,22.000,0,2013,'تحويل منتجات إلى المخزن','storemovementController.php',542.000,564.000,1,'2026-04-13',0,0,0),
(5866,89,7,31.000,1,2014,'تحويل منتجات من المخزن','storemovementController.php',298.000,267.000,1,'2026-04-13',0,0,0),
(5867,89,1,31.000,0,2014,'تحويل منتجات إلى المخزن','storemovementController.php',980.000,1011.000,1,'2026-04-13',0,0,0),
(5868,289,1,0.000,0,289,'إضاÙة منتج','productController.php',0.000,0.000,1,'2026-04-13',0,0,0),
(5869,55,7,74.000,1,2015,'تحويل منتجات من المخزن','storemovementController.php',8.000,-66.000,1,'2026-04-13',0,0,0),
(5870,55,1,74.000,0,2015,'تحويل منتجات إلى المخزن','storemovementController.php',227.000,301.000,1,'2026-04-13',0,0,0),
(5871,53,7,23.000,1,2016,'تحويل منتجات من المخزن','storemovementController.php',12.000,-11.000,1,'2026-04-13',0,0,0),
(5872,53,1,23.000,0,2016,'تحويل منتجات إلى المخزن','storemovementController.php',117.000,140.000,1,'2026-04-13',0,0,0),
(5873,54,7,14.000,1,2017,'تحويل منتجات من المخزن','storemovementController.php',4.000,-10.000,1,'2026-04-13',0,0,0),
(5874,54,1,14.000,0,2017,'تحويل منتجات إلى المخزن','storemovementController.php',56.000,70.000,1,'2026-04-13',0,0,0),
(5875,56,7,46.000,1,2018,'تحويل منتجات من المخزن','storemovementController.php',9.000,-37.000,1,'2026-04-13',0,0,0),
(5876,56,1,46.000,0,2018,'تحويل منتجات إلى المخزن','storemovementController.php',38.000,84.000,1,'2026-04-13',0,0,0),
(5877,57,7,4.000,1,2019,'تحويل منتجات من المخزن','storemovementController.php',37.000,33.000,1,'2026-04-13',0,0,0),
(5878,57,1,4.000,0,2019,'تحويل منتجات إلى المخزن','storemovementController.php',305.000,309.000,1,'2026-04-13',0,0,0),
(5879,56,7,2.000,1,2020,'تحويل منتجات من المخزن','storemovementController.php',-37.000,-39.000,1,'2026-04-13',0,0,0),
(5880,56,1,2.000,0,2020,'تحويل منتجات إلى المخزن','storemovementController.php',84.000,86.000,1,'2026-04-13',0,0,0),
(5881,24,7,194.000,1,2021,'تحويل منتجات من المخزن','storemovementController.php',203.000,9.000,1,'2026-04-13',0,0,0),
(5882,24,1,194.000,0,2021,'تحويل منتجات إلى المخزن','storemovementController.php',246.000,440.000,1,'2026-04-13',0,0,0),
(5883,27,7,500.000,1,2022,'تحويل منتجات من المخزن','storemovementController.php',-2223.000,-2723.000,1,'2026-04-13',0,0,0),
(5884,27,1,500.000,0,2022,'تحويل منتجات إلى المخزن','storemovementController.php',8567.000,9067.000,1,'2026-04-13',0,0,0),
(5885,8,8,1.000,0,236,'اضاÙة Ùاتورة مشتريات','buyBillController.php',78.000,79.000,1,'2026-04-13',0,0,0),
(5886,6,8,1.000,0,236,'اضاÙة Ùاتورة مشتريات','buyBillController.php',48.000,49.000,1,'2026-04-13',0,0,0),
(5887,16,8,1.000,0,236,'اضاÙة Ùاتورة مشتريات','buyBillController.php',0.000,1.000,1,'2026-04-13',0,0,0),
(5888,17,8,1.000,0,236,'اضاÙة Ùاتورة مشتريات','buyBillController.php',0.000,1.000,1,'2026-04-13',0,0,0),
(5889,19,8,1.000,0,236,'اضاÙة Ùاتورة مشتريات','buyBillController.php',0.000,1.000,1,'2026-04-13',0,0,0),
(5890,4,8,1.000,0,236,'اضاÙة Ùاتورة مشتريات','buyBillController.php',0.000,1.000,1,'2026-04-13',0,0,0),
(5891,1,8,1.000,0,236,'اضاÙة Ùاتورة مشتريات','buyBillController.php',0.000,1.000,1,'2026-04-13',0,0,0),
(5892,15,8,1.000,0,236,'اضاÙة Ùاتورة مشتريات','buyBillController.php',0.000,1.000,1,'2026-04-13',0,0,0),
(5893,223,8,1.000,0,236,'اضاÙة Ùاتورة مشتريات','buyBillController.php',0.000,1.000,1,'2026-04-13',0,0,0),
(5894,13,8,1.000,0,236,'اضاÙة Ùاتورة مشتريات','buyBillController.php',0.000,1.000,1,'2026-04-13',0,0,0),
(5895,20,8,1.000,0,236,'اضاÙة Ùاتورة مشتريات','buyBillController.php',0.000,1.000,1,'2026-04-13',0,0,0),
(5896,12,8,1.000,0,236,'اضاÙة Ùاتورة مشتريات','buyBillController.php',0.000,1.000,1,'2026-04-13',0,0,0),
(5897,11,8,1.000,0,236,'اضاÙة Ùاتورة مشتريات','buyBillController.php',0.000,1.000,1,'2026-04-13',0,0,0),
(5898,204,8,1.000,0,236,'اضاÙة Ùاتورة مشتريات','buyBillController.php',0.000,1.000,1,'2026-04-13',0,0,0),
(5899,8,8,10.000,1,2023,'تحويل منتجات من المخزن','storemovementController.php',79.000,69.000,1,'2026-04-13',0,0,0),
(5900,8,7,10.000,0,2023,'تحويل منتجات إلى المخزن','storemovementController.php',414.000,424.000,1,'2026-04-13',0,0,0),
(5901,6,8,2.000,1,2024,'تحويل منتجات من المخزن','storemovementController.php',49.000,47.000,1,'2026-04-13',0,0,0),
(5902,6,7,2.000,0,2024,'تحويل منتجات إلى المخزن','storemovementController.php',146.000,148.000,1,'2026-04-13',0,0,0),
(5903,2,8,90.000,1,2025,'تحويل منتجات من المخزن','storemovementController.php',94.000,4.000,1,'2026-04-13',0,0,0),
(5904,2,7,90.000,0,2025,'تحويل منتجات إلى المخزن','storemovementController.php',567.000,657.000,1,'2026-04-13',0,0,0),
(5905,18,8,26.000,1,2026,'تحويل منتجات من المخزن','storemovementController.php',131.000,105.000,1,'2026-04-13',0,0,0),
(5906,18,7,26.000,0,2026,'تحويل منتجات إلى المخزن','storemovementController.php',211.000,237.000,1,'2026-04-13',0,0,0),
(5907,4,8,11.000,1,2027,'تحويل منتجات من المخزن','storemovementController.php',1.000,-10.000,1,'2026-04-13',0,0,0),
(5908,4,7,11.000,0,2027,'تحويل منتجات إلى المخزن','storemovementController.php',1609.000,1620.000,1,'2026-04-13',0,0,0),
(5909,1,8,5.000,1,2028,'تحويل منتجات من المخزن','storemovementController.php',1.000,-4.000,1,'2026-04-13',0,0,0),
(5910,1,7,5.000,0,2028,'تحويل منتجات إلى المخزن','storemovementController.php',181.000,186.000,1,'2026-04-13',0,0,0),
(5911,19,8,12.000,1,2029,'تحويل منتجات من المخزن','storemovementController.php',1.000,-11.000,1,'2026-04-13',0,0,0),
(5912,19,7,12.000,0,2029,'تحويل منتجات إلى المخزن','storemovementController.php',191.000,203.000,1,'2026-04-13',0,0,0),
(5913,17,8,80.000,1,2030,'تحويل منتجات من المخزن','storemovementController.php',1.000,-79.000,1,'2026-04-13',0,0,0),
(5914,17,7,80.000,0,2030,'تحويل منتجات إلى المخزن','storemovementController.php',541.000,621.000,1,'2026-04-13',0,0,0),
(5915,16,8,125.000,1,2031,'تحويل منتجات من المخزن','storemovementController.php',1.000,-124.000,1,'2026-04-13',0,0,0),
(5916,16,7,125.000,0,2031,'تحويل منتجات إلى المخزن','storemovementController.php',505.000,630.000,1,'2026-04-13',0,0,0),
(5917,223,8,16.000,1,2032,'تحويل منتجات من المخزن','storemovementController.php',1.000,-15.000,1,'2026-04-13',0,0,0),
(5918,223,7,16.000,0,2032,'تحويل منتجات إلى المخزن','storemovementController.php',-62.000,-46.000,1,'2026-04-13',0,0,0),
(5919,13,8,84.000,1,2033,'تحويل منتجات من المخزن','storemovementController.php',1.000,-83.000,1,'2026-04-13',0,0,0),
(5920,13,7,84.000,0,2033,'تحويل منتجات إلى المخزن','storemovementController.php',2245.000,2329.000,1,'2026-04-13',0,0,0),
(5921,20,8,3.000,1,2034,'تحويل منتجات من المخزن','storemovementController.php',1.000,-2.000,1,'2026-04-13',0,0,0),
(5922,20,7,3.000,0,2034,'تحويل منتجات إلى المخزن','storemovementController.php',18.000,21.000,1,'2026-04-13',0,0,0),
(5923,12,8,1.000,1,2035,'تحويل منتجات من المخزن','storemovementController.php',1.000,0.000,1,'2026-04-13',0,0,0),
(5924,12,7,1.000,0,2035,'تحويل منتجات إلى المخزن','storemovementController.php',344.000,345.000,1,'2026-04-13',0,0,0),
(5925,11,8,1.000,1,2036,'تحويل منتجات من المخزن','storemovementController.php',1.000,0.000,1,'2026-04-13',0,0,0),
(5926,11,7,1.000,0,2036,'تحويل منتجات إلى المخزن','storemovementController.php',53.000,54.000,1,'2026-04-13',0,0,0),
(5927,204,8,2.000,1,2037,'تحويل منتجات من المخزن','storemovementController.php',1.000,-1.000,1,'2026-04-13',0,0,0),
(5928,204,7,2.000,0,2037,'تحويل منتجات إلى المخزن','storemovementController.php',141.000,143.000,1,'2026-04-13',0,0,0),
(5929,7,7,33.000,1,2038,'تحويل منتجات من المخزن','storemovementController.php',9.000,-24.000,1,'2026-04-13',0,0,0),
(5930,7,1,33.000,0,2038,'تحويل منتجات إلى المخزن','storemovementController.php',147.000,180.000,1,'2026-04-13',0,0,0),
(5931,13,7,345.000,1,2039,'تحويل منتجات من المخزن','storemovementController.php',2329.000,1984.000,1,'2026-04-13',0,0,0),
(5932,13,1,345.000,0,2039,'تحويل منتجات إلى المخزن','storemovementController.php',13232.000,13577.000,1,'2026-04-13',0,0,0),
(5933,8,7,8.000,1,2040,'تحويل منتجات من المخزن','storemovementController.php',424.000,416.000,1,'2026-04-13',0,0,0),
(5934,8,1,8.000,0,2040,'تحويل منتجات إلى المخزن','storemovementController.php',2414.000,2422.000,1,'2026-04-13',0,0,0),
(5935,18,7,4.000,1,2041,'تحويل منتجات من المخزن','storemovementController.php',237.000,233.000,1,'2026-04-13',0,0,0),
(5936,18,1,4.000,0,2041,'تحويل منتجات إلى المخزن','storemovementController.php',813.000,817.000,1,'2026-04-13',0,0,0),
(5937,16,7,2.000,1,2042,'تحويل منتجات من المخزن','storemovementController.php',630.000,628.000,1,'2026-04-13',0,0,0),
(5938,16,1,2.000,0,2042,'تحويل منتجات إلى المخزن','storemovementController.php',15768.000,15770.000,1,'2026-04-13',0,0,0),
(5939,223,7,4.000,1,2043,'تحويل منتجات من المخزن','storemovementController.php',-46.000,-50.000,1,'2026-04-13',0,0,0),
(5940,223,1,4.000,0,2043,'تحويل منتجات إلى المخزن','storemovementController.php',1044.000,1048.000,1,'2026-04-13',0,0,0),
(5941,9,8,1.000,0,237,'اضاÙة Ùاتورة مشتريات','buyBillController.php',0.000,1.000,1,'2026-04-13',0,0,0),
(5942,26,8,1.000,0,237,'اضاÙة Ùاتورة مشتريات','buyBillController.php',2.000,3.000,1,'2026-04-13',0,0,0),
(5943,27,8,1.000,0,237,'اضاÙة Ùاتورة مشتريات','buyBillController.php',0.000,1.000,1,'2026-04-13',0,0,0),
(5944,28,8,1.000,0,237,'اضاÙة Ùاتورة مشتريات','buyBillController.php',0.000,1.000,1,'2026-04-13',0,0,0),
(5945,25,8,1.000,0,237,'اضاÙة Ùاتورة مشتريات','buyBillController.php',0.000,1.000,1,'2026-04-13',0,0,0),
(5946,89,8,1.000,0,237,'اضاÙة Ùاتورة مشتريات','buyBillController.php',-1.000,0.000,1,'2026-04-13',0,0,0),
(5947,32,8,1.000,0,237,'اضاÙة Ùاتورة مشتريات','buyBillController.php',0.000,1.000,1,'2026-04-13',0,0,0),
(5948,33,8,1.000,0,237,'اضاÙة Ùاتورة مشتريات','buyBillController.php',-6.000,-5.000,1,'2026-04-13',0,0,0),
(5949,204,8,1.000,0,237,'اضاÙة Ùاتورة مشتريات','buyBillController.php',-1.000,0.000,1,'2026-04-13',0,0,0),
(5950,89,8,1.000,0,238,'اضاÙة Ùاتورة مشتريات','buyBillController.php',0.000,1.000,1,'2026-04-13',0,0,0),
(5951,204,8,1.000,0,239,'اضاÙة Ùاتورة مشتريات','buyBillController.php',0.000,1.000,1,'2026-04-13',0,0,0),
(5952,26,8,36.000,1,2044,'تحويل منتجات من المخزن','storemovementController.php',3.000,-33.000,1,'2026-04-13',0,0,0),
(5953,26,7,36.000,0,2044,'تحويل منتجات إلى المخزن','storemovementController.php',-1139.000,-1103.000,1,'2026-04-13',0,0,0),
(5954,9,8,26.000,1,2045,'تحويل منتجات من المخزن','storemovementController.php',1.000,-25.000,1,'2026-04-13',0,0,0),
(5955,9,7,26.000,0,2045,'تحويل منتجات إلى المخزن','storemovementController.php',162.000,188.000,1,'2026-04-13',0,0,0),
(5956,27,8,11.000,1,2046,'تحويل منتجات من المخزن','storemovementController.php',1.000,-10.000,1,'2026-04-13',0,0,0),
(5957,27,7,11.000,0,2046,'تحويل منتجات إلى المخزن','storemovementController.php',-2723.000,-2712.000,1,'2026-04-13',0,0,0),
(5958,28,8,22.000,1,2047,'تحويل منتجات من المخزن','storemovementController.php',1.000,-21.000,1,'2026-04-13',0,0,0),
(5959,28,7,22.000,0,2047,'تحويل منتجات إلى المخزن','storemovementController.php',-1175.000,-1153.000,1,'2026-04-13',0,0,0),
(5960,25,8,3.000,1,2048,'تحويل منتجات من المخزن','storemovementController.php',1.000,-2.000,1,'2026-04-13',0,0,0),
(5961,25,7,3.000,0,2048,'تحويل منتجات إلى المخزن','storemovementController.php',697.000,700.000,1,'2026-04-13',0,0,0),
(5962,89,8,7.000,1,2049,'تحويل منتجات من المخزن','storemovementController.php',1.000,-6.000,1,'2026-04-13',0,0,0),
(5963,89,7,7.000,0,2049,'تحويل منتجات إلى المخزن','storemovementController.php',267.000,274.000,1,'2026-04-13',0,0,0),
(5964,32,8,37.000,1,2050,'تحويل منتجات من المخزن','storemovementController.php',1.000,-36.000,1,'2026-04-13',0,0,0),
(5965,32,7,37.000,0,2050,'تحويل منتجات إلى المخزن','storemovementController.php',4315.000,4352.000,1,'2026-04-13',0,0,0),
(5966,33,8,2.000,1,2051,'تحويل منتجات من المخزن','storemovementController.php',-5.000,-7.000,1,'2026-04-13',0,0,0),
(5967,33,7,2.000,0,2051,'تحويل منتجات إلى المخزن','storemovementController.php',5276.000,5278.000,1,'2026-04-13',0,0,0),
(5968,204,8,5.000,1,2052,'تحويل منتجات من المخزن','storemovementController.php',1.000,-4.000,1,'2026-04-13',0,0,0),
(5969,204,7,5.000,0,2052,'تحويل منتجات إلى المخزن','storemovementController.php',143.000,148.000,1,'2026-04-13',0,0,0),
(5970,90,8,1.000,0,240,'اضاÙة Ùاتورة مشتريات','buyBillController.php',0.000,1.000,1,'2026-04-13',0,0,0),
(5971,91,8,1.000,0,240,'اضاÙة Ùاتورة مشتريات','buyBillController.php',0.000,1.000,1,'2026-04-13',0,0,0),
(5972,89,8,3.000,1,2053,'تحويل منتجات من المخزن','storemovementController.php',-6.000,-9.000,1,'2026-04-13',0,0,0),
(5973,89,7,3.000,0,2053,'تحويل منتجات إلى المخزن','storemovementController.php',274.000,277.000,1,'2026-04-13',0,0,0),
(5974,26,8,7.000,1,2054,'تحويل منتجات من المخزن','storemovementController.php',-33.000,-40.000,1,'2026-04-13',0,0,0),
(5975,26,7,7.000,0,2054,'تحويل منتجات إلى المخزن','storemovementController.php',-1103.000,-1096.000,1,'2026-04-13',0,0,0),
(5976,27,8,4.000,1,2055,'تحويل منتجات من المخزن','storemovementController.php',-10.000,-14.000,1,'2026-04-13',0,0,0),
(5977,27,7,4.000,0,2055,'تحويل منتجات إلى المخزن','storemovementController.php',-2712.000,-2708.000,1,'2026-04-13',0,0,0),
(5978,28,8,1.000,1,2056,'تحويل منتجات من المخزن','storemovementController.php',-21.000,-22.000,1,'2026-04-13',0,0,0),
(5979,28,7,1.000,0,2056,'تحويل منتجات إلى المخزن','storemovementController.php',-1153.000,-1152.000,1,'2026-04-13',0,0,0),
(5980,90,8,4.000,1,2057,'تحويل منتجات من المخزن','storemovementController.php',1.000,-3.000,1,'2026-04-13',0,0,0),
(5981,90,7,4.000,0,2057,'تحويل منتجات إلى المخزن','storemovementController.php',-78.000,-74.000,1,'2026-04-13',0,0,0),
(5982,91,8,11.000,1,2058,'تحويل منتجات من المخزن','storemovementController.php',1.000,-10.000,1,'2026-04-13',0,0,0),
(5983,91,7,11.000,0,2058,'تحويل منتجات إلى المخزن','storemovementController.php',-9.000,2.000,1,'2026-04-13',0,0,0),
(5984,16,8,1.000,1,2059,'تحويل منتجات من المخزن','storemovementController.php',-124.000,-125.000,1,'2026-04-13',0,0,0),
(5985,16,7,1.000,0,2059,'تحويل منتجات إلى المخزن','storemovementController.php',628.000,629.000,1,'2026-04-13',0,0,0),
(5986,15,8,1.000,1,2060,'تحويل منتجات من المخزن','storemovementController.php',1.000,0.000,1,'2026-04-13',0,0,0),
(5987,15,7,1.000,0,2060,'تحويل منتجات إلى المخزن','storemovementController.php',805.000,806.000,1,'2026-04-13',0,0,0),
(5988,26,8,2.000,1,2061,'تحويل منتجات من المخزن','storemovementController.php',-40.000,-42.000,1,'2026-04-13',0,0,0),
(5989,26,7,2.000,0,2061,'تحويل منتجات إلى المخزن','storemovementController.php',-1096.000,-1094.000,1,'2026-04-13',0,0,0),
(5990,28,8,7.000,1,2062,'تحويل منتجات من المخزن','storemovementController.php',-22.000,-29.000,1,'2026-04-13',0,0,0),
(5991,28,7,7.000,0,2062,'تحويل منتجات إلى المخزن','storemovementController.php',-1152.000,-1145.000,1,'2026-04-13',0,0,0),
(5992,91,8,1.000,1,2063,'تحويل منتجات من المخزن','storemovementController.php',-10.000,-11.000,1,'2026-04-13',0,0,0),
(5993,91,7,1.000,0,2063,'تحويل منتجات إلى المخزن','storemovementController.php',2.000,3.000,1,'2026-04-13',0,0,0),
(5994,18,8,1.000,1,2064,'تحويل منتجات من المخزن','storemovementController.php',105.000,104.000,1,'2026-04-13',0,0,0),
(5995,18,7,1.000,0,2064,'تحويل منتجات إلى المخزن','storemovementController.php',233.000,234.000,1,'2026-04-13',0,0,0),
(5996,12,7,12.000,0,-1,'تم إعادة جرد المنتج بالقيمة الحالية بالزيادة','inventoryController.php',345.000,357.000,1,'2026-04-13',0,0,0),
(5997,13,7,100.000,0,-1,'تم إعادة جرد المنتج بالقيمة الحالية بالزيادة','inventoryController.php',1984.000,2084.000,1,'2026-04-13',0,0,0),
(5998,223,7,60.000,0,-1,'تم إعادة جرد المنتج بالقيمة الحالية بالزيادة','inventoryController.php',-50.000,10.000,1,'2026-04-13',0,0,0),
(5999,15,7,255.000,0,-1,'تم إعادة جرد المنتج بالقيمة الحالية بالزيادة','inventoryController.php',806.000,1061.000,1,'2026-04-13',0,0,0),
(6000,16,7,206.000,0,-1,'تم إعادة جرد المنتج بالقيمة الحالية بالزيادة','inventoryController.php',629.000,835.000,1,'2026-04-13',0,0,0),
(6001,17,7,140.000,0,-1,'تم إعادة جرد المنتج بالقيمة الحالية بالزيادة','inventoryController.php',621.000,761.000,1,'2026-04-13',0,0,0),
(6002,14,7,42.000,0,-1,'تم إعادة جرد المنتج بالقيمة الحالية بالزيادة','inventoryController.php',501.000,543.000,1,'2026-04-13',0,0,0),
(6003,49,7,47.000,0,-1,'تم إعادة جرد المنتج بالقيمة الحالية بالزيادة','inventoryController.php',16.000,63.000,1,'2026-04-13',0,0,0),
(6004,51,7,2.000,0,-1,'تم إعادة جرد المنتج بالقيمة الحالية بالزيادة','inventoryController.php',5.000,7.000,1,'2026-04-13',0,0,0),
(6005,53,7,18.000,0,-1,'تم إعادة جرد المنتج بالقيمة الحالية بالزيادة','inventoryController.php',-11.000,7.000,1,'2026-04-13',0,0,0),
(6006,257,7,8.000,0,-1,'تم إعادة جرد المنتج بالقيمة الحالية بالزيادة','inventoryController.php',8.000,16.000,1,'2026-04-13',0,0,0),
(6007,56,7,49.000,0,-1,'تم إعادة جرد المنتج بالقيمة الحالية بالزيادة','inventoryController.php',-39.000,10.000,1,'2026-04-13',0,0,0),
(6008,54,7,19.000,0,-1,'تم إعادة جرد المنتج بالقيمة الحالية بالزيادة','inventoryController.php',-10.000,9.000,1,'2026-04-13',0,0,0),
(6009,57,7,4.000,0,-1,'تم إعادة جرد المنتج بالقيمة الحالية بالزيادة','inventoryController.php',33.000,37.000,1,'2026-04-13',0,0,0),
(6010,55,7,76.000,0,-1,'تم إعادة جرد المنتج بالقيمة الحالية بالزيادة','inventoryController.php',-66.000,10.000,1,'2026-04-13',0,0,0),
(6011,56,7,10.000,0,-1,'تم إعادة جرد المنتج بالقيمة الحالية بالزيادة','inventoryController.php',10.000,20.000,1,'2026-04-13',0,0,0),
(6012,1,7,3.000,0,-1,'تم إعادة جرد المنتج بالقيمة الحالية بالزيادة','inventoryController.php',186.000,189.000,1,'2026-04-13',0,0,0),
(6013,2,7,240.000,0,-1,'تم إعادة جرد المنتج بالقيمة الحالية بالزيادة','inventoryController.php',657.000,897.000,1,'2026-04-13',0,0,0),
(6014,4,7,42.000,0,-1,'تم إعادة جرد المنتج بالقيمة الحالية بالزيادة','inventoryController.php',1620.000,1662.000,1,'2026-04-13',0,0,0),
(6015,6,7,54.000,0,-1,'تم إعادة جرد المنتج بالقيمة الحالية بالزيادة','inventoryController.php',148.000,202.000,1,'2026-04-13',0,0,0),
(6016,8,7,148.000,0,-1,'تم إعادة جرد المنتج بالقيمة الحالية بالزيادة','inventoryController.php',416.000,564.000,1,'2026-04-13',0,0,0),
(6017,1,7,118.000,0,-1,'تم إعادة جرد المنتج بالقيمة الحالية بالزيادة','inventoryController.php',189.000,307.000,1,'2026-04-13',0,0,0),
(6018,2,7,445.000,0,-1,'تم إعادة جرد المنتج بالقيمة الحالية بالزيادة','inventoryController.php',897.000,1342.000,1,'2026-04-13',0,0,0),
(6019,4,7,175.000,0,-1,'تم إعادة جرد المنتج بالقيمة الحالية بالزيادة','inventoryController.php',1662.000,1837.000,1,'2026-04-13',0,0,0),
(6020,32,7,7.000,0,-1,'تم إعادة جرد المنتج بالقيمة الحالية بالزيادة','inventoryController.php',4352.000,4359.000,1,'2026-04-13',0,0,0),
(6021,204,7,14.000,0,-1,'تم إعادة جرد المنتج بالقيمة الحالية بالزيادة','inventoryController.php',148.000,162.000,1,'2026-04-13',0,0,0),
(6022,13,7,673.000,0,-1,'تم إعادة جرد المنتج بالقيمة الحالية بالزيادة','inventoryController.php',2084.000,2757.000,1,'2026-04-13',0,0,0),
(6023,14,7,314.000,0,-1,'تم إعادة جرد المنتج بالقيمة الحالية بالزيادة','inventoryController.php',543.000,857.000,1,'2026-04-13',0,0,0),
(6024,33,7,140.000,0,-1,'تم إعادة جرد المنتج بالقيمة الحالية بالزيادة','inventoryController.php',5278.000,5418.000,1,'2026-04-13',0,0,0),
(6025,3,7,11.000,0,-1,'تم إعادة جرد المنتج بالقيمة الحالية بالزيادة','inventoryController.php',0.000,11.000,1,'2026-04-13',0,0,0),
(6026,16,7,835.000,1,-1,'تم إعادة جرد المنتج بالقيمة الحالية بالنقص','inventoryController.php',835.000,0.000,1,'2026-04-13',0,0,0),
(6027,28,7,1145.000,0,-1,'تم إعادة جرد المنتج بالقيمة الحالية بالزيادة','inventoryController.php',-1145.000,0.000,1,'2026-04-13',0,0,0),
(6028,28,7,735.000,0,-1,'تم إعادة جرد المنتج بالقيمة الحالية بالزيادة','inventoryController.php',0.000,735.000,1,'2026-04-13',0,0,0),
(6029,8,7,8.000,0,-1,'تم إعادة جرد المنتج بالقيمة الحالية بالزيادة','inventoryController.php',564.000,572.000,1,'2026-04-13',0,0,0),
(6030,17,7,6.000,0,-1,'تم إعادة جرد المنتج بالقيمة الحالية بالزيادة','inventoryController.php',761.000,767.000,1,'2026-04-13',0,0,0),
(6031,32,7,707.000,0,-1,'تم إعادة جرد المنتج بالقيمة الحالية بالزيادة','inventoryController.php',4359.000,5066.000,1,'2026-04-13',0,0,0);

--
-- Table structure for table `studentabsences`
--

CREATE TABLE `studentabsences` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `onlys` int(11) unsigned DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  `arrivedtime` int(11) unsigned DEFAULT NULL,
  `addtoday` datetime DEFAULT NULL,
  `adduserid` double DEFAULT NULL,
  `uniqid` int(11) unsigned DEFAULT NULL,
  `studentid` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `todaysend` date DEFAULT NULL,
  `timesend` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deviceid` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int(11) unsigned DEFAULT NULL,
  `studentsubjectid` int(11) unsigned DEFAULT NULL,
  `studentsubjectgroupid` int(11) unsigned DEFAULT NULL,
  `studentaddsubjectid` int(11) unsigned DEFAULT NULL,
  `studentaddsubjectdetailid` int(11) unsigned DEFAULT NULL,
  `deltoday` datetime DEFAULT NULL,
  `deluserid` double DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `studentabsences`
--


--
-- Table structure for table `studentaddsubjectdetails`
--

CREATE TABLE `studentaddsubjectdetails` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `del` int(11) unsigned DEFAULT NULL,
  `addtoday` datetime DEFAULT NULL,
  `adduserid` double DEFAULT NULL,
  `studentid` int(11) unsigned DEFAULT NULL,
  `studentsubjectid` int(11) unsigned DEFAULT NULL,
  `studentsubjectgroupid` int(11) unsigned DEFAULT NULL,
  `studentaddsubjectid` int(11) unsigned DEFAULT NULL,
  `deltoday` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deluserid` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `studentname` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `studentphone` int(11) unsigned DEFAULT NULL,
  `deviceid` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subjectname` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subjectprice` tinyint(1) unsigned DEFAULT NULL,
  `subjectgroupname` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subjectgroupprice` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `studentaddsubjectdetails`
--


--
-- Table structure for table `studentaddsubjects`
--

CREATE TABLE `studentaddsubjects` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `del` int(11) unsigned DEFAULT NULL,
  `addtoday` datetime DEFAULT NULL,
  `adduserid` double DEFAULT NULL,
  `deltoday` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deluserid` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `studentsubjectid` int(11) unsigned DEFAULT NULL,
  `studentsubjectgroupid` int(11) unsigned DEFAULT NULL,
  `studentid` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deviceid` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `studentaddsubjects`
--


--
-- Table structure for table `students`
--

CREATE TABLE `students` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `del` int(11) unsigned DEFAULT NULL,
  `addtoday` datetime DEFAULT NULL,
  `adduserid` double DEFAULT NULL,
  `deltoday` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deluserid` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `studentname` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `studentdatebirth` double DEFAULT NULL,
  `studentnumber` double DEFAULT NULL,
  `idnumber` double DEFAULT NULL,
  `studentphone` double DEFAULT NULL,
  `parentsname` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `parentsphone` double DEFAULT NULL,
  `studentaddress` tinyint(1) unsigned DEFAULT NULL,
  `clientid` int(11) unsigned DEFAULT NULL,
  `branchid` double DEFAULT NULL,
  `studentimage` tinyint(1) unsigned DEFAULT NULL,
  `studentnote` tinyint(1) unsigned DEFAULT NULL,
  `studentaddsubjectid` tinyint(1) unsigned DEFAULT NULL,
  `studentsubjectid` tinyint(1) unsigned DEFAULT NULL,
  `studentsubjectgroupid` tinyint(1) unsigned DEFAULT NULL,
  `studentspaymentsystemid` tinyint(1) unsigned DEFAULT NULL,
  `studentaddsubjectdetailid` tinyint(1) unsigned DEFAULT NULL,
  `paymonths` int(11) unsigned DEFAULT NULL,
  `paytype` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `paytypenum` int(11) unsigned DEFAULT NULL,
  `payprice` int(11) unsigned DEFAULT NULL,
  `countmonths` tinyint(1) unsigned DEFAULT NULL,
  `newprice` tinyint(1) unsigned DEFAULT NULL,
  `paystartdate` date DEFAULT NULL,
  `payenddate` date DEFAULT NULL,
  `studentspayid` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `students`
--


--
-- Table structure for table `studentsetting`
--

CREATE TABLE `studentsetting` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `updateuserid` double DEFAULT NULL,
  `studentorplayer` tinyint(1) unsigned DEFAULT NULL,
  `paymentsystems1` int(11) unsigned DEFAULT NULL,
  `paymentsystems2` tinyint(1) unsigned DEFAULT NULL,
  `paymentsystems3` tinyint(1) unsigned DEFAULT NULL,
  `showdel` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `studentsetting`
--


--
-- Table structure for table `studentsexams`
--

CREATE TABLE `studentsexams` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `deltoday` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deluserid` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  `addtoday` datetime DEFAULT NULL,
  `adduserid` double DEFAULT NULL,
  `studentaddsubjectid` int(11) unsigned DEFAULT NULL,
  `studentsubjectid` int(11) unsigned DEFAULT NULL,
  `studentsubjectgroupid` int(11) unsigned DEFAULT NULL,
  `studentid` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `examname` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `greatdegree` int(11) unsigned DEFAULT NULL,
  `examsstudent` int(11) unsigned DEFAULT NULL,
  `updatetoday` datetime DEFAULT NULL,
  `updateuserid` double DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `studentsexams`
--


--
-- Table structure for table `studentsexamsval`
--

CREATE TABLE `studentsexamsval` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `studentid` int(11) unsigned DEFAULT NULL,
  `examsvalue` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `examspresence` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `studentaddsubjectid` int(11) unsigned DEFAULT NULL,
  `studentsubjectgroupid` int(11) unsigned DEFAULT NULL,
  `studentsubjectid` int(11) unsigned DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  `addtoday` datetime DEFAULT NULL,
  `adduserid` double DEFAULT NULL,
  `deltoday` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deluserid` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `studentsexamid` int(11) unsigned DEFAULT NULL,
  `updatetoday` datetime DEFAULT NULL,
  `updateuserid` double DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `studentsexamsval`
--


--
-- Table structure for table `studentspaymentsystems`
--

CREATE TABLE `studentspaymentsystems` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `del` int(11) unsigned DEFAULT NULL,
  `addtoday` datetime DEFAULT NULL,
  `adduserid` double DEFAULT NULL,
  `deltoday` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deluserid` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `paymentname` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `paymentprice` int(11) unsigned DEFAULT NULL,
  `paymentmonth` int(11) unsigned DEFAULT NULL,
  `studentaddsubjectid` int(11) unsigned DEFAULT NULL,
  `studentsubjectid` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `studentspaymentsystems`
--


--
-- Table structure for table `studentspays`
--

CREATE TABLE `studentspays` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `del` int(11) unsigned DEFAULT NULL,
  `addtoday` datetime DEFAULT NULL,
  `adduserid` double DEFAULT NULL,
  `deltoday` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deluserid` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `studentaddsubjectid` int(11) unsigned DEFAULT NULL,
  `studentsubjectid` int(11) unsigned DEFAULT NULL,
  `studentsubjectgroupid` int(11) unsigned DEFAULT NULL,
  `studentspaymentsystemid` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `studentaddsubjectdetailid` int(11) unsigned DEFAULT NULL,
  `studentid` int(11) unsigned DEFAULT NULL,
  `paymonths` int(11) unsigned DEFAULT NULL,
  `paytype` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `paytypenum` int(11) unsigned DEFAULT NULL,
  `payprice` int(11) unsigned DEFAULT NULL,
  `countmonths` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `newprice` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `paystartdate` date DEFAULT NULL,
  `payenddate` date DEFAULT NULL,
  `paytypered` tinyint(1) unsigned DEFAULT NULL,
  `paykind` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `studentspays`
--


--
-- Table structure for table `studentsubjectgroupdays`
--

CREATE TABLE `studentsubjectgroupdays` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `del` int(11) unsigned DEFAULT NULL,
  `addtoday` datetime DEFAULT NULL,
  `adduserid` double DEFAULT NULL,
  `deltoday` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deluserid` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `studentsubjectid` int(11) unsigned DEFAULT NULL,
  `studentsubjectgroupid` int(11) unsigned DEFAULT NULL,
  `dayar` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dayen` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `day` int(11) unsigned DEFAULT NULL,
  `timeform` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `timeto` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `useit` int(11) unsigned DEFAULT NULL,
  `updatetoday` datetime DEFAULT NULL,
  `updateuserid` double DEFAULT NULL,
  `deviceid` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `studentsubjectgroupdays`
--


--
-- Table structure for table `studentsubjectgroups`
--

CREATE TABLE `studentsubjectgroups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `del` int(11) unsigned DEFAULT NULL,
  `addtoday` datetime DEFAULT NULL,
  `adduserid` double DEFAULT NULL,
  `deltoday` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deluserid` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `studentsubjectid` int(11) unsigned DEFAULT NULL,
  `subjectgroupname` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subjectgroupprice` int(11) unsigned DEFAULT NULL,
  `useit` int(11) unsigned DEFAULT NULL,
  `updatetoday` datetime DEFAULT NULL,
  `updateuserid` double DEFAULT NULL,
  `deviceid` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `studentsubjectgroups`
--


--
-- Table structure for table `studentsubjects`
--

CREATE TABLE `studentsubjects` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `del` int(11) unsigned DEFAULT NULL,
  `addtoday` datetime DEFAULT NULL,
  `adduserid` double DEFAULT NULL,
  `deltoday` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deluserid` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subjectname` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subjectprice` int(11) unsigned DEFAULT NULL,
  `ipaddress` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deviceid` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `useit` int(11) unsigned DEFAULT NULL,
  `incometypeid` int(11) unsigned DEFAULT NULL,
  `updatetoday` datetime DEFAULT NULL,
  `updateuserid` double DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `studentsubjects`
--


--
-- Table structure for table `suppay`
--

CREATE TABLE `suppay` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idsupdeptchange` int(11) NOT NULL,
  `paytype` int(11) NOT NULL DEFAULT 0,
  `accountid` int(11) DEFAULT NULL,
  `del` int(11) NOT NULL DEFAULT 0,
  `bankid` int(11) DEFAULT NULL,
  `checkno` int(11) DEFAULT NULL,
  `beneficiaryname` varchar(255) DEFAULT NULL,
  `chckdate` date DEFAULT NULL,
  `chckimage` varchar(255) DEFAULT NULL,
  `senderbank` varchar(50) DEFAULT NULL,
  `details` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `suppay`
--


--
-- Table structure for table `supplier`
--

CREATE TABLE `supplier` (
  `supplierid` int(11) NOT NULL AUTO_INCREMENT,
  `suppliername` varchar(256) NOT NULL,
  `supplieraddress` varchar(256) DEFAULT NULL,
  `supplierphone` varchar(20) DEFAULT NULL,
  `suppliercurrentDebt` decimal(10,2) DEFAULT 0.00,
  `supplierdetails` text DEFAULT NULL,
  `conditions` int(11) NOT NULL DEFAULT 0,
  `userid` int(11) NOT NULL,
  `supplierdate` date NOT NULL,
  `dailyentryid` int(11) NOT NULL DEFAULT 0,
  `category_id` varchar(200) DEFAULT NULL,
  `typesupplier_id` varchar(200) DEFAULT NULL,
  `linkedClientId` int(11) NOT NULL DEFAULT 0,
  `inUse` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 free - 1 in use means to stop changing debt till it is free again',
  `suppliercode` varchar(256) NOT NULL,
  `goverareaid` varchar(256) NOT NULL,
  `namepayeecheck` varchar(256) NOT NULL,
  `suppliermobile` varchar(256) NOT NULL,
  `warrantyOfficer` varchar(256) NOT NULL,
  `warrantymobile` varchar(256) NOT NULL,
  `sellername` varchar(256) NOT NULL,
  `sellermobile` varchar(256) NOT NULL,
  `taxnumber` varchar(255) DEFAULT NULL,
  `supplierTypeForTree` tinyint(4) NOT NULL DEFAULT 0,
  `treeId` int(11) NOT NULL DEFAULT 0,
  `sullpierCurrencyid` int(11) NOT NULL DEFAULT 1,
  `suppliercurrentDebtInCurrency` decimal(10,2) DEFAULT 0.00,
  PRIMARY KEY (`supplierid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `supplier`
--

INSERT INTO `supplier` VALUES
(1,'J1017','','',0.00,'',0,1,'2026-04-13',0,'','',0,0,'','','','','','','','','',0,418,1,0.00),
(2,'UNEC','','',4.00,'',0,1,'2025-05-04',0,'','',0,0,'','','','','','','','','',0,431,1,4.00);

--
-- Table structure for table `supplierdebtchange`
--

CREATE TABLE `supplierdebtchange` (
  `supplierdebtchangeid` int(11) NOT NULL AUTO_INCREMENT,
  `supplierid` int(11) NOT NULL,
  `supplierdebtchangebefore` decimal(10,2) NOT NULL,
  `supplierdebtchangeamount` decimal(10,2) NOT NULL,
  `supplierdebtchangetype` int(11) NOT NULL COMMENT '0 => plus- 1 => minus',
  `processname` varchar(256) NOT NULL,
  `supplierdebtchangemodelid` int(11) NOT NULL,
  `supplierdebtchangeafter` decimal(10,2) NOT NULL,
  `supplierdebtchangedate` datetime NOT NULL,
  `userid` int(11) NOT NULL,
  `tablename` varchar(500) NOT NULL,
  `comment` text DEFAULT NULL,
  `del` int(11) NOT NULL DEFAULT 0,
  `dailyentryid` int(11) NOT NULL DEFAULT 0,
  `saveid` int(11) DEFAULT NULL,
  `costcenterid` int(11) DEFAULT NULL,
  `currencyId` int(11) NOT NULL,
  `conversionFactor` float NOT NULL,
  `payedInCurrency` decimal(10,2) NOT NULL,
  `saveConversionFactor` float NOT NULL,
  `debtchangbeforeInSupplierCurrency` decimal(10,2) NOT NULL,
  `debtchangamountInSupplierCurrency` decimal(10,2) NOT NULL,
  `debtchangafterInSupplierCurrency` decimal(10,2) NOT NULL,
  PRIMARY KEY (`supplierdebtchangeid`),
  KEY `idx_supplierdebtchange` (`tablename`(255)),
  KEY `supplierid` (`supplierid`)
) ENGINE=InnoDB AUTO_INCREMENT=243 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `supplierdebtchange`
--

INSERT INTO `supplierdebtchange` VALUES
(1,1,0.00,0.00,0,'إضاÙة مورد جديد',1,0.00,'2025-02-20 07:41:32',1,'supplierController.php','',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(2,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',1,0.00,'2024-11-22 00:00:00',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(3,2,0.00,0.00,0,'إضاÙة مورد جديد',2,0.00,'2025-02-20 10:17:34',1,'supplierController.php','',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(4,2,0.00,1.00,0,'اضاÙة Ùاتورة مشتريات',2,1.00,'2024-11-22 00:05:34',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,1.00,1,0.00,1.00,1.00),
(5,2,1.00,1.00,0,'اضاÙة Ùاتورة مشتريات',3,2.00,'2025-02-23 06:56:21',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,1.00,1,1.00,1.00,2.00),
(6,2,2.00,1.00,0,'اضاÙة Ùاتورة مشتريات',4,3.00,'2025-02-23 07:42:23',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,1.00,1,2.00,1.00,3.00),
(7,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',5,0.00,'2025-02-23 07:43:31',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(8,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',6,0.00,'2025-02-23 07:44:18',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(9,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',7,0.00,'2025-02-23 07:45:26',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(10,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',8,0.00,'2025-02-23 08:25:33',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(11,2,3.00,1.00,0,'اضاÙة Ùاتورة مشتريات',9,4.00,'2025-02-23 14:17:01',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,1.00,1,3.00,1.00,4.00),
(12,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',10,4.00,'2025-02-23 15:00:55',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(13,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',11,4.00,'2025-02-23 15:06:43',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(14,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',12,4.00,'2025-02-25 10:40:56',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(15,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',13,4.00,'2025-02-25 10:59:48',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(16,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',14,4.00,'2025-02-25 12:45:12',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(17,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',15,4.00,'2025-02-25 13:25:42',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(18,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',16,4.00,'2025-02-27 07:17:11',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(19,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',17,4.00,'2025-03-03 05:57:32',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(20,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',18,4.00,'2025-03-03 06:31:15',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(21,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',19,4.00,'2025-03-03 06:34:36',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(22,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',20,4.00,'2025-03-03 07:00:06',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(23,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',21,0.00,'2025-03-05 09:17:49',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(24,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',22,0.00,'2025-03-05 09:25:27',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(25,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',23,0.00,'2025-03-08 05:10:45',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(26,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',24,4.00,'2025-03-08 05:54:41',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(27,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',25,4.00,'2025-03-11 05:36:07',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(28,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',26,4.00,'2025-03-11 05:41:10',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(29,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',27,4.00,'2025-03-11 09:38:20',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(30,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',28,4.00,'2025-03-11 10:31:33',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(31,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',29,4.00,'2025-03-11 10:35:20',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(32,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',30,0.00,'2025-03-13 07:57:49',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(33,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',31,4.00,'2025-03-13 08:44:17',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(34,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',32,4.00,'2025-03-13 08:53:36',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(35,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',33,4.00,'2025-03-15 09:56:25',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(36,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',34,4.00,'2025-03-22 07:08:36',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(37,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',35,4.00,'2025-04-05 08:12:48',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(38,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',36,4.00,'2025-04-05 08:22:13',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(39,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',37,4.00,'2025-04-05 08:25:38',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(40,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',38,4.00,'2025-04-05 08:41:19',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(41,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',39,0.00,'2025-04-07 07:05:38',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(42,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',40,4.00,'2025-04-07 07:08:59',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(43,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',41,4.00,'2025-04-09 07:02:05',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(44,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',42,4.00,'2025-04-09 07:12:10',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(45,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',43,0.00,'2025-04-09 07:48:20',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(46,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',44,0.00,'2025-04-09 07:50:55',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(47,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',45,4.00,'2025-04-09 07:52:37',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(48,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',46,4.00,'2025-04-10 06:44:49',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(49,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',47,4.00,'2025-04-17 06:39:04',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(50,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',48,0.00,'2025-04-17 06:54:06',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(51,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',49,4.00,'2025-04-17 07:05:48',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(52,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',50,4.00,'2025-04-17 07:12:46',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(53,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',51,4.00,'2025-04-17 07:09:38',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(54,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',52,4.00,'2025-04-17 07:24:46',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(55,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',53,0.00,'2025-04-17 07:27:58',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(56,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',54,4.00,'2025-04-17 08:04:58',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(57,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',55,4.00,'2025-04-17 08:07:48',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(58,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',56,0.00,'2025-04-17 08:09:37',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(59,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',57,0.00,'2025-04-17 08:11:11',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(60,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',58,0.00,'2025-04-17 08:12:36',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(61,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',59,4.00,'2025-04-17 08:28:28',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(62,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',60,4.00,'2025-04-17 08:29:55',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(63,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',61,0.00,'2025-04-20 13:39:31',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(64,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',62,0.00,'2025-04-20 13:42:46',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(65,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',63,0.00,'2025-04-20 13:48:09',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(66,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',64,4.00,'2025-04-20 14:31:35',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(67,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',65,0.00,'2025-04-20 14:45:02',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(68,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',66,0.00,'2025-04-20 14:49:23',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(69,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',67,4.00,'2025-04-20 14:50:53',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(70,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',68,0.00,'2025-04-20 14:53:10',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(71,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',69,0.00,'2025-04-20 14:56:26',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(72,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',70,4.00,'2025-04-22 06:38:34',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(73,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',71,4.00,'2025-04-22 06:39:56',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(74,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',72,4.00,'2025-04-22 06:45:38',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(75,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',73,4.00,'2025-04-24 06:43:19',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(76,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',74,4.00,'2025-04-24 06:50:19',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(77,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',75,4.00,'2025-04-24 06:56:14',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(78,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',76,0.00,'2025-04-24 07:02:37',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(79,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',77,4.00,'2025-04-24 07:40:54',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(80,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',78,4.00,'2025-04-24 07:45:33',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(81,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',79,0.00,'2025-04-24 08:10:59',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(82,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',80,4.00,'2025-04-24 08:22:32',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(83,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',81,4.00,'2025-04-28 15:56:33',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(84,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',82,0.00,'2025-04-28 15:59:11',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(85,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',83,0.00,'2025-04-28 16:02:16',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(86,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',84,0.00,'2025-04-28 16:03:10',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(87,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',85,0.00,'2025-04-28 16:12:48',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(88,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',86,0.00,'2025-05-01 15:39:15',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(89,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',87,0.00,'2025-05-01 15:46:59',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(90,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',88,0.00,'2025-05-04 15:25:26',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(91,2,4.00,0.00,0,'اضاÙة Ùاتورة مشتريات',89,4.00,'2025-05-04 15:28:53',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,4.00,0.00,4.00),
(92,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',90,0.00,'2025-05-10 15:31:46',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(93,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',91,0.00,'2025-05-10 15:36:43',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(94,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',92,0.00,'2025-05-10 15:47:36',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(95,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',93,0.00,'2025-05-10 15:51:47',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(96,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',94,0.00,'2025-05-10 15:57:02',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(97,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',95,0.00,'2025-05-17 09:59:40',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(98,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',96,0.00,'2025-05-17 10:06:17',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(99,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',97,0.00,'2025-05-17 10:12:10',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(100,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',98,0.00,'2025-05-17 10:17:41',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(101,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',99,0.00,'2025-05-17 16:24:24',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(102,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',100,0.00,'2025-05-17 16:25:56',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(103,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',101,0.00,'2025-05-18 14:01:41',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(104,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',102,0.00,'2025-05-18 14:03:53',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(105,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',103,0.00,'2025-05-18 14:04:45',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(106,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',104,0.00,'2025-05-18 14:20:07',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(107,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',105,0.00,'2025-05-18 14:33:55',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(108,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',106,0.00,'2025-05-18 14:41:32',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(109,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',107,0.00,'2025-05-18 14:45:17',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(110,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',108,0.00,'2025-05-18 14:53:33',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(111,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',109,0.00,'2025-05-19 14:04:10',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(112,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',110,0.00,'2025-05-20 15:45:03',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(113,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',111,0.00,'2025-05-27 16:00:50',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(114,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',112,0.00,'2025-05-27 16:06:57',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(115,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',113,0.00,'2025-05-28 16:27:15',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(116,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',114,0.00,'2025-05-28 16:32:08',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(117,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',115,0.00,'2025-05-28 16:34:59',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(118,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',116,0.00,'2025-05-28 16:36:30',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(119,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',117,0.00,'2025-06-16 08:55:12',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(120,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',118,0.00,'2025-06-16 08:56:34',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(121,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',119,0.00,'2025-06-16 09:03:23',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(122,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',120,0.00,'2025-06-16 09:04:18',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(123,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',121,0.00,'2025-06-16 09:12:37',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(124,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',122,0.00,'2025-06-16 09:16:33',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(125,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',123,0.00,'2025-06-16 09:17:28',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(126,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',124,0.00,'2025-06-16 09:18:25',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(127,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',125,0.00,'2025-06-16 09:19:43',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(128,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',126,0.00,'2025-06-16 09:28:39',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(129,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',127,0.00,'2025-06-16 09:31:22',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(130,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',128,0.00,'2025-06-16 09:32:26',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(131,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',129,0.00,'2025-07-05 13:18:52',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(132,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',130,0.00,'2025-07-05 13:20:47',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(133,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',131,0.00,'2025-07-05 13:22:48',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(134,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',132,0.00,'2025-07-08 08:46:04',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(135,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',133,0.00,'2025-07-08 08:50:06',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(136,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',134,0.00,'2025-07-10 10:35:03',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(137,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',135,0.00,'2025-07-10 11:00:19',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(138,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',136,0.00,'2025-07-14 11:28:44',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(139,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',137,0.00,'2025-07-14 11:34:04',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(140,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',138,0.00,'2025-07-14 11:39:01',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(141,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',139,0.00,'2025-07-14 11:43:30',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(142,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',140,0.00,'2025-07-16 09:02:32',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(143,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',141,0.00,'2025-07-16 09:05:38',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(144,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',142,0.00,'2025-07-16 09:12:16',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(145,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',143,0.00,'2025-07-16 09:13:15',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(146,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',144,0.00,'2025-07-20 08:09:55',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(147,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',145,0.00,'2025-07-20 08:16:10',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(148,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',146,0.00,'2025-07-20 08:31:20',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(149,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',147,0.00,'2025-07-20 08:39:08',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(150,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',148,0.00,'2025-07-20 08:45:05',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(151,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',149,0.00,'2025-07-20 08:47:36',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(152,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',150,0.00,'2025-07-20 08:51:54',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(153,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',151,0.00,'2025-07-20 09:01:08',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(154,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',152,0.00,'2025-07-20 09:02:50',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(155,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',153,0.00,'2025-07-26 09:27:39',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(156,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',154,0.00,'2025-07-26 09:30:53',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(157,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',155,0.00,'2025-07-26 09:36:09',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(158,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',156,0.00,'2025-07-26 09:45:27',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(159,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',157,0.00,'2025-07-31 09:24:36',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(160,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',158,0.00,'2025-07-31 09:28:22',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(161,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',159,0.00,'2025-07-31 09:30:36',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(162,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',160,0.00,'2025-07-31 09:33:23',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(163,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',161,0.00,'2025-07-31 09:48:08',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(164,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',162,0.00,'2025-08-14 10:04:32',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(165,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',163,0.00,'2025-08-14 10:10:43',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(166,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',164,0.00,'2025-08-14 10:12:36',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(167,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',165,0.00,'2025-08-14 10:17:35',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(168,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',166,0.00,'2025-08-14 10:21:09',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(169,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',167,0.00,'2025-08-14 10:26:38',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(170,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',168,0.00,'2025-08-14 10:28:27',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(171,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',169,0.00,'2025-10-08 11:09:18',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(172,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',170,0.00,'2025-10-08 11:13:04',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(173,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',171,0.00,'2025-10-08 11:17:02',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(174,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',172,0.00,'2025-10-16 09:26:13',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(175,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',173,0.00,'2025-10-16 09:58:35',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(176,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',174,0.00,'2025-10-16 10:07:31',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(177,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',175,0.00,'2025-10-16 10:13:16',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(178,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',176,0.00,'2025-10-16 10:29:09',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(179,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',177,0.00,'2025-10-22 14:44:20',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(180,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',178,0.00,'2025-10-22 14:56:15',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(181,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',179,0.00,'2025-10-29 09:47:37',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(182,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',180,0.00,'2025-10-29 09:56:37',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(183,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',181,0.00,'2025-10-29 10:03:55',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(184,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',182,0.00,'2025-11-11 15:11:57',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(185,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',183,0.00,'2025-12-01 09:16:22',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(186,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',184,0.00,'2025-12-20 09:40:31',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(187,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',185,0.00,'2025-12-20 12:20:45',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(188,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',186,0.00,'2025-12-20 14:12:34',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(189,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',187,0.00,'2026-01-06 14:24:41',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(190,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',188,0.00,'2026-01-12 10:41:57',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(191,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',189,0.00,'2026-01-13 12:02:59',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(192,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',190,0.00,'2026-01-31 14:08:13',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(193,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',191,0.00,'2026-04-07 09:13:08',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(194,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',192,0.00,'2026-04-07 09:17:57',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(195,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',193,0.00,'2026-04-07 09:32:11',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(196,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',194,0.00,'2026-04-08 07:33:16',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(197,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',195,0.00,'2026-04-11 07:30:46',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(198,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',196,0.00,'2026-04-11 07:36:20',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(199,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',197,0.00,'2026-04-11 07:39:25',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(200,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',198,0.00,'2026-04-11 07:41:10',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(201,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',199,0.00,'2026-04-11 13:41:52',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(202,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',200,0.00,'2026-04-11 13:57:25',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(203,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',201,0.00,'2026-04-12 07:33:32',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(204,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',202,0.00,'2026-04-12 07:39:44',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(205,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',203,0.00,'2026-04-12 07:44:32',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(206,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',204,0.00,'2026-04-12 07:47:38',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(207,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',205,0.00,'2026-04-12 07:56:36',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(208,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',206,0.00,'2026-04-12 08:02:02',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(209,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',207,0.00,'2026-04-12 08:07:51',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(210,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',208,0.00,'2026-04-12 08:08:55',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(211,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',209,0.00,'2026-04-12 08:11:49',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(212,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',210,0.00,'2026-04-12 08:14:59',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(213,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',211,0.00,'2026-04-12 08:16:06',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(214,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',212,0.00,'2026-04-12 08:16:50',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(215,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',213,0.00,'2026-04-12 08:20:10',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(216,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',214,0.00,'2026-04-12 08:33:17',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(217,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',215,0.00,'2026-04-12 08:38:17',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(218,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',216,0.00,'2026-04-12 08:52:29',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(219,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',217,0.00,'2026-04-12 09:18:21',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(220,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',218,0.00,'2026-04-12 09:19:49',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(221,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',219,0.00,'2026-04-12 09:23:00',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(222,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',220,0.00,'2026-04-12 09:26:16',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(223,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',221,0.00,'2026-04-12 09:51:42',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(224,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',222,0.00,'2026-04-12 09:57:41',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(225,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',223,0.00,'2026-04-12 10:01:41',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(226,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',224,0.00,'2026-04-12 10:05:46',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(227,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',225,0.00,'2026-04-12 10:31:19',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(228,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',226,0.00,'2026-04-12 10:35:47',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(229,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',227,0.00,'2026-04-12 12:58:12',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(230,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',228,0.00,'2026-04-12 13:20:13',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(231,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',229,0.00,'2026-04-12 13:31:39',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(232,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',230,0.00,'2026-04-12 13:59:07',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(233,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',231,0.00,'2026-04-12 14:09:11',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(234,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',232,0.00,'2026-04-12 14:16:41',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(235,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',233,0.00,'2026-04-13 06:45:26',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(236,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',234,0.00,'2026-04-13 06:54:09',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(237,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',235,0.00,'2026-04-13 06:56:07',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(238,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',236,0.00,'2026-04-13 07:01:40',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(239,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',237,0.00,'2026-04-13 07:23:41',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(240,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',238,0.00,'2026-04-13 07:26:46',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(241,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',239,0.00,'2026-04-13 07:28:04',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00),
(242,1,0.00,0.00,0,'اضاÙة Ùاتورة مشتريات',240,0.00,'2026-04-13 07:53:41',1,'buyBillController.php','اضاÙة Ùاتورة مشتريات',0,0,0,0,1,1,0.00,1,0.00,0.00,0.00);

--
-- Table structure for table `supplieropen`
--

CREATE TABLE `supplieropen` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `value` float NOT NULL,
  `treeId` int(11) NOT NULL,
  `dailyentryid` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `sysdate` datetime NOT NULL,
  `del` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `supplieropen`
--


--
-- Table structure for table `supplieropendebtchange`
--

CREATE TABLE `supplieropendebtchange` (
  `supplieropendebtchangeid` int(11) NOT NULL AUTO_INCREMENT,
  `opensupplierid` int(11) NOT NULL,
  `supplierdebtchangebefore` decimal(10,2) NOT NULL,
  `supplierdebtchangeamount` decimal(10,2) NOT NULL,
  `supplierdebtchangetype` int(11) NOT NULL COMMENT '0 => plus- 1 => minus',
  `processname` varchar(256) NOT NULL,
  `supplierdebtchangemodelid` int(11) NOT NULL,
  `supplierdebtchangeafter` decimal(10,2) NOT NULL,
  `supplierdebtchangedate` datetime NOT NULL,
  `userid` int(11) NOT NULL,
  `tablename` varchar(500) NOT NULL,
  `comment` text DEFAULT NULL,
  `del` int(11) NOT NULL DEFAULT 0,
  `dailyentryid` int(11) NOT NULL DEFAULT 0,
  `saveid` int(11) DEFAULT NULL,
  `costcenterid` int(11) DEFAULT NULL,
  `currencyId` int(11) NOT NULL,
  `conversionFactor` float NOT NULL,
  `payedInCurrency` decimal(10,2) NOT NULL,
  `saveConversionFactor` float NOT NULL,
  PRIMARY KEY (`supplieropendebtchangeid`),
  KEY `idx_supplierdebtchange` (`tablename`(255)),
  KEY `supplierid` (`opensupplierid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `supplieropendebtchange`
--


--
-- Table structure for table `supplieropenexchangeorclosing`
--

CREATE TABLE `supplieropenexchangeorclosing` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `thetype` tinyint(4) NOT NULL COMMENT '0 exchange , 1 closing',
  `supplieropenid` int(11) NOT NULL,
  `saveid` int(11) NOT NULL,
  `assetorexpense` tinyint(4) NOT NULL COMMENT '0 asset, 1 expense',
  `assetorexpenseid` int(11) NOT NULL,
  `val` float NOT NULL,
  `dailyentryid` int(11) NOT NULL,
  `note` text NOT NULL,
  `userid` int(11) NOT NULL,
  `sysdate` datetime NOT NULL,
  `del` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `supplieropenexchangeorclosing`
--


--
-- Table structure for table `tamweenbill`
--

CREATE TABLE `tamweenbill` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `clientid` int(11) NOT NULL,
  `quantity` int(11) NOT NULL,
  `billdate` datetime NOT NULL,
  `billMonthDays` int(11) NOT NULL,
  `comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `userid` int(11) NOT NULL,
  `sysdate` datetime NOT NULL,
  `del` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tamweenbill`
--


--
-- Table structure for table `tamweenda3mstatus`
--

CREATE TABLE `tamweenda3mstatus` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `clientid` int(11) NOT NULL,
  `month` date NOT NULL,
  `tamweenStatus` tinyint(4) NOT NULL COMMENT '0 client didnot take it,1 client take it',
  `da3mStatus` tinyint(4) NOT NULL COMMENT '0 client didnot take it,1 client take it,   bread is in da3m',
  `userid` int(11) NOT NULL,
  `sysdate` datetime NOT NULL,
  `del` tinyint(4) NOT NULL,
  `useridTamween` int(11) NOT NULL,
  `sysdateTamween` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tamweenda3mstatus`
--


--
-- Table structure for table `tamweenremainstatus`
--

CREATE TABLE `tamweenremainstatus` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `clientid` int(11) NOT NULL,
  `month` date NOT NULL,
  `remainstatus` tinyint(4) NOT NULL COMMENT '0 didnot take it, 1 take it',
  `userid` int(11) NOT NULL,
  `sysdate` datetime NOT NULL,
  `del` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tamweenremainstatus`
--


--
-- Table structure for table `taskorder`
--

CREATE TABLE `taskorder` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `startdate` date NOT NULL,
  `enddate` date NOT NULL,
  `productId` int(11) NOT NULL,
  `num` decimal(10,2) NOT NULL,
  `userId` int(11) NOT NULL,
  `thedate` date NOT NULL,
  `conditions` int(11) NOT NULL DEFAULT 0 COMMENT '0 for notdel- 1for del',
  `clientid` int(11) NOT NULL,
  `file` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `taskorder`
--


--
-- Table structure for table `taskorderproducts`
--

CREATE TABLE `taskorderproducts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `taskorderid` int(11) NOT NULL,
  `productid` int(11) NOT NULL,
  `unitid` int(11) NOT NULL,
  `quantity` decimal(10,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `taskorderproducts`
--


--
-- Table structure for table `taskscases`
--

CREATE TABLE `taskscases` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `del` int(11) unsigned DEFAULT NULL,
  `taskcase` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `taskscases`
--

INSERT INTO `taskscases` VALUES
(1,0,'مهمة جديده'),
(2,0,'تحت التنÙيذ'),
(3,0,'تم التنÙيذ'),
(4,0,'لم يتم التنÙيذ'),
(5,0,'تم الالغاء');

--
-- Table structure for table `temreturnsellbill`
--

CREATE TABLE `temreturnsellbill` (
  `returnsellbillid` int(11) NOT NULL AUTO_INCREMENT,
  `returnsellbilldate` date DEFAULT NULL,
  `returnsellbillserial` varchar(255) DEFAULT NULL,
  `returnsellbillclientid` int(11) NOT NULL,
  `returnsellbilltotaldeptbefor` decimal(10,2) NOT NULL,
  `returnsellbilltotaldeptafter` decimal(10,2) NOT NULL,
  `returnsellbilldiscount` varchar(255) NOT NULL DEFAULT '',
  `returnsellbilldiscounttype` int(11) NOT NULL DEFAULT 1 COMMENT '1 for direct- 2 for percent',
  `returnsellbilltotalbill` decimal(10,2) NOT NULL,
  `returnsellbillaftertotalbill` decimal(10,2) NOT NULL,
  `returnsellbilltotalpayed` decimal(10,2) NOT NULL,
  `returnsellbillfinalbill` decimal(10,2) NOT NULL,
  `returnsellbillstoreid` int(11) NOT NULL,
  `returnsellbillsysdate` date NOT NULL,
  `userid` int(11) NOT NULL,
  `conditions` int(11) NOT NULL DEFAULT 0,
  `returnsellbillclientname` text NOT NULL,
  `returnsellbillsaveid` int(11) NOT NULL,
  `returnsellbildirectpayment` int(11) NOT NULL DEFAULT 0,
  `billnameid` int(11) NOT NULL,
  `sellerid` int(11) NOT NULL,
  `tempclientName` varchar(255) NOT NULL,
  `returnsellQuantity` decimal(10,2) NOT NULL,
  `deletedsellid` int(11) NOT NULL DEFAULT 0,
  `controlname` varchar(255) NOT NULL DEFAULT '0',
  `tax` decimal(10,2) NOT NULL DEFAULT 0.00,
  PRIMARY KEY (`returnsellbillid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `temreturnsellbill`
--


--
-- Table structure for table `temreturnsellbilldetail`
--

CREATE TABLE `temreturnsellbilldetail` (
  `returnsellbilldetailid` int(11) NOT NULL AUTO_INCREMENT,
  `buyprice` decimal(10,2) NOT NULL,
  `parcode` varchar(256) NOT NULL DEFAULT '',
  `returnsellbillid` int(11) NOT NULL,
  `returnsellbilldetailcatid` int(11) NOT NULL,
  `returnsellbilldetailproductid` int(11) NOT NULL,
  `returnsellbilldetailquantity` decimal(10,2) NOT NULL,
  `returnsellbilldetailprice` decimal(10,2) NOT NULL,
  `returnsellbilldetailtotalprice` decimal(10,2) NOT NULL,
  `conditions` decimal(10,2) NOT NULL,
  `note` varchar(256) DEFAULT NULL,
  `pricetype` tinyint(4) NOT NULL DEFAULT 0,
  `discountvalue` decimal(10,2) NOT NULL,
  `productunitid` int(11) NOT NULL,
  `buydiscount` decimal(10,2) NOT NULL,
  `buydiscounttype` int(11) NOT NULL,
  `storeid` int(11) NOT NULL DEFAULT 0,
  `actualqty` int(11) NOT NULL,
  PRIMARY KEY (`returnsellbilldetailid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `temreturnsellbilldetail`
--


--
-- Table structure for table `temsellandruternbilldetail`
--

CREATE TABLE `temsellandruternbilldetail` (
  `buyprice` decimal(10,2) NOT NULL,
  `parcode` varchar(256) NOT NULL DEFAULT '',
  `sellbilldetailid` int(11) NOT NULL AUTO_INCREMENT,
  `sellbillid` int(11) NOT NULL,
  `sellbilldetailcatid` int(11) NOT NULL,
  `sellbilldetailproductid` int(11) NOT NULL,
  `sellbilldetailquantity` decimal(10,2) NOT NULL,
  `sellbilldetailprice` decimal(10,2) NOT NULL,
  `sellbilldetailtotalprice` decimal(10,2) NOT NULL,
  `discountvalue` decimal(10,2) NOT NULL,
  `note` varchar(256) DEFAULT NULL,
  `pricetype` tinyint(4) NOT NULL DEFAULT 0,
  `sellbilldetaildate` date NOT NULL,
  `selltype` int(11) NOT NULL COMMENT '0 for sell 1 for return',
  `productunitid` int(11) NOT NULL,
  `buydiscount` decimal(10,2) NOT NULL,
  `buydiscounttype` int(11) NOT NULL,
  `storeid` int(11) NOT NULL DEFAULT 0,
  `actualqty` int(11) NOT NULL,
  PRIMARY KEY (`sellbilldetailid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `temsellandruternbilldetail`
--


--
-- Table structure for table `temsellbill`
--

CREATE TABLE `temsellbill` (
  `sellbillid` int(11) NOT NULL AUTO_INCREMENT,
  `sellbilldate` date DEFAULT NULL,
  `sellbillserial` varchar(255) DEFAULT NULL,
  `sellbillclientid` int(11) NOT NULL DEFAULT 0,
  `sellbilltotaldeptbefor` decimal(10,2) NOT NULL,
  `sellbilltotaldeptafter` decimal(10,2) NOT NULL,
  `sellbilldiscount` varchar(255) NOT NULL DEFAULT '',
  `sellbilldiscounttype` int(11) NOT NULL DEFAULT 0,
  `sellbilltotalbill` decimal(10,2) NOT NULL,
  `sellbillaftertotalbill` decimal(10,2) NOT NULL,
  `sellbilltotalpayed` decimal(10,2) NOT NULL,
  `sellbillfinalbill` decimal(10,2) NOT NULL,
  `sellbillstoreid` int(11) NOT NULL,
  `sellbillsysdate` date NOT NULL,
  `userid` int(11) NOT NULL,
  `conditions` int(11) NOT NULL DEFAULT 0,
  `sellbillclientname` text NOT NULL,
  `sellbillsaveid` int(11) NOT NULL,
  `sellbildirectpayment` int(11) NOT NULL,
  `billnameid` int(11) NOT NULL,
  `sellerid` int(11) NOT NULL,
  `tempclientName` varchar(255) NOT NULL,
  `sellQuantity` decimal(10,2) NOT NULL,
  `deletedsellid` int(11) NOT NULL,
  `controlname` varchar(255) NOT NULL,
  `tax` decimal(10,2) NOT NULL DEFAULT 0.00,
  PRIMARY KEY (`sellbillid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `temsellbill`
--


--
-- Table structure for table `temsellbillandrutern`
--

CREATE TABLE `temsellbillandrutern` (
  `sellbillid` int(11) NOT NULL AUTO_INCREMENT,
  `sellbilldate` date DEFAULT NULL,
  `sellbillserial` varchar(255) DEFAULT NULL,
  `sellbillclientid` int(11) NOT NULL DEFAULT 0,
  `sellbilltotaldeptbefor` decimal(10,2) NOT NULL,
  `sellbilltotaldeptafter` decimal(10,2) NOT NULL,
  `sellbilldiscount` varchar(255) NOT NULL DEFAULT '',
  `sellbilldiscounttype` int(11) NOT NULL DEFAULT 0,
  `sellbilltotalbill` decimal(10,2) NOT NULL,
  `sellbillaftertotalbill` decimal(10,2) NOT NULL,
  `sellbilltotalpayed` decimal(10,2) NOT NULL,
  `sellbillfinalbill` decimal(10,2) NOT NULL,
  `sellbillstoreid` int(11) NOT NULL,
  `sellbillsysdate` date NOT NULL,
  `userid` int(11) NOT NULL,
  `conditions` int(11) NOT NULL DEFAULT 0,
  `sellbillclientname` text NOT NULL,
  `sellbillsaveid` int(11) NOT NULL,
  `sellbildirectpayment` int(11) NOT NULL,
  `billnameid` int(11) NOT NULL,
  `sellerid` int(11) NOT NULL,
  `sellbillprice` decimal(10,2) NOT NULL,
  `returnsellbillprice` decimal(10,2) NOT NULL,
  `tempclientName` varchar(255) NOT NULL,
  `sellQuantity` decimal(10,2) NOT NULL,
  `returnsellQuantity` decimal(10,2) NOT NULL,
  `deletedsellid` int(11) NOT NULL,
  `controlname` varchar(255) NOT NULL,
  `tax` decimal(10,2) NOT NULL DEFAULT 0.00,
  PRIMARY KEY (`sellbillid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `temsellbillandrutern`
--


--
-- Table structure for table `temsellbilldetail`
--

CREATE TABLE `temsellbilldetail` (
  `buyprice` decimal(10,2) NOT NULL,
  `parcode` varchar(256) NOT NULL DEFAULT '',
  `sellbilldetailid` int(11) NOT NULL AUTO_INCREMENT,
  `sellbillid` int(11) NOT NULL,
  `sellbilldetailcatid` int(11) NOT NULL,
  `sellbilldetailproductid` int(11) NOT NULL,
  `sellbilldetailquantity` decimal(10,2) NOT NULL,
  `sellbilldetailprice` decimal(10,2) NOT NULL,
  `sellbilldetailtotalprice` decimal(10,2) NOT NULL,
  `discountvalue` decimal(10,2) NOT NULL,
  `note` varchar(256) DEFAULT NULL,
  `pricetype` tinyint(4) NOT NULL DEFAULT 0,
  `sellbilldetaildate` date NOT NULL,
  `productunitid` int(11) NOT NULL,
  `buydiscount` decimal(10,2) NOT NULL,
  `buydiscounttype` int(11) NOT NULL,
  `storeid` int(11) NOT NULL DEFAULT 0,
  `actualqty` int(11) NOT NULL,
  PRIMARY KEY (`sellbilldetailid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `temsellbilldetail`
--


--
-- Table structure for table `toworkshoporder`
--

CREATE TABLE `toworkshoporder` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `driverIdBack` int(11) NOT NULL,
  `deliverIdBack` int(11) NOT NULL,
  `orderNo` varchar(100) NOT NULL,
  `driverId` int(11) NOT NULL,
  `workshopId` int(11) NOT NULL,
  `productNo` int(11) NOT NULL,
  `deliverWorkshopDate` datetime NOT NULL,
  `deliverId` int(11) NOT NULL,
  `branchId` int(11) NOT NULL,
  `orderStatus` int(11) NOT NULL,
  `sysDate` datetime NOT NULL,
  `del` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `recieveWorkshopDate` datetime NOT NULL,
  `deliverBranchDate` datetime NOT NULL,
  `recieveBranchDate` datetime NOT NULL,
  `drivertimeout` int(11) NOT NULL DEFAULT 0,
  `driverdelay` int(11) NOT NULL DEFAULT 0,
  `workshoptimeout` int(11) NOT NULL DEFAULT 0,
  `workshopdelay` int(11) NOT NULL DEFAULT 0,
  `drivertimeoutback` int(11) NOT NULL DEFAULT 0,
  `driverdelayback` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `toworkshoporder`
--


--
-- Table structure for table `toworkshoporderbill`
--

CREATE TABLE `toworkshoporderbill` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `toworkshoporderid` int(11) NOT NULL,
  `billid` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `toworkshoporderbill`
--


--
-- Table structure for table `transferbtweenbankaccount`
--

CREATE TABLE `transferbtweenbankaccount` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `bankidfrom` int(11) NOT NULL,
  `accountidfrom` int(11) NOT NULL,
  `bankidto` int(11) NOT NULL,
  `accountidto` int(11) NOT NULL,
  `transfervalue` decimal(10,2) NOT NULL,
  `transferdate` datetime NOT NULL,
  `userid` int(11) NOT NULL,
  `conditions` tinyint(4) NOT NULL,
  `dailyentryid` int(11) NOT NULL,
  `comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `transferbtweenbankaccount`
--


--
-- Table structure for table `transferclientaccounts`
--

CREATE TABLE `transferclientaccounts` (
  `transferid` int(11) NOT NULL AUTO_INCREMENT,
  `clientidfrom` int(11) NOT NULL,
  `clientidto` int(11) NOT NULL,
  `transfervalue` decimal(10,2) NOT NULL,
  `transferdate` date NOT NULL,
  `userid` int(11) NOT NULL,
  `conditions` int(11) NOT NULL DEFAULT 0,
  `dailyentryid` int(11) NOT NULL DEFAULT 0,
  `comment` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`transferid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `transferclientaccounts`
--


--
-- Table structure for table `transfermoney`
--

CREATE TABLE `transfermoney` (
  `transfermoneyid` int(11) NOT NULL AUTO_INCREMENT,
  `saveidfrom` int(11) NOT NULL,
  `saveidto` int(11) NOT NULL,
  `transfermoneyvalue` decimal(10,2) NOT NULL,
  `transfermoneydate` date NOT NULL,
  `userid` int(11) NOT NULL,
  `conditions` int(11) NOT NULL DEFAULT 0,
  `dailyentryid` int(11) NOT NULL DEFAULT 0,
  `comment` varchar(255) DEFAULT NULL,
  `currencyId` int(11) NOT NULL,
  `conversionFactor` float NOT NULL,
  `conversionFactorFrom` float NOT NULL,
  `conversionFactorTo` float NOT NULL,
  `transfermoneyvalueInCurrency` decimal(10,2) NOT NULL,
  PRIMARY KEY (`transfermoneyid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `transfermoney`
--


--
-- Table structure for table `typeclient`
--

CREATE TABLE `typeclient` (
  `typeId` int(11) NOT NULL AUTO_INCREMENT,
  `typeName` varchar(255) NOT NULL,
  `conditions` int(11) NOT NULL DEFAULT 0,
  `comments` text NOT NULL,
  `typeDate` date NOT NULL,
  PRIMARY KEY (`typeId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `typeclient`
--


--
-- Table structure for table `typesimpotencetreatment`
--

CREATE TABLE `typesimpotencetreatment` (
  `typesimpotencetreatmentid` int(11) NOT NULL AUTO_INCREMENT,
  `typesimpotencetreatmentname` varchar(256) DEFAULT NULL,
  `typesimpotencetreatmentdate` datetime NOT NULL,
  `userid` int(11) NOT NULL,
  `conditions` int(1) NOT NULL,
  `typesimpotencetreatmentcomment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`typesimpotencetreatmentid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `typesimpotencetreatment`
--


--
-- Table structure for table `typesupplier`
--

CREATE TABLE `typesupplier` (
  `typeId` int(11) NOT NULL AUTO_INCREMENT,
  `typeName` varchar(100) NOT NULL,
  `conditions` int(11) NOT NULL DEFAULT 0,
  `comments` text NOT NULL,
  `typeDate` date NOT NULL,
  `category_id` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`typeId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `typesupplier`
--


--
-- Table structure for table `unit`
--

CREATE TABLE `unit` (
  `unitId` int(11) NOT NULL AUTO_INCREMENT,
  `unitName` varchar(256) NOT NULL,
  `unitSymbol` varchar(256) DEFAULT NULL,
  `unitDescription` text DEFAULT NULL,
  `unitDate` date NOT NULL,
  `conditions` int(1) NOT NULL DEFAULT 0,
  `userId` int(11) NOT NULL,
  PRIMARY KEY (`unitId`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `unit`
--

INSERT INTO `unit` VALUES
(1,'قطعة','','','2025-02-19',0,1);

--
-- Table structure for table `usergroupadmin`
--

CREATE TABLE `usergroupadmin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `propertyid` int(11) NOT NULL,
  `isallowed` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 allowed,1not allowed',
  PRIMARY KEY (`id`),
  UNIQUE KEY `propertyid` (`propertyid`)
) ENGINE=InnoDB AUTO_INCREMENT=565 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `usergroupadmin`
--

INSERT INTO `usergroupadmin` VALUES
(1,1,0),
(2,2,0),
(3,3,1),
(4,4,0),
(5,5,0),
(6,6,0),
(7,7,0),
(8,8,0),
(9,9,0),
(10,10,0),
(11,11,0),
(12,12,0),
(13,13,0),
(14,14,0),
(15,15,0),
(16,16,0),
(17,17,0),
(18,18,0),
(19,19,0),
(20,23,0),
(21,24,0),
(22,25,0),
(23,26,0),
(24,27,0),
(25,28,1),
(26,29,1),
(27,30,1),
(28,31,0),
(29,32,0),
(30,33,0),
(31,34,0),
(32,35,0),
(33,36,0),
(34,37,0),
(35,38,0),
(36,39,0),
(37,40,0),
(38,41,0),
(39,42,0),
(40,43,0),
(41,44,0),
(42,45,0),
(43,46,0),
(44,47,1),
(45,48,1),
(46,49,0),
(47,50,0),
(48,51,0),
(49,52,0),
(50,53,0),
(51,54,0),
(52,55,0),
(53,56,0),
(54,57,0),
(55,58,0),
(56,59,0),
(57,60,0),
(58,61,0),
(59,62,0),
(60,63,0),
(61,64,0),
(62,65,0),
(63,66,0),
(64,67,0),
(65,68,0),
(66,69,0),
(67,70,0),
(68,71,0),
(69,72,0),
(70,73,0),
(71,74,0),
(72,75,0),
(73,76,0),
(74,77,0),
(75,78,0),
(76,79,0),
(77,80,0),
(78,82,0),
(79,83,0),
(80,84,0),
(81,85,0),
(82,87,0),
(83,89,0),
(84,90,0),
(85,91,0),
(86,92,0),
(87,93,0),
(88,96,1),
(89,97,0),
(90,98,0),
(91,99,0),
(92,100,0),
(93,105,0),
(94,123,0),
(95,124,0),
(96,125,0),
(97,126,1),
(98,127,1),
(99,128,1),
(100,129,1),
(101,130,1),
(102,131,1),
(103,133,0),
(104,134,0),
(105,135,0),
(106,136,0),
(107,137,0),
(108,138,0),
(109,139,0),
(110,140,0),
(111,141,0),
(112,142,0),
(113,143,0),
(114,144,0),
(115,145,0),
(116,146,0),
(117,147,0),
(118,148,0),
(119,149,1),
(120,150,1),
(121,151,1),
(122,152,1),
(123,153,1),
(124,154,1),
(125,155,1),
(126,156,1),
(127,157,1),
(128,158,1),
(129,159,1),
(130,160,1),
(131,161,1),
(132,162,1),
(133,163,1),
(134,164,1),
(135,165,1),
(136,166,1),
(137,167,0),
(138,168,0),
(139,169,0),
(140,170,0),
(141,171,0),
(142,172,0),
(143,173,1),
(144,174,1),
(145,175,1),
(146,176,1),
(147,177,1),
(148,178,1),
(149,179,1),
(150,180,1),
(151,181,1),
(152,182,1),
(153,183,1),
(154,187,1),
(155,188,1),
(156,189,1),
(157,190,1),
(158,191,1),
(159,192,1),
(160,193,1),
(161,194,1),
(162,195,1),
(163,196,1),
(164,197,1),
(165,198,1),
(166,199,1),
(167,200,1),
(168,201,0),
(169,202,0),
(170,203,0),
(171,205,1),
(172,206,0),
(173,207,0),
(174,208,0),
(175,209,1),
(176,210,1),
(177,211,1),
(178,212,1),
(179,213,1),
(180,214,1),
(181,215,1),
(182,216,1),
(183,217,1),
(184,218,1),
(185,219,1),
(186,220,1),
(187,221,1),
(188,227,1),
(189,228,1),
(190,231,1),
(191,232,0),
(192,233,0),
(193,234,1),
(194,235,0),
(195,243,0),
(196,244,1),
(197,250,0),
(198,252,0),
(199,253,0),
(200,256,0),
(201,257,0),
(202,258,0),
(203,259,0),
(204,260,0),
(205,261,0),
(206,262,0),
(207,263,0),
(208,264,1),
(209,265,0),
(210,266,1),
(211,267,1),
(212,268,0),
(213,269,0),
(214,274,0),
(215,275,0),
(216,278,0),
(217,279,0),
(218,280,0),
(219,281,0),
(220,282,0),
(221,283,0),
(222,284,0),
(223,285,0),
(224,286,0),
(225,287,0),
(226,288,0),
(227,289,0),
(228,290,0),
(229,291,0),
(230,292,0),
(231,293,1),
(232,294,1),
(233,295,1),
(234,296,1),
(235,297,0),
(236,298,0),
(237,299,1),
(238,300,0),
(239,301,0),
(240,302,0),
(241,303,1),
(242,304,1),
(243,305,0),
(244,307,1),
(245,308,1),
(246,309,1),
(247,310,1),
(248,311,1),
(249,312,1),
(250,313,1),
(251,314,1),
(252,315,1),
(253,316,0),
(254,317,1),
(255,318,1),
(256,319,1),
(257,320,1),
(258,321,1),
(259,322,1),
(260,323,1),
(261,324,1),
(262,325,1),
(263,326,0),
(264,327,0),
(265,328,0),
(266,329,0),
(267,330,0),
(268,331,0),
(269,332,0),
(270,333,0),
(271,334,0),
(272,335,0),
(273,336,0),
(274,337,0),
(275,338,0),
(276,339,0),
(277,340,0),
(278,341,0),
(279,342,0),
(280,343,0),
(281,344,0),
(282,345,0),
(283,346,0),
(284,347,0),
(285,348,0),
(286,349,0),
(287,350,0),
(288,351,0),
(289,352,0),
(290,353,0),
(291,354,0),
(292,355,0),
(293,356,0),
(294,357,0),
(295,358,0),
(296,359,0),
(297,360,0),
(298,361,0),
(299,362,0),
(300,363,0),
(301,364,0),
(302,365,0),
(303,366,0),
(304,367,0),
(305,368,0),
(306,369,0),
(307,370,0),
(308,371,0),
(309,372,0),
(310,373,0),
(311,374,0),
(312,375,0),
(313,376,0),
(314,377,0),
(315,378,0),
(316,379,0),
(317,380,0),
(318,381,0),
(319,382,0),
(320,383,0),
(321,384,0),
(322,385,0),
(323,386,0),
(324,387,0),
(325,388,0),
(326,389,0),
(327,390,0),
(328,391,0),
(329,392,0),
(330,393,0),
(331,394,0),
(332,395,0),
(333,396,0),
(334,397,0),
(335,398,0),
(336,399,0),
(337,400,0),
(338,401,1),
(339,402,1),
(340,403,1),
(341,404,0),
(342,405,1),
(343,406,1),
(344,407,1),
(345,408,1),
(346,409,1),
(347,410,1),
(348,411,1),
(349,412,0),
(350,413,0),
(351,414,0),
(352,417,0),
(353,418,0),
(354,419,0),
(355,420,0),
(356,421,0),
(357,422,0),
(358,423,0),
(359,424,0),
(360,425,0),
(361,426,0),
(362,427,0),
(363,428,0),
(364,429,0),
(365,430,0),
(366,431,0),
(367,432,0),
(368,433,0),
(369,434,0),
(370,436,1),
(371,437,0),
(372,438,0),
(373,439,1),
(374,440,0),
(375,441,0),
(376,442,1),
(377,443,0),
(378,444,0),
(379,445,0),
(380,446,0),
(381,447,0),
(382,448,0),
(383,449,1),
(384,450,1),
(385,451,0),
(386,452,0),
(387,453,0),
(388,454,0),
(389,455,0),
(390,456,0),
(391,457,0),
(392,458,0),
(393,459,0),
(394,460,0),
(395,461,1),
(396,462,1),
(397,463,0),
(398,464,1),
(399,465,0),
(400,466,0),
(401,467,0),
(402,468,1),
(403,469,0),
(404,470,0),
(405,471,0),
(406,472,0),
(407,473,0),
(408,474,0),
(409,475,0),
(410,476,0),
(411,477,0),
(412,478,0),
(413,479,0),
(414,480,0),
(415,481,0),
(416,482,0),
(417,483,0),
(418,484,0),
(419,485,0),
(420,486,0),
(421,487,0),
(422,488,0),
(423,489,0),
(424,490,1),
(425,491,1),
(426,492,0),
(427,493,0),
(428,494,0),
(429,495,0),
(430,496,0),
(431,497,0),
(432,498,0),
(433,499,0),
(434,500,0),
(435,501,0),
(436,502,0),
(437,503,0),
(438,504,0),
(439,505,0),
(440,506,0),
(441,507,0),
(442,508,1),
(443,509,0),
(444,510,0),
(445,511,1),
(446,512,0),
(447,513,0),
(448,514,0),
(449,515,0),
(450,516,0),
(451,517,0),
(452,518,0),
(453,519,0),
(454,520,0),
(455,521,0),
(456,522,1),
(457,523,0),
(458,524,0),
(459,525,0),
(460,526,0),
(461,527,1),
(462,528,1),
(463,529,1),
(464,530,0),
(465,531,0),
(466,532,0),
(467,533,0),
(468,534,0),
(469,535,1),
(470,536,1),
(471,537,1),
(472,538,1),
(473,539,1),
(474,540,0),
(475,541,0),
(476,542,0),
(477,543,1),
(478,544,0),
(479,545,0),
(480,546,0),
(481,547,0),
(482,548,0),
(483,549,1),
(484,550,0),
(485,551,0),
(486,552,0),
(487,553,0),
(488,554,0),
(489,555,0),
(490,556,0),
(491,557,0),
(492,558,0),
(493,559,0),
(494,560,0),
(495,561,0),
(496,562,0),
(497,563,0),
(498,564,0),
(499,565,0),
(500,566,0),
(501,567,0),
(502,568,0),
(503,569,0),
(504,570,1),
(505,571,1),
(506,572,1),
(507,573,1),
(508,574,1),
(509,575,1),
(510,576,1),
(511,577,1),
(512,578,1),
(513,579,0),
(514,580,0),
(515,581,0),
(516,582,0),
(517,583,0),
(518,584,0),
(519,585,1),
(520,586,1),
(521,587,0);

--
-- Table structure for table `vatpayment`
--

CREATE TABLE `vatpayment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `amount` decimal(10,2) NOT NULL,
  `saveid` int(11) NOT NULL,
  `comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `userid` int(11) NOT NULL,
  `sysdate` datetime NOT NULL,
  `conditions` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `vatpayment`
--


--
-- Table structure for table `workshop`
--

CREATE TABLE `workshop` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `thedate` date NOT NULL,
  `userid` int(11) NOT NULL,
  `del` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `workshop`
--


--
-- Table structure for table `workstation`
--

CREATE TABLE `workstation` (
  `workstationid` int(11) NOT NULL AUTO_INCREMENT,
  `workname` varchar(255) NOT NULL,
  `workerhours` decimal(10,2) NOT NULL,
  `assetshours` decimal(10,2) NOT NULL,
  `date` varchar(255) NOT NULL,
  `conditions` int(11) NOT NULL DEFAULT 0 COMMENT '0del-1-notdel',
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`workstationid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `workstation`
--


--
-- Table structure for table `workstationassets`
--

CREATE TABLE `workstationassets` (
  `workstationassetsId` int(11) NOT NULL AUTO_INCREMENT,
  `workstationid` int(11) NOT NULL,
  `assetsId` varchar(255) NOT NULL,
  `workhours` decimal(10,2) NOT NULL,
  `efficiency` decimal(10,2) NOT NULL,
  PRIMARY KEY (`workstationassetsId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `workstationassets`
--


--
-- Table structure for table `workstationworker`
--

CREATE TABLE `workstationworker` (
  `workstationworkerId` int(11) NOT NULL AUTO_INCREMENT,
  `workstationid` int(11) NOT NULL,
  `employeeId` varchar(255) NOT NULL,
  `workhours` decimal(10,2) NOT NULL,
  `efficiency` decimal(10,2) NOT NULL,
  PRIMARY KEY (`workstationworkerId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `workstationworker`
--


--
-- Table structure for table `youtube_link`
--

CREATE TABLE `youtube_link` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `url` varchar(255) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=290 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `youtube_link`
--

INSERT INTO `youtube_link` VALUES
(1,'#1',1),
(2,'#2',1),
(3,'#3',1),
(4,'#4',1),
(5,'#5',1),
(6,'#6',1),
(7,'#7',1),
(8,'#8',1),
(9,'#9',1),
(10,'#10',1),
(11,'#11',1),
(12,'#12',1),
(13,'#13',1),
(14,'#14',1),
(15,'#15',1),
(16,'#16',1),
(17,'#17',1),
(18,'#18',1),
(19,'#19',1),
(20,'#20',1),
(21,'#21',1),
(22,'#22',1),
(23,'#23',1),
(24,'#24',1),
(25,'#25',1),
(26,'#26',1),
(27,'#27',1),
(28,'#28',1),
(29,'#29',1),
(30,'#30',1),
(31,'#31',1),
(32,'#32',1),
(33,'#33',1),
(34,'#34',1),
(35,'#35',1),
(36,'#36',1),
(37,'#37',1),
(38,'#38',1),
(39,'#39',1),
(40,'#40',1),
(41,'#41',1),
(42,'#42',1),
(43,'#43',1),
(44,'#44',1),
(45,'#45',1),
(46,'#46',1),
(47,'#47',1),
(48,'#48',1),
(49,'#49',1),
(50,'#50',1),
(51,'#51',1),
(52,'#52',1),
(53,'#53',1),
(54,'#54',1),
(55,'#55',1),
(56,'#56',1),
(57,'#57',1),
(58,'#58',1),
(59,'#59',1),
(60,'#60',1),
(61,'#61',1),
(62,'#62',1),
(63,'#63',1),
(64,'#64',1),
(65,'#65',1),
(66,'#66',1),
(67,'#67',1),
(68,'#68',1),
(69,'#69',1),
(70,'#70',1),
(71,'#71',1),
(72,'#72',1),
(73,'#73',1),
(74,'#74',1),
(75,'#75',1),
(76,'#76',1),
(77,'#77',1),
(78,'#78',1),
(79,'#79',1),
(80,'#80',1),
(81,'#81',1),
(82,'#82',1),
(83,'#83',1),
(84,'#84',1),
(85,'#85',1),
(86,'#86',1),
(87,'#87',1),
(88,'#88',1),
(89,'#89',1),
(90,'#90',1),
(91,'#91',1),
(92,'#92',1),
(93,'#93',1),
(94,'#94',1),
(95,'#95',1),
(96,'#96',1),
(97,'#97',1),
(98,'#98',1),
(99,'#99',1),
(100,'#100',1),
(101,'#101',1),
(102,'#102',1),
(103,'#103',1),
(104,'#104',1),
(105,'#105',1),
(106,'#106',1),
(107,'#107',1),
(108,'#108',1),
(109,'#109',1),
(110,'#110',1),
(111,'#111',1),
(112,'#112',1),
(113,'#113',1),
(114,'#114',1),
(115,'#115',1),
(116,'#116',1),
(117,'#117',1),
(118,'#118',1),
(119,'#119',1),
(120,'#120',1),
(121,'#121',1),
(122,'#122',1),
(123,'#123',1),
(124,'#124',1),
(125,'#125',1),
(126,'#126',1),
(127,'#127',1),
(128,'#128',1),
(129,'#129',1),
(130,'#130',1),
(131,'#131',1),
(132,'#132',1),
(133,'#133',1),
(134,'#134',1),
(135,'#135',1),
(136,'#136',1),
(137,'#137',1),
(138,'#138',1),
(139,'#139',1),
(140,'#140',1),
(141,'#141',1),
(142,'#142',1),
(143,'#143',1),
(144,'#144',1),
(145,'#145',1),
(146,'#146',1),
(147,'#147',1),
(148,'#148',1),
(149,'#149',1),
(150,'#150',1),
(151,'#151',1),
(152,'#152',1),
(153,'#153',1),
(154,'#154',1),
(155,'#155',1),
(156,'#156',1),
(157,'#157',1),
(158,'#158',1),
(159,'#159',1),
(160,'#160',1),
(161,'#161',1),
(162,'#162',1),
(163,'#163',1),
(164,'#164',1),
(165,'#165',1),
(166,'#166',1),
(167,'#167',1),
(168,'#168',1),
(169,'#169',1),
(170,'#170',1),
(171,'#171',1),
(172,'#172',1),
(173,'#173',1),
(174,'#174',1),
(175,'#175',1),
(176,'#176',1),
(177,'#177',1),
(178,'#178',1),
(179,'#179',1),
(180,'#180',1),
(181,'#181',1),
(182,'#182',1),
(183,'#183',1),
(184,'#184',1),
(185,'#185',1),
(186,'#186',1),
(187,'#187',1),
(188,'#188',1),
(189,'#189',1),
(190,'#190',1),
(191,'#191',1),
(192,'#192',1),
(193,'#193',1),
(194,'#194',1),
(195,'#195',1),
(196,'#196',1),
(197,'#197',1),
(198,'#198',1),
(199,'#199',1),
(200,'#200',1),
(201,'#201',1),
(202,'#202',1),
(203,'#203',1),
(204,'#204',1),
(205,'#205',1),
(206,'#206',1),
(207,'#207',1),
(208,'#208',1),
(209,'#209',1),
(210,'#210',1),
(211,'#211',1),
(212,'#212',1),
(213,'#213',1),
(214,'#214',1),
(215,'#215',1),
(216,'#216',1),
(217,'#217',1),
(218,'#218',1),
(219,'#219',1),
(220,'#220',1),
(221,'#221',1),
(222,'#222',1),
(223,'#223',1),
(224,'#224',1),
(225,'#225',1),
(226,'#226',1),
(227,'#227',1),
(228,'#228',1),
(229,'#229',1),
(230,'#230',1),
(231,'#231',1),
(232,'#232',1),
(233,'#233',1),
(234,'#234',1),
(235,'#235',1),
(236,'#236',1),
(237,'#237',1),
(238,'#238',1),
(239,'#239',1),
(240,'#240',1),
(241,'#241',1),
(242,'#242',1),
(243,'#243',1),
(244,'#244',1),
(245,'#245',1),
(246,'#246',1),
(247,'#247',1),
(248,'#248',1),
(249,'#249',1),
(250,'#250',1),
(251,'#251',1),
(252,'#252',1),
(253,'#253',1),
(254,'#254',1),
(255,'#255',1),
(256,'#256',1),
(257,'#257',1),
(258,'#258',1),
(259,'#259',1),
(260,'#260',1),
(261,'#261',1),
(262,'#262',1),
(263,'#263',1),
(264,'#264',1),
(265,'#265',1),
(266,'#266',1),
(267,'#267',1),
(268,'#268',1),
(269,'#269',1),
(270,'#270',1),
(271,'#271',1),
(272,'#272',1),
(273,'#273',1),
(274,'#274',1),
(275,'#275',1),
(276,'#276',1),
(277,'#277',1),
(278,'#278',1),
(279,'#279',1),
(280,'#280',1),
(281,'#281',1),
(282,'#282',1),
(283,'#283',1),
(284,'#284',1),
(285,'#285',1),
(286,'#286',1),
(287,'#287',1),
(288,'#288',1),
(289,'#289',1);


