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,'carrots kg','1.0','70.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20240730-000011','05:44:07 AM','2024 07 30','admin','1','  General','  Cash','1551.00','1551.00','1',NULL,NULL,NULL,NULL,'30 Jul 2024','2024073005:44:07','%','0','70.00','no','0.00',NULL,'202407300544','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'70.00','','','','',NULL,'70.00'),(2,'cauliflower kg','1.0','45.00','45.00','Item',NULL,NULL,'no',NULL,NULL,'20240730-000011','05:44:07 AM','2024 07 30','admin','1','  General','  Cash','1551.00','1551.00','2',NULL,NULL,NULL,NULL,'30 Jul 2024','2024073005:44:07','%','0','45.00','no','0.00',NULL,'202407300544','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'45.00','','','','',NULL,'45.00'),(3,'cucumbers kg','2.0','20.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20240730-000011','05:44:07 AM','2024 07 30','admin','1','  General','  Cash','1551.00','1551.00','3',NULL,NULL,NULL,NULL,'30 Jul 2024','2024073005:44:07','%','0','40.00','no','0.00',NULL,'202407300544','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'20.00'),(4,'capsicum green kg','2.0','80.00','160.00','Item',NULL,NULL,'no',NULL,NULL,'20240730-000011','05:44:07 AM','2024 07 30','admin','1','  General','  Cash','1551.00','1551.00','4',NULL,NULL,NULL,NULL,'30 Jul 2024','2024073005:44:07','%','0','160.00','no','0.00',NULL,'202407300544','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'160.00','','','','',NULL,'80.00'),(5,'loreal color 90gms','2.0','76.00','152.00','Item',NULL,NULL,'no',NULL,NULL,'20240730-000011','05:44:07 AM','2024 07 30','admin','1','  General','  Cash','1551.00','1551.00','5',NULL,NULL,NULL,NULL,'30 Jul 2024','2024073005:44:07','%','0','152.00','no','0.00',NULL,'202407300544','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'personal care','admin','madmin',NULL,NULL,'',NULL,'152.00','','','','',NULL,'76.00'),(6,'fig fruit kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240730-000011','05:44:07 AM','2024 07 30','admin','1','  General','  Cash','1551.00','1551.00','6',NULL,NULL,NULL,NULL,'30 Jul 2024','2024073005:44:07','%','0','250.00','no','0.00',NULL,'202407300544','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(7,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20240730-000011','05:44:07 AM','2024 07 30','admin','1','  General','  Cash','1551.00','1551.00','7',NULL,NULL,NULL,NULL,'30 Jul 2024','2024073005:44:07','%','0','56.00','no','0.00',NULL,'202407300544','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin',NULL,NULL,'',NULL,'56.00','','','','',NULL,'56.00'),(8,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240730-000011','05:44:07 AM','2024 07 30','admin','1','  General','  Cash','1551.00','1551.00','8',NULL,NULL,NULL,NULL,'30 Jul 2024','2024073005:44:07','%','0','250.00','no','0.00',NULL,'202407300544','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','admin','madmin',NULL,NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(9,'sweet corn piece','1.0','15.00','15.00','Item',NULL,NULL,'no',NULL,NULL,'20240730-000011','05:44:07 AM','2024 07 30','admin','1','  General','  Cash','1551.00','1551.00','9',NULL,NULL,NULL,NULL,'30 Jul 2024','2024073005:44:07','%','0','15.00','no','0.00',NULL,'202407300544','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'15.00','','','','',NULL,'15.00'),(10,'apples kg','1.0','202.00','202.00','Item',NULL,NULL,'no',NULL,NULL,'20240730-000011','05:44:07 AM','2024 07 30','admin','1','  General','  Cash','1551.00','1551.00','10',NULL,NULL,NULL,NULL,'30 Jul 2024','2024073005:44:07','%','0','202.00','no','0.00',NULL,'202407300544','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'202.00','','','','',NULL,'202.00'),(11,'tomatoes kg','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20240730-000011','05:44:07 AM','2024 07 30','admin','1','  General','  Cash','1551.00','1551.00','11',NULL,NULL,NULL,NULL,'30 Jul 2024','2024073005:44:07','%','0','25.00','no','0.00',NULL,'202407300544','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00'),(12,'akar salt crystal 1kg','1.0','17.00','17.00','Item',NULL,NULL,'no',NULL,NULL,'20240730-000011','05:44:07 AM','2024 07 30','admin','1','  General','  Cash','1551.00','1551.00','12',NULL,NULL,NULL,NULL,'30 Jul 2024','2024073005:44:07','%','0','17.00','no','0.00',NULL,'202407300544','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'salt and sugar','admin','madmin',NULL,NULL,'',NULL,'17.00','','','','',NULL,'17.00'),(13,'tata tea premium 100gm','1.0','34.00','34.00','Item',NULL,NULL,'no',NULL,NULL,'20240730-000011','05:44:07 AM','2024 07 30','admin','1','  General','  Cash','1551.00','1551.00','13',NULL,NULL,NULL,NULL,'30 Jul 2024','2024073005:44:07','%','0','34.00','no','0.00',NULL,'202407300544','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'beverages','admin','madmin',NULL,NULL,'',NULL,'34.00','','','','',NULL,'34.00'),(14,'surfexcel blue 70gm','1.0','76.00','76.00','Item',NULL,NULL,'no',NULL,NULL,'20240730-000011','05:44:07 AM','2024 07 30','admin','1','  General','  Cash','1551.00','1551.00','14',NULL,NULL,NULL,NULL,'30 Jul 2024','2024073005:44:07','%','0','76.00','no','0.00',NULL,'202407300544','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','admin','madmin',NULL,NULL,'',NULL,'76.00','','','','',NULL,'76.00'),(15,'rin 500gm','1.0','37.00','37.00','Item',NULL,NULL,'no',NULL,NULL,'20240730-000011','05:44:07 AM','2024 07 30','admin','1','  General','  Cash','1551.00','1551.00','15',NULL,NULL,NULL,NULL,'30 Jul 2024','2024073005:44:07','%','0','37.00','no','0.00',NULL,'202407300544','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','admin','madmin',NULL,NULL,'',NULL,'37.00','','','','',NULL,'37.00'),(16,'tata tea fusion assan tea  and  kenyan tea 250gm','1.0','122.00','122.00','Item',NULL,NULL,'no',NULL,NULL,'20240730-000011','05:44:07 AM','2024 07 30','admin','1','  General','  Cash','1551.00','1551.00','16',NULL,NULL,NULL,NULL,'30 Jul 2024','2024073005:44:07','%','0','122.00','no','0.00',NULL,'202407300544','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'beverages','admin','madmin',NULL,NULL,'',NULL,'122.00','','','','',NULL,'122.00'),(17,'rin powder500gm','1.0','36.00','36.00','Item',NULL,NULL,'no',NULL,NULL,'20240730-000031','05:44:43 AM','2024 07 30','admin','3','  General','  Cash','1739.00','1739.00','1',NULL,NULL,NULL,NULL,'30 Jul 2024','2024073005:44:43','%','0','36.00','no','0.00',NULL,'202407300544','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','admin','madmin',NULL,NULL,'',NULL,'36.00','','','','',NULL,'36.00'),(18,'ghari detergent powder 1kg','1.0','47.00','47.00','Item',NULL,NULL,'no',NULL,NULL,'20240730-000031','05:44:43 AM','2024 07 30','admin','3','  General','  Cash','1739.00','1739.00','2',NULL,NULL,NULL,NULL,'30 Jul 2024','2024073005:44:43','%','0','47.00','no','0.00',NULL,'202407300544','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','admin','madmin',NULL,NULL,'',NULL,'47.00','','','','',NULL,'47.00'),(19,'surf excel 2kg','1.0','432.00','432.00','Item',NULL,NULL,'no',NULL,NULL,'20240730-000031','05:44:43 AM','2024 07 30','admin','3','  General','  Cash','1739.00','1739.00','3',NULL,NULL,NULL,NULL,'30 Jul 2024','2024073005:44:43','%','0','432.00','no','0.00',NULL,'202407300544','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','admin','madmin',NULL,NULL,'',NULL,'432.00','','','','',NULL,'432.00'),(20,'surfexcel blue 70gm','1.0','76.00','76.00','Item',NULL,NULL,'no',NULL,NULL,'20240730-000031','05:44:43 AM','2024 07 30','admin','3','  General','  Cash','1739.00','1739.00','4',NULL,NULL,NULL,NULL,'30 Jul 2024','2024073005:44:43','%','0','76.00','no','0.00',NULL,'202407300544','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','admin','madmin',NULL,NULL,'',NULL,'76.00','','','','',NULL,'76.00'),(21,'rin powder 4kg','1.0','274.00','274.00','Item',NULL,NULL,'no',NULL,NULL,'20240730-000031','05:44:43 AM','2024 07 30','admin','3','  General','  Cash','1739.00','1739.00','5',NULL,NULL,NULL,NULL,'30 Jul 2024','2024073005:44:43','%','0','274.00','no','0.00',NULL,'202407300544','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','admin','madmin',NULL,NULL,'',NULL,'274.00','','','','',NULL,'274.00'),(22,'robin powder blue 200gm','1.0','46.00','46.00','Item',NULL,NULL,'no',NULL,NULL,'20240730-000031','05:44:43 AM','2024 07 30','admin','3','  General','  Cash','1739.00','1739.00','6',NULL,NULL,NULL,NULL,'30 Jul 2024','2024073005:44:43','%','0','46.00','no','0.00',NULL,'202407300544','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','admin','madmin',NULL,NULL,'',NULL,'46.00','','','','',NULL,'46.00'),(23,'ezee liqud 200gm','1.0','44.00','44.00','Item',NULL,NULL,'no',NULL,NULL,'20240730-000031','05:44:43 AM','2024 07 30','admin','3','  General','  Cash','1739.00','1739.00','7',NULL,NULL,NULL,NULL,'30 Jul 2024','2024073005:44:43','%','0','44.00','no','0.00',NULL,'202407300544','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','admin','madmin',NULL,NULL,'',NULL,'44.00','','','','',NULL,'44.00'),(24,'ujala fabric 75ml','1.0','17.00','17.00','Item',NULL,NULL,'no',NULL,NULL,'20240730-000031','05:44:43 AM','2024 07 30','admin','3','  General','  Cash','1739.00','1739.00','8',NULL,NULL,NULL,NULL,'30 Jul 2024','2024073005:44:43','%','0','17.00','no','0.00',NULL,'202407300544','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','admin','madmin',NULL,NULL,'',NULL,'17.00','','','','',NULL,'17.00'),(25,'rin white 500gm','1.0','36.00','36.00','Item',NULL,NULL,'no',NULL,NULL,'20240730-000031','05:44:43 AM','2024 07 30','admin','3','  General','  Cash','1739.00','1739.00','9',NULL,NULL,NULL,NULL,'30 Jul 2024','2024073005:44:43','%','0','36.00','no','0.00',NULL,'202407300544','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','admin','madmin',NULL,NULL,'',NULL,'36.00','','','','',NULL,'36.00'),(26,'roohafza 750ml','1.0','119.00','119.00','Item',NULL,NULL,'no',NULL,NULL,'20240730-000031','05:44:43 AM','2024 07 30','admin','3','  General','  Cash','1739.00','1739.00','10',NULL,NULL,NULL,NULL,'30 Jul 2024','2024073005:44:43','%','0','119.00','no','0.00',NULL,'202407300544','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'beverages','admin','madmin',NULL,NULL,'',NULL,'119.00','','','','',NULL,'119.00'),(27,'gatorade sports drink 500ml','1.0','38.00','38.00','Item',NULL,NULL,'no',NULL,NULL,'20240730-000031','05:44:43 AM','2024 07 30','admin','3','  General','  Cash','1739.00','1739.00','11',NULL,NULL,NULL,NULL,'30 Jul 2024','2024073005:44:43','%','0','38.00','no','0.00',NULL,'202407300544','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'beverages','admin','madmin',NULL,NULL,'',NULL,'38.00','','','','',NULL,'38.00'),(28,'coca cola 600ml','1.0','33.00','33.00','Item',NULL,NULL,'no',NULL,NULL,'20240730-000031','05:44:43 AM','2024 07 30','admin','3','  General','  Cash','1739.00','1739.00','12',NULL,NULL,NULL,NULL,'30 Jul 2024','2024073005:44:43','%','0','33.00','no','0.00',NULL,'202407300544','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'beverages','admin','madmin',NULL,NULL,'',NULL,'33.00','','','','',NULL,'33.00'),(29,'mtr badam drink 200gm','1.0','93.00','93.00','Item',NULL,NULL,'no',NULL,NULL,'20240730-000031','05:44:43 AM','2024 07 30','admin','3','  General','  Cash','1739.00','1739.00','13',NULL,NULL,NULL,NULL,'30 Jul 2024','2024073005:44:43','%','0','93.00','no','0.00',NULL,'202407300544','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'beverages','admin','madmin',NULL,NULL,'',NULL,'93.00','','','','',NULL,'93.00'),(30,'limca 1.25ltr','1.0','52.00','52.00','Item',NULL,NULL,'no',NULL,NULL,'20240730-000031','05:44:43 AM','2024 07 30','admin','3','  General','  Cash','1739.00','1739.00','14',NULL,NULL,NULL,NULL,'30 Jul 2024','2024073005:44:43','%','0','52.00','no','0.00',NULL,'202407300544','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'beverages','admin','madmin',NULL,NULL,'',NULL,'52.00','','','','',NULL,'52.00'),(31,'fanta 1.25ltr','1.0','52.00','52.00','Item',NULL,NULL,'no',NULL,NULL,'20240730-000031','05:44:43 AM','2024 07 30','admin','3','  General','  Cash','1739.00','1739.00','15',NULL,NULL,NULL,NULL,'30 Jul 2024','2024073005:44:43','%','0','52.00','no','0.00',NULL,'202407300544','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'beverages','admin','madmin',NULL,NULL,'',NULL,'52.00','','','','',NULL,'52.00'),(32,'thumbs up 1.25ltr','1.0','52.00','52.00','Item',NULL,NULL,'no',NULL,NULL,'20240730-000031','05:44:43 AM','2024 07 30','admin','3','  General','  Cash','1739.00','1739.00','16',NULL,NULL,NULL,NULL,'30 Jul 2024','2024073005:44:43','%','0','52.00','no','0.00',NULL,'202407300544','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'beverages','admin','madmin',NULL,NULL,'',NULL,'52.00','','','','',NULL,'52.00'),(33,'real fruit promegrante 1itr','1.0','104.00','104.00','Item',NULL,NULL,'no',NULL,NULL,'20240730-000031','05:44:43 AM','2024 07 30','admin','3','  General','  Cash','1739.00','1739.00','17',NULL,NULL,NULL,NULL,'30 Jul 2024','2024073005:44:43','%','0','104.00','no','0.00',NULL,'202407300544','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'beverages','admin','madmin',NULL,NULL,'',NULL,'104.00','','','','',NULL,'104.00'),(34,'tropicana mixed fruit 1ltr','1.0','94.00','94.00','Item',NULL,NULL,'no',NULL,NULL,'20240730-000031','05:44:43 AM','2024 07 30','admin','3','  General','  Cash','1739.00','1739.00','18',NULL,NULL,NULL,NULL,'30 Jul 2024','2024073005:44:43','%','0','94.00','no','0.00',NULL,'202407300544','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'beverages','admin','madmin',NULL,NULL,'',NULL,'94.00','','','','',NULL,'94.00'),(35,'real active apple 1ltr','1.0','94.00','94.00','Item',NULL,NULL,'no',NULL,NULL,'20240730-000031','05:44:43 AM','2024 07 30','admin','3','  General','  Cash','1739.00','1739.00','19',NULL,NULL,NULL,NULL,'30 Jul 2024','2024073005:44:43','%','0','94.00','no','0.00',NULL,'202407300544','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'beverages','admin','madmin',NULL,NULL,'',NULL,'94.00','','','','',NULL,'94.00');
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,'20240730-000011','1551.00','admin','2024 07 30','  Cash','  General','1551.00','0.00','0.00','0.0','1','202407300544',NULL,NULL,NULL,NULL,NULL,NULL),(2,'20240730-000031','1739.00','admin','2024 07 30','  Cash','  General','1739.00','0.00','0.00','0.0','2','202407300544',NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
INSERT INTO `expenses_sales` (`_id`, `expensename`, `price`, `category`, `counterperson_username`, `counterperson_name`, `date`, `time`, `datetimee_new`) VALUES (1,'Todd','80','Rent','madmin','madmin','30 jul. 2024','05:45 AM','202430'),(2,'Raby','30','Transportation','madmin','madmin','30 jul. 2024','05:45 AM','202430');
