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,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20220101-000011','05:37:54 AM','2022 01 01','admin','1','  General','  Cash','136.00','136.00','1',NULL,NULL,NULL,NULL,'01 Jan 2022','2022010105:37:54','%','0','56.00','no','0.00',NULL,'202201010537','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin',NULL,NULL,'',NULL,'56.00','','','','',NULL,'56.00'),(2,'capsicum green kg','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20220101-000011','05:37:54 AM','2022 01 01','admin','1','  General','  Cash','136.00','136.00','2',NULL,NULL,NULL,NULL,'01 Jan 2022','2022010105:37:54','%','0','80.00','no','0.00',NULL,'202201010537','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(3,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20220101-000012','05:39:31 AM','2022 01 01','admin','1','  General','  Cash','56.00','56.00','3',NULL,NULL,NULL,NULL,'01 Jan 2022','2022010105:39:31','%','0','56.00','no','0.00',NULL,'202201010539','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin',NULL,NULL,'',NULL,'56.00','','','','',NULL,'56.00'),(4,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20260711-000011','12:09:51 PM','2026 07 11','admin','1','  General','  Cash','56.00','56.00','4',NULL,NULL,NULL,NULL,'11 Jul 2026','2026071112:09:51','%','0','56.00','no','0.00',NULL,'202607111209','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin',NULL,NULL,'',NULL,'56.00','','','','',NULL,'56.00'),(5,'fanta','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20260711-000012','12:10:18 PM','2026 07 11','admin','1','  General','  Cash','170.00','170.00','5',NULL,NULL,NULL,NULL,'11 Jul 2026','2026071112:10:18','%','0','20.00','no','0.00',NULL,'202607111210','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'8901764022913',NULL,'20.00','','','','',NULL,'20.00'),(6,'capsicum green kg','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20260711-000012','12:10:18 PM','2026 07 11','admin','1','  General','  Cash','170.00','170.00','6',NULL,NULL,NULL,NULL,'11 Jul 2026','2026071112:10:18','%','0','80.00','no','0.00',NULL,'202607111210','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(7,'carrots kg','1.0','70.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20260711-000012','12:10:18 PM','2026 07 11','admin','1','  General','  Cash','170.00','170.00','7',NULL,NULL,NULL,NULL,'11 Jul 2026','2026071112:10:18','%','0','70.00','no','0.00',NULL,'202607111210','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'70.00','','','','',NULL,'70.00'),(8,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20260711-000013','12:10:36 PM','2026 07 11','admin','1','  General','  Cash','360.00','360.00','8',NULL,NULL,NULL,NULL,'11 Jul 2026','2026071112:10:36','%','0','250.00','no','0.00',NULL,'202607111210','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','admin','madmin',NULL,NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(9,'carrots kg','1.0','70.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20260711-000013','12:10:36 PM','2026 07 11','admin','1','  General','  Cash','360.00','360.00','9',NULL,NULL,NULL,NULL,'11 Jul 2026','2026071112:10:36','%','0','70.00','no','0.00',NULL,'202607111210','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'70.00','','','','',NULL,'70.00'),(10,'fanta','2.0','20.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20260711-000013','12:10:36 PM','2026 07 11','admin','1','  General','  Cash','360.00','360.00','10',NULL,NULL,NULL,NULL,'11 Jul 2026','2026071112:10:36','%','0','40.00','no','0.00',NULL,'202607111210','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'8901764022913',NULL,'40.00','','','','',NULL,'20.00'),(11,'SHIRT','5','450.00','2250.00','Item',NULL,NULL,'no',NULL,NULL,'20260711-000014','03:46:55 PM','2026 07 11','admin','1','  General','  Cash','2250.00','2250.00','11',NULL,NULL,NULL,NULL,'11 Jul 2026','2026071115:46:55','%','0','1350.00','no','0.00',NULL,'202607111546','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHIRT','admin','madmin',NULL,NULL,'',NULL,'2250.00','','','','',NULL,'450.00'),(12,'SHIRT','1.0','450.00','450.00','Item',NULL,NULL,'no',NULL,NULL,'20260711-000015','03:48:35 PM','2026 07 11','admin','1','  General','  Cash','450.00','450.00','12',NULL,NULL,NULL,NULL,'11 Jul 2026','2026071115:48:35','%','0','450.00','no','0.00',NULL,'202607111548','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHIRT','admin','madmin',NULL,NULL,'',NULL,'450.00','','','','',NULL,'450.00'),(13,'SHIRT 2','1.0','450.00','450.00','Item',NULL,NULL,'no',NULL,NULL,'20260711-000016','04:16:45 PM','2026 07 11','admin','1','  General','  Cash','900.00','900.00','14',NULL,NULL,NULL,NULL,'11 Jul 2026','2026071116:16:45','%','0','450.00','no','0.00',NULL,'202607111616','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHIRT','admin','madmin',NULL,NULL,'No.123456',NULL,'450.00','','','','',NULL,'450.00'),(14,'SHIRT','1.0','450.00','450.00','Item',NULL,NULL,'no',NULL,NULL,'20260711-000016','04:16:45 PM','2026 07 11','admin','1','  General','  Cash','900.00','900.00','15',NULL,NULL,NULL,NULL,'11 Jul 2026','2026071116:16:45','%','0','450.00','no','0.00',NULL,'202607111616','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHIRT','admin','madmin',NULL,NULL,'',NULL,'450.00','','','','',NULL,'450.00'),(15,'SHIRT','1.0','450.00','450.00','Item',NULL,NULL,'no',NULL,NULL,'20260711-000017','04:17:08 PM','2026 07 11','admin','1','  General','  Cash','450.00','450.00','16',NULL,NULL,NULL,NULL,'11 Jul 2026','2026071116:17:08','%','0','450.00','no','0.00',NULL,'202607111617','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHIRT','admin','madmin',NULL,NULL,'',NULL,'450.00','','','','',NULL,'450.00'),(16,'SHIRT','1.0','450.00','450.00','Item',NULL,NULL,'no',NULL,NULL,'20260711-000018','04:59:04 PM','2026 07 11','admin','1','  General','  Cash','450.00','450.00','17',NULL,NULL,NULL,NULL,'11 Jul 2026','2026071116:59:04','%','0','450.00','no','0.00',NULL,'202607111659','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHIRT','admin','madmin',NULL,NULL,'',NULL,'450.00','','','','',NULL,'450.00'),(17,'SHIRT','1.0','450.00','450.00','Item',NULL,NULL,'no',NULL,NULL,'20260711-000019','04:59:48 PM','2026 07 11','admin','1','  General','  Cash','450.00','450.00','18',NULL,NULL,NULL,NULL,'11 Jul 2026','2026071116:59:48','%','0','450.00','no','0.00',NULL,'202607111659','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHIRT','admin','madmin',NULL,NULL,'',NULL,'450.00','','','','',NULL,'450.00'),(18,'SHIRT','4.0','450.00','1800.00','Item',NULL,NULL,'no',NULL,NULL,'20260711-0000110','05:09:20 PM','2026 07 11','admin','1','  General','  Cash','1800.00','1800.00','19',NULL,NULL,NULL,NULL,'11 Jul 2026','2026071117:09:20','%','0','1800.00','no','0.00',NULL,'202607111709','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHIRT','admin','madmin',NULL,NULL,'',NULL,'1800.00','','','','',NULL,'450.00'),(19,'SHIRT','1.0','450.00','450.00','Item',NULL,NULL,'no',NULL,NULL,'20260711-0000111','05:15:16 PM','2026 07 11','admin','1','  General','  Cash','450.00','450.00','21',NULL,NULL,NULL,NULL,'11 Jul 2026','2026071117:15:16','%','0','450.00','no','0.00',NULL,'202607111715','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHIRT','admin','madmin',NULL,NULL,'',NULL,'450.00','','','','',NULL,'450.00'),(20,'SHIRT','6.0','450.00','2700.00','Item',NULL,NULL,'no',NULL,NULL,'20260711-0000112','11:35:18 PM','2026 07 11','admin','1','  General','  Cash','2700.00','2700.00','22',NULL,NULL,NULL,NULL,'11 Jul 2026','2026071123:35:18','%','0','2700.00','no','0.00',NULL,'202607112335','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHIRT','admin','madmin',NULL,NULL,'',NULL,'2700.00','','','','',NULL,'450.00'),(21,'SHIRT','1.0','450.00','450.00','Item',NULL,NULL,'no',NULL,NULL,'20260711-0000113','11:35:49 PM','2026 07 11','admin','1','  General','  Cash','450.00','450.00','23',NULL,NULL,NULL,NULL,'11 Jul 2026','2026071123:35:49','%','0','450.00','no','0.00',NULL,'202607112335','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHIRT','admin','madmin',NULL,NULL,'',NULL,'450.00','','','','',NULL,'450.00'),(22,'SHIRT 2','1.0','450.00','450.00','Item',NULL,NULL,'no',NULL,NULL,'20260712-000011','12:00:54 AM','2026 07 12','admin','1','  General','  Cash','450.00','450.00','24',NULL,NULL,NULL,NULL,'12 Jul 2026','2026071200:00:54','%','0','450.00','no','0.00',NULL,'202607120000','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHIRT','admin','madmin',NULL,NULL,'No.123456',NULL,'450.00','','','','',NULL,'450.00'),(23,'dothi','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20260712-000012','12:02:52 AM','2026 07 12','admin','1','  General','  Cash','250.00','250.00','25',NULL,NULL,NULL,NULL,'12 Jul 2026','2026071200:02:52','%','0','250.00','no','0.00',NULL,'202607120002','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(24,'SHIRT','1.0','450.00','450.00','Item',NULL,NULL,'no',NULL,NULL,'20260712-000013','12:07:17 AM','2026 07 12','admin','1','  General','  Cash','450.00','450.00','26',NULL,NULL,NULL,NULL,'12 Jul 2026','2026071200:07:17','%','0','450.00','no','0.00',NULL,'202607120007','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHIRT','admin','madmin',NULL,NULL,'',NULL,'450.00','','','','',NULL,'450.00'),(25,'SHIRT','1.0','450.00','450.00','Item',NULL,NULL,'no',NULL,NULL,'20260712-000014','12:07:33 AM','2026 07 12','admin','1','  General','  Cash','450.00','450.00','27',NULL,NULL,NULL,NULL,'12 Jul 2026','2026071200:07:33','%','0','450.00','no','0.00',NULL,'202607120007','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHIRT','admin','madmin',NULL,NULL,'',NULL,'450.00','','','','',NULL,'450.00'),(26,'SHIRT','4.0','450.00','1800.00','Item',NULL,NULL,'no',NULL,NULL,'20260712-000015','08:02:30 AM','2026 07 12','admin','1','  General','  Cash','1800.00','1800.00','28',NULL,NULL,NULL,NULL,'12 Jul 2026','2026071208:02:30','%','0','1800.00','no','0.00',NULL,'202607120802','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHIRT','admin','madmin',NULL,NULL,'',NULL,'1800.00','','','','',NULL,'450.00'),(27,'dothi','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20260712-000016','08:05:03 AM','2026 07 12','user1','1','  General','  Cash','250.00','250.00','29',NULL,NULL,NULL,NULL,'12 Jul 2026','2026071208:05:03','%','0','250.00','no','0.00',NULL,'202607120805','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(28,'dothi','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20260712-000017','08:05:49 AM','2026 07 12','admin','1','  General','  Cash','250.00','250.00','30',NULL,NULL,NULL,NULL,'12 Jul 2026','2026071208:05:49','%','0','750.00','no','0.00',NULL,'202607120805','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(29,'SHIRT','1.0','450.00','450.00','Item',NULL,NULL,'no',NULL,NULL,'20260712-000018','08:10:59 AM','2026 07 12','admin','1','  General','  Cash','450.00','450.00','31',NULL,NULL,NULL,NULL,'12 Jul 2026','2026071208:10:59','%','0','450.00','no','0.00',NULL,'202607120810','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHIRT','admin','madmin',NULL,NULL,'',NULL,'450.00','','','','',NULL,'450.00'),(30,'SHIRT','1.0','450.00','450.00','Item',NULL,NULL,'no',NULL,NULL,'20260712-000019','08:44:30 AM','2026 07 12','admin','1','  General','  Cash','450.00','450.00','32',NULL,NULL,NULL,NULL,'12 Jul 2026','2026071208:44:30','%','0','450.00','no','0.00',NULL,'202607120844','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHIRT','admin','madmin',NULL,NULL,'',NULL,'450.00','','','','',NULL,'450.00'),(31,'SHIRT','1.0','450.00','450.00','Item',NULL,NULL,'no',NULL,NULL,'20260712-0000110','08:45:22 AM','2026 07 12','admin','1','  General','  Cash','450.00','450.00','33',NULL,NULL,NULL,NULL,'12 Jul 2026','2026071208:45:22','%','0','450.00','no','0.00',NULL,'202607120845','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHIRT','admin','madmin',NULL,NULL,'',NULL,'450.00','','','','',NULL,'450.00'),(32,'SHIRT','2.0','450.00','900.00','Item',NULL,NULL,'no',NULL,NULL,'20260712-0000111','08:46:52 AM','2026 07 12','admin','1','  General','  Cash','900.00','900.00','34',NULL,NULL,NULL,NULL,'12 Jul 2026','2026071208:46:52','%','0','900.00','no','0.00',NULL,'202607120846','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHIRT','admin','madmin',NULL,NULL,'',NULL,'900.00','','','','',NULL,'450.00'),(33,'SHIRT','1.0','450.00','450.00','Item',NULL,NULL,'no',NULL,NULL,'20260712-0000112','08:47:12 AM','2026 07 12','admin','1','  General','  Cash','450.00','450.00','35',NULL,NULL,NULL,NULL,'12 Jul 2026','2026071208:47:12','%','0','450.00','no','0.00',NULL,'202607120847','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHIRT','admin','madmin',NULL,NULL,'',NULL,'450.00','','','','',NULL,'450.00'),(34,'SHIRT','1.0','450.00','450.00','Item',NULL,NULL,'no',NULL,NULL,'20260713-000011','11:13:14 AM','2026 07 13','admin','1','  General','  Cash','450.00','450.00','36',NULL,NULL,NULL,NULL,'13 Jul 2026','2026071311:13:14','%','0','450.00','no','0.00',NULL,'202607131113','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHIRT','admin','madmin',NULL,NULL,'',NULL,'450.00','','','','',NULL,'450.00'),(35,'SHIRT','1.0','450.00','450.00','Item',NULL,NULL,'no',NULL,NULL,'20260713-000012','11:31:39 AM','2026 07 13','admin','1','  General','  Cash','450.00','450.00','37',NULL,NULL,NULL,NULL,'13 Jul 2026','2026071311:31:39','%','0','450.00','no','0.00',NULL,'202607131131','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHIRT','admin','madmin',NULL,NULL,'',NULL,'450.00','','','','',NULL,'450.00'),(36,'SHIRT','2.0','450.00','900.00','Item',NULL,NULL,'no',NULL,NULL,'20260713-000013','11:32:41 AM','2026 07 13','admin','1','  General','  Cash','900.00','900.00','38',NULL,NULL,NULL,NULL,'13 Jul 2026','2026071311:32:41','%','0','900.00','no','0.00',NULL,'202607131132','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHIRT','admin','madmin',NULL,NULL,'',NULL,'900.00','','','','',NULL,'450.00'),(37,'SHIRT','1.0','450.00','450.00','Item',NULL,NULL,'no',NULL,NULL,'20260713-000014','11:33:02 AM','2026 07 13','admin','1','  General','  Cash','450.00','450.00','39',NULL,NULL,NULL,NULL,'13 Jul 2026','2026071311:33:02','%','0','450.00','no','0.00',NULL,'202607131133','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHIRT','admin','madmin',NULL,NULL,'',NULL,'450.00','','','','',NULL,'450.00'),(38,'SHIRT 2','3.0','450.00','1350.00','Item',NULL,NULL,'no',NULL,NULL,'20260713-000015','11:42:58 AM','2026 07 13','admin','1','  General','  Cash','2700.00','2700.00','40',NULL,NULL,NULL,NULL,'13 Jul 2026','2026071311:42:58','%','0','1350.00','no','0.00',NULL,'202607131142','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHIRT','admin','madmin',NULL,NULL,'No.123456',NULL,'1350.00','','','','',NULL,'450.00'),(39,'SHIRT','3.0','450.00','1350.00','Item',NULL,NULL,'no',NULL,NULL,'20260713-000015','11:42:58 AM','2026 07 13','admin','1','  General','  Cash','2700.00','2700.00','41',NULL,NULL,NULL,NULL,'13 Jul 2026','2026071311:42:58','%','0','1350.00','no','0.00',NULL,'202607131142','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHIRT','admin','madmin',NULL,NULL,'',NULL,'1350.00','','','','',NULL,'450.00'),(40,'SHIRT','1.0','450.00','450.00','Item',NULL,NULL,'no',NULL,NULL,'20260713-000016','11:44:07 AM','2026 07 13','admin','1','  General','  Cash','450.00','450.00','42',NULL,NULL,NULL,NULL,'13 Jul 2026','2026071311:44:07','%','0','450.00','no','0.00',NULL,'202607131144','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHIRT','admin','madmin',NULL,NULL,'',NULL,'450.00','','','','',NULL,'450.00'),(41,'SHIRT','1.0','450.00','450.00','Item',NULL,NULL,'no',NULL,NULL,'20260713-000017','11:44:40 AM','2026 07 13','admin','1','  General','  Card','450.00','450.00','43',NULL,NULL,NULL,NULL,'13 Jul 2026','2026071311:44:40','%','0','450.00','no','0.00',NULL,'202607131144','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHIRT','admin','madmin','0',NULL,'',NULL,'450.00','','','','',NULL,'450.00'),(42,'t shart','1.0','500.00','500.00','Item',NULL,NULL,'no',NULL,NULL,'20260713-000018','11:47:56 AM','2026 07 13','admin','1','  General','  Cash','250.00','250.00','44',NULL,NULL,NULL,NULL,'13 Jul 2026','2026071311:47:56','%','50','250.00','yes','250.00',NULL,'202607131147','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'No.123457',NULL,'500.00','','','','',NULL,'500.00'),(43,'t shart','8.0','500.00','4000.00','Item',NULL,NULL,'no',NULL,NULL,'20260713-000019','11:50:07 AM','2026 07 13','admin','1','  General','  Cash','2000.00','2000.00','45',NULL,NULL,NULL,NULL,'13 Jul 2026','2026071311:50:07','%','50','2000.00','yes','2000.00',NULL,'202607131150','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'No.123457',NULL,'4000.00','','','','',NULL,'500.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`, `transaction_id`, `transaction_id_org`, `source`, `source1`) VALUES (1,'20220101-000011','136.00','admin','2022 01 01','  Cash','  General','136.00','0.00','0.00','0.0','1','202201010537',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(2,'20220101-000012','56.00','admin','2022 01 01','  Cash','  General','56.00','0.00','0.00','0.0','2','202201010539',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(3,'20260711-000011','56.00','admin','2026 07 11','  Cash','  General','56.00','0.00','0.00','0.0','3','202607111209',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(4,'20260711-000012','170.00','admin','2026 07 11','  Cash','  General','170.00','0.00','0.00','0.0','4','202607111210',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(5,'20260711-000013','360.00','admin','2026 07 11','  Cash','  General','360.00','0.00','0.00','0.0','5','202607111210',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(6,'20260711-000014','2250.00','admin','2026 07 11','  Cash','  General','2250.00','0.00','0.00','0.0','6','202607111546',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(7,'20260711-000015','450.00','admin','2026 07 11','  Cash','  General','450.00','0.00','0.00','0.0','7','202607111548',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(8,'20260711-000016','900.00','admin','2026 07 11','  Cash','  General','900.00','0.00','0.00','0.0','8','202607111616',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(9,'20260711-000017','450.00','admin','2026 07 11','  Cash','  General','450.00','0.00','0.00','0.0','9','202607111617',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(10,'20260711-000018','450.00','admin','2026 07 11','  Cash','  General','450.00','0.00','0.00','0.0','10','202607111659',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(11,'20260711-000019','450.00','admin','2026 07 11','  Cash','  General','450.00','0.00','0.00','0.0','11','202607111659',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(12,'20260711-0000110','1800.00','admin','2026 07 11','  Cash','  General','1800.00','0.00','0.00','0.0','12','202607111709',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(13,'20260711-0000111','450.00','admin','2026 07 11','  Cash','  General','450.00','0.00','0.00','0.0','13','202607111715',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(14,'20260711-0000112','2700.00','admin','2026 07 11','  Cash','  General','2700.00','0.00','0.00','0.0','14','202607112335',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(15,'20260711-0000113','450.00','admin','2026 07 11','  Cash','  General','450.00','0.00','0.00','0.0','15','202607112335',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(16,'20260712-000011','450.00','admin','2026 07 12','  Cash','  General','450.00','0.00','0.00','0.0','16','202607120000',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(17,'20260712-000012','250.00','admin','2026 07 12','  Cash','  General','250.00','0.00','0.00','0.0','17','202607120002',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(18,'20260712-000013','450.00','admin','2026 07 12','  Cash','  General','450.00','0.00','0.00','0.0','18','202607120007',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(19,'20260712-000014','450.00','admin','2026 07 12','  Cash','  General','450.00','0.00','0.00','0.0','19','202607120007',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(20,'20260712-000015','1800.00','admin','2026 07 12','  Cash','  General','1800.00','0.00','0.00','0.0','20','202607120802',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(21,'20260712-000016','250.00','user1','2026 07 12','  Cash','  General','250.00','0.00','0.00','0.0','21','202607120805',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(22,'20260712-000017','250.00','admin','2026 07 12','  Cash','  General','250.00','0.00','0.00','0.0','22','202607120805',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(23,'20260712-000018','450.00','admin','2026 07 12','  Cash','  General','450.00','0.00','0.00','0.0','23','202607120810',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(24,'20260712-000019','450.00','admin','2026 07 12','  Cash','  General','450.00','0.00','0.00','0.0','24','202607120844',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(25,'20260712-0000110','450.00','admin','2026 07 12','  Cash','  General','450.00','0.00','0.00','0.0','25','202607120845',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(26,'20260712-0000111','900.00','admin','2026 07 12','  Cash','  General','900.00','0.00','0.00','0.0','26','202607120846',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(27,'20260712-0000112','450.00','admin','2026 07 12','  Cash','  General','450.00','0.00','0.00','0.0','27','202607120847',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(28,'20260713-000011','450.00','admin','2026 07 13','  Cash','  General','450.00','0.00','0.00','0.0','28','202607131113',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(29,'20260713-000012','450.00','admin','2026 07 13','  Cash','  General','450.00','0.00','0.00','0.0','29','202607131131',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(30,'20260713-000013','900.00','admin','2026 07 13','  Cash','  General','900.00','0.00','0.00','0.0','30','202607131132',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(31,'20260713-000014','450.00','admin','2026 07 13','  Cash','  General','450.00','0.00','0.00','0.0','31','202607131133',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(32,'20260713-000015','2700.00','admin','2026 07 13','  Cash','  General','2700.00','0.00','0.00','0.0','32','202607131142',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(33,'20260713-000016','450.00','admin','2026 07 13','  Cash','  General','450.00','0.00','0.00','0.0','33','202607131144',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(34,'20260713-000017','450.00','admin','2026 07 13','  Card','  General','450.00','0.00','0.00','0.0','34','202607131144',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(35,'20260713-000018','250.00','admin','2026 07 13','  Cash','  General','250.00','0.00','0.00','0.0','35','202607131147',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(36,'20260713-000019','2000.00','admin','2026 07 13','  Cash','  General','2000.00','0.00','0.00','0.0','36','202607131150',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,'');
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
