ÿØÿà JFIF    ÿÛ „  ( %"1!%)+...383,7(-.+  -+++--++++---+-+-----+---------------+---+-++7-----ÿÀ  ß â" ÿÄ     ÿÄ H    !1AQaq"‘¡2B±ÁÑð#R“Ò Tbr‚²á3csƒ’ÂñDS¢³$CÿÄ   ÿÄ %  !1AQa"23‘ÿÚ   ? ôÿ ¨pŸªáÿ —åYõõ\?àÒü©ŠÄï¨pŸªáÿ —åYõõ\?àÓü©ŠÄá 0Ÿªáÿ Ÿå[úƒ ú®ði~TÁbqÐ8OÕpÿ ƒOò¤Oè`–RÂáœá™êi€ßÉ< FtŸI“öÌ8úDf´°å}“¾œ6  öFá°y¥jñÇh†ˆ¢ã/ÃÐ:ªcÈ "Y¡ðÑl>ÿ ”ÏËte:qž\oäŠe÷󲍷˜HT4&ÿ ÓÐü6ö®¿øþßèô Ÿ•7Ñi’•j|“ñì>b…þS?*Óôÿ ÓÐü*h¥£ír¶ü UãSç‚Ÿ[AÐaè[ûª•õ&õj?†Éö+EzP—WeÒírJFt ‘BŒ†Ï‡%#tE Øz ¥OÛ«!1›üä±Í™%ºÍãö]°î(–:@<‹ŒÊö×òÆt¦ãº+‡¦%ÌÁ²h´OƒJŒtMÜ>ÀÜÊw3Y´•牋4ǍýʏTì>œú=Íwhyë,¾Ôò×õ¿ßÊa»«þˆѪQ|%6ž™A õ%:øj<>É—ÿ Å_ˆCbõ¥š±ý¯Ýƒï…¶|RëócÍf溪“t.СøTÿ *Ä¿-{†çàczůŽ_–^XþŒ±miB[X±d 1,é”zEù»& î9gœf™9Ð'.;—™i}!ôšåîqêÛ٤ёý£½ÆA–àôe"A$˝Úsäÿ ÷Û #°xŸëí(l »ý3—¥5m! rt`†0~'j2(]S¦¦kv,ÚÇ l¦øJA£Šƒ J3E8ÙiŽ:cÉžúeZ°€¯\®kÖ(79«Ž:¯X”¾³Š&¡* ….‰Ž(ÜíŸ2¥ª‡×Hi²TF¤ò[¨íÈRëÉ䢍mgÑ.Ÿ<öäS0í„ǹÁU´f#Vß;Õ–…P@3ío<ä-±»Ž.L|kªÀê›fÂ6@»eu‚|ÓaÞÆŸ…¨ááå>åŠ?cKü6ùTÍÆ”†sĤÚ;H2RÚ†õ\Ö·Ÿn'¾ ñ#ºI¤Å´%çÁ­‚â7›‹qT3Iï¨ÖÚ5I7Ë!ÅOóŸ¶øÝñØôת¦$Tcö‘[«Ö³šÒ';Aþ ¸èíg A2Z"i¸vdÄ÷.iõ®§)¿]¤À†–‡É&ä{V¶iŽ”.Ó×Õÿ û?h¬Mt–íª[ÿ Ñÿ ÌV(í}=ibÔ¡›¥¢±b Lô¥‡piη_Z<‡z§èŒ)iÖwiÇ 2hÙ3·=’d÷8éŽ1¦¸c¤µ€7›7Ø ð\á)} ¹fËí›pAÃL%âc2 í§æQz¿;T8sæ°qø)QFMð‰XŒÂ±N¢aF¨…8¯!U  Z©RÊ ÖPVÄÀÍin™Ì-GˆªÅËŠ›•zË}º±ŽÍFò¹}Uw×#ä5B¤{î}Ð<ÙD é©¤&‡ïDbàÁôMÁ." ¤‡ú*õ'VŽ|¼´Úgllº¼klz[Æüï÷Aób‡Eÿ dÑ»Xx9ÃÜ£ÁT/`¼¸vI±Ýµ·Ë‚“G³þ*Ÿû´r|*}<¨îºœ @¦mÄ’M¹”.œ«Y–|6ÏU¤jç¥ÕÞqO ˜kDÆÁ¨5ÿ š;Њ¦¦€GÙk \ –Þ=â¼=SͧµªS°ÚÍpÜãQűÀõ¬?ÃÁ1Ñ•õZà?hóœ€ L¦l{Y*K˜Ù›zc˜–ˆâ ø+¾ ­-Ök¥%ùEÜA'}ˆ><ÊIè“bpÍ/qÞâvoX€w,\úªò6Z[XdÒæ­@Ö—€$òJí#é>'°Ú ôª˜<)4ryÙ£|óAÅn5žêŸyÒäMÝ2{"}‰–¤l÷ûWX\l¾Á¸góÉOÔ /óñB¤f¸çñ[.P˜ZsÊË*ßT܈§QN¢’¡¨§V¼(Üù*eÕ“”5T¨‹Âê¥FŒã½Dü[8'Ò¥a…Ú¶k7a *•›¼'Ò·\8¨ª\@\õ¢¦íq+DÙrmÎ…_ªæ»ŠÓœ¡¯’Ré9MÅ×D™lælffc+ŒÑ,ý™ÿ ¯þǤ=Å’Á7µ÷ÚÛ/“Ü€ñýã¼àí¾ÕÑ+ƒ,uµMâÀÄbm:ÒÎPæ{˜Gz[ƒ¯«® KHà`ßØŠéí¯P8Aq.C‰ à€kòpj´kN¶qô€…Õ,ÜNŠª-­{Zö’æû44‰sŽè‰îVíRœÕm" 6?³D9¡ÇTíÅꋇ`4«¸ÝÁô ï’ýorqКÇZ«x4Žâéþuïf¹µö[P ,Q£éaX±`PÉÍZ ¸äYúg üAx ’6Lê‚xÝÓ*äQ  Ï’¨hÍ =²,6ï#rÃ<¯–£»ƒ‹,–ê•€ aÛsñ'%Æ"®ÛüìBᝠHÚ3ß°©$“XnœÖ’î2ËTeûìxîß ¦å¿çÉ ðK§þ{‘t‚Ϋ¬jéîZ[ ”š7L¥4VÚCE×]m¤Øy”ä4-dz£œ§¸x.*ãÊÊ b÷•h:©‡¦s`BTÁRû¾g⻩‹jø sF¢àJøFl‘È•Xᓁà~*j¯ +(ÚÕ6-£¯÷GŠØy‚<Ç’.F‹Hœw(+)ÜÜâÈzÄäT§FߘãÏ;DmVœ3Àu@mÚüXÝü•3B¨òÌÁÛ<·ÃÜ z,Ì@õÅ·d2]ü8s÷IôÞ¯^Ç9¢u„~ëAŸï4«M? K]­ÅàPl@s_ p:°¬ZR”´›JC[CS.h‹ƒïËœ«Æ]–÷ó‚wR×k7X‰k›‘´ù¦=¡«‰¨¨Â')—71ó’c‡Ðúµ `é.{§p¹ój\Ž{1h{o±Ý=áUÊïGÖŒõ–-BÄm+AZX¶¡ ïHðæ¥JmÙ;…ä¡Ÿˆ¦ ° äšiÉg«$üMk5¤L“’çÊvïâï ,=f“"íἊ5ô¬x6{ɏžID0e¸vçmi'︧ºð9$ò¹÷*£’9ÿ ²TÔ…×>JV¥}Œ}$p[bÔ®*[jzS*8 ”·T›Í–ñUîƒwo$áè=LT™ç—~ô·¤ÈÚ$榍q‰„+´kFm)ž‹©i–ËqÞŠ‰à¶ü( ‚•§ •°ò·‡#5ª•µÊ﯅¡X¨šÁ*F#TXJÊ ušJVÍ&=iÄs1‚3•'fý§5Ñ<=[íÞ­ PÚ;ѱÌ_~Ä££8rÞ ²w;’hDT°>ÈG¬8Á²ÚzŽ®ò®qZcqJêäÞ-ö[ܘbň±çb“Š¶31²n×iƒðÕ;1¶þÉ ªX‰,ßqÏ$>•î íZ¥Z 1{ç൵+ƒÕµ¥°T$§K]á»Ûï*·¤tMI’ÂZbŽÕiÒ˜}bÓ0£ª5›¨ [5Ž^ÝœWøÂÝh° ¢OWun£¤5 a2Z.G2³YL]jåtì”ä ÁÓ‘%"©<ÔúÊ°sº UZvä‡ÄiÆÒM .÷V·™ø#kèýiíÌ–ª)µT[)BˆõÑ xB¾B€ÖT¨.¥~ð@VĶr#¸ü*åZNDŽH;âi ],©£öØpù(šºãö¼T.uCê•4@ÿ GÕÛ)Cx›®0ø#:ÏðFÒbR\(€€Ä®fã4Þ‰Fä¯HXƒÅ,†öEÑÔÜ]Öv²?tLÃvBY£ú6Êu5ÅAQ³1‘’¬x–HŒÐ‡ ^ ¸KwJôÖŽ5×CÚ¨vÜ«/B0$×k°=ðbÇ(Ï)w±A†Á† 11Í=èQšµ626ŒÜ/`G«µ<}—-Ö7KEHÈÉðóȤmݱû±·ø«Snmá=“ä«šmݱŸ¡¶~ó·“äUóJæúòB|E LêŽy´jDÔ$G¢þÐñ7óR8ýÒ…Ç› WVe#·Ÿ p·Fx~•ݤF÷0Èÿ K¯æS<6’¡WШ; ´ÿ ¥Êø\Òuî†åÝ–VNœkÒ7oòX¨Á­Ø÷FÎÑä±g÷ÿ M~Çî=p,X´ ÝÌÚÅ‹’ÃjÖ.ØöÏñ qïQ¤ÓZE†° =6·]܈ s¸>v•Ž^Ý\wq9r‰Î\¸¡kURÒ$­*‹Nq?Þª*!sŠÆ:TU_u±T+øX¡ ®¹¡,ÄâÃBTsÜ$Ø›4m椴zÜK]’’›Pƒ @€#â˜`é¹=I‡fiV•Ôî“nRm+µFPOhÍ0B£ €+¬5c v•:P'ÒyÎ ‰V~‚Ó†ÖuókDoh$å\*ö%Ю=£«…aȼ½÷Û.-½VŒŠ¼'lyî±1¬3ó#ÞE¿ÔS¤gV£m›=§\û"—WU¤ÚǼÿ ÂnÁGŒÃ ‚õN D³õNÚíŒÕ;HôyÄÈ©P¹Ä{:?R‘Ô¨âF÷ø£bÅó® JS|‚R÷ivýáâ€Æé¡è³´IئÑT!§˜•Øª‚¬â@q€wnïCWÄ@JU€ê¯m6]Ï:£âx'+ÒðXvÓ¦Úm=–´7œ $ì“B£~p%ÕŸUþ« N@¼üï~w˜ñø5®—'Ôe»¤5ã//€ž~‰Tþ›Å7•#¤× Íö pÄ$ùeåì*«ÓŠEØWEÈsßg ¦ûvžSsLpºÊW–âµEWöˬH; ™!CYõZ ÃÄf æ#1W. \uWâ\,\Çf j’<qTbên›Î[vxx£ë 'ö¨1›˜ÀM¼Pÿ H)ƒêêŒA7s,|F“ 꺸k³9Ìö*ç®;Ö!Ö$Eiž•¹ÒÚ†ýóéÝû¾ÕS®ó$’NÝäŸz¤5r¦ãÄÃD÷Üø!°ø‡Ô&@m™Ì^Ãä­d q5Lnÿ N;.6½·N|#ä"1Nƒx“ã<3('&ñßt  ~ªu”1Tb㫨9ê–›–bìd$ߣ=#ÕãÒmU¯eí$EFù5ýYô櫨æ왍Ǘ±ssM]·á¿0ÕåJRÓªîiƒ+O58ÖñªŠÒx" \µâá¨i’¤i —Ö ” M+M¤ë9‚‰A¦°Qõ¾ßøK~¼Ã‘g…Ö´~÷Ï[3GUœÒ½#…kàÔ®Ò”‰³·dWV‰IP‰Ú8u¹”E ÖqLj¾êÕCBš{A^Âß;–¨`¯¬ìö ˼ ×tìø.tƐm*n¨y4o&Àx¥n¦×î‡aupáÛj8¿m›è¶ã!o½;ß0y^ý×^EÑ¿ÒjzŒ­)vÚÑnÄL …^ªô× ‡—‚3k Îý­hï]içå–îÏ*÷ñþ»Ô CÒjøjÍznˆ´ ¹#b'Fô‹ ‰v¥'’à'T´ƒHýÍ%M‰ ƒ&ÆÇŒï1 ‘ –Þ ‰i¬s žR-Ÿ kŠ¬á¬7:þ 0ŒÅÒÕ/aÙ¬ÃÝ#Úøœ ©aiVc‰. ¹¦ãµ” ›Yg¦›ÆÎýº°f³7ƒhá·¸­}&D9¡ÂsÉÙÞèŠõØàC™¨ñbFC|´Ü(ŸƒÚÒ-%»'a Ì¿)ËÇn¿úÿ ÞŽX…4ÊÅH^ôΑí@ù¹Eh¶“L8Çjù ¼ÎåVªóR©Ï5uà V4lZß®=€xÖŸ–ÑÈ ÷”¨°¾__yM1tÉ?uÆþIkÄgæ@þ[¢†°XÃJ£j·:nkÅ¢u ‘}âGzö­/IµèŠ¬¼48q¦F°ŽR¼=ûì{´¯RýicS ÕÛ íNtÍÙï£,w4rêì®»~x(©Uñ§#Ñ&œÕ¤>ÎåÍÓ9’Ö{9eV­[Öjâ²ãu]˜å2›qÑšÕJç0€sÄ|Êëè0튔bÁ>“{×_F`Ø©ºê:µä,v¤ðfc1±"«ÔÍän1#=· Âøv~H½ÐßA¾¿Ü€Óš]Õ; I¾÷ç‚Qi†î¹9ywÔKG˜áñ zQY—§ÃÕZ07§X‚ Áh;ÁM)iÌCH-¯T‘ë|A0{Ò½LÚ–TâÖkÜ’dÀ“rmm»”جPF³ÖcbE§T€ÒxKºû’Ó®7±²(\4ŽÃ¸Uu@j™yĵ;³µ!Á¢b.W¤=mõ´êµK k ¸K^ÜÛ#p*Ü14qkZç5ïë †°5Ï%ÍÛ<Õ¤×Ô¥ê†C Õ´¼ú$ƒÖ“”]Ù¬qÞÚ[4©ý!ûÏ—Áb쳐XµA¬â~`›Çr¸8ìùÝ䫦<>ä÷«?xs´ÇÑ /á;¹øüÊÈÙà{"@Žïzâ¬[âß‚ U_<ÇŸ½4èN˜ú61®qŠu ¦þF£»äJ_ˆÙÎ~ ÞAã–Ý„Ï—rŠD;xTž‘ô`É«…suãO`?³à™ô Lý#Íc5öoæØ‚y´´÷«ZR§<&JÇ+éâô´€i!Àˆ0æAoàðLèÖ-2ŸõW.’t^–(KÁmHµV@xÜÇy®Ñø­â^:Ú3w· 7½¹°ñ¸â¹®:',«Mœ—n­Á+Ãbš LÈ‘ÄnRÓÅœ%¦²‰¨ùQ:¤f‚ "PÕtô¸…cæl…&˜Ú˜Ôkv‹ž+vŠ,=¢v­6—Xy*¥t£«<™:“aîϲ=¦6rO]XI¿Œ÷¤zÚ­›¶ 6÷”w\d ü~v®ˆÌk«^m<ÿ ¢‰Õ\)ùºŽ;… lîÙÅEŠ®cѾ@vnMÏ,¼“ñ•ŽBxðÃzãÇç%3ˆ"}Ù•Åî> BÉú;Ò]V+P˜F_´ßé> Øše|ï‡ÄOmFæÇ ãqÞ$/xÐx­z`ï9"œÜij‚!7.\Td…9M‡•iŽ‹¾‘50ÞŽn¥ß4ÉôO ¹*í^QêËÜÇÌ8=Ž§s‰'ÂëÙ«á%Pú[O †ÅP¯VsŽ°.‰,kc¶ ¬A9n˜XÎ-ÞšN["¹QÕ‰ƒMýÁߺXJæÍaLj¾×Ãmã¾ãÚ uñÒþåQô¦¥ /ÄUx:‚ÍÜ’ Đ©ØÝ3V¨‰ÕnÐ6ó*óúK­«…c ¯U òhsý­jóÔj#,ímŒRµ«lbïUTŒÑ8†Ä0œÏr`ð¡¬É Ї ë"À² ™ 6¥ f¶ ¢ÚoܱԷ-<Àî)†a¶ž'Ú»¨TXqØæ¶÷YÄHy˜9ÈIW­YÀuMFë ºÏ’AqÌ4·/Ú †ô'i$øä­=Ä Ý|öK×40è|È6p‘0§)o¥ctî§H+CA-“ xØ|ÐXŠç l8íºð3Ø:³¤¬KX¯UÿÙ -- MySQL dump 10.13 Distrib 5.7.29, for Linux (x86_64) -- -- Host: localhost Database: billbee360 -- ------------------------------------------------------ -- Server version 5.7.29-0ubuntu0.18.04.1 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `customer_last_ids` -- DROP TABLE IF EXISTS `customer_last_ids`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `customer_last_ids` ( `id` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `customer_last_ids` -- LOCK TABLES `customer_last_ids` WRITE; /*!40000 ALTER TABLE `customer_last_ids` DISABLE KEYS */; INSERT INTO `customer_last_ids` VALUES (1013); /*!40000 ALTER TABLE `customer_last_ids` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `customers` -- DROP TABLE IF EXISTS `customers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `customers` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `Name` text COLLATE utf8mb4_unicode_ci NOT NULL, `AccNo` text COLLATE utf8mb4_unicode_ci, `Email` text COLLATE utf8mb4_unicode_ci, `PhoneNo` text COLLATE utf8mb4_unicode_ci, `Address` text COLLATE utf8mb4_unicode_ci, `Debit` text COLLATE utf8mb4_unicode_ci, `Credit` text COLLATE utf8mb4_unicode_ci, `CreatedDate` text COLLATE utf8mb4_unicode_ci, `Username` text COLLATE utf8mb4_unicode_ci, `Password` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `OpeningBalance` decimal(10,2) DEFAULT '0.00', `CurrentBalance` decimal(10,2) DEFAULT '0.00', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `customers` -- LOCK TABLES `customers` WRITE; /*!40000 ALTER TABLE `customers` DISABLE KEYS */; INSERT INTO `customers` VALUES (3,'Sarves','ETC1003','sarves.tv@gmail.com','+14168544112','2657 Eglinton',NULL,NULL,'2019-12-25','sarves','123','2019-12-25 09:21:52','2020-02-01 06:07:19',0.00,3700.00),(4,'Kugeenthan','ETC1004','kugeenthan23@hotmail.com','+14169539192','2657 Eglinton',NULL,NULL,'2019-12-25','kuheenthan','123','2019-12-25 10:36:41','2020-01-20 03:29:42',24250.00,23107.00),(5,'Siva','ETC1005','siv38@live.com','+16475013108','2657 Eglinton',NULL,NULL,'2019-12-25','siva','123','2019-12-25 13:14:35','2020-01-17 03:56:12',12573.00,7632.00),(6,'Thushy','ETC1006','thushy@gmail.com','+16479604000','2657 Eglinton',NULL,NULL,'2019-12-25','thushy','123','2019-12-25 14:18:53','2020-01-23 01:52:58',10124.00,6284.00),(7,'Dinesh','ETC1007','dinesharan1985@gmail.com','+14167169050','2657 Eglinton',NULL,NULL,'2019-12-25','dinesh','123','2019-12-25 19:00:35','2020-01-21 15:26:20',45968.75,58164.25),(8,'Ananthaa','ETC1008','ananthaa@live.com','+16472061537','2657 Eglinton',NULL,NULL,'2019-12-26','ananthaa','123','2019-12-26 00:07:57','2020-01-06 12:11:51',3487.50,2487.50),(9,'Muhunthan','ETC1009','muhunth1@gmail.com','+14169186640','2657 Eglinton',NULL,NULL,'2019-12-26','muhunthan','123','2019-12-26 11:02:37','2020-02-02 09:46:50',960.00,575.00),(10,'Test User','ETC1010','selva.aran2012@gmail.com','+16472732759','Mississauga',NULL,NULL,'2019-12-27','Tsr','1123','2019-12-27 03:16:27','2020-02-01 03:04:14',75.00,2645.00),(12,'iptvdaddymaster','ETC1012','Mat@iptvdaddy.com','+13439967933','Ottawa',NULL,NULL,'2020-01-01','iptvdaddymaster','123','2020-01-01 15:55:40','2020-01-20 00:15:41',1064.00,3015.00); /*!40000 ALTER TABLE `customers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `generals` -- DROP TABLE IF EXISTS `generals`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `generals` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `CustomerName` text COLLATE utf8mb4_unicode_ci, `CompanyName` text COLLATE utf8mb4_unicode_ci, `Address` text COLLATE utf8mb4_unicode_ci, `Email` text COLLATE utf8mb4_unicode_ci, `PhoneNo` text COLLATE utf8mb4_unicode_ci, `Currency` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `LogoImage` text COLLATE utf8mb4_unicode_ci, `Prefix` text COLLATE utf8mb4_unicode_ci, `ThemeColor` text COLLATE utf8mb4_unicode_ci, `BgImage` text COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `generals` -- LOCK TABLES `generals` WRITE; /*!40000 ALTER TABLE `generals` DISABLE KEYS */; INSERT INTO `generals` VALUES (1,'Sarvesh Poopalasingam','Eagle TV','AJAX','spoopalasingam@gmail.com','+14168544112','$',NULL,'2020-01-31 00:35:09','LogoImage202001310035090000001580430909.jpg','ET','#1111111','BgImage202001310035090000001580430909.jpg'); /*!40000 ALTER TABLE `generals` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `invoice_items` -- DROP TABLE IF EXISTS `invoice_items`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `invoice_items` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `InvoiceId` int(10) unsigned NOT NULL, `ProductId` int(10) unsigned NOT NULL, `Quantity` int(10) unsigned NOT NULL, `SubTotal` decimal(10,2) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `Price` decimal(10,2) DEFAULT '0.00', `CustomerId` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=75 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `invoice_items` -- LOCK TABLES `invoice_items` WRITE; /*!40000 ALTER TABLE `invoice_items` DISABLE KEYS */; INSERT INTO `invoice_items` VALUES (5,4,10,1,-0.25,NULL,NULL,-0.25,3),(6,5,10,1,-0.25,NULL,NULL,-0.25,NULL),(8,6,11,1000,4000.00,NULL,NULL,4.00,NULL),(9,8,11,1000,4000.00,NULL,NULL,4.00,NULL),(10,9,7,2,210.00,NULL,NULL,105.00,NULL),(11,9,6,7,525.00,NULL,NULL,75.00,NULL),(12,9,7,9,945.00,NULL,NULL,105.00,NULL),(13,10,9,10,60.00,NULL,NULL,6.00,NULL),(14,11,11,1000,4000.00,NULL,NULL,4.00,NULL),(15,12,7,10,1.00,NULL,NULL,105.00,NULL),(16,12,12,17,85.00,NULL,NULL,5.00,NULL),(17,13,11,1000,4000.00,NULL,NULL,4.00,NULL),(18,14,6,10,750.00,NULL,NULL,75.00,NULL),(19,14,7,10,1050.00,NULL,NULL,105.00,NULL),(20,15,3,1000,5000.00,NULL,NULL,5.00,NULL),(21,16,6,0,-80.00,NULL,NULL,80.00,NULL),(22,16,16,0,-95.00,NULL,NULL,95.00,NULL),(23,17,16,2,190.00,NULL,NULL,95.00,NULL),(24,17,6,1,80.00,NULL,NULL,80.00,NULL),(25,18,16,0,-190.00,NULL,NULL,95.00,NULL),(26,18,6,0,-80.00,NULL,NULL,80.00,NULL),(27,19,2,100,475.00,NULL,NULL,4.75,NULL),(28,20,2,100,475.00,NULL,NULL,4.75,NULL),(29,21,5,10,720.00,NULL,NULL,72.00,NULL),(30,22,1,100,300.00,NULL,NULL,3.00,NULL),(31,22,6,5,400.00,NULL,NULL,80.00,NULL),(32,23,1,50,150.00,NULL,NULL,3.00,NULL),(33,24,11,15,60.00,NULL,NULL,4.00,NULL),(34,25,17,1062,1062.00,NULL,NULL,1.00,NULL),(35,26,1,75,225.00,NULL,NULL,3.00,NULL),(36,26,5,3,216.00,NULL,NULL,72.00,NULL),(37,27,8,5,575.00,NULL,NULL,115.00,NULL),(38,27,7,3,315.00,NULL,NULL,105.00,NULL),(39,28,7,10,1050.00,NULL,NULL,105.00,NULL),(40,29,2,100,475.00,NULL,NULL,4.75,NULL),(41,29,8,2,230.00,NULL,NULL,115.00,NULL),(42,30,4,22,121.00,NULL,NULL,5.50,NULL),(43,31,3,100,500.00,NULL,NULL,5.00,NULL),(44,31,6,20,1600.00,NULL,NULL,80.00,NULL),(45,32,18,548,2466.00,NULL,NULL,4.50,NULL),(46,33,3,497,2485.00,NULL,NULL,5.00,NULL),(47,34,9,20,120.00,NULL,NULL,6.00,NULL),(48,35,6,1,75.00,NULL,NULL,75.00,NULL),(49,37,6,2,150.00,NULL,NULL,75.00,NULL),(50,38,2,100,475.00,NULL,NULL,4.75,NULL),(51,39,3,100,500.00,NULL,NULL,5.00,NULL),(52,40,3,50,250.00,NULL,NULL,5.00,NULL),(53,41,5,2,144.00,NULL,NULL,72.00,NULL),(54,41,15,5,50.00,NULL,NULL,10.00,NULL),(55,42,9,50,300.00,NULL,NULL,6.00,NULL),(56,43,6,6,450.00,NULL,NULL,75.00,NULL),(57,44,3,1000,5000.00,NULL,NULL,5.00,NULL),(58,45,6,3,225.00,NULL,NULL,75.00,NULL),(59,46,2,50,237.50,NULL,NULL,4.75,NULL),(60,47,3,50,250.00,NULL,NULL,5.00,NULL),(61,48,2,1000,4750.00,NULL,NULL,4.75,NULL),(62,49,2,3984,18924.00,NULL,NULL,4.75,NULL),(63,50,3,100,500.00,NULL,NULL,5.00,NULL),(64,51,14,2,50.00,NULL,NULL,25.00,NULL),(65,52,2,100,375.00,NULL,NULL,3.75,10),(66,53,1,100,275.00,NULL,NULL,2.75,10),(67,54,1,60,60.00,NULL,NULL,1.00,10),(68,55,1,25,75.00,NULL,NULL,3.00,10),(69,55,5,3,210.00,NULL,NULL,70.00,10),(70,56,8,3,330.00,NULL,NULL,110.00,10),(71,57,1,10,30.00,NULL,NULL,3.00,10),(72,58,1,1,5.00,NULL,NULL,5.00,3),(74,61,3,50,250.00,NULL,NULL,5.00,9); /*!40000 ALTER TABLE `invoice_items` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `invoices` -- DROP TABLE IF EXISTS `invoices`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `invoices` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `CustomerId` int(10) unsigned NOT NULL, `CustomerName` text COLLATE utf8mb4_unicode_ci NOT NULL, `InvoiceNo` text COLLATE utf8mb4_unicode_ci NOT NULL, `Date` text COLLATE utf8mb4_unicode_ci NOT NULL, `Total` decimal(10,2) DEFAULT '0.00', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `DueDate` text COLLATE utf8mb4_unicode_ci, `InvoiceNote` text COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=62 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `invoices` -- LOCK TABLES `invoices` WRITE; /*!40000 ALTER TABLE `invoices` DISABLE KEYS */; INSERT INTO `invoices` VALUES (5,3,'Sarves','ETI1005','2019-12-25',-0.25,'2019-12-25 10:10:40','2019-12-25 10:10:40','2019-12-25',''),(8,4,'Kugeenthan','ETI1008','2019-12-25',4000.00,'2019-12-25 10:58:47','2019-12-25 10:58:47','2019-12-25',''),(9,4,'Kugeenthan','ETI1009','2019-12-25',1680.00,'2019-12-25 11:08:49','2019-12-25 11:08:49','2019-12-25',''),(10,4,'Kugeenthan','ETI1010','2019-12-25',60.00,'2019-12-25 11:09:58','2019-12-25 11:09:58','2019-12-25',''),(11,4,'Kugeenthan','ETI1011','2019-12-25',4000.00,'2019-12-25 11:10:57','2019-12-25 11:10:57','2019-12-25',''),(12,4,'Kugeenthan','ETI1012','2019-12-25',1135.00,'2019-12-25 11:12:58','2019-12-25 11:12:58','2019-12-25',''),(13,4,'Kugeenthan','ETI1013','2019-12-25',4000.00,'2019-12-25 11:17:20','2019-12-25 11:17:20','2019-12-25',''),(14,4,'Kugeenthan','ETI1014','2019-12-25',1800.00,'2019-12-25 11:27:08','2019-12-25 11:27:08','2019-12-25',''),(15,4,'Kugeenthan','ETI1015','2019-12-25',5000.00,'2019-12-25 11:27:44','2019-12-25 11:27:44','2019-12-25',''),(17,3,'Sarves','ETI1017','2019-12-27',270.00,'2019-12-27 00:38:56','2019-12-27 00:38:56','2019-12-27',''),(18,3,'Sarves','ETI1018','2019-12-27',-270.00,'2019-12-27 00:40:26','2019-12-27 00:40:26','2019-12-27',''),(19,3,'Sarves','ETI1019','2019-12-27',475.00,'2019-12-27 01:12:50','2019-12-27 01:12:50','2019-12-27',''),(20,3,'Sarves','ETI1020','2019-12-27',475.00,'2019-12-27 01:12:51','2019-12-27 01:12:51','2019-12-27',''),(21,3,'Sarves','ETI1021','2019-12-27',720.00,'2019-12-27 01:13:54','2019-12-27 01:13:54','2019-12-27',''),(22,10,'Test User','ETI1022','2019-12-27',700.00,'2019-12-27 03:17:29','2019-12-27 03:17:29','2019-12-27',''),(23,10,'Test User','ETI1023','2019-12-27',150.00,'2019-12-27 03:18:58','2019-12-27 03:18:58','2019-12-27',''),(29,10,'Test User','ETI1029','2019-12-31',705.00,'2019-12-31 06:48:30','2019-12-31 06:48:30','2019-12-31','Boxes will be delivered on 3rd Jan 2020.'),(25,7,'Dinesh','ETI1025','2019-12-28',1062.00,'2019-12-28 13:01:35','2019-12-28 13:01:35','2019-12-28',''),(26,10,'Test User','ETI1026','2019-12-30',441.00,'2019-12-30 06:56:21','2019-12-30 06:56:21','2019-12-30','You can collect 2 boxes now. You will get third one on Wednesday.'),(27,10,'Test User','ETI1027','2019-12-30',890.00,'2019-12-30 07:22:25','2019-12-30 07:22:25','2019-12-30','You will receive the Mag420 boxes by 2nd Jan 2020.'),(30,3,'Sarves','ETI1030','2019-12-31',121.00,'2019-12-31 16:46:58','2019-12-31 16:46:58','2019-12-31','credits'),(31,3,'Sarves','ETI1031','2019-12-31',2100.00,'2019-12-31 16:54:26','2019-12-31 16:54:26','2019-12-31','test'),(32,12,'iptvdaddymaster','ETI1032','2020-01-01',2466.00,'2020-01-01 15:59:56','2020-01-01 15:59:56','2020-01-01','DEC 1st 2019'),(33,12,'iptvdaddymaster','ETI1033','2020-01-01',2485.00,'2020-01-01 16:01:23','2020-01-01 16:01:23','2020-01-01','ACTIVE USERS as of Jan 1st, 2020'),(34,4,'Kugeenthan','ETI1034','2020-01-01',120.00,'2020-01-01 20:19:58','2020-01-01 20:19:58','2020-01-01','Ipguys'),(35,9,'Muhunthan','ETI1035','2020-01-03',75.00,'2020-01-03 22:18:51','2020-01-03 22:18:51','2020-01-03','for Cell Tell'),(36,3,'Sarves','ETI1036','2020-01-03',-170.00,'2020-01-03 23:49:39','2020-01-03 23:49:39','2020-01-03','testtt'),(37,9,'Muhunthan','ETI1036','2020-01-04',150.00,'2020-01-04 00:28:15','2020-01-04 00:28:15','2020-01-04','For Murugan'),(38,10,'Test User','ETI1037','2020-01-05',475.00,'2020-01-05 19:02:36','2020-01-05 19:02:36','2020-01-05','N/A'),(39,8,'Ananthaa','ETI1038','2020-01-06',500.00,'2020-01-06 12:04:10','2020-01-06 12:04:10','2020-01-06','N/A'),(40,9,'Muhunthan','ETI1039','2020-01-07',250.00,'2020-01-07 01:32:24','2020-01-07 01:32:24','2020-01-07','N/A'),(41,5,'Siva','ETI1040','2020-01-07',194.00,'2020-01-07 03:48:11','2020-01-07 03:48:11','2020-01-07','N/A'),(42,5,'Siva','ETI1041','2020-01-08',300.00,'2020-01-08 01:18:26','2020-01-08 01:18:26','2020-01-08','N/A'),(43,5,'Siva','ETI1042','2020-01-10',450.00,'2020-01-10 01:19:38','2020-01-10 01:19:38','2020-01-10','N/A'),(44,4,'Kugeenthan','ETI1043','2020-01-16',5000.00,'2020-01-16 05:33:27','2020-01-16 05:33:27','2020-01-16','N/A'),(45,9,'Muhunthan','ETI1044','2020-01-17',225.00,'2020-01-17 00:17:55','2020-01-17 00:17:55','2020-01-17','N/A'),(46,7,'Dinesh','ETI1045','2020-01-18',237.50,'2020-01-18 01:41:32','2020-01-18 01:41:32','2020-01-18','Added to Nivaiptv'),(47,9,'Muhunthan','ETI1046','2020-01-20',250.00,'2020-01-20 18:23:06','2020-01-20 18:23:06','2020-01-20','N/A'),(48,7,'Dinesh','ETI1047','2020-01-21',4750.00,'2020-01-21 01:52:33','2020-01-21 01:52:33','2020-01-21','N/A'),(49,7,'Dinesh','ETI1048','2020-01-21',18924.00,'2020-01-21 15:26:18','2020-01-21 15:26:18','2020-01-21','Total 4984 credits added -1000 =3984'),(50,6,'Thushy','ETI1049','2020-01-23',500.00,'2020-01-23 01:52:57','2020-01-23 01:52:57','2020-01-22','N/A'),(51,9,'Muhunthan','ETI1050','2020-01-22',50.00,'2020-01-23 02:13:06','2020-01-23 02:13:06','2020-01-23','N/A'),(52,10,'Test User','ETI1051','2020-01-31',375.00,'2020-01-31 00:37:26','2020-01-31 00:37:26','2020-01-31','N/A'),(53,10,'Test User','ETI1052','2020-02-01',275.00,'2020-02-01 02:36:24','2020-02-01 02:36:24','2020-02-01','Inv Note'),(54,10,'Test User','ETI1053','2020-02-01',60.00,'2020-02-01 02:39:39','2020-02-01 02:39:39','2020-02-01','invoice note'),(55,10,'Test User','ETI1054','2020-02-01',285.00,'2020-02-01 02:50:42','2020-02-01 02:50:42','2020-01-31','Box will be delivered on 3rd Feb.'),(56,10,'Test User','ETI1055','2020-02-01',330.00,'2020-02-01 03:01:32','2020-02-01 03:01:32','2020-01-31','will be delivered on 5th Feb'),(57,10,'Test User','ETI1056','2020-02-01',30.00,'2020-02-01 03:04:14','2020-02-01 03:04:14','2020-02-01','test'),(58,3,'Sarves','ETI1057','2020-02-01',5.00,'2020-02-01 06:01:58','2020-02-01 06:01:58','2020-02-01','N/A'),(61,9,'Muhunthan','ETI1059','2020-02-02',250.00,'2020-02-02 09:46:50','2020-02-02 09:46:50','2020-02-02','N/A'); /*!40000 ALTER TABLE `invoices` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `last_invoice_numbers` -- DROP TABLE IF EXISTS `last_invoice_numbers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `last_invoice_numbers` ( `id` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `last_invoice_numbers` -- LOCK TABLES `last_invoice_numbers` WRITE; /*!40000 ALTER TABLE `last_invoice_numbers` DISABLE KEYS */; INSERT INTO `last_invoice_numbers` VALUES (1060); /*!40000 ALTER TABLE `last_invoice_numbers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `last_payment_ids` -- DROP TABLE IF EXISTS `last_payment_ids`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `last_payment_ids` ( `id` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `last_payment_ids` -- LOCK TABLES `last_payment_ids` WRITE; /*!40000 ALTER TABLE `last_payment_ids` DISABLE KEYS */; INSERT INTO `last_payment_ids` VALUES (1062); /*!40000 ALTER TABLE `last_payment_ids` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `last_product_ids` -- DROP TABLE IF EXISTS `last_product_ids`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `last_product_ids` ( `id` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `last_product_ids` -- LOCK TABLES `last_product_ids` WRITE; /*!40000 ALTER TABLE `last_product_ids` DISABLE KEYS */; INSERT INTO `last_product_ids` VALUES (1019); /*!40000 ALTER TABLE `last_product_ids` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `migrations` -- DROP TABLE IF EXISTS `migrations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `migrations` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `migrations` -- LOCK TABLES `migrations` WRITE; /*!40000 ALTER TABLE `migrations` DISABLE KEYS */; INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2019_09_11_105343_create_products_table',2),(3,'2019_09_11_154151_create_customers_table',3),(4,'2019_09_12_044130_create_transactions_table',4),(5,'2019_09_14_061422_create_customer_last_ids_table',5),(6,'2019_09_15_052130_create_payments_table',6),(7,'2019_10_12_104340_create_invoices_table',7),(8,'2019_10_12_105207_create_invoice_items_table',7),(9,'2019_10_17_053544_create_last_invoice_numbers_table',8),(10,'2019_10_29_100415_create_last_product_ids_table',9),(11,'2019_10_29_153459_create_payment_last_nos_table',10),(12,'2019_10_29_153527_create_transaction_last_nos_table',10),(13,'2019_10_29_154131_create_payment_last_ids_table',11),(14,'2019_10_29_154157_create_transaction_last_ids_table',11),(15,'2019_10_29_161726_create_last_payment_ids_table',12),(16,'2019_11_15_040647_create_generals_table',13),(17,'2019_12_14_150657_create_tests_table',14); /*!40000 ALTER TABLE `migrations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `payments` -- DROP TABLE IF EXISTS `payments`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `payments` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `CustomerId` int(11) unsigned NOT NULL, `Description` text COLLATE utf8mb4_unicode_ci, `Date` text COLLATE utf8mb4_unicode_ci, `Amount` decimal(10,2) DEFAULT '0.00', `PaymentType` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `PaymentNo` text COLLATE utf8mb4_unicode_ci, `CustomerName` text COLLATE utf8mb4_unicode_ci, `PaymentMethod` text COLLATE utf8mb4_unicode_ci, `PaymentNote` text COLLATE utf8mb4_unicode_ci, `InvoiceId` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=62 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `payments` -- LOCK TABLES `payments` WRITE; /*!40000 ALTER TABLE `payments` DISABLE KEYS */; INSERT INTO `payments` VALUES (1,1,NULL,'2019-12-16',30000.00,'Discount','2019-12-15 23:48:09','2019-12-15 23:48:09','ETP1','Thangarasa Senthura','Paypal','N/A',NULL),(2,4,NULL,'2019-12-25',2500.00,'Payment','2019-12-25 10:56:31','2019-12-25 10:56:31','ETP1002','Kugeenthan','E-Transfer','N/A',NULL),(3,4,NULL,'2019-12-25',2250.00,'Payment','2019-12-25 10:57:35','2019-12-25 10:57:35','ETP1003','Kugeenthan','Cash','N/A',NULL),(4,4,NULL,'2019-12-25',1600.00,'Payment','2019-12-25 10:59:31','2019-12-25 10:59:31','ETP1004','Kugeenthan','E-Transfer','N/A',NULL),(5,4,NULL,'2019-12-25',1420.00,'Payment','2019-12-25 11:09:21','2019-12-25 11:09:21','ETP1005','Kugeenthan','Cash','N/A',NULL),(6,4,NULL,'2019-12-25',1600.00,'Payment','2019-12-25 11:11:31','2019-12-25 11:11:31','ETP1006','Kugeenthan','Cash','N/A',NULL),(7,4,NULL,'2019-12-25',190.00,'Owing','2019-12-25 11:14:01','2019-12-25 11:14:01','ETP1007','Kugeenthan','Cash','N/A',NULL),(8,4,NULL,'2019-12-25',1600.00,'Payment','2019-12-25 11:15:23','2019-12-25 11:15:23','ETP1008','Kugeenthan','E-Transfer','N/A',NULL),(9,4,NULL,'2019-12-25',1900.00,'Payment','2019-12-25 11:16:03','2019-12-25 11:16:03','ETP1009','Kugeenthan','Cash','N/A',NULL),(10,4,NULL,'2019-12-25',900.00,'Payment','2019-12-25 11:16:25','2019-12-25 11:16:25','ETP1010','Kugeenthan','E-Transfer','N/A',NULL),(11,4,NULL,'2019-12-25',2500.00,'Payment','2019-12-25 11:17:46','2019-12-25 11:17:46','ETP1011','Kugeenthan','Cash','N/A',NULL),(12,4,NULL,'2019-12-25',1500.00,'Payment','2019-12-25 11:18:14','2019-12-25 11:18:14','ETP1012','Kugeenthan','Cash','N/A',NULL),(13,4,NULL,'2019-12-25',393.00,'Payment','2019-12-25 11:31:19','2019-12-25 11:31:19','ETP1013','Kugeenthan','Paypal','N/A',NULL),(14,4,NULL,'2019-12-25',685.00,'Payment','2019-12-25 11:36:45','2019-12-25 11:36:45','ETP1014','Kugeenthan','Paypal','N/A',NULL),(15,7,NULL,'2019-12-27',900.00,'Payment','2019-12-27 16:22:16','2019-12-31 16:25:03','ETP1015','Dinesh','E-Transfer','Vinoth E Transfer',NULL),(16,7,NULL,'2019-12-27',1000.00,'Payment','2019-12-27 18:53:08','2019-12-31 16:23:32','ETP1016','Dinesh','E-Transfer','Aravinthan Kitchner',NULL),(17,10,NULL,'2019-12-30',426.00,'Payment','2019-12-30 07:03:33','2019-12-30 07:03:33','ETP1017','Test User','Cash','Could you please make the $250 immediately on remaining payment. Thanks!',NULL),(18,10,NULL,'2019-12-30',450.00,'Payment','2019-12-30 07:24:44','2019-12-30 07:24:44','ETP1018','Test User','Cash','Please send the remaining money as e-Transfer.',NULL),(21,7,NULL,'2019-12-31',1000.00,'Payment','2019-12-31 16:38:44','2019-12-31 16:38:44','ETP1021','Dinesh','E-Transfer','from Melvin on DEC 30th',NULL),(22,7,NULL,'2019-12-31',340.00,'Payment','2019-12-31 16:40:47','2019-12-31 16:40:47','ETP1022','Dinesh','Paypal','for new line paypalnew0221@gmail.com',NULL),(23,3,NULL,'2019-12-31',196.25,'Payment','2019-12-31 16:49:33','2019-12-31 16:49:33','ETP1023','Sarves','Cash','for new server 121.121.121.121 Swiss network',NULL),(24,7,NULL,'2020-01-03',262.00,'Payment','2020-01-03 09:16:45','2020-01-03 09:16:45','ETP1024','Dinesh','E-Transfer','From vinoth29@yahoo.ca',NULL),(25,9,NULL,'2020-01-04',200.00,'Payment','2020-01-04 00:28:57','2020-01-04 00:28:57','ETP1025','Muhunthan','Cash','Cash',NULL),(26,9,NULL,'2020-01-04',100.00,'Payment','2020-01-04 01:09:55','2020-01-04 01:09:55','ETP1026','Muhunthan','Cash','Cash',NULL),(27,6,NULL,'2020-01-04',1480.00,'Payment','2020-01-04 01:56:39','2020-01-04 01:56:39','ETP1027','Thushy','Cash','Cash',NULL),(28,7,NULL,'2020-01-04',1000.00,'Payment','2020-01-04 23:33:15','2020-01-04 23:33:15','ETP1028','Dinesh','E-Transfer','Yesterday from Malaravan',NULL),(29,7,NULL,'2020-01-04',500.00,'Payment','2020-01-04 23:34:02','2020-01-04 23:34:02','ETP1029','Dinesh','E-Transfer','Auto deposited',NULL),(30,5,NULL,'2020-01-05',2000.00,'Payment','2020-01-05 03:20:23','2020-01-05 03:20:23','ETP1030','Siva','Cash','Cash at home',NULL),(31,7,NULL,'2020-01-05',570.00,'Payment','2020-01-05 03:33:44','2020-01-05 03:33:44','ETP1031','Dinesh','Cash','From Nivaiptv',NULL),(32,5,NULL,'2020-01-05',1050.00,'Payment','2020-01-05 20:07:00','2020-01-05 20:07:00','ETP1032','Siva','Cash','Cash',NULL),(33,7,NULL,'2020-01-05',500.00,'Payment','2020-01-05 22:27:16','2020-01-05 22:27:16','ETP1033','Dinesh','Paypal','to Hari Swiss',NULL),(34,7,NULL,'2020-01-05',2800.00,'Payment','2020-01-05 22:27:54','2020-01-05 22:27:54','ETP1034','Dinesh','Cash','Kannna TechSource',NULL),(35,7,NULL,'2020-01-05',263.00,'Payment','2020-01-05 22:29:00','2020-01-05 22:29:00','ETP1035','Dinesh','E-Transfer','from Vimalraj',NULL),(36,8,NULL,'2020-01-06',1500.00,'Payment','2020-01-06 12:11:49','2020-01-06 12:11:49','ETP1036','Ananthaa','E-Transfer','E transfer',NULL),(37,9,NULL,'2020-01-07',600.00,'Payment','2020-01-07 01:24:41','2020-01-07 01:24:41','ETP1037','Muhunthan','Cash','N/A',NULL),(38,6,NULL,'2020-01-07',600.00,'Payment','2020-01-07 01:25:22','2020-01-07 01:25:22','ETP1038','Thushy','Cash','N/A',NULL),(39,5,NULL,'2020-01-07',240.00,'Payment','2020-01-07 03:50:12','2020-01-07 03:50:12','ETP1039','Siva','Cash','N/A',NULL),(40,5,NULL,'2020-01-08',750.00,'Payment','2020-01-08 01:19:06','2020-01-08 01:19:06','ETP1040','Siva','Cash','N/A',NULL),(41,5,NULL,'2020-01-08',200.00,'Payment','2020-01-08 22:46:37','2020-01-08 22:46:37','ETP1041','Siva','Cash','From Myura',NULL),(42,5,NULL,'2020-01-10',400.00,'Payment','2020-01-10 01:20:42','2020-01-10 01:20:42','ETP1042','Siva','Cash','N/A',NULL),(43,5,NULL,'2020-01-10',375.00,'Owing','2020-01-10 01:56:21','2020-01-10 01:56:21','ETP1043','Siva','Cash','5 Mag322w1 to Sayanthan DEC 27th',NULL),(44,7,NULL,'2020-01-11',1000.00,'Payment','2020-01-11 22:12:01','2020-01-11 22:12:01','ETP1044','Dinesh','Cash','From Malaravan',NULL),(45,7,NULL,'2020-01-11',1005.00,'Payment','2020-01-11 23:23:21','2020-01-11 23:23:21','ETP1045','Dinesh','Paypal','PayPal to Hari',NULL),(46,6,NULL,'2020-01-13',1150.00,'Payment','2020-01-13 03:10:44','2020-01-13 03:10:44','ETP1046','Thushy','Cash','N/A',NULL),(47,7,NULL,'2020-01-16',575.00,'Payment','2020-01-16 05:25:58','2020-01-16 05:25:58','ETP1047','Dinesh','E-Transfer','Jan 15th, 2020',NULL),(48,9,NULL,'2020-01-17',360.00,'Payment','2020-01-17 03:36:38','2020-01-17 03:36:38','ETP1048','Muhunthan','Cash','N/A',NULL),(49,5,NULL,'2020-01-17',870.00,'Payment','2020-01-17 03:56:11','2020-01-17 03:56:11','ETP1049','Siva','Cash','N/A',NULL),(50,7,NULL,'2020-01-18',300.00,'Payment','2020-01-18 01:47:15','2020-01-18 01:47:15','ETP1050','Dinesh','Cash','From Niva',NULL),(51,7,NULL,'2020-01-18',263.00,'Payment','2020-01-19 02:12:45','2020-01-19 02:12:45','ETP1051','Dinesh','E-Transfer','N/A',NULL),(52,12,NULL,'2020-01-20',3000.00,'Payment','2020-01-20 00:15:39','2020-01-20 00:15:39','ETP1052','iptvdaddymaster','Paypal','JAN 15th',NULL),(53,4,NULL,'2020-01-20',3900.00,'Payment','2020-01-20 03:29:40','2020-01-20 03:29:40','ETP1053','Kugeenthan','Cash','Cash',NULL),(54,7,NULL,'2020-01-20',500.00,'Payment','2020-01-21 01:53:25','2020-01-21 01:53:25','ETP1054','Dinesh','E-Transfer','Etransfer',NULL),(55,6,NULL,'2020-01-22',1110.00,'Payment','2020-01-22 01:53:58','2020-01-22 01:53:58','ETP1055','Thushy','Cash','N/A',NULL),(56,9,NULL,'2020-01-23',200.00,'Payment','2020-01-23 01:51:49','2020-01-23 01:51:49','ETP1056','Muhunthan','Cash','At the Office',NULL),(57,10,NULL,'2020-01-31',225.00,'Payment','2020-01-31 00:37:28','2020-01-31 00:37:28','ETP1057','Test User','Cash','Test',52),(58,10,NULL,'2020-02-01',275.00,'Payment','2020-02-01 02:36:24','2020-02-01 02:36:24','ETP1058','Test User','Cash','Pay Note',53),(59,10,NULL,'2020-02-01',60.00,'Payment','2020-02-01 02:39:39','2020-02-01 02:39:39','ETP1059','Test User','Cash','Pay Note',54),(60,10,NULL,'2020-02-01',710.00,'Payment','2020-02-01 02:48:02','2020-02-01 02:48:02','ETP1060','Test User','Cash','On behalf of Ram.',NULL),(61,3,NULL,'2020-02-01',5.00,'Payment','2020-02-01 06:02:42','2020-02-01 06:02:42','ETP1061','Sarves','Cash','N/A',NULL); /*!40000 ALTER TABLE `payments` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `paymenttransaction` -- DROP TABLE IF EXISTS `paymenttransaction`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `paymenttransaction` ( `id` int(11) NOT NULL AUTO_INCREMENT, `paymenttransaction` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `paymenttransaction` -- LOCK TABLES `paymenttransaction` WRITE; /*!40000 ALTER TABLE `paymenttransaction` DISABLE KEYS */; INSERT INTO `paymenttransaction` VALUES (1,'invoicetransaction'),(2,'invoicetransaction'),(3,'invoicetransaction'),(4,'invoicetransaction'),(5,'invoicetransaction'),(6,'invoicetransaction'),(7,'invoicetransaction'),(8,'invoicetransaction'),(9,'invoicetransaction'),(10,'invoicetransaction'),(11,'invoicetransaction'),(12,'invoicetransaction'),(13,'invoicetransaction'),(14,'invoicetransaction'),(15,'invoicetransaction'),(16,'invoicetransaction'); /*!40000 ALTER TABLE `paymenttransaction` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `products` -- DROP TABLE IF EXISTS `products`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `products` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `Name` text COLLATE utf8mb4_unicode_ci, `Description` text COLLATE utf8mb4_unicode_ci, `Price` decimal(10,2) DEFAULT '0.00', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `ProductNo` text COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `products` -- LOCK TABLES `products` WRITE; /*!40000 ALTER TABLE `products` DISABLE KEYS */; INSERT INTO `products` VALUES (1,'Admin Super Reseller Credit','Admin Super Reseller Credit',3.00,'2019-12-15 23:45:23','2019-12-25 09:33:55','EP1001'),(2,'Main Super Reseller Credit 4.75','Main Super Reseller Credit 4.75',4.75,'2019-12-19 04:34:17','2019-12-25 09:53:14','EP1002'),(3,'Main Super Reseller Credit 5.00','Main Super Reseller Credit 5.00',5.00,'2019-12-19 04:35:19','2019-12-25 09:55:22','EP1003'),(4,'Reseller Credit 5.50','Reseller Credit 5.50',5.50,'2019-12-19 04:35:57','2019-12-25 09:58:01','EP1004'),(5,'Box - Mag322','Box - Mag322',72.00,'2019-12-25 09:37:10','2019-12-25 09:41:52','EP1005'),(6,'Box - Mag322 w1','Box - Mag322 w1',75.00,'2019-12-25 09:42:49','2020-01-03 22:17:31','EP1006'),(7,'Box - Mag324 w2','Box - Mag324 w2',105.00,'2019-12-25 09:43:48','2019-12-25 09:43:48','EP1007'),(8,'Box - Mag420 w1','Box - Mag420 w1',115.00,'2019-12-25 09:45:19','2019-12-25 09:45:19','EP1008'),(9,'Ipguys','Ipguys',6.00,'2019-12-25 10:01:30','2019-12-25 10:01:30','EP1009'),(10,'Reseller Credit 6.00','Reseller Credit 6.00',6.00,'2019-12-25 10:03:46','2019-12-25 10:21:33','EP1010'),(11,'Reseller Credit 4.00','Reseller Credit 4.00',4.00,'2019-12-25 10:31:15','2019-12-25 10:31:15','EP1011'),(12,'Remote 5.00','Remote 5.00',5.00,'2019-12-25 10:37:12','2019-12-25 10:37:53','EP1012'),(13,'Remote 10.00','Rermote 10.00',10.00,'2019-12-25 10:37:41','2019-12-25 10:37:41','EP1013'),(14,'Wifi Ext','Wifi Ext',25.00,'2019-12-25 10:38:20','2019-12-25 10:38:20','EP1014'),(15,'Wifi USB','Wifi USB',10.00,'2019-12-25 10:38:50','2019-12-25 10:38:50','EP1015'),(16,'Formuler Z7','Formuler Z7',95.00,'2019-12-27 00:25:00','2019-12-27 00:25:00','EP1016'),(17,'Patel - Nov 19th - Dec 25th','Patel - Nov 19th - Dec 25th',1.00,'2019-12-28 12:59:40','2019-12-28 12:59:40','EP1017'),(18,'Main Super Reseller Credit 4.50','Main Super Reseller Credit 4.50',4.50,'2020-01-01 15:58:27','2020-01-01 15:58:27','EP1018'); /*!40000 ALTER TABLE `products` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tests` -- DROP TABLE IF EXISTS `tests`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tests` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `Name` text COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tests` -- LOCK TABLES `tests` WRITE; /*!40000 ALTER TABLE `tests` DISABLE KEYS */; INSERT INTO `tests` VALUES (1,'senthu',NULL,NULL),(2,'saran',NULL,NULL); /*!40000 ALTER TABLE `tests` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `transaction_last_ids` -- DROP TABLE IF EXISTS `transaction_last_ids`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `transaction_last_ids` ( `id` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `transaction_last_ids` -- LOCK TABLES `transaction_last_ids` WRITE; /*!40000 ALTER TABLE `transaction_last_ids` DISABLE KEYS */; INSERT INTO `transaction_last_ids` VALUES (1132); /*!40000 ALTER TABLE `transaction_last_ids` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `transactions` -- DROP TABLE IF EXISTS `transactions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `transactions` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `CustomerId` int(11) DEFAULT NULL, `Description` text COLLATE utf8mb4_unicode_ci, `Date` text COLLATE utf8mb4_unicode_ci, `Debit` decimal(10,2) DEFAULT NULL, `Credit` decimal(10,2) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `InvoiceTransaction` int(11) DEFAULT NULL, `TransactionNo` text COLLATE utf8mb4_unicode_ci, `PaymentTransaction` int(11) DEFAULT NULL, `TransactionType` text COLLATE utf8mb4_unicode_ci, `OpeningTransaction` int(11) DEFAULT NULL, `Note` varchar(3000) COLLATE utf8mb4_unicode_ci DEFAULT 'N/A', `InvoicePayment` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=132 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `transactions` -- LOCK TABLES `transactions` WRITE; /*!40000 ALTER TABLE `transactions` DISABLE KEYS */; INSERT INTO `transactions` VALUES (6,3,'Opening Balance','2019-12-25',0.00,0.00,'2019-12-25 09:21:52','2019-12-25 09:21:52',NULL,'ETT1006',NULL,'OBL',3,'N/A',NULL),(7,3,'Invoice->(ETI1003)','2019-12-25',0.00,5.50,'2019-12-25 09:23:39','2019-12-25 09:23:39',3,'ETT1007',NULL,'INV',NULL,'N/A',NULL),(9,3,'Invoice->(ETI1005)','2019-12-25',0.00,-0.25,'2019-12-25 10:10:40','2019-12-25 10:10:40',5,'ETT1009',NULL,'INV',NULL,'N/A',NULL),(10,4,'Opening Balance','2019-12-25',0.00,24250.00,'2019-12-25 10:36:41','2019-12-25 10:36:41',NULL,'ETT1010',NULL,'OBL',4,'N/A',NULL),(12,4,'Payment->(ETP1002)','2019-12-25',2500.00,0.00,'2019-12-25 10:56:31','2019-12-25 10:56:31',NULL,'ETT1012',2,'PAY',NULL,'N/A',NULL),(13,4,'Payment->(ETP1003)','2019-12-25',2250.00,0.00,'2019-12-25 10:57:35','2019-12-25 10:57:35',NULL,'ETT1013',3,'PAY',NULL,'N/A',NULL),(14,4,'Invoice->(ETI1008)','2019-12-25',0.00,4000.00,'2019-12-25 10:58:47','2019-12-25 10:58:47',8,'ETT1014',NULL,'INV',NULL,'N/A',NULL),(15,4,'Payment->(ETP1004)','2019-12-25',1600.00,0.00,'2019-12-25 10:59:31','2019-12-25 10:59:31',NULL,'ETT1015',4,'PAY',NULL,'N/A',NULL),(16,4,'Invoice->(ETI1009)','2019-12-25',0.00,1680.00,'2019-12-25 11:08:49','2019-12-25 11:08:49',9,'ETT1016',NULL,'INV',NULL,'N/A',NULL),(17,4,'Payment->(ETP1005)','2019-12-25',1420.00,0.00,'2019-12-25 11:09:21','2019-12-25 11:09:21',NULL,'ETT1017',5,'PAY',NULL,'N/A',NULL),(18,4,'Invoice->(ETI1010)','2019-12-25',0.00,60.00,'2019-12-25 11:09:58','2019-12-25 11:09:58',10,'ETT1018',NULL,'INV',NULL,'N/A',NULL),(19,4,'Invoice->(ETI1011)','2019-12-25',0.00,4000.00,'2019-12-25 11:10:57','2019-12-25 11:10:57',11,'ETT1019',NULL,'INV',NULL,'N/A',NULL),(20,4,'Payment->(ETP1006)','2019-12-25',1600.00,0.00,'2019-12-25 11:11:31','2019-12-25 11:11:31',NULL,'ETT1020',6,'PAY',NULL,'N/A',NULL),(21,4,'Invoice->(ETI1012)','2019-12-25',0.00,1135.00,'2019-12-25 11:12:58','2019-12-25 11:12:58',12,'ETT1021',NULL,'INV',NULL,'N/A',NULL),(22,4,'Owing->(ETP1007)','2019-12-25',190.00,0.00,'2019-12-25 11:14:01','2019-12-25 11:14:01',NULL,'ETT1022',7,'PAY',NULL,'N/A',NULL),(23,4,'Payment->(ETP1008)','2019-12-25',1600.00,0.00,'2019-12-25 11:15:23','2019-12-25 11:15:23',NULL,'ETT1023',8,'PAY',NULL,'N/A',NULL),(24,4,'Payment->(ETP1009)','2019-12-25',1900.00,0.00,'2019-12-25 11:16:03','2019-12-25 11:16:03',NULL,'ETT1024',9,'PAY',NULL,'N/A',NULL),(25,4,'Payment->(ETP1010)','2019-12-25',900.00,0.00,'2019-12-25 11:16:25','2019-12-25 11:16:25',NULL,'ETT1025',10,'PAY',NULL,'N/A',NULL),(26,4,'Invoice->(ETI1013)','2019-12-25',0.00,4000.00,'2019-12-25 11:17:20','2019-12-25 11:17:20',13,'ETT1026',NULL,'INV',NULL,'N/A',NULL),(27,4,'Payment->(ETP1011)','2019-12-25',2500.00,0.00,'2019-12-25 11:17:46','2019-12-25 11:17:46',NULL,'ETT1027',11,'PAY',NULL,'N/A',NULL),(28,4,'Payment->(ETP1012)','2019-12-25',1500.00,0.00,'2019-12-25 11:18:14','2019-12-25 11:18:14',NULL,'ETT1028',12,'PAY',NULL,'N/A',NULL),(29,4,'Invoice->(ETI1014)','2019-12-25',0.00,1800.00,'2019-12-25 11:27:08','2019-12-25 11:27:08',14,'ETT1029',NULL,'INV',NULL,'N/A',NULL),(39,3,'Invoice->(ETI1017)','2019-12-27',0.00,270.00,'2019-12-27 00:38:56','2019-12-27 00:38:56',17,'ETT1039',NULL,'INV',NULL,'N/A',NULL),(31,4,'Payment->(ETP1013)','2019-12-25',393.00,0.00,'2019-12-25 11:31:19','2019-12-25 11:31:19',NULL,'ETT1031',13,'PAY',NULL,'N/A',NULL),(32,4,'Payment->(ETP1014)','2019-12-25',685.00,0.00,'2019-12-25 11:36:45','2019-12-25 11:36:45',NULL,'ETT1032',14,'PAY',NULL,'N/A',NULL),(33,5,'Opening Balance','2019-12-25',0.00,12573.00,'2019-12-25 13:14:36','2019-12-25 13:14:36',NULL,'ETT1033',NULL,'OBL',5,'N/A',NULL),(34,6,'Opening Balance','2019-12-25',0.00,10124.00,'2019-12-25 14:18:53','2019-12-25 14:18:53',NULL,'ETT1034',NULL,'OBL',6,'N/A',NULL),(35,7,'Opening Balance','2019-12-25',0.00,45968.75,'2019-12-25 19:00:35','2019-12-25 19:00:35',NULL,'ETT1035',NULL,'OBL',7,'N/A',NULL),(36,8,'Opening Balance','2019-12-26',0.00,3487.50,'2019-12-26 00:07:57','2019-12-26 00:07:57',NULL,'ETT1036',NULL,'OBL',8,'N/A',NULL),(37,9,'Opening Balance','2019-12-26',0.00,960.00,'2019-12-26 11:02:37','2019-12-26 11:02:37',NULL,'ETT1037',NULL,'OBL',9,'N/A',NULL),(38,9,'Invoice->(ETI1016)','2019-12-27',0.00,-175.00,'2019-12-27 00:26:52','2019-12-27 00:26:52',16,'ETT1038',NULL,'INV',NULL,'N/A',NULL),(40,3,'Invoice->(ETI1018)','2019-12-27',0.00,-270.00,'2019-12-27 00:40:26','2019-12-27 00:40:26',18,'ETT1040',NULL,'INV',NULL,'N/A',NULL),(41,3,'Invoice->(ETI1019)','2019-12-27',0.00,475.00,'2019-12-27 01:12:50','2019-12-27 01:12:50',19,'ETT1041',NULL,'INV',NULL,'N/A',NULL),(42,3,'Invoice->(ETI1020)','2019-12-27',0.00,475.00,'2019-12-27 01:12:51','2019-12-27 01:12:51',20,'ETT1042',NULL,'INV',NULL,'N/A',NULL),(43,3,'Invoice->(ETI1021)','2019-12-27',0.00,720.00,'2019-12-27 01:13:54','2019-12-27 01:13:54',21,'ETT1043',NULL,'INV',NULL,'N/A',NULL),(44,10,'Opening Balance','2019-12-27',0.00,75.00,'2019-12-27 03:16:27','2019-12-27 03:16:27',NULL,'ETT1044',NULL,'OBL',10,'N/A',NULL),(45,10,'Invoice->(ETI1022)','2019-12-27',0.00,700.00,'2019-12-27 03:17:29','2019-12-27 03:17:29',22,'ETT1045',NULL,'INV',NULL,'N/A',NULL),(46,10,'Invoice->(ETI1023)','2019-12-27',0.00,150.00,'2019-12-27 03:18:58','2019-12-27 03:18:58',23,'ETT1046',NULL,'INV',NULL,'N/A',NULL),(59,10,'Invoice->(ETI1029)','2019-12-31',0.00,705.00,'2019-12-31 06:48:30','2019-12-31 06:48:30',29,'ETT1059',NULL,'INV',NULL,'N/A',NULL),(48,7,'Payment->(ETP1015)','2019-12-27',900.00,0.00,'2019-12-27 16:22:16','2019-12-27 16:22:16',NULL,'ETT1048',15,'PAY',NULL,'N/A',NULL),(49,7,'Payment->(ETP1016)','2019-12-27',1000.00,0.00,'2019-12-27 18:53:08','2019-12-27 18:53:08',NULL,'ETT1049',16,'PAY',NULL,'N/A',NULL),(50,7,'Invoice->(ETI1025)','2019-12-28',0.00,1062.00,'2019-12-28 13:01:35','2019-12-28 13:01:35',25,'ETT1050',NULL,'INV',NULL,'N/A',NULL),(51,10,'Invoice->(ETI1026)','2019-12-30',0.00,441.00,'2019-12-30 06:56:21','2019-12-30 06:56:21',26,'ETT1051',NULL,'INV',NULL,'N/A',NULL),(52,10,'Payment->(ETP1017)','2019-12-30',426.00,0.00,'2019-12-30 07:03:33','2019-12-30 07:03:33',NULL,'ETT1052',17,'PAY',NULL,'N/A',NULL),(53,10,'Invoice->(ETI1027)','2019-12-30',0.00,890.00,'2019-12-30 07:22:25','2019-12-30 07:22:25',27,'ETT1053',NULL,'INV',NULL,'N/A',NULL),(54,10,'Payment->(ETP1018)','2019-12-30',450.00,0.00,'2019-12-30 07:24:44','2019-12-30 07:24:44',NULL,'ETT1054',18,'PAY',NULL,'N/A',NULL),(63,3,'Payment->(ETP1023)','2019-12-31',196.25,0.00,'2019-12-31 16:49:33','2019-12-31 16:49:33',NULL,'ETT1063',23,'PAY',NULL,'N/A',NULL),(62,3,'Invoice->(ETI1030)','2019-12-31',0.00,121.00,'2019-12-31 16:46:58','2019-12-31 16:46:58',30,'ETT1062',NULL,'INV',NULL,'N/A',NULL),(61,7,'Payment->(ETP1022)','2019-12-31',340.00,0.00,'2019-12-31 16:40:47','2019-12-31 16:40:47',NULL,'ETT1061',22,'PAY',NULL,'N/A',NULL),(60,7,'Payment->(ETP1021)','2019-12-31',1000.00,0.00,'2019-12-31 16:38:44','2019-12-31 16:38:44',NULL,'ETT1060',21,'PAY',NULL,'N/A',NULL),(64,3,'Invoice->(ETI1031)','2019-12-31',0.00,2100.00,'2019-12-31 16:54:26','2019-12-31 16:54:26',31,'ETT1064',NULL,'INV',NULL,'N/A',NULL),(65,12,'Opening Balance','2020-01-01',0.00,1064.00,'2020-01-01 15:55:40','2020-01-01 15:55:40',NULL,'ETT1065',NULL,'OBL',12,'N/A',NULL),(66,12,'Invoice->(ETI1032)','2020-01-01',0.00,2466.00,'2020-01-01 15:59:56','2020-01-01 15:59:56',32,'ETT1066',NULL,'INV',NULL,'N/A',NULL),(67,12,'Invoice->(ETI1033)','2020-01-01',0.00,2485.00,'2020-01-01 16:01:23','2020-01-01 16:01:23',33,'ETT1067',NULL,'INV',NULL,'N/A',NULL),(68,4,'Invoice->(ETI1034)','2020-01-01',0.00,120.00,'2020-01-01 20:19:58','2020-01-01 20:19:58',34,'ETT1068',NULL,'INV',NULL,'N/A',NULL),(69,7,'Payment->(ETP1024)','2020-01-03',262.00,0.00,'2020-01-03 09:16:45','2020-01-03 09:16:45',NULL,'ETT1069',24,'PAY',NULL,'N/A',NULL),(70,9,'Invoice->(ETI1035)','2020-01-03',0.00,75.00,'2020-01-03 22:18:51','2020-01-03 22:18:51',35,'ETT1070',NULL,'INV',NULL,'N/A',NULL),(71,9,'Invoice->(ETI1036)','2020-01-04',0.00,150.00,'2020-01-04 00:28:15','2020-01-04 00:28:15',37,'ETT1071',NULL,'INV',NULL,'N/A',NULL),(72,9,'Payment->(ETP1025)','2020-01-04',200.00,0.00,'2020-01-04 00:28:57','2020-01-04 00:28:57',NULL,'ETT1072',25,'PAY',NULL,'N/A',NULL),(73,9,'Payment->(ETP1026)','2020-01-04',100.00,0.00,'2020-01-04 01:09:55','2020-01-04 01:09:55',NULL,'ETT1073',26,'PAY',NULL,'N/A',NULL),(74,6,'Payment->(ETP1027)','2020-01-04',1480.00,0.00,'2020-01-04 01:56:39','2020-01-04 01:56:39',NULL,'ETT1074',27,'PAY',NULL,'N/A',NULL),(75,7,'Payment->(ETP1028)','2020-01-04',1000.00,0.00,'2020-01-04 23:33:15','2020-01-04 23:33:15',NULL,'ETT1075',28,'PAY',NULL,'N/A',NULL),(76,7,'Payment->(ETP1029)','2020-01-04',500.00,0.00,'2020-01-04 23:34:02','2020-01-04 23:34:02',NULL,'ETT1076',29,'PAY',NULL,'N/A',NULL),(77,5,'Payment->(ETP1030)','2020-01-05',2000.00,0.00,'2020-01-05 03:20:23','2020-01-05 03:20:23',NULL,'ETT1077',30,'PAY',NULL,'N/A',NULL),(78,7,'Payment->(ETP1031)','2020-01-05',570.00,0.00,'2020-01-05 03:33:44','2020-01-05 03:33:44',NULL,'ETT1078',31,'PAY',NULL,'N/A',NULL),(79,10,'Invoice->(ETI1037)','2020-01-05',0.00,475.00,'2020-01-05 19:02:36','2020-01-05 19:02:36',38,'ETT1079',NULL,'INV',NULL,'N/A',NULL),(80,5,'Payment->(ETP1032)','2020-01-05',1050.00,0.00,'2020-01-05 20:07:00','2020-01-05 20:07:00',NULL,'ETT1080',32,'PAY',NULL,'N/A',NULL),(81,7,'Payment->(ETP1033)','2020-01-05',500.00,0.00,'2020-01-05 22:27:16','2020-01-05 22:27:16',NULL,'ETT1081',33,'PAY',NULL,'N/A',NULL),(82,7,'Payment->(ETP1034)','2020-01-05',2800.00,0.00,'2020-01-05 22:27:54','2020-01-05 22:27:54',NULL,'ETT1082',34,'PAY',NULL,'N/A',NULL),(83,7,'Payment->(ETP1035)','2020-01-05',263.00,0.00,'2020-01-05 22:29:00','2020-01-05 22:29:00',NULL,'ETT1083',35,'PAY',NULL,'N/A',NULL),(84,8,'Invoice->(ETI1038)','2020-01-06',0.00,500.00,'2020-01-06 12:04:10','2020-01-06 12:04:10',39,'ETT1084',NULL,'INV',NULL,'N/A',NULL),(85,8,'Payment->(ETP1036)','2020-01-06',1500.00,0.00,'2020-01-06 12:11:49','2020-01-06 12:11:49',NULL,'ETT1085',36,'PAY',NULL,'N/A',NULL),(86,9,'Payment->(ETP1037)','2020-01-07',600.00,0.00,'2020-01-07 01:24:41','2020-01-07 01:24:41',NULL,'ETT1086',37,'PAY',NULL,'N/A',NULL),(87,6,'Payment->(ETP1038)','2020-01-07',600.00,0.00,'2020-01-07 01:25:22','2020-01-07 01:25:22',NULL,'ETT1087',38,'PAY',NULL,'N/A',NULL),(88,9,'Invoice->(ETI1039)','2020-01-07',0.00,250.00,'2020-01-07 01:32:24','2020-01-07 01:32:24',40,'ETT1088',NULL,'INV',NULL,'N/A',NULL),(89,5,'Invoice->(ETI1040)','2020-01-07',0.00,194.00,'2020-01-07 03:48:11','2020-01-07 03:48:11',41,'ETT1089',NULL,'INV',NULL,'N/A',NULL),(90,5,'Payment->(ETP1039)','2020-01-07',240.00,0.00,'2020-01-07 03:50:12','2020-01-07 03:50:12',NULL,'ETT1090',39,'PAY',NULL,'N/A',NULL),(91,5,'Invoice->(ETI1041)','2020-01-08',0.00,300.00,'2020-01-08 01:18:26','2020-01-08 01:18:26',42,'ETT1091',NULL,'INV',NULL,'N/A',NULL),(92,5,'Payment->(ETP1040)','2020-01-08',750.00,0.00,'2020-01-08 01:19:06','2020-01-08 01:19:06',NULL,'ETT1092',40,'PAY',NULL,'N/A',NULL),(93,5,'Payment->(ETP1041)','2020-01-08',200.00,0.00,'2020-01-08 22:46:37','2020-01-08 22:46:37',NULL,'ETT1093',41,'PAY',NULL,'N/A',NULL),(94,5,'Invoice->(ETI1042)','2020-01-10',0.00,450.00,'2020-01-10 01:19:38','2020-01-10 01:19:38',43,'ETT1094',NULL,'INV',NULL,'N/A',NULL),(95,5,'Payment->(ETP1042)','2020-01-10',400.00,0.00,'2020-01-10 01:20:42','2020-01-10 01:20:42',NULL,'ETT1095',42,'PAY',NULL,'N/A',NULL),(96,5,'Owing->(ETP1043)','2020-01-10',375.00,0.00,'2020-01-10 01:56:21','2020-01-10 01:56:21',NULL,'ETT1096',43,'PAY',NULL,'N/A',NULL),(97,7,'Payment->(ETP1044)','2020-01-11',1000.00,0.00,'2020-01-11 22:12:01','2020-01-11 22:12:01',NULL,'ETT1097',44,'PAY',NULL,'N/A',NULL),(98,7,'Payment->(ETP1045)','2020-01-11',1005.00,0.00,'2020-01-11 23:23:21','2020-01-11 23:23:21',NULL,'ETT1098',45,'PAY',NULL,'N/A',NULL),(99,6,'Payment->(ETP1046)','2020-01-13',1150.00,0.00,'2020-01-13 03:10:44','2020-01-13 03:10:44',NULL,'ETT1099',46,'PAY',NULL,'N/A',NULL),(100,7,'Payment->(ETP1047)','2020-01-16',575.00,0.00,'2020-01-16 05:25:58','2020-01-16 05:25:58',NULL,'ETT1100',47,'PAY',NULL,'N/A',NULL),(101,4,'Invoice->(ETI1043)','2020-01-16',0.00,5000.00,'2020-01-16 05:33:27','2020-01-16 05:33:27',44,'ETT1101',NULL,'INV',NULL,'N/A',NULL),(102,9,'Invoice->(ETI1044)','2020-01-17',0.00,225.00,'2020-01-17 00:17:55','2020-01-17 00:17:55',45,'ETT1102',NULL,'INV',NULL,'N/A',NULL),(103,9,'Payment->(ETP1048)','2020-01-17',360.00,0.00,'2020-01-17 03:36:38','2020-01-17 03:36:38',NULL,'ETT1103',48,'PAY',NULL,'N/A',NULL),(104,5,'Payment->(ETP1049)','2020-01-17',870.00,0.00,'2020-01-17 03:56:11','2020-01-17 03:56:11',NULL,'ETT1104',49,'PAY',NULL,'N/A',NULL),(105,7,'Invoice->(ETI1045)','2020-01-18',0.00,237.50,'2020-01-18 01:41:32','2020-01-18 01:41:32',46,'ETT1105',NULL,'INV',NULL,'N/A',NULL),(106,7,'Payment->(ETP1050)','2020-01-18',300.00,0.00,'2020-01-18 01:47:15','2020-01-18 01:47:15',NULL,'ETT1106',50,'PAY',NULL,'N/A',NULL),(107,7,'Payment->(ETP1051)','2020-01-18',263.00,0.00,'2020-01-19 02:12:45','2020-01-19 02:12:45',NULL,'ETT1107',51,'PAY',NULL,'N/A',NULL),(108,12,'Payment->(ETP1052)','2020-01-20',3000.00,0.00,'2020-01-20 00:15:39','2020-01-20 00:15:39',NULL,'ETT1108',52,'PAY',NULL,'N/A',NULL),(109,4,'Payment->(ETP1053)','2020-01-20',3900.00,0.00,'2020-01-20 03:29:40','2020-01-20 03:29:40',NULL,'ETT1109',53,'PAY',NULL,'N/A',NULL),(110,9,'Invoice->(ETI1046)','2020-01-20',0.00,250.00,'2020-01-20 18:23:06','2020-01-20 18:23:06',47,'ETT1110',NULL,'INV',NULL,'N/A',NULL),(111,7,'Invoice->(ETI1047)','2020-01-21',0.00,4750.00,'2020-01-21 01:52:33','2020-01-21 01:52:33',48,'ETT1111',NULL,'INV',NULL,'N/A',NULL),(112,7,'Payment->(ETP1054)','2020-01-20',500.00,0.00,'2020-01-21 01:53:25','2020-01-21 01:53:25',NULL,'ETT1112',54,'PAY',NULL,'N/A',NULL),(113,7,'Invoice->(ETI1048)','2020-01-21',0.00,18924.00,'2020-01-21 15:26:18','2020-01-21 15:26:18',49,'ETT1113',NULL,'INV',NULL,'N/A',NULL),(114,6,'Payment->(ETP1055)','2020-01-22',1110.00,0.00,'2020-01-22 01:53:58','2020-01-22 01:53:58',NULL,'ETT1114',55,'PAY',NULL,'N/A',NULL),(115,9,'Payment->(ETP1056)','2020-01-23',200.00,0.00,'2020-01-23 01:51:49','2020-01-23 01:51:49',NULL,'ETT1115',56,'PAY',NULL,'N/A',NULL),(116,6,'Invoice->(ETI1049)','2020-01-23',0.00,500.00,'2020-01-23 01:52:57','2020-01-23 01:52:57',50,'ETT1116',NULL,'INV',NULL,'N/A',NULL),(117,9,'Invoice->(ETI1050)','2020-01-22',0.00,50.00,'2020-01-23 02:13:06','2020-01-23 02:13:06',51,'ETT1117',NULL,'INV',NULL,'N/A',NULL),(118,10,'Invoice->(ETI1051)','2020-01-31',0.00,375.00,'2020-01-31 00:37:26','2020-01-31 00:37:26',52,'ETT1118',NULL,'INV',NULL,'N/A',NULL),(119,10,'Payment->(ETP1057)','2020-01-31',225.00,0.00,'2020-01-31 00:37:28','2020-01-31 00:37:28',NULL,'ETT1119',57,'PAY',NULL,'Test',52),(120,10,'Invoice->(ETI1052)','2020-02-01',0.00,275.00,'2020-02-01 02:36:24','2020-02-01 02:36:24',53,'ETT1120',NULL,'INV',NULL,'Inv Note',NULL),(121,10,'Payment->(ETP1058)','2020-02-01',275.00,0.00,'2020-02-01 02:36:24','2020-02-01 02:36:24',NULL,'ETT1121',58,'PAY',NULL,'Pay Note',53),(122,10,'Invoice->(ETI1053)','2020-02-01',0.00,60.00,'2020-02-01 02:39:39','2020-02-01 02:39:39',54,'ETT1122',NULL,'INV',NULL,'invoice note',NULL),(123,10,'Payment->(ETP1059)','2020-02-01',60.00,0.00,'2020-02-01 02:39:39','2020-02-01 02:39:39',NULL,'ETT1123',59,'PAY',NULL,'Pay Note',54),(124,10,'Payment->(ETP1060)','2020-02-01',710.00,0.00,'2020-02-01 02:48:02','2020-02-01 02:48:02',NULL,'ETT1124',60,'PAY',NULL,'On behalf of Ram.',NULL),(125,10,'Invoice->(ETI1054)','2020-02-01',0.00,285.00,'2020-02-01 02:50:42','2020-02-01 02:50:42',55,'ETT1125',NULL,'INV',NULL,'Box will be delivered on 3rd Feb.',NULL),(126,10,'Invoice->(ETI1055)','2020-02-01',0.00,330.00,'2020-02-01 03:01:32','2020-02-01 03:01:32',56,'ETT1126',NULL,'INV',NULL,'will be delivered on 5th Feb',NULL),(127,10,'Invoice->(ETI1056)','2020-02-01',0.00,30.00,'2020-02-01 03:04:14','2020-02-01 03:04:14',57,'ETT1127',NULL,'INV',NULL,'test',NULL),(128,3,'Invoice->(ETI1057)','2020-02-01',0.00,5.00,'2020-02-01 06:01:58','2020-02-01 06:01:58',58,'ETT1128',NULL,'INV',NULL,'N/A',NULL),(129,3,'Payment->(ETP1061)','2020-02-01',5.00,0.00,'2020-02-01 06:02:42','2020-02-01 06:02:42',NULL,'ETT1129',61,'PAY',NULL,'N/A',NULL),(131,9,'Invoice->(ETI1059)','2020-02-02',0.00,250.00,'2020-02-02 09:46:50','2020-02-02 09:46:50',61,'ETT1131',NULL,'INV',NULL,'N/A',NULL); /*!40000 ALTER TABLE `transactions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `users` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `remember_token` text COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `users` -- LOCK TABLES `users` WRITE; /*!40000 ALTER TABLE `users` DISABLE KEYS */; INSERT INTO `users` VALUES (1,'Sarvesh','spoopalasingam@gmail.com','$2y$10$3.ivAvPH8O27ZvU0BUZ4gOXRd0y67m8goHmxvkBzdO6erD7SXjWEW','2019-09-11 05:30:11','2019-12-19 04:31:15','d37V4Myw1z330O3j2i4107h3c23fVIxyg0fdzUKXT7gDVF9eu2xCri3l9E9Z'); /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2020-02-02 23:25:55