INSERT INTO `all_sales` (`_id`, `itemname`, `quantity`, `price`, `total`, `type`, `parent`, `parentid`, `mod_assigned`, `tax`, `taxname`, `bill_no`, `time`, `date`, `user`, `table_id`, `billtype`, `paymentmethod`, `billamount_disapply`, `billamount_disnotapply`, `_idd`, `deleted_not`, `modifiedquantity`, `quantitycopy`, `modifiedtotal`, `date1`, `datetimee`, `disc_type`, `disc_value`, `newtotal`, `disc_thereornot`, `disc_indiv_total`, `new_modified_total`, `datetimee_new`, `hsn_code`, `taxname2`, `tax2`, `taxname3`, `tax3`, `taxname4`, `tax4`, `taxname5`, `tax5`, `category`, `counterperson_username`, `counterperson_name`, `credit`, `Phone_num`, `barcode_get`, `order_id`, `old_total`, `hsn_code2`, `hsn_code3`, `hsn_code4`, `hsn_code5`, `item_online`, `old_total_indiv`) VALUES (1,'Mens Jacket','1.0','650.00','650.00','Item',NULL,NULL,'no','2.5','SGST(2.5%)','20241206-000011','11:32:09 AM','2024 12 06','admin','1','  General','  Cash','650.00','650.00','12',NULL,NULL,NULL,NULL,'06 Dec 2024','2024120611:32:09','%','0','650.00','no','0.00',NULL,'202412061132','','SGST(2.5%)','2.5',NULL,NULL,NULL,NULL,NULL,NULL,'Mens wear','admin','madmin',NULL,NULL,'',NULL,'619.05','','','','',NULL,'619.05'),(2,'Mens shirt','1.0','400.00','400.00','Item',NULL,NULL,'no','2.5','SGST(2.5%)','20241206-000012','12:26:21 PM','2024 12 06','admin','1','  General','  Cash','2850.00','2850.00','20',NULL,NULL,NULL,NULL,'06 Dec 2024','2024120612:26:21','%','0','400.00','no','0.00',NULL,'202412061226','','SGST(2.5%)','2.5',NULL,NULL,NULL,NULL,NULL,NULL,'Mens wear','admin','madmin',NULL,NULL,'',NULL,'237.50','','','','',NULL,'380.95'),(3,'Mens Tshirt','3.0','300.00','900.00','Item',NULL,NULL,'no','2.5','SGST(2.5%)','20241206-000012','12:26:21 PM','2024 12 06','admin','1','  General','  Cash','2850.00','2850.00','21',NULL,NULL,NULL,NULL,'06 Dec 2024','2024120612:26:21','%','0','900.00','no','0.00',NULL,'202412061226','','SGST(2.5%)','2.5',NULL,NULL,NULL,NULL,NULL,NULL,'Mens wear','admin','madmin',NULL,NULL,'',NULL,'712.50','','','','',NULL,'285.71'),(4,'Leggings','1.0','500','500.00','Item',NULL,NULL,'no','2.5','SGST(2.5%)','20241206-000012','12:26:21 PM','2024 12 06','admin','1','  General','  Cash','2850.00','2850.00','24',NULL,NULL,NULL,NULL,'06 Dec 2024','2024120612:26:21','%','0','307.50','no','0.00',NULL,'202412061226','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Womens wear','admin','madmin',NULL,NULL,NULL,NULL,'237.50','','','','',NULL,'300.00'),(5,'Palazzo','1.0','300','300.00','Item',NULL,NULL,'no','2.5','SGST(2.5%)','20241206-000012','12:26:21 PM','2024 12 06','admin','1','  General','  Cash','2850.00','2850.00','25',NULL,NULL,NULL,NULL,'06 Dec 2024','2024120612:26:21','%','0','615.00','no','0.00',NULL,'202412061226','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Womens wear','admin','madmin',NULL,NULL,NULL,NULL,'237.50','','','','',NULL,'600.00'),(6,'Panties','1.0','250','250.00','Item',NULL,NULL,'no','2.5','SGST(2.5%)','20241206-000012','12:26:21 PM','2024 12 06','admin','1','  General','  Cash','2850.00','2850.00','26',NULL,NULL,NULL,NULL,'06 Dec 2024','2024120612:26:21','%','0','249.38','no','0.00',NULL,'202412061226','','SGST(2.5%)','2.5',NULL,NULL,NULL,NULL,NULL,NULL,'Womens wear','admin','madmin',NULL,NULL,'',NULL,'237.50','','','','',NULL,'237.50'),(7,'Bags','1.0','500','500.00','Item',NULL,NULL,'no','2.5','SGST(2.5%)','20241206-000012','12:26:21 PM','2024 12 06','admin','1','  General','  Cash','2850.00','2850.00','27',NULL,NULL,NULL,NULL,'06 Dec 2024','2024120612:26:21','%','0','498.75','no','0.00',NULL,'202412061226','','SGST(2.5%)','2.5',NULL,NULL,NULL,NULL,NULL,NULL,'Accessories','admin','madmin',NULL,NULL,'',NULL,'237.50','','','','',NULL,'475.00'),(8,'Bags','2.0','500.00','1000.00','Item',NULL,NULL,'no','2.5','SGST(2.5%)','20241206-000013','12:43:59 PM','2024 12 06','admin','1','  General','  Cash','1000.00','1000.00','28',NULL,NULL,NULL,NULL,'06 Dec 2024','2024120612:43:59','%','0','1000.00','no','0.00',NULL,'202412061243','','SGST(2.5%)','2.5',NULL,NULL,NULL,NULL,NULL,NULL,'Accessories','admin','madmin',NULL,NULL,'',NULL,'950.00','','','','',NULL,'475.00'),(9,'Lagging','1.0','200.00','200.00','Item',NULL,NULL,'no','2.5','SGST(2.5%)','20241206-000014','01:40:19 PM','2024 12 06','admin','1','  General','  Cash','1800.00','1800.00','43',NULL,NULL,NULL,NULL,'06 Dec 2024','2024120613:40:19','%','0','200.00','no','0.00',NULL,'202412061340','','SGST(2.5%)','2.5',NULL,NULL,NULL,NULL,NULL,NULL,'Womens wear','admin','madmin',NULL,NULL,'',NULL,'190.48','','','','',NULL,'190.48'),(10,'Janvi Em','1.0','1600.00','1600.00','Item',NULL,NULL,'no','2.5','SGST(2.5%)','20241206-000014','01:40:19 PM','2024 12 06','admin','1','  General','  Cash','1800.00','1800.00','44',NULL,NULL,NULL,NULL,'06 Dec 2024','2024120613:40:19','%','0','1600.00','no','0.00',NULL,'202412061340','','SGST(2.5%)','2.5',NULL,NULL,NULL,NULL,NULL,NULL,'Womens wear','admin','madmin',NULL,NULL,'',NULL,'1523.81','','','','',NULL,'1523.81');
INSERT INTO `billcount` (`_id`, `value`) VALUES (1,'0');
INSERT INTO `billnumber` (`_id`, `billnumber`, `total`, `user`, `date`, `paymentmethod`, `billtype`, `subtotal`, `taxtotal`, `roundoff`, `globaltaxtotal`, `billcount`, `datetimee_new`, `comments_sales`, `delivery_fee`, `packing_charges`, `loyalty_points`, `loyalty_amount`, `order_id`) VALUES (1,'20241206-000011','650.00','admin','2024 12 06','  Cash','  General','650.00','30.95','0.00','0.0','1','202412061132',NULL,NULL,NULL,NULL,NULL,NULL),(2,'20241206-000012','2850.00','admin','2024 12 06','  Cash','  General','2850.00','83.13','0.00','0.0','2','202412061226',NULL,NULL,NULL,NULL,NULL,NULL),(3,'20241206-000013','1000.00','admin','2024 12 06','  Cash','  General','1000.00','47.50','0.00','0.0','3','202412061243',NULL,NULL,NULL,NULL,NULL,NULL),(4,'20241206-000014','1800.00','admin','2024 12 06','  Cash','  General','1800.00','85.71','0.00','0.0','4','202412061340',NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
INSERT INTO `itemdata` (`_id`, `itemname`, `total`) VALUES (1,'Mens Jacket',650),(2,'Janvi Em',1600),(3,'Lagging',200),(4,'Leggings',500),(5,'Mens Jacket',650),(6,'Mens Tshirt',900),(7,'Mens shirt',400),(8,'Palazzo',300),(9,'Panties',250);
INSERT INTO `itemwiseorderlistitems` (`_id`, `itemno`, `itemname`, `sales`, `salespercentage`, `itemtotalquan`, `category`, `i_buying_price`, `mi_buying_price`, `i_cost_value`, `i_cost_percent`, `mi_cost_value`, `mi_cost_percent`, `barcode_value`) VALUES (1,'19','Mens Jacket',650,100,'1','Mens wear',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'45','Janvi Em',1600,25,'1','Womens wear',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'40','Lagging',200,3,'1','Womens wear',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'40','Leggings',500,8,'1','Womens wear',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'40','Mens Jacket',650,10,'1','Mens wear',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'40','Mens Tshirt',900,14,'3','Mens wear',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'40','Mens shirt',400,6,'1','Mens wear',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'40','Palazzo',300,5,'1','Womens wear',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'40','Panties',250,4,'1','Womens wear',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (2,'Mens wear',650),(3,'Mens wear',650),(4,'Mens wear',650),(5,'Accessories',1500),(6,'Mens wear',1950),(7,'Womens wear',2850);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'admin',650);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'madmin',650,100);
