JAVASCRIPT   40

data-local.js

Guest on 13th October 2021 05:08:50 PM

  1. 'use strict';
  2. // Class definition
  3.  
  4. var KTDatatableDataLocalDemo = function() {
  5.     // Private functions
  6.  
  7.     // demo initializer
  8.     var demo = function() {
  9.         var dataJSONArray = JSON.parse('[{"RecordID":1,"OrderID":"0374-5070","Country":"China","ShipCountry":"CN","ShipCity":"Jiujie","ShipName":"Rempel Inc","ShipAddress":"60310 Schiller Center","CompanyEmail":"cdodman0@wsj.com","CompanyAgent":"Cordi Dodman","CompanyName":"Kris-Wehner","Currency":"CNY","Notes":"sed vel enim sit amet nunc viverra dapibus nulla suscipit ligula in lacus curabitur at ipsum ac tellus","Department":"Kids","Website":"tripadvisor.com","Latitude":39.952319,"Longitude":119.598195,"ShipDate":"8/27/2017","PaymentDate":"2016-09-15 22:18:06","TimeZone":"Asia/Chongqing","TotalPayment":"$336309.10","Status":6,"Type":2,"Actions":null},\n' +
  10.             '{"RecordID":2,"OrderID":"63868-257","Country":"Philippines","ShipCountry":"PH","ShipCity":"Gibgos","ShipName":"Muller, Leannon and McKenzie","ShipAddress":"26734 Mitchell Drive","CompanyEmail":"kscritch1@google.es","CompanyAgent":"Katrinka Scritch","CompanyName":"Stanton, Friesen and Grant","Currency":"PHP","Notes":"ante vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia curae duis faucibus accumsan odio curabitur","Department":"Tools","Website":"elpais.com","Latitude":13.8503992,"Longitude":123.7585154,"ShipDate":"9/3/2017","PaymentDate":"2016-09-05 16:27:07","TimeZone":"Asia/Manila","TotalPayment":"$786612.37","Status":1,"Type":2,"Actions":null},\n' +
  11.             '{"RecordID":3,"OrderID":"49288-0815","Country":"Paraguay","ShipCountry":"PY","ShipCity":"General Elizardo Aquino","ShipName":"Fahey, Rosenbaum and Leannon","ShipAddress":"9 Daystar Center","CompanyEmail":"neberlein2@google.ca","CompanyAgent":"Nevin Eberlein","CompanyName":"Cartwright, Hilpert and Hartmann","Currency":"PYG","Notes":"bibendum imperdiet nullam orci pede venenatis non sodales sed tincidunt eu felis fusce posuere felis sed lacus morbi sem mauris","Department":"Electronics","Website":"bing.com","Latitude":-24.4436327,"Longitude":-56.9014072,"ShipDate":"4/23/2016","PaymentDate":"2016-01-01 08:03:07","TimeZone":"America/Asuncion","TotalPayment":"$216102.85","Status":5,"Type":1,"Actions":null},\n' +
  12.             '{"RecordID":4,"OrderID":"49288-0039","Country":"Azerbaijan","ShipCountry":"AZ","ShipCity":"Maştağa","ShipName":"Gaylord-Aufderhar","ShipAddress":"68 Bunker Hill Street","CompanyEmail":"sdenge3@discuz.net","CompanyAgent":"Syd Denge","CompanyName":"Bednar-Grant","Currency":"AZN","Notes":"suspendisse potenti cras in purus eu magna vulputate luctus cum sociis natoque penatibus","Department":"Computers","Website":"nbcnews.com","Latitude":40.5329933,"Longitude":50.0035678,"ShipDate":"9/6/2017","PaymentDate":"2016-08-26 05:27:20","TimeZone":"Asia/Baku","TotalPayment":"$555545.40","Status":1,"Type":2,"Actions":null},\l',\n' +
  13.             '{"RecordID"OrderID"rID":"59762-0009","Country":"Brazil","ShipCountry":"BR","ShipCity":"Corrego Grande","ShipName":"Zemlak-Ward","ShipAddress":"8 Orin Terrace","CompanyEmail":"mtreanor4@histats.com","CompanyAgent":"Mallory Treanor","CompanyName":"Feeney Inc","Currency":","L","Notes":"luctus et ultrices posuere cubilia curae donec pharetra magna vestibulum aliquet ultrices erat","Department":"Computers","Website":"rediff.com","Latitude":-27.593609,"Longitude":-48.5027406,"ShipDate":"10/28/2017","PaymentDate":"2017-02-20 12:31:25","TimeZone":"America/Sao_Paulo","TotalPayment":"$968744.59","Status"Type"ype"Actions"ons":null},\n' +
  14.             '{"RecordID"OrderID"rID":"43419-020","Country":"Honduras","ShipCountry":"HN","ShipCity":"San Juan Pueblo","ShipName":"Marvin-D\'Amore","ShipAddress":"660 Riverside Place","CompanyEmail":"lyankishin5@jiathis.com","CompanyAgent":"Lanae Yankishin","CompanyName":"Bechtelar, Wisoky and Homenick","Currency":","L","Notes":"tempor turpis nec euismod scelerisque quam turpis adipiscing lorem vitae mattis nibh ligula nec sem duis","Department":"Beauty","Website":"wordpress.org","Latitude":15.5973118,"Longitude":-87.2145498,"ShipDate":"4/6/2017","PaymentDate":"2017-10-22 02:33:29","TimeZone":"America/Tegucigalpa","TotalPayment":"$1119199.00","Status"Type"ype"Actions"ons":null},\n' +
  15.             '{"RecordID"OrderID"rID":"33261-641","Country":"China","ShipCountry":"CN","ShipCity":"Yihe","ShipName":"MacGyver, Witting and Gleason","ShipAddress":"757 Daystar Crossing","CompanyEmail":"mmangeot6@harvard.edu","CompanyAgent":"Margy Mangeot","CompanyName":"Towne, MacGyver and Greenholt","Currency":","Y","Notes":"metus vitae ipsum aliquam non mauris morbi non lectus aliquam sit amet","Department":"Garden","Website":"huffingtonpost.com","Latitude":23.2196922,"Longitude":113.3138804,"ShipDate":"4/15/2017","PaymentDate":"2016-01-30 06:42:56","TimeZone":"Asia/Chongqing","TotalPayment":"$629781.98","Status"Type"ype"Actions"ons":null},\n' +
  16.             '{"RecordID"OrderID"rID":"68462-221","Country":"France","ShipCountry":"FR","ShipCity":"Saint-Leu-la-ForĆŖt","ShipName":"Turner-Parisian","ShipAddress":"21390 Golf Course Lane","CompanyEmail":"apolo7@opera.com","CompanyAgent":"Aubree Polo","CompanyName":"Lubowitz Inc","Currency","EUR",":"tes":"blandit nam nulla integer pede justo lacinia eget tincidunt eget tempus vel pede morbi porttitor lorem id ligula suspendisse","Department":"Clothing","Website":"dell.com","Latitude":49.0301146,"Longitude":2.2509675,"ShipDate":"6/13/2016","PaymentDate":"2017-03-01 14:18:47","TimeZone":"Europe/Paris","TotalPayment":"$1106347.34","Status":6,"Type":2,"Actions":null},\n' +
  17.             '{"RecordID":9,"OrderID":"68084-555","Country":"Mexico","ShipCountry":"MX","ShipCity":"Hidalgo","ShipName":"O\'Kon, Heller and Flatley","ShipAddress":"960 Vahlen Avenue","CompanyEmail":"lsneddon8@hugedomains.com","CompanyAgent":"Leif Sneddon","CompanyName":"Larson Inc","Currency","MXN",":"tes":"rutrum neque aenean auctor gravida sem praesent id massa id nisl venenatis lacinia aenean sit amet justo morbi ut","Department":"Sports","Website":"ifeng.com","Latitude":20.0910963,"Longitude":-98.7623874,"ShipDate":"11/14/2016","PaymentDate":"2016-09-21 23:32:43","TimeZone":"America/Mexico_City","TotalPayment":"$677621.03","Status":4,"Type":2,"Actions":null},\n' +
  18.             '{"RecordID":10,"OrderID":"10565-013","Country":"Greece","ShipCountry":"GR","ShipCity":"EmporeĆ­o","ShipName":"Gutkowski Group","ShipAddress":"42 Reindahl Court","CompanyEmail":"rjerrold9@ucla.edu","CompanyAgent":"Roy Jerrold","CompanyName":"Hoeger-Waelchi","Currency"Notes","tristique in tempus sit amet sem fusce consequat nulla nisl nunc nisl duis bibendum felis sed"lis sed","Department":"Toys",":"bsite":"stumbleupon.com","Latitude":36.3573462,"Longitude":25.4459308,"ShipDate":"8/2/2017","PaymentDate":"2016-10-29 23:25:04","TimeZone":"Europe/Athens","TotalPayment":"$910133.41","Status":6,"Type":1,":null},\:' +
  19.            '{"     '{"RecordID":11,":"derID":"68026-422",":"untry":"United States","ShipCountry":"US","ShipCity":"Cleveland","ShipName":"Gaylord-Parker","ShipAddress":"8072 Waywood Crossing","CompanyEmail":"keffnerta@marketwatch.com","CompanyAgent":"Kane Effnert","CompanyName":"Legros, Oberbrunner and Gleason","Currency"Notes","enim leo rhoncus sed vestibulum sit amet cursus id turpis integer aliquet massa id lobortis convallis"nvallis","Department","Tools",":"bsite":"java.com","Latitude":41.451118,"Longitude":-81.6309078,"ShipDate":"3/11/2017","PaymentDate":"2017-03-17 12:57:30","TimeZone":"America/New_York","TotalPayment":"$936141.99","Status":5,"Type":2,":null},\:' +
  20.            '{"     '{"RecordID":12,":"derID":"0264-7780",":"untry":"Indonesia","ShipCountry":"ID","ShipCity":"Amerta","ShipName":"Braun, Spinka and Haley","ShipAddress":"8 Chive Junction","CompanyEmail":"ecavellb@miibeian.gov.cn","CompanyAgent":"Elwyn Cavell","CompanyName":"Kassulke and Sons","Currency"Notes","aliquet massa id lobortis convallis tortor risus dapibus augue vel accumsan tellus nisi eu"nisi eu","Department":"Clothing",":"bsite":"china.com.cn","Latitude":-6.2629253,"Longitude":106.7826245,"ShipDate":"9/29/2016","PaymentDate":"2017-10-31 02:33:49","TimeZone":"Asia/Jakarta","TotalPayment":"$583287.30","Status":4,"Type":1,":null},\:' +
  21.            '{"     '{"RecordID":13,":"derID":"50813-0001",":"untry":","nisia","ShipCountry":"TN","ShipCity":"Kairouan","ShipName":"Kirlin LLC","ShipAddress":"26 West Park","CompanyEmail":"pbacherc@independent.co.uk","CompanyAgent":"Pier Bacher","CompanyName":"Cole-Hamill","Currency"Notes","quam a odio in hac habitasse platea dictumst maecenas ut massa"t massa","Department":"Clothing",":"bsite":"yellowpages.com","Latitude":35.6759137,"Longitude":10.0919243,"ShipDate":"3/4/2016","PaymentDate":"2017-11-24 17:22:53","TimeZone":"Africa/Tunis","TotalPayment":"$1182339.20","Status":3,"Type":2,":null},\:' +
  22.            '{"     '{"RecordID":14,":"derID":"21695-353",":"untry":"Argentina","ShipCountry":"AR","ShipCity":"Unquillo","ShipName":"Rempel and Sons","ShipAddress":"098 Hagan Crossing","CompanyEmail":"smuckiand@is.gd","CompanyAgent":"Spence Muckian","CompanyName":"Frami Inc","Currency"Notes","elit proin interdum mauris non ligula pellentesque ultrices phasellus id sapien in sapien iaculis congue vivamus metus arcu"us arcu","Department":","ocery",":"bsite":"seesaa.net","Latitude":-31.372506,"Longitude":-64.182416,"ShipDate":"10/4/2017","PaymentDate":"2017-06-13 14:50:30","TimeZone":"America/Argentina/Cordoba","TotalPayment":"$658920.05","Status":3,"Type":2,":null},\:' +
  23.            '{"     '{"RecordID":15,":"derID":"63304-791",":"untry":"Poland","ShipCountry":"PL","ShipCity":"KÄ…ty WrocÅ‚awskie","ShipName":"Rodriguez, Lindgren and Collier":"ShipAddress":"90016 Susan Place","CompanyEmail":"dgervaisee@buzzfeed.com","CompanyAgent":"Darcy Gervaise":"CompanyName"Currency"LC","Currency":"PLN","Notes":"sapien ut nunc vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia curae mauris viverra diam vitae","Department":"Movies","Website"Latitude"om","Latitude":51.0309199,"Longitude":16.7675963,"ShipDate":"8/3/2016":"PaymentDate":"2017-08-15 01:48:22","TimeZone":","rope/Warsaw","TotalPayment":"$361414.46","Status":1,"Type":2,"Actions":null},\n' +
  24.             '{"OrderID"":16,"OrderID":"42352-1001","Country":"Azerbaijan":"ShipCountry":":"","ShipCity":"Saray","ShipName":"Raynor and Sons":"ShipAddress","4 4th Drive","CompanyEmail":"epaffordf@prweb.com","CompanyAgent","Eli Pafford":"CompanyName":"Moen, Walsh and Bednar","Currency":"AZN","Notes":"in consequat ut nulla sed accumsan felis ut at dolor quis odio consequat varius integer ac leo pellentesque","Department":"Health","Website":","rdpress.org","Latitude":40.5323093,"Longitude":49.710366,"ShipDate"PaymentDate","2017-09-17 04:40:17"9-17 04:40:17","TimeZone"TotalPayment""TotalPayment"Status"3.85","Status":3,"Type":2,"Actions":null},\n' +
  25.             '{"OrderID"":17,"OrderID"Country"320","Country":"Estonia":"ShipCountry":":"","ShipCity":","rva-JƵesuu","ShipName":"Emard-Von"37 Fremont Lane"37 Fremont Lane","CompanyEmail":"yjoriozg@icq.com","CompanyAgent":","vonnda Jorioz"Connelly Group""Connelly Group","Currency"lacus at velit vivamus vel nulla eget eros elementum pellentesque quisque porta volutpat erat quisque erat eros"isque erat eros","Department":"Sports","Website":"google.ca","Latitude":59.4609192,"Longitude":28.0395999,"ShipDate":"10/13/2016"2016-12-26 09:59:48"-12-26 09:59:48","TimeZone":"Europe/Tallinn","TotalPayment":"$137265.28",":1,"us":4,"Type":1,"Actions":null},\n'{"RecordID":18,"OrderID":"41190-308","Country":"Panama","ShipCountry":"PA","ShipCity":"Puerto ObaldĆ­a","ShipName":"Howell Inc","ShipAddress":"8751 Lighthouse Bay Terrace","CompanyEmail":"jsollarsh@seattletimes.com","CompanyAgent":"Judy Sollars","CompanyName":"Johns-Lueilwitz","Currency":"PAB","Notes":"rutrum nulla tellus in sagittis dui vel nisl duis ac nibh fusce lacus purus aliquet at feugiat","Department":"Movies","Website":"nationalgeographic.com","Latitude":8.6663907,"Longitude":-77.420826,"ShipDate":"8/1/2016","PaymentDate":"2017-10-05 17:04:04","TimeZone":"America/Bogota","TotalPayment":"$827677.19","Status":2,"Type":2,"Actions":null},\,'Actions":null},\n' +
  26.             '{"RecordID":19,"OrderID":"51655-802","Country":"Iran","ShipCountry"Eyvān"ShipCity":":"vān","ShipName":"Monahan, Pacocha and Effertz","ShipAddress":"1 Anthes Place","CompanyEmail":"cpericoi@springer.com","CompanyAgent":"Cobbie Perico","CompanyName":","sciski-Williamson","Currency":"IRR","Notes":"sit amet eleifend pede libero quis orci nullam molestie nibh in lectus pellentesque at","Department":"Baby",","bsite":"nymag.com","Latitude":33.8297993,"Longitude":46.3073161,"ShipDate":"11/15/2016","PaymentDate":","17-12-22 08:07:51","TimeZone":"Asia/Tehran","TotalPayment":":5,"018.99","Actions"5,"Type":1,"Actions":null},\n' +
  27.             '{"RecordID":20,"OrderID":"68151-2713","Country":"Costa Rica","ShipCountry":"CR","ShipCity":"Pital","ShipName":"Romaguera-Batz","ShipAddress":"6 Schlimgen Lane","CompanyEmail":"labeauj@mashable.com","CompanyAgent":"Lucretia Abeau","CompanyName":"Vandervort, Lesch and Bins","Currency":"CRC","Notes":"habitasse platea dictumst morbi vestibulum velit id pretium iaculis diam erat fermentum justo nec condimentum neque","Department":"Clothing",","bsite":"naver.com","Latitude":10.4492758,"Longitude":-84.2725621,"ShipDate":"4/22/2017","PaymentDate":","16-10-31 13:12:03","TimeZone":"America/Costa_Rica","TotalPayment":":1,"445.05","Actions"1,"Type":1,"Actions":null},\n' +
  28.             '{"RecordID":21,","derID":":"382-161"ShipCountry"Japan","ShipCountry":"JP","ShipCity":"Itoman","ShipName":"Kessler, Boyle and Volkman","ShipAddress":"9 Lawn Point","CompanyEmail":"mlinkletk@wp.com","CompanyAgent","Mireielle Linklet","CompanyName":"Maggio-Friesen","Currency":"JPY","Notes":"venenatis lacinia aenean sit amet justo morbi ut odio cras mi pede malesuada in imperdiet","Department":":"mputers","Website":"reference.com","Latitude":26.1288392,"Longitude":127.6681281,"ShipDate":"4/26/2017","PaymentDate":","16-05-13 03:10:54","TimeZone":"Asia/Tokyo","TotalPayment":":5,"295.83","Actions"5,"Type":3,"Actions":null},\n' +
  29.             '{"RecordID":22,","derID":":"345-061","Country":"Russia","ShipCountry":"RU","ShipCity":"Mirny","ShipName":"Baumbach Group","ShipAddress":"4649 Clarendon Terrace","CompanyEmail":"bbigmorel@nationalgeographic.com","CompanyAgent":"Belita Bigmore","CompanyName":"Rath Group","Currency":"RUB","Notes":"diam cras pellentesque volutpat dui maecenas tristique est et tempus semper est quam","Department":"Industrial","Website":"tiny.cc","Latitude":62.5412431,"Longitude":113.9960031,","ipDate":"6/6/2017","PaymentDate":","17-04-07 03:26:21","TimeZone":"Asia/Yakutsk","TotalPayment":"$1097247.60","Actions"4,"Type":1,"Actions":null},\n' +
  30.             '{"RecordID":23,","derID":":"342-072","Country":"Philippines","ShipCountry":"PH","ShipCity":"Lepanto","ShipName":"VonRueden, Satterfield and Pacocha","ShipAddress":"9 Green Way","CompanyEmail":"fdurramm@themeforest.net","CompanyAgent":"Fabio Durram","CompanyName","Gutkowski-Bartell","Currency":"PHP","Notes":"posuere cubilia curae duis faucibus accumsan odio curabitur convallis duis consequat dui nec nisi volutpat eleifend donec",","partment":"Beauty","Website":"smugmug.com","Latitude":9.3136403,"Longitude":123.3036704,"ShipDate":"6/14/2017","PaymentDate":","16-08-01 06:55:55","TimeZone":"Asia/Manila","TotalPayment":":1,"706.25","Actions"1,"Type":2,"Actions":null},\n' +
  31.             '{"RecordID":24,","derID":":"13-0274","Country":"Philippines","ShipCountry":"PH","ShipCity":"Kolambugan","ShipName":"Grady, Barton and Mosciski","ShipAddress":"832 Loftsgordon Court","CompanyEmail":"hheseyn@bandcamp.com","CompanyAgent":"Haskel Hesey","CompanyName":"Brown, Glover and Bednar","Currency":"PHP","Notes":"diam cras pellentesque volutpat dui maecenas tristique est et tempus semper est quam pharetra magna",","partment":"Movies",","bsite":"apple.com","Latitude":8.1113884,"Longitude":123.8961588,"ShipDate":"10/6/2017","PaymentDate":","16-10-15 21:51:09","TimeZone":"Asia/Manila","TotalPayment":":1,"650.19","Actions"1,"Type":1,"Actions":null},\n' +
  32.             '{"RecordID":25,","derID":":"637-013","Country":"Sweden","ShipCountry":"SE","ShipCity":"Vallentuna","ShipName":"Bednar-Wyman","ShipAddress","9945 Old Gate Way","CompanyEmail":"gdurringtono@fda.gov","CompanyAgent":"Gregorius Durrington","CompanyName":":"ag Inc","Currency":"SEK","Notes":"potenti nullam porttitor lacus at turpis donec posuere metus vitae ipsum aliquam non mauris morbi non lectus aliquam","Department":"Jewelery","Website":"sbwire.com","Latitude":59.6535297,"Longitude":18.3648033,"ShipDate":"4/28/2017","PaymentDate":","17-07-19 06:11:51","TimeZone":"Europe/Stockholm","TotalPayment":"$52391.03","Actions"5,"Type":1,"Actions":null},\n' +
  33.             '{"RecordID":26,","derID":":"81-5626"ShipCountry"China","ShipCountry":"CN","ShipCity":"Kertai","ShipName":"Weissnat Group","ShipAddress"CompanyEmail"Hill","CompanyEmail":","olbyp@comcast.net","CompanyAgent":"Berky Dolby","CompanyName","Hodkiewicz-Ledner","Currency":"CNY","Notes":"scelerisque quam turpis adipiscing lorem vitae mattis nibh ligula nec sem duis","Department":"Toys","Website":"google.com.hk","Latitude":46.900546,"Longitude":124.214976,"ShipDate":"9/27/2017","PaymentDate":","16-05-14 03:23:30","TimeZone":"Asia/Harbin","TotalPayment":":2,"211.21","Actions"2,"Type":2,"Actions":null},\n' +
  34.             '{"RecordID":27,"OrderID":"10742-8095","Country":"Philippines","ShipCountry":"PH","ShipCity":"Malinta","ShipName":"Powlowski and Sons","ShipAddress":"8569 Laurel Hill","CompanyEmail":"ccollettq@themeforest.net","CompanyAgent":"Cobbie Collett","CompanyName":"Emard Group","Currency":"PHP","Notes":"lobortis sapien sapien non mi integer ac neque duis bibendum morbi non","Department":"Electronics","Website":"newyorker.com","Latitude":14.6925451,"Longitude":120.9653066,"ShipDate":"9/20/2016","PaymentDate":","16-11-04 21:58:05","TimeZone":"Asia/Manila","TotalPayment":":4,"977.88","Actions"4,"Type":3,"Actions":null},\n' +
  35.             '{"RecordID":28,"OrderID":"49288-0426","Country":"Hungary","ShipCountry":"HU",","ipCity":":"dapest","ShipName","Bahringer-Kautzer","ShipAddress","532 Donald Street","CompanyEmail":"ssangwiner@bizjournals.com","CompanyAgent":"Sheilakathryn Sangwine","CompanyName":"Morar, Bosco and Rosenbaum","Currency":"HUF","Notes":"in congue etiam justo etiam pretium iaculis justo in hac habitasse platea dictumst etiam faucibus cursus","Department":"Toys","Website":"vkontakte.ru","Longitude"47.53708,"Longitude":19.127509,"ShipDate":"12/5/2017","PaymentDate":","17-11-17 07:49:20","TimeZone"TotalPayment"pest","TotalPayment":":2,"043.78","Actions"2,"Type":2,"Actions":null},\n' +
  36.             '{"RecordID":29,"OrderID":"59091-2001","Country":"Netherlands","ShipCountry":"NL","ShipCity":"Arnhem","ShipName":"Kreiger, Hermiston and Maggio","ShipAddress":"395 Maple Road","CompanyEmail":"blents@goo.ne.jp","CompanyAgent":"Bernadene Lent","CompanyName":","athcote-Lueilwitz","Currency":"EUR","Notes":"in lectus pellentesque at nulla suspendisse potenti cras in purus eu","Department":":"mputers","Website","howstuffworks.com","Latitude":51.9489686,"Longitude":5.8564699,","ipDate":"7/8/2016","PaymentDate":","16-05-23 20:05:31","TimeZone":"Europe/Amsterdam","TotalPayment":":6,"709.22","Actions"6,"Type":2,"Actions":null},\n' +
  37.             '{"RecordID":30,"OrderID":"63629-1299","Country":"Russia","ShipCountry":"RU","ShipCity":"Naro-Fominsk","ShipName":"Klocko Inc","ShipAddress":"8 Mitchell Way","CompanyEmail":","ivallantt@nyu.edu","CompanyAgent","Miquela Rivallant","CompanyName":"Harber-Hyatt","Currency":"RUB","Notes":"mauris morbi non lectus aliquam sit amet diam in magna bibendum imperdiet nullam orci pede venenatis non",","partment":"Health","Website":":55.4211657,"titude":55.4211657,"Longitude":36.6585689,"ShipDate":"8/10/2017","PaymentDate":","17-03-22 16:45:31","TimeZone":"Europe/Moscow","TotalPayment":"$1158882.77","Actions"5,"Type":1,"Actions":null},\n' +
  38.             '{"RecordID":31,","derID":":"527-022","Country":"French Polynesia","ShipCountry":"PF"ShipName"y"Renner, Metz and Kuphal"er, Metz and Kuphal","ShipAddress":"3 4th Road","CompanyEmail":"epickersgillu@mapy.cz","CompanyAgent":"Erie Pickersgill","CompanyName":"Hermiston, Stanton and Weissnat","Currency":"XPF","Notes":"elit proin risus praesent lectus vestibulum quam sapien varius ut blandit non interdum in ante vestibulum ante ipsum",","partment":"Movies","Website":"canalblog.com","Latitude":-17.3878955,"Longitude":-145.582949,"ShipDate":"8/10/2017","PaymentDate":","16-01-13 22:56:10","TimeZone":"Pacific/Tahiti","TotalPayment":":2,"927.89","Actions"2,"Type":1,"Actions":null},\n' +
  39.             '{"RecordID":32,","derID":":"523-535",","untry":"Argentina","ShipCountry":"AR",","ipCity":":"lpalĆ�",","ipName":"Sanford Inc","ShipAddress":"397 Mendota Lane","CompanyEmail":"htawsev@desdev.cn","CompanyAgent":"Harriett Tawse","CompanyName":"Zboncak, Hickle and McLaughlin",":"rrency":"ARS","Notes":"ut rhoncus aliquet pulvinar sed nisl nunc rhoncus dui vel sem sed sagittis nam congue risus semper porta"Website"ment":"Games","Website":"theguardian.com","Longitude"-31.4561755,"Longitude":"64.2111608,"PaymentDate"/16/2017","PaymentDate":"2016-04-21 02:02:40","TimeZone":"America/Argentina/Jujuy","TotalPayment":1,"168618.71","Status":1,"Type":3,"Actions":null},\n' +
  40.             '{"RecordID":33,"OrderID":"63402-306","Country":"Sweden","ShipCountry":"SE","ShipCity":"Olofstrƶm","ShipName":"Zboncak Inc","ShipAddress":"248 Reindahl Alley","CompanyEmail":"rcrafterw@sina.com.cn","CompanyAgent":"Richie Crafter","CompanyName":"Larkin-Armstrong":"Currency":"SEK","Notes":"sapien urna pretium nisl ut volutpat sapien arcu sed augue aliquam erat volutpat in congue etiam justo etiam","Department":"Garden","Website":"barnesandnoble.com","Latitude":56.2462038,"Longitude":14.6265298,"ShipDate":"1/29/2016","PaymentDate":"2016-09-30 20:24:13","TimeZone":"Europe/Stockholm","TotalPayment":"$966796.75","Status":3,"Type":1,"Actions":null},\n' +
  41.             '{"RecordID":34,"OrderID"El Salvador"","Country":"El Salvador","ShipCountry":"SV"ShipName"y"Koelpin-Jast""ShipName":"Koelpin-Jast","ShipAddress","62878 Maple Wood Plaza","CompanyEmail":"yjotchamx@bloglovin.com","CompanyAgent":"Yolanthe Jotcham",","mpanyName":"Kohler Inc":"Currency":"USD","Notes":"tempus vel pede morbi porttitor lorem id ligula suspendisse ornare consequat lectus","Department":"Baby",","bsite":"washington.edu","Latitude":13.748419,"Longitude"11/29/2017"8,"ShipDate":":"/29/2017","PaymentDate":"2016-05-26 22:12:21","TimeZone":"America/El_Salvador",","talPayment"Type"449.09","Status":6,"Type":1,"Actions":null},\n' +
  42.             '{"RecordID","5,"OrderID":"49981-010","Country":"Philippines","ShipCountry":"PH"ShipName"y"Eichmann, Hills and McCullough"nn, Hills and McCullough","ShipAddress":"3201 Katie Street","CompanyEmail":"bwoosnamy@zdnet.com","CompanyAgent":"Barthel Woosnam","CompanyName":"Goodwin and Sons":"Currency":"PHP","Notes":"felis sed lacus morbi sem mauris laoreet ut rhoncus aliquet pulvinar sed nisl nunc rhoncus dui vel","Department":"Outdoors","Website":"stumbleupon.com","Latitude":8.3104933,"Longitude"11/27/2017"7,"ShipDate":":"/27/2017","PaymentDate":"2016-01-14 10:54:05","TimeZone":"Asia/Manila","TotalPayment":"$320289.72","Status":3,"Type":2,"Actions":null},\n' +
  43.             '{"RecordID","6,"OrderID":"0023-4383","Country":"Philippines","ShipCountry","PH","ShipCity":"Tiguha","ShipName":"Schmidt and Sons","ShipAddress":"912 Lyons Street","CompanyEmail","crayez@kickstarter.com","CompanyAgent":"Christean Raye","CompanyName":"Witting, Lindgren and Kessler":"Currency":"PHP","Notes":"non velit donec diam neque vestibulum eget vulputate ut ultrices vel augue vestibulum","Department":","oks","Website":"ft.com","Latitude":7.7151954,"Longitude"1/29/2017"52,"ShipDate":"1/29/2017","PaymentDate":"2016-12-05 19:36:44","TimeZone":"Asia/Manila","TotalPayment":"$922800.64","Status":4,"Type":1,"Actions":null},\n' +
  44.             '{"RecordID","7,"OrderID":"50988-254","Country":"Philippines","ShipCountry","PH","ShipCity":"Manila","ShipName":":"over Inc","ShipAddress":"661 Mesta Crossing","CompanyEmail":"lfronzek10@addtoany.com","CompanyAgent":"Lida Fronzek","CompanyName":"Yundt-Jacobs":"Currency":"PHP","Notes":"dignissim vestibulum vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia curae nulla dapibus","Department":"Jewelery","Website":"elegantthemes.com","Latitude":14.3641338,"Longitude"12/12/2016"5,"ShipDate":":"/12/2016","PaymentDate":"2016-08-16 01:47:41","TimeZone":"Asia/Manila",","talPayment"Type"883.89","Status":6,"Type":2,"Actions":null},\n' +
  45.             '{"RecordID":38,"OrderID"Norway"-9924","Country"NO"orway","ShipCountry":"NO","ShipCity":"Kristiansand S","ShipName":"Treutel, Hirthe and Runolfsson","ShipAddress":"2312 Upham Pass","CompanyEmail":"friehm11@army.mil",","mpanyAgent":"Fax Riehm","CompanyName":"Schulist Inc":"Currency":"NOK","Notes":"fusce posuere felis sed lacus morbi sem mauris laoreet ut rhoncus aliquet","Department":"Computers"Latitude"":"toplist.cz","Latitude":58.1348867,"Longitude":8.006095,"ShipDate":"9/15/2017","PaymentDate":"2016-01-08 14:30:49","TimeZone":"Europe/Oslo","TotalPayment":"$435466.56","Status":2,"Type":2,"Actions":null},\n' +
  46.             '{"RecordID","9,"OrderID":"31722-500","Country":"Philippines","ShipCountry":"PH","ShipCity":"Salcedo","ShipName":"Larson-Vandervort","ShipAddress":"8 Red Cloud Plaza","CompanyEmail":","owry12@statcounter.com","CompanyAgent":"Taddeusz Bowry","CompanyName":"Koelpin Inc":"Currency":"PHP","Notes":"massa quis augue luctus tincidunt nulla mollis molestie lorem quisque ut erat curabitur gravida","Department":"Tools","Website":"youtu.be","Latitude":14.5560877,"Longitude"5/4/2017"081,"ShipDate":"5/4/2017","PaymentDate":"2017-04-18 17:53:19","TimeZone":"Asia/Manila","TotalPayment":"$677626.59","Status":3,"Type":1,"Actions":null},\n' +
  47.             '{"RecordID":40,"OrderID"Poland"-7053","Country"PL"oland","ShipCountry":"PL",","ipCity":":"‚owo -Osada","ShipName":"Batz LLC","ShipAddress":"9434 Packers Road","CompanyEmail":"kdunmuir13@ucoz.ru","CompanyAgent":"Kayley Dunmuir","CompanyName":":"ckman-Baumbach","Currency":"PLN","Notes":"faucibus accumsan odio curabitur convallis duis consequat dui nec nisi volutpat eleifend donec ut dolor","Department":"Garden","Website":"theguardian.com","Latitude":53.1664955,"Longitude":20.2914434,"ShipDate":"2/5/2016","PaymentDate":"2016-04-25 10:48:48","TimeZone":"Europe/Warsaw","TotalPayment":"$123550.24",":null},\4' +
  48.            '{":null},\n' +
  49.             '{"RecordID":41,"OrderID":","736-027","Country":"China",":"ipCountry":"CN","ShipCity":"Bazi","ShipName":"Stark-Brown",","ipAddress":"3 Gerald Park","CompanyEmail":"tlotte14@histats.com","CompanyAgent"Larson Inc"","CompanyName":","rson Inc","Currency":"CNY","Notes":"pede justo lacinia eget tincidunt eget tempus vel pede morbi porttitor lorem id ligula suspendisse ornare consequat lectus","Department":"Garden","Website":"salon.com","Latitude":30.7959602,"Longitude":120.6060568,"ShipDate":"10/21/2016","PaymentDate":"2016-07-23 01:21:17","TimeZone":"Asia/Shanghai","TotalPayment":"$326161.60",":null},\4' +
  50.            '{":null},\n' +
  51.             '{"RecordID":42,"OrderID":","575-228","Country":"China",":"ipCountry":"CN","ShipCity":"Dongyang","ShipName":"Effertz LLC","ShipAddress"CompanyEmail" Ridge Trail","CompanyEmail":"smcintee15@google.pl","CompanyAgent":"Sterne McIntee","CompanyName","Robel, Hegmann and Grimes","Currency":"CNY","Notes":"condimentum curabitur in libero ut massa volutpat convallis morbi odio odio elementum eu interdum eu tincidunt in leo maecenas pulvinar","Department":"Garden","Website":"nbcnews.com","Latitude":29.289648,"Longitude":120.241565,"ShipDate":"11/13/2017","PaymentDate":"2017-10-01 15:42:11","TimeZone":"Asia/Chongqing","TotalPayment":"$875336.96",":null},\1' +
  52.            '{":null},\n' +
  53.             '{"RecordID":43,"OrderID":","125-370","Country":"China",":"ipCountry":"CN","ShipCity":"Changzheng","ShipName":"Kozey, Roob and Howell","ShipAddress":"3591 Oxford Plaza","CompanyEmail":","pperson16@dagondesign.com","CompanyAgent":"Thedrick Epperson","CompanyName":"Armstrong, Shields and Osinski","Currency":"CNY","Notes":"vitae nisi nam ultrices libero non mattis pulvinar nulla pede","Department":"Movies","Website":31.23285,"e.com","Latitude":31.23285,"Longitude":121.467218,"ShipDate"2016-04-05 06:38:33"tDate":"2016-04-05 06:38:33","TimeZone":"Asia/Chongqing","TotalPayment":":1,"15.23",":null},\5' +
  54.            '{":null},\n' +
  55.             '{"RecordID"Country"erID":"36987-3290","Country":"South Africa",":"ipCountry":"ZA"ShipName"y"Ward, Little and Flatley"":"Ward, Little and Flatley","ShipAddress":"7627 Sycamore Crossing","CompanyEmail":"pilsley17@nba.com",","mpanyAgent":"Patty Ilsley","CompanyName"ZAR"rson-Kunze","Currency":"ZAR","Notes":"nisi eu orci mauris lacinia sapien quis libero nullam sit amet turpis elementum ligula vehicula","Department":"Health"Latitude"":"wordpress.com","Latitude":-28.7415512,"Longitude":30.461686,"ShipDate":"7/9/2016","PaymentDate":"2017-08-08 07:23:41","TimeZone":"Africa/Johannesburg","TotalPayment":":2,"40.25",":null},\3' +
  56.            '{":null},\n' +
  57.             '{"RecordID":45,"OrderID":"68737-236","Country","Russia",":"ipCountry","RU","ShipCity":"Omutninsk"ShipAddress""Wisoky-Huels","ShipAddress":"5647 Vahlen Way","CompanyEmail":","olding18@domainmarket.com","CompanyAgent":"Amandy Polding","CompanyName"RUB"onin-Purdy","Currency":"RUB","Notes":"ut nulla sed accumsan felis ut at dolor quis odio consequat varius integer ac leo pellentesque","Department":"Beauty","Website":"dyndns.org","Latitude":58.6772898,"Longitude":52.190142,"ShipDate"2016-02-19 06:37:37"tDate":"2016-02-19 06:37:37",","meZone":"Europe/Volgograd","TotalPayment":"$107259.06",":null},\2' +
  58.            '{":null},\n' +
  59.             '{"RecordID"Country"erID":"54868-5511","Country":","rtugal",":"ipCountry":"PT","ShipCity":"CabeƧa Gorda","ShipName":"Kilback Group","ShipAddress":"526 Springview Crossing","CompanyEmail"CompanyAgent"sinessweek.com","CompanyAgent":"Estella Roset","CompanyName":"Skiles-McCullough","Currency":"EUR","Notes":"molestie hendrerit at vulputate vitae nisl aenean lectus pellentesque eget nunc","Department":"Books"Latitude"":"squarespace.com","Latitude":39.1955731,"Longitude":-9.263539,"ShipDate":"5/16/2017","PaymentDate":"2017-06-16 22:18:36","TimeZone":"Europe/Lisbon"Status"Payment":"$607759.63":null},\"' +
  60.            '{"s":null},\n' +
  61.             '{"RecordID":47,":"derID":"51389-112","Country"ShipCity","Lubenia"try":"PL",":"ipCity":"Lubenia","ShipName":"Pacocha-Wolff",","ipAddress":"4 Reindahl Hill","CompanyEmail":","anderson1a@sciencedaily.com","CompanyAgent":"Stillman Sanderson","CompanyName":"Kub LLC","Currency":"PLN","Notes":"luctus et ultrices posuere cubilia curae donec pharetra magna vestibulum aliquet ultrices erat tortor sollicitudin mi sit amet lobortis sapien","Department":"Music"Latitude"":"istockphoto.com","Latitude":49.9409133,"Longitude":21.9374619,"ShipDate":"9/5/2016","PaymentDate":"2016-11-01 20:40:41","TimeZone":"Europe/Warsaw"Status"Payment":"$940344.95":null},\"' +
  62.            '{"s":null},\n' +
  63.             '{"RecordID":48,"OrderID":"53346-1330","Country":"Indonesia":"ShipCountry":"ID","ShipCity":"Wonocolo","ShipName":":"dson and Sons","ShipAddress":"523 Namekagon Trail","CompanyEmail":"lhoyland1b@sphinn.com","CompanyAgent":"Lynn Hoyland"Currency"Name":"Mraz-Spinka","Currency":"IDR","Notes":"volutpat convallis morbi odio odio elementum eu interdum eu tincidunt","Department":"Industrial","Website":"examiner.com","Latitude":-7.3198199,"Longitude":112.7420274,"ShipDate":"5/8/2016","PaymentDate":"2017-12-24 00:13:05","TimeZone":"Asia/Jakarta"Status"Payment":"$612744.04":null},\"' +
  64.            '{"s":null},\n' +
  65.             '{"RecordID":49,":"derID","11410-803",":"untry":"China":"ShipCountry"ShipName"ipCity":"Baimajing","ShipName":"Reynolds, Botsford and MacGyver","ShipAddress":"6 Summit Road","CompanyEmail":"estansfield1c@webs.com","CompanyAgent":"Emmalee Stansfield",","mpanyName":"Cartwright-Cole","Currency":"CNY","Notes":"posuere metus vitae ipsum aliquam non mauris morbi non lectus aliquam sit amet diam in magna bibendum imperdiet nullam":"Department":"Home","Website":"bbc.co.uk","Latitude":19.696407,"Longitude":109.218734,"ShipDate":"12/24/2017","PaymentDate":"2016-03-20 19:34:44"TotalPayment"Asia/Chongqing"Status"Payment":"$427176.05":null},\"' +
  66.            '{"s":null},\n' +
  67.             '{"RecordID":50,":"derID":"54473-254","Country":"Australia":"ShipCountry":"AU","ShipCity":"Sydney",","ipName":"Schroeder-Schulist","ShipAddress":"84 2nd Place","CompanyEmail","hleyban1d@cocolog-nifty.com","CompanyAgent":"Henrietta Leyban","CompanyName":"Ankunding-Hudson","Currency":"AUD","Notes":"potenti cras in purus eu magna vulputate luctus cum sociis natoque penatibus et magnis dis parturient montes nascetur",":"partment":"Health","Website":"pinterest.com","Latitude":-33.8688197,"Longitude":151.2092955,"ShipDate":"9/6/2016","PaymentDate":"2017-07-30 00:54:38","TimeZone":"Australia/Sydney"Status"Payment":"$269139.08":null},\"' +
  68.            '{"s":null},\n' +
  69.             '{"RecordID":51,":"derID":"49967-106","Country":"Indonesia":"ShipCountry"ShipName"ipCity":"Margasari","ShipName":"Watsica and Sons","ShipAddress":"2004 Scofield Drive","CompanyEmail":"uruddlesden1e@meetup.com","CompanyAgent":"Ulrike Ruddlesden","CompanyName":"Koch and Sons","Currency":"IDR","Notes":"dui maecenas tristique est et tempus semper est quam pharetra":"Department":"Baby","Website":"angelfire.com","Latitude":-7.0976672,"Longitude":109.0215438,"ShipDate":"12/6/2017","PaymentDate":"2016-03-24 02:22:17","TimeZone":"Asia/Jakarta"Status"Payment":"$511041.28":null},\"' +
  70.            '{"s":null},\n' +
  71.             '{"RecordID":52,":"derID":"65649-501","Country"PH"hilippines":"ShipCountry":"PH","ShipCity":"Buenavista","ShipName":"Larkin Inc","ShipAddress":"7 Maple Trail","CompanyEmail","wmancktelow1f@princeton.edu","CompanyAgent":"Wilone Mancktelow","CompanyName":","rvin Group","Currency":"PHP","Notes":"erat quisque erat eros viverra eget congue eget semper rutrum nulla nunc purus phasellus in",":"partment","Health",":8.972681,"amu.edu",":125.408732,"72681,"Longitude":125.408732,"ShipDate":"8/19/2016","PaymentDate":"2017-06-29 22:18:35","TimeZone":"Asia/Manila"Status"Payment":"$945403.35":null},\"' +
  72.            '{"s":null},\n' +
  73.             '{"RecordID":53,"OrderID":"11695-1405","Country":"Albania":"ShipCountry":"AL","ShipCity":"Rrasa e SipĆ«rme","ShipName":"Smith, Kovacek and Bogan",","ipAddress":"7633 Towne Street","CompanyEmail":"dlees1g@barnesandnoble.com","CompanyAgent":"Deidre Lees","CompanyName"Currency", Hoeger and Stanton","Currency":"ALL","Notes":"sed ante vivamus tortor duis mattis egestas metus aenean fermentum donec ut mauris eget massa tempor","Department":"Grocery","Website":"nationalgeographic.com",":"titude":",".96778",":"ngitude":",".82111","ShipDate":"3/14/2017","PaymentDate":"2016-10-10 16:32:23","TimeZone":"Europe/Tirane","TotalPayment":"$455561.49","Status":2,"Type":2,"Actions":null},\n' +
  74.             '{"RecordID":54,"OrderID":"68788-6760":"Country":"China"Xiaping"untry":"CN":"ShipCity":"Xiaping","ShipName":"Dickinson Group","ShipAddress":":"85 Merry Plaza","CompanyEmail":"mbourne1h@macromedia.com","CompanyAgent":"Malorie Bourne"Currency"Name":"Blick-Farrell","Currency":"CNY","Notes":"orci vehicula condimentum curabitur in libero ut massa volutpat convallis","Department":"Computers":27.568278,"1und1.de","Latitude":27.568278,":"ngitude":117.562238,"ShipDate":"8/13/2017","PaymentDate":"2016-09-11 19:00:24","TimeZone":"Asia/Chongqing","TotalPayment":"$147162.27","Status":3,"Type":2,"Actions":null},\n' +
  75.             '{"RecordID":55,"China"D"ShipCountry","CN"ntry":"China"Zhangjiawan"y"ShipName"ipCity":"Zhangjiawan","ShipName":"Welch-Gislason","ShipAddress":":" Mcbride Place","CompanyEmail":"hgammie1i@globo.com","CompanyAgent"Hegmann-Hettinger"CompanyName":"Hegmann-Hettinger","Currency":"CNY","Notes":"rutrum at lorem integer tincidunt ante vel ipsum praesent blandit lacinia erat vestibulum sed magna at nunc","Department"Latitude""Website":"yandex.ru","Latitude":31.686188,":"ngitude":104.969819,"ShipDate":"5/27/2016","PaymentDate":"2016-08-19 17:30:11","TimeZone":"Asia/Harbin","TotalPayment":"$974736.80","Status":4,"Type":2,"Actions":null},\n' +
  76.             '{"RecordID":56,"Israel"":"62032-524","Country":"Israel"Ramat Gan"try":"IL",":"ipCity":"Ramat Gan","ShipName":"Stokes-Homenick","ShipAddress":"95694 Clove Crossing",","mpanyEmail":":"ante1j@php.net","CompanyAgent"Kerluke, Witting and Zboncak"":"Kerluke, Witting and Zboncak","Currency":"ILS","Notes":"gravida nisi at nibh in hac habitasse platea dictumst aliquam augue quam":"Department":"Movies"Latitude"":"deliciousdays.com","Latitude":32.068424,"Longitude","4.824785,"ShipDate":"5/6/2017","PaymentDate":"2016-10-29 15:41:43","TimeZone":"Asia/Jerusalem","TotalPayment":"$939821.62","Status":6,"Type":2,"Actions":null},\n' +
  77.             '{"RecordID":57,"Yemen"D"ShipCountry","YE"ntry":"Yemen"Raydah"ountry":"YE","ShipCity":"Raydah"ShipAddress""Pfannerstill LLC","ShipAddress":":"67 Warner Lane","CompanyEmail":"onazer1k@github.com","CompanyAgent"Barton-Mann"zer","CompanyName":"Barton-Mann","Currency":"YER","Notes":"consequat nulla nisl nunc nisl duis bibendum felis sed interdum venenatis turpis enim blandit mi in porttitor pede justo","Department":"Automotive","Website":"nytimes.com",":44.041335,".8161032,"Longitude":44.041335,"ShipDate":"12/6/2017","PaymentDate":"2017-07-15 23:15:32","TimeZone":"Asia/Aden","TotalPayment":"$971056.71","Status":1,"Type":1,"Actions":null},\n' +
  78.             '{"RecordID":58,"Indonesia"0536-3233","Country":"Indonesia"Krajan Srigonco"ID","ShipCity":"Krajan Srigonco","ShipName":"Torphy, Bosco and Ortiz","ShipAddress":"8379 Shopko Circle","CompanyEmail":"platliff1l@theatlantic.com","CompanyAgent"Feil, Mante and Becker"nyName":"Feil, Mante and Becker","Currency":"IDR","Notes":"sit amet consectetuer adipiscing elit proin interdum mauris non ligula pellentesque ultrices phasellus id sapien":"Department":"Garden","Website":"angelfire.com","Latitude":"-8.3418",":"ngitude":","2.5618","ShipDate":"3/10/2016","PaymentDate":"2017-03-06 12:26:09","TimeZone"$1176948.84"ta","TotalPayment":1,"176948.84","Status":2,"Type":1,"Actions":null},\n' +
  79.             '{"RecordID":59,"Indonesia"0143-1265","Country":"Indonesia"Panggungasri"":"ID","ShipCity":"Panggungasri","ShipName":"Schiller LLC","ShipAddress":"75 Barnett Crossing","CompanyEmail":"bpackwood1m@salon.com",","mpanyAgent":"Benetta Packwood",","mpanyName":"Zboncak-Hettinger","Currency":"IDR","Notes":"lectus suspendisse potenti in eleifend quam a odio in hac habitasse platea dictumst maecenas ut massa quis augue","Department"Latitude""Website":"issuu.com",":112.2950314,"182795,"Longitude":112.2950314,"ShipDate":"7/7/2017","PaymentDate":"2017-09-23 10:42:52","TimeZone"$214315.57"rta","TotalPayment":"$214315.57","Status":3,"Type":2,"Actions":null},\n' +
  80.             '{"RecordID":60,"Macedonia"64980-119","Country":"Macedonia"ŠˆŠµŠ³ŃƒŠ½Š¾Š²Ń†Šµ","ShipName":"Hyatt, Kovacek and Schulist"цŠµ","ShipName":"Hyatt, Kovacek and Schulist"mcolliar1n@hugedomains.com"Center","CompanyEmail":"mcolliar1n@hugedomains.com","CompanyAgent":"Merilee Colliar",":"mpanyName":":"ore, Toy and McCullough","Currency":"MKD","Notes":"turpis elementum ligula vehicula consequat morbi a ipsum integer a nibh in quis justo maecenas rhoncus aliquam lacus morbi","Department":"Tools"Longitude":"craigslist.org","Latitude":42.0733374,"Longitude":21.1202878,"ShipDate":"2/3/2017","PaymentDate"TotalPayment"12:43:48","TimeZone":":2,"pe/Skopje","TotalPayment":"$526035.07","Status":2,"Type":2,"Actions":null},\n' +
  81.             '{"RecordID"ShipCountry"":"0363-0198","Country":"Philippines","ShipCountry":"PH","ShipCity":":"grumbuan","ShipName":"Hills-Mayert","ShipAddress":"505 Cardinal Drive",":"mpanyEmail":","oyner1o@zimbio.com","CompanyAgent":"Ennis Poyner","CompanyName":"Simonis and Sons","Currency":"PHP","Notes":"odio in hac habitasse platea dictumst maecenas ut massa quis augue luctus tincidunt nulla mollis molestie lorem quisque","Department":"Tools"Longitude":"mayoclinic.com","Latitude":16.8991985,"Longitude"2017-04-05 11:19:31"te":"8/30/2017","PaymentDate":"2017-04-05 11:19:31",","meZone":5,"ia/Manila","TotalPayment":"$925471.01","Status":5,"Type":1,"Actions":null},\n' +
  82.             '{"RecordID":62,"OrderID":","862-142","Country":"Indonesia","ShipCountry":"ID",","ipCity":"Leuwipicung","ShipName":"Schultz-Cronin","ShipAddress":"306 Beilfuss Parkway","CompanyEmail":"apetherick1p@hatena.ne.jp","CompanyAgent":"Ailyn Petherick",":"mpanyName":"Dach-Ernser","Currency":"IDR","Notes":"sed tincidunt eu felis fusce posuere felis sed lacus morbi sem mauris laoreet ut rhoncus","Department":"Longitude"ebsite":"house.gov",":"titude":-7.71725,"Longitude":108.07666,"ShipDate":"3/4/2016","PaymentDate":"2017-01-12 13:27:43","TimeZone":"Asia/Jakarta","TotalPayment":"$300684.83","Status":6,"Type":1,"Actions":null},\n' +
  83.             '{"RecordID":63,"OrderID"ShipCity"561","Country"ShipName"ShipCountry":"PE","ShipCity":"Patambuco","ShipName":"Crist and Sons","ShipAddress":"90561 Superior Parkway":"CompanyEmail","sgasking1q@sun.com","CompanyAgent":"Saba Gasking","CompanyName":"Wisozk-Ratke","Currency":"PEN","Notes":"leo pellentesque ultrices mattis odio donec vitae nisi nam ultrices libero non mattis pulvinar nulla pede","Department":"Jewelery","Website":"apple.com","Latitude":-14.27079,"Longitude":-69.567879,"ShipDate":"6/27/2017","PaymentDate":"2017-02-14 05:11:52","TimeZone":"America/Lima","TotalPayment":"$296798.64","Status":5,"Type":2,"Actions":null},\n' +
  84.             '{"RecordID":64,"OrderID":"67877-169"Sananduva":"ShipName"ShipCountry":"BR","ShipCity","Sananduva",":"ipName":"Koss, Yost and Wintheiser","ShipAddress":"76 Di Loreto Place",","mpanyEmail":":"atitiaho1r@networkadvertising.org","CompanyAgent":"Kelly Matitiaho","CompanyName":"Schuster, Flatley and Ledner","Currency":"BRL","Notes":"hendrerit at vulputate vitae nisl aenean lectus pellentesque eget nunc donec quis orci eget orci","Department":"Automotive","Website":"squidoo.com","Latitude":-27.950568,"Longitude"2016-04-14 15:50:12"te":"9/21/2017","PaymentDate":","16-04-14 15:50:12","TimeZone":"America/Sao_Paulo","TotalPayment":"$683140.08","Status":4,"Type":2,"Actions":null},\n' +
  85.             '{"RecordID":65,"OrderID":"13537-402"Pader Palwo"Uganda","ShipCountry":"UG","ShipCity":"Pader Palwo","ShipName":"Konopelski, Goyette and Borer","ShipAddress":"34 Charing Cross Junction","CompanyEmail":"dgasperi1s@newsvine.com","CompanyAgent":"Daron Gasperi","CompanyName":"Kuphal Inc","Currency":"UGX","Notes":"curabitur gravida nisi at nibh in hac habitasse platea dictumst aliquam augue quam","Department":"Electronics",":33.0057261,".com","Latitude":2.7798518,"Longitude":33.0057261,"ShipDate":"7/8/2016","PaymentDate":"2016-12-02 10:21:48","TimeZone":"Africa/Kampala","TotalPayment":"$245786.01","Status":2,"Type":2,"Actions":null},\n' +
  86.             '{"RecordID":66,"OrderID":","951-8237":"Country","Portugal":"ShipCountry":"PT","ShipCity":"Portela","ShipName":"Marks-Batz","ShipAddress":"114 Barnett Avenue",":"mpanyEmail":"meustes1t@nsw.gov.au","CompanyAgent":"Marketa Eustes",":"mpanyName":"Kautzer Inc","Currency":"EUR","Notes":"proin leo odio porttitor id consequat in consequat ut nulla sed accumsan","Department":"Outdoors","Website":"paypal.com","Latitude":41.1604713,"Longitude":-7.7452871,"ShipDate":"12/6/2016","PaymentDate"TotalPayment"07:39:20","TimeZone":":1,"pe/Lisbon","TotalPayment":"$148246.67","Status":1,"Type":1,"Actions":null},\n' +
  87.             '{"RecordID":67,"OrderID":"36987-3279","Country":"Spain":"ShipCountry":"ES","ShipCity":","dajoz","ShipName":"Osinski, Nitzsche and Schaden":"ShipAddress":"6 Commercial Center":"CompanyEmail":"bshowl1u@lycos.com","CompanyAgent":"Bernita Showl"Notes"anyName":"Jacobson-Brakus","Currency":"EUR","Notes":"odio porttitor id consequat in consequat ut nulla sed accumsan felis ut at dolor quis odio consequat varius","Department":"Movies","Website":"wikimedia.org","Latitude":38.8794495,"Longitude":-6.9706535,"ShipDate":"11/2/2016","PaymentDate"TotalPayment"10:42:38","TimeZone":"Europe/Madrid"Actions"ayment":"$1145811.38","Status":2,"Type":3,"Actions":null},\n' +
  88.             '{"RecordID":68,"OrderID":"36987-3092","Country":"Belarus",":"ipCountry":","","ShipCity":"Hlybokaye","ShipName":"Fahey-Jones","ShipAddress":"43 Scott Lane","CompanyEmail":"dohoey1v@sitemeter.com","CompanyAgent":"Danielle O\'Hoey",":"mpanyName":":"pes, Schaden and Larkin","Currency":"BYR","Notes":"nullam porttitor lacus at turpis donec posuere metus vitae ipsum aliquam non mauris morbi","Department":"Toys","Website":"joomla.org","Latitude":55.1391321,"Longitude":27.6842905,"ShipDate":"4/12/2017","PaymentDate":"2017-01-03 22:32:16","TimeZone":":3,"pe/Minsk"Actions"ayment":"$1075453.72","Status":3,"Type":3,"Actions":null},\n' +
  89.             '{"RecordID":69,"OrderID":"17271-503":"Country":"Slovenia","ShipCountry":"SI","ShipCity":"Slovenska Bistrica","ShipName":"Padberg, West and Hoeger","ShipAddress":"48462 Jackson Avenue","CompanyEmail":"sstanistrete1w@samsung.com","CompanyAgent"Currency"Stanistrete",":"mpanyName":"Reinger Inc","Currency":"EUR","Notes":"tortor quis turpis sed ante vivamus tortor duis mattis egestas metus aenean","Department":"Clothing","Website":"people.com.cn","Latitude":46.3919813,"Longitude":15.5727869,"ShipDate":"6/26/2017","PaymentDate":"2016-10-01 11:26:13","TimeZone":"Europe/Ljubljana"Actions"ayment":"$1113114.34","Status":4,"Type":1,"Actions":null},\n' +
  90.             '{"RecordID":70,"OrderID","49288-0206"Aix-en-Provence"ce","ShipCountry":"FR","ShipCity":"Aix-en-Provence","ShipName":"Johnson, Beahan and McCullough","ShipAddress":","Bartillon Pass"Denys Omrod"il":"domrod1x@ihg.com","CompanyAgent":"Denys Omrod","CompanyName":"Dicki and Sons","Currency":"EUR","Notes":"vestibulum proin eu mi nulla ac enim in tempor turpis nec euismod scelerisque quam","Department":"Electronics","Website":"lulu.com","Latitude":43.5190858,"Longitude":5.4431946,"ShipDate"TimeZone"017","PaymentDate":"2016-07-28 12:41:30","TimeZone":"Europe/Paris","TotalPayment":"$264342.99","Status":6,"Type":3,"Actions":null},\n' +
  91.             '{"RecordID":71,"OrderID","55312-118","Country":"Belarus",":"ipCountry":"BY","ShipCity":"Pyetrykaw","ShipName":"Howell, Swaniawski and Mosciski":"ShipAddress":"16514 Glendale Road","CompanyEmail":"pmallall1y@cnet.com","CompanyAgent":"Phillipe Mallall","CompanyName":"Jacobs, Blanda and Dickinson","Currency":"BYR","Notes":"quis lectus suspendisse potenti in eleifend quam a odio in hac habitasse platea dictumst","Department":"Movies","Website":"desdev.cn","Latitude":52.1267722,"Longitude"2017-06-17 12:58:28"e"TimeZone"017","PaymentDate":"2017-06-17 12:58:28","TimeZone":"Europe/Minsk","TotalPayment":"$366433.13","Status":3,"Type":1,"Actions":null},\n' +
  92.             '{"RecordID":72,"OrderID":"49035-111"Caieiras"":"Brazil","ShipCountry":"BR","ShipCity"ShipAddress""ShipName":"Skiles, Mayert and Huels",":"ipAddress":"551 Briar Crest Drive","CompanyEmail":"fmantha1z@usatoday.com","CompanyAgent":"Flinn Mantha","CompanyName":"Zboncak-Dooley","Currency":"BRL","Notes":"justo morbi ut odio cras mi pede malesuada in imperdiet et commodo vulputate justo in blandit ultrices","Department":"Beauty","Website":"wired.com","Latitude":-23.3711864,"Longitude"2016-06-28 10:50:05"te":"1/18/2016","PaymentDate":","16-06-28 10:50:05","TimeZone":"America/Sao_Paulo","TotalPayment":"$623396.37","Status":2,"Type":3,"Actions":null},\n' +
  93.             '{"RecordID":73,"OrderID"ShipCity"88","Country":"China":"ShipCountry":"CN","ShipCity":"Yicheng","ShipName":"Boyer, Koepp and O\'Hara","ShipAddress":"1 Blue Bill Park Way"Melodie Gange"":"mgange20@wix.com","CompanyAgent":":"lodie Gange":"CompanyName":"Lemke Inc","Currency":"CNY","Notes":"eros elementum pellentesque quisque porta volutpat erat quisque erat eros","Department":"Garden"Longitude":"yellowpages.com","Latitude":31.719806,"Longitude"2017-06-17 19:57:08"e"TimeZone"016","PaymentDate":"2017-06-17 19:57:08","TimeZone":"Asia/Chongqing","TotalPayment":"$668062.14","Status":5,"Type":2,"Actions":null},\n' +
  94.             '{"RecordID"ShipCountry"":"60709-105","Country":"Philippines"Muller-Rosenbaum"H"ShipAddress""Babug","ShipName":"Muller-Rosenbaum","ShipAddress":"69 Northview Parkway","CompanyEmail":"rdabner21@indiatimes.com","CompanyAgent":"Randi Dabner","CompanyName":"Schimmel, Mohr and Kutch","Currency":"PHP","Notes":"eu sapien cursus vestibulum proin eu mi nulla ac enim in","Department":"Sports","Website":"wikimedia.org","Latitude":14.8744012,"Longitude"2017-09-15 19:14:19"te":"5/21/2017","PaymentDate":"2017-09-15 19:14:19",","meZone":5,"ia/Manila","TotalPayment":"$990135.61","Status":5,"Type":1,"Actions":null},\n' +
  95.             '{"RecordID":75,"OrderID":"63629-2679","Country","Finland","ShipCountry":"FI","ShipCity":"Koski Tl","ShipName":"Crona, Halvorson and Larkin","ShipAddress":"0 Vernon Center","CompanyEmail":"ggabbat22@newsvine.com","CompanyAgent":"Ginnie Gabbat","CompanyName":"Bergnaum-Kozey","Currency":"EUR","Notes":"donec quis orci eget orci vehicula condimentum curabitur in libero ut massa volutpat convallis morbi odio odio","Department":"Jewelery","Website":"newyorker.com","Latitude":60.6569706,"Longitude"2017-06-21 16:16:24"e"TimeZone"016","PaymentDate","2017-06-21 16:16:24","TimeZone":"Europe/Helsinki","TotalPayment":"$232536.81","Status":4,"Type":1,"Actions":null},\n' +
  96.             '{"RecordID":76,"OrderID":"36800-277"Radenka"y"ShipName","Hahn LLC"ry":"RS","ShipCity":"Radenka","ShipName":"Hahn LLC","ShipAddress":"0 Erie Plaza","CompanyEmail","jadnett23@about.com","CompanyAgent":"Josi Adnett","CompanyName":"Schulist-Yost","Currency":"RSD","Notes":"ipsum dolor sit amet consectetuer adipiscing elit proin risus praesent lectus vestibulum quam sapien varius ut blandit non","Department":"Computers","Website":"google.de","Latitude":44.5847556,"Longitude":21.7503934,"ShipDate":"9/19/2017","PaymentDate","2017-11-09 17:37:52","TimeZone":"Europe/Belgrade","TotalPayment":"$830071.82","Status":1,"Type":3,"Actions":null},\n' +
  97.             '{"RecordID":77,"OrderID","52125-910","Country":"Armenia":"ShipCountry","AM","ShipCity"57 Arapahoe Way"Name":"Will-Dooley","ShipAddress":"57 Arapahoe Way",":"mpanyEmail":"nyerill24@rediff.com","CompanyAgent"Currency"al Yerill","CompanyName":"Rosenbaum Inc","Currency":"AMD","Notes":"volutpat in congue etiam justo etiam pretium iaculis justo in hac habitasse platea dictumst etiam faucibus cursus urna ut tellus",":40.894048,""Baby","Website":"webmd.com","Latitude":40.894048,"Longitude":44.1992229,"ShipDate":"5/24/2017","PaymentDate":"2017-04-15 08:51:50",","meZone":5,"ia/Yerevan","TotalPayment":"$97687.69","Status":5,"Type":3,"Actions":null},\n' +
  98.             '{"RecordID":78,"OrderID":"24236-120"MĆ¢con"ry":"France","ShipCountry":"FR","ShipCity":"MĆ¢con"40389 Buell Alley"va, Metz and Stamm","ShipAddress":"40389 Buell Alley","CompanyEmail":"pbrewin25@timesonline.co.uk","CompanyAgent":"Priscilla Brewin":"CompanyName":"Witting-Von","Currency":"EUR","Notes":"sociis natoque penatibus et magnis dis parturient montes nascetur ridiculus mus","Department":"Movies":4.8265786,"hp.com",":"titude":46.2993504,"Longitude":4.8265786,"ShipDate":"2/5/2016","PaymentDate":"2017-07-02 14:21:54","TimeZone":"Europe/Paris","TotalPayment":"$892539.18","Status":6,"Type":1,"Actions":null},\n' +
  99.             '{"RecordID":79,"OrderID","76173-1008"Kandhkot"":"Pakistan","ShipCountry":"PK","ShipCity":"Kandhkot","ShipName":"Quigley-Halvorson","ShipAddress"CompanyAgent"","CompanyEmail":","llard26@google.ca","CompanyAgent":"Barbabas Allard","CompanyName":"Kunde-Veum","Currency":"PKR","Notes":"cras non velit nec nisi vulputate nonummy maecenas tincidunt lacus at velit vivamus vel nulla eget eros","Department":"Music","Website":"trellian.com","Latitude":28.1771009,"Longitude":68.7257945,"ShipDate":"1/29/2016","PaymentDate":"2017-08-08 19:08:11","TimeZone":"Type"Karachi","TotalPayment":"$64027.72","Status":6,"Type":2,"Actions":null},\n' +
  100.             '{"RecordID":80,"OrderID":"41163-146","Country":"China","ShipCountry":"CN","ShipCity":"Dadianzi","ShipName":"Hilll Inc","ShipAddress":"4569 Heath Street","CompanyEmail":"mcassie27@canalblog.com","CompanyAgent":"Marshall Cassie","CompanyName":"Brown-Hudson","Currency":"CNY","Notes":"ut erat id mauris vulputate elementum nullam varius nulla facilisi cras","Department":"Toys","Website":"tripadvisor.com",":"titude":43.661922,"Longitude":128.500964,"ShipDate":"3/5/2016","PaymentDate":"2016-02-25 11:11:16","TimeZone":"Type"Harbin","TotalPayment":"$620902.30","Status":2,"Type":2,"Actions":null},\n' +
  101.             '{"RecordID":81,"OrderID":","084-198","Country":"Philippines"Nikolaus, Zulauf and Gutkowski""Pagatin","ShipName":"Nikolaus, Zulauf and Gutkowski","ShipAddress":"70 Coolidge Hill","CompanyEmail":"wferneley28@studiopress.com","CompanyAgent":"William Ferneley","CompanyName":"Adams, Macejkovic and Little","Currency":"PHP","Notes":"sit amet nulla quisque arcu libero rutrum ac lobortis vel dapibus at diam nam tristique tortor","Department":"Jewelery","Website":"netvibes.com","Latitude":6.7640051,"Longitude":124.3754414,"ShipDate":"10/4/2017","PaymentDate":"2016-10-19 03:43:03","TimeZone":"Asia/Manila","TotalPayment":"$33879.28","Status":2,"Type":3,"Actions":null},\n' +
  102.             '{"RecordID":82,"OrderID","60512-1043"Cimo de Vila"ortugal","ShipCountry":"PT"ShipAddress""Cimo de Vila","ShipName":"Cole-Daniel","ShipAddress":"08329 Marcy Trail","CompanyEmail","jjallin29@latimes.com","CompanyAgent":"Josy Jallin":"CompanyName":"Osinski LLC","Currency":"EUR","Notes":"pharetra magna vestibulum aliquet ultrices erat tortor sollicitudin mi sit amet lobortis sapien sapien","Department":"Grocery","Website":"imgur.com","Latitude":41.3389801,"Longitude":-8.1591621,"ShipDate":"8/23/2017","PaymentDate":"2016-11-17 23:27:10","TimeZone":"Europe/Lisbon","TotalPayment":"$45465.01","Status":5,"Type":1,"Actions":null},\n' +
  103.             '{"RecordID":83,"OrderID":"21695-139"Kobarid"y"ShipName"a"Wuckert-Corkery"SI","ShipCity":"Kobarid","ShipName","Wuckert-Corkery","ShipAddress":"9576 Russell Alley":"CompanyEmail":"tbuxton2a@seesaa.net","CompanyAgent":"Tomasine Buxton","CompanyName":"Schaefer-Smith","Currency":"EUR","Notes":"in faucibus orci luctus et ultrices posuere cubilia curae duis","Department":"Books","Website":"fda.gov","Latitude":46.2476549,"Longitude":13.5791749,"ShipDate":"4/27/2017","PaymentDate":"2016-02-14 15:10:51","TimeZone":"Type"e/Rome","TotalPayment":"$271185.36","Status":3,"Type":3,"Actions":null},\n' +
  104.             '{"RecordID":84,"ShipCountry"28-3003","Country"Bajos de Haina"ublic","ShipCountry":"DO","ShipCity":"Bajos de Haina","ShipName":"Grady-Connelly","ShipAddress":"2079 Larry Way","CompanyEmail":"cpaskerful2b@i2i.jp":"CompanyAgent":"Cairistiona Paskerful","CompanyName":"Wiegand and Sons","Currency":"DOP","Notes":"habitasse platea dictumst morbi vestibulum velit id pretium iaculis diam erat fermentum justo","Department":"Computers","Website":"china.com.cn","Latitude":18.4091399,"Longitude":-70.031039,"ShipDate":"11/14/2016","PaymentDate":"2017-11-01 16:40:06","TimeZone":"America/Santo_Domingo","TotalPayment":"$612602.70","Status":2,"Type":1,"Actions":null},\n' +
  105.             '{","cordID":85,":"derID":"36800-124","Country":"Mexico","ShipCountry":","","ShipCity":"El Rosario","ShipName":"Rogahn Group","ShipAddress":"5332 Cambridge Way":"CompanyEmail":"gboggis2c@sbwire.com","CompanyAgent":"Godwin Boggis","CompanyName":"Cartwright, Mante and Kris","Currency":"MXN","Notes":"ut massa quis augue luctus tincidunt nulla mollis molestie lorem quisque ut erat curabitur","Department":"Automotive","Website":"flickr.com","Latitude":30.059549,"Longitude":-115.725753,"ShipDate":"1/13/2016","PaymentDate":","16-01-24 18:48:06","TimeZone"Status"ca/Mexico_City","TotalPayment":"$1014910.05","Status":5,"Type":2,"Actions":null},\n' +
  106.             '{"RecordID":86,"OrderID":","746-175","Country":"Philippines","ShipCountry":"PH","ShipCity":","ncepcion","ShipName":"Tromp, Wisozk and Stiedemann","ShipAddress":"74705 Oakridge Point",":"mpanyEmail":"khayzer2d@marriott.com","CompanyAgent":"Kirbie Hayzer",":"mpanyName":"Nicolas-Bayer","Currency":"PHP","Notes":"commodo vulputate justo in blandit ultrices enim lorem ipsum dolor sit amet consectetuer adipiscing","Department":"Computers","Website":"issuu.com","Latitude":14.6688068,"Longitude":121.1138058,"ShipDate":"5/20/2016","PaymentDate":"2017-03-14 05:05:26","TimeZone":"Type"Manila","TotalPayment":"$201601.94","Status":2,"Type":1,"Actions":null},\n' +
  107.             '{"RecordID":87,"OrderID":"0268-1481","Country":"Palestinian Territory","ShipCountry":"PS","ShipCity":","€˜Aşīrah al QiblÄ«yah","ShipName":"Morissette Inc","ShipAddress":"4339 Armistice Circle","CompanyEmail":"cgresley2e@wsj.com","CompanyAgent":"Cherlyn Gresley","CompanyName":"Langosh, Kris and Ernser","Currency":"ILS","Notes":"sed vestibulum sit amet cursus id turpis integer aliquet massa id lobortis convallis tortor risus dapibus augue vel","Department":"Jewelery","Website":"google.co.uk","Latitude":"32.17842","Longitude":"35.21569","ShipDate":"4/2/2016"TotalPayment"":"2017-01-21 06:18:17","TimeZone":"Asia/Hebron","TotalPayment":"$435115.69","Status"OrderID"":3,"Actions":null},\n' +
  108.             '{"RecordID":88,"OrderID":"58411-157","Country":"China","ShipCountry":"CN",":"ipCity":"Baisha","ShipName":"Morissette-Schoen","ShipAddress":"2 Menomonie Terrace","CompanyEmail":"hshorto2f@imdb.com","CompanyAgent":","ratio Shorto","CompanyName":"Lueilwitz-Cole","Currency":"CNY","Notes":"vestibulum velit id pretium iaculis diam erat fermentum justo nec","Department":100.222545,"bsite":"about.me","Latitude":26.641315,"Longitude":100.222545,"ShipDate":"9/11/2017","PaymentDate":":"17-03-30 06:17:36",":1,"Zone":1,"ia/Chongqing","TotalPayment":"$428954.11","Status"OrderID"":1,"Actions","ull},\n' +
  109.             '{"RecordID"PT","ShipCity""54569-6438","Country":"Portugal","ShipCountry":"PT",":"ipCity":"Brejieira","ShipName"lcrayden2g@multiply.com"ddress":"1 Union Park","CompanyEmail":"lcrayden2g@multiply.com","CompanyAgent":"Lorrin Crayden","CompanyName":"Price Group","Currency":"EUR","Notes":"ultricies eu nibh quisque id justo sit amet sapien dignissim vestibulum vestibulum ante ipsum primis in faucibus orci luctus et":39.764261,"":"Industrial","Website":"csmonitor.com","Latitude":39.764261,"Longitude":-8.7386338,"ShipDate":"9/17/2016","PaymentDate":"2017-05-24 15:56:55","TimeZone":"Europe/Lisbon","TotalPayment":"$101625.67","Status"OrderID"":3,"Actions":null},\n' +
  110.             '{"RecordID":90,"OrderID":"64720-141","Country":"China","ShipCountry":"CN","ShipCity":"Xiangtan","ShipName":"Wilderman and Sons","ShipAddress":"54779 Talisman Pass","CompanyEmail":"mlilburn2h@fotki.com"Currency"Agent","Marci Lilburn","CompanyName":"Hackett-Olson","Currency":"CNY","Notes":"hac habitasse platea dictumst aliquam augue quam sollicitudin vitae consectetuer eget rutrum at lorem integer tincidunt ante","Department"Longitude"ics","Website":"microsoft.com","Latitude":27.829795,"Longitude":112.944026,"ShipDate":"7/2/2017","PaymentDate":":"16-11-02 16:08:14",":5,"Zone":2,"ia/Chongqing","TotalPayment":"$453268.63","Status"OrderID"":2,"Actions":null},\n' +
  111.             '{"RecordID","1,"OrderID"Penedo"-059","Country":"Brazil","ShipCountry":"BR","ShipCity":"Penedo","ShipName":"Torp, Brekke and Mitchell","ShipAddress":","4 Heffernan Alley","CompanyEmail":"gsoaper2i@dailymotion.com","CompanyAgent":"Giavani Soaper","CompanyName":"Pfeffer, Harber and Hintz","Currency":"BRL","Notes":"et ultrices posuere cubilia curae mauris viverra diam vitae quam suspendisse potenti nullam porttitor",":-10.2735517,"lectronics","Website":"prnewswire.com","Latitude":-10.2735517,"Longitude":-36.5536172,"ShipDate":"6/26/2017","PaymentDate":":"17-08-01 21:21:10",":2,"Zone":1,"erica/Maceio","TotalPayment":"$461213.42","Status"OrderID"":1,"Actions","ull},\n' +
  112.             '{"RecordID","2,"OrderID"Wanshi"-0396","Country":"China","ShipCountry":"CN"75440 Loftsgordon Avenue"pName":"Lockman-Davis","ShipAddress":"75440 Loftsgordon Avenue","CompanyEmail":"kgowenlock2j@a8.net","CompanyAgent"Currency"Gowenlock","CompanyName":"Kirlin, Goldner and Upton","Currency":"CNY","Notes":"posuere felis sed lacus morbi sem mauris laoreet ut rhoncus aliquet pulvinar sed","Department":"Kids","Website":"behance.net","Latitude":31.471686,"Longitude":119.934764,"ShipDate":"9/11/2017","PaymentDate":"2016-05-06 03:36:46","TimeZone":"Asia/Shanghai","TotalPayment":"$290389.01","Status"OrderID"":3,"Actions":null},\n' +
  113.             '{"RecordID":93,"OrderID":":"236-184",","untry":"Azerbaijan","ShipCountry"ShipAddress"ity":"Lƶkbatan","ShipName":"Morissette-Gislason","ShipAddress":"8338 Saint Paul Plaza","CompanyEmail":"tsandon2k@trellian.com","CompanyAgent"Notes"ie Sandon","CompanyName":"Herman-Erdman","Currency":"AZN","Notes":"at vulputate vitae nisl aenean lectus pellentesque eget nunc donec quis orci","Department":49.7355969,"site":"ebay.co.uk","Latitude":40.3281802,"Longitude":49.7355969,"ShipDate":"9/16/2016","PaymentDate":"2016-12-24 08:27:33","TimeZone":"Asia/Baku","TotalPayment":"$525119.41",":94,"s":3,"Type":1,"Actions"Country"n' +
  114.             '{"RecordID":94,"OrderID":"11822-9854",","untry":"Indonesia","ShipCountry"ShipAddress"ity":"Pasirpanjang","ShipName":"Dietrich-Langworth","ShipAddress":"5 Hollow Ridge Plaza","CompanyEmail","mtrayhorn2l@sciencedirect.com"Currency"Agent","Marcos Trayhorn","CompanyName":"Pacocha-Kling","Currency":"IDR","Notes":"justo sollicitudin ut suscipit a feugiat et eros vestibulum ac est","Department":"Sports","Website":"ShipDate"ibune.com",","titude":0.845865,"Longitude":108.8796091,"ShipDate":"3/27/2016","PaymentDate"$362198.01"8 14:15:50","Type"one"Actions"akarta","TotalPayment":"$362198.01",":95,"s":4,"Type":3,"Actions":null},\n' +
  115.             '{"RecordID"ShipCity"rID":"49643-120"ShipName"":"Russia","ShipCountry":"RU","ShipCity","Muchkapskiy","ShipName":"Conn LLC","ShipAddress":"68 5th Drive","CompanyEmail":"fmunford2m@tiny.cc","CompanyAgent":"Francis Munford","CompanyName":"Smith-Stokes","Currency":"RUB","Notes":"tempus vel pede morbi porttitor lorem id ligula suspendisse ornare consequat","Longitude"":"Beauty","Website":":".ac.uk","Latitude":51.8478427,"Longitude":42.4697909,"ShipDate":"9/12/2016"TotalPayment"":"2017-01-27 16:06:13":4,"meZone":"Actions"oscow","TotalPayment":"$1001206.62",":96,"s":4,"Type":1,"Actions":null},\n' +
  116.             '{":"cordID":96,"OrderID":"56062-393","Country":"Guam":"ShipCountry":"GU","ShipCity":"Agana Heights Village","ShipName":"Mayer-Cole","ShipAddress":"04373 Golden Leaf Center","CompanyEmail":"ckahler2n@histats.com",","mpanyAgent"USD"triona Kahler","CompanyName":"Lynch-Satterfield","Currency":"USD","Notes":"ullamcorper purus sit amet nulla quisque arcu libero rutrum ac lobortis vel dapibus at diam","Department":"Jewelery","Website":"newyorker.com","Latitude":13.4677672,"Longitude":144.7453228,"ShipDate":"7/18/2017","PaymentDate"$717532.21"1 16:10:22","Type"one"Actions"c/Guam","TotalPayment":"$717532.21",":97,"s":5,"Type":1,"Actions"Country"n' +
  117.             '{"RecordID":97,"OrderID":"50436-0120","Country":"Dominica","ShipCountry":"DM"ShipAddress""SoufriĆØre","ShipName":"Ernser, Miller and Barton","ShipAddress":"7 Canary Crossing","CompanyEmail":"gkleinplatz2o@naver.com","CompanyAgent":","useppe Kleinplatz","CompanyName":"Denesik-Wyman","Currency":"XCD","Notes":"congue elementum in hac habitasse platea dictumst morbi vestibulum velit id","Department":":-61.3567483,"":"miibeian.gov.cn","Latitude":15.2338798,"Longitude":-61.3567483,"ShipDate":"12/20/2017","PaymentDate":"2016-08-13 23:06:00":2,"meZone":"Actions"Dominica","TotalPayment":"$630409.34":98,"tus":2,":"pe":3,"Actions":null},\n' +
  118.             '{":"cordID":98,"OrderID":"42507-004","Country"Borer and Sons"Country":"MX","ShipCity":"Rancho Nuevo","ShipName":"Borer and Sons","ShipAddress","424 Birchwood Terrace","CompanyEmail":"lgrinishin2p@hubpages.com","CompanyAgent":"Lucky Grinishin","CompanyName":"O\'Reilly, Block and Goyette","Currency":"MXN","Notes":"mauris lacinia sapien quis libero nullam sit amet turpis elementum ligula vehicula consequat morbi a ipsum integer a nibh"Longitude"nt":"Tools","Website":"hexun.com","Latitude":22.2222241,"Longitude":-100.9256085,"ShipDate":"12/22/2017",","ymentDate":"2016-04-09 03:07:19","TimeZone":"America/Mexico_City","TotalPayment":"$314052.63":99,"tus":2,":"pe":3,"Actions":null},\n' +
  119.             '{"RecordID":99,"OrderID":"49230-191","Country":"Japan","ShipCountry":"JP","ShipCity":"Yokosuka","ShipName":"White, Legros and Carroll","ShipAddress":"8 Annamark Place",","mpanyEmail":"mellse2q@xinhuanet.com","CompanyAgent":":"ade Ellse","CompanyName":"Purdy-Carroll","Currency":"JPY","Notes":"magna ac consequat metus sapien ut nunc vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia","Longitude"":"Sports","Website":"abc.net.au","Latitude":34.6830797,"Longitude":137.9865313,"ShipDate":"12/12/2016","PaymentDate":"2016-08-30 12:27:38","TimeZone":"Asia/Tokyo","TotalPayment":"$1127673.96":100,"us":1,"Type":1,"Actions":null},\n' +
  120.             '{"RecordID":100,"OrderID":"50865-056","Country":"Honduras","ShipCountry":"HN","ShipCity":"YuscarĆ�n","ShipName":"Anderson, Pfannerstill and Miller",","ipAddress":"116 Bay Way","CompanyEmail":"hensley2r@businessweek.com","CompanyAgent":"Hamil Ensley","CompanyName":"Kessler, Greenfelder and Gaylord","Currency":"HNL","Notes":"nulla ac enim in tempor turpis nec euismod scelerisque quam turpis adipiscing lorem vitae mattis","Department":"Kids","Website"1/14/2016"","Latitude":13.9448964,"Longitude":-86.8508942,"America/Tegucigalpa"","PaymentDate":"2016-12-27 22:25:10":6,"meZone":"Actions"Tegucigalpa","TotalPayment":"$386091.31","Status":6,"Type":3,"Actions":null}]');
  121. // datasource definition
  122. $('#kt_datatable').KTDatatable({
  123.             // datasource definition
  124.             data: {
  125.                 type: 'local',
  126.                 source: dat// layout definition
  127.        pageSize: 10,
  128.             },
  129.  
  130.             // l// enable/disable datatable scroll both horizontal and vertical when needed.
  131. le/disable datat// height: 450, // datatable's body's fixed height
  132. d.
  133.                 // height: 4// display/hide footer
  134. 's fixed height
  135.             // column sorting
  136.  // display/hide footer
  137.             },
  138.  
  139.             // column sorting
  140.             sortable: true,
  141.  
  142.             pagination: true,
  143.  
  144.             search: {
  145.                 input: $('#kt_datatable_search_quer// columns definition
  146. ey: 'generalSearch'
  147.             },
  148.  
  149.             // columns definition
  150.             columns: [{
  151.                 field: 'RecordID',
  152.                 title: '#',
  153.                 sortable: false,
  154.                 width: 20,
  155.                 type: 'number',
  156.                 selector: {
  157.                     class: ''
  158.                 },
  159.                 textAlign: 'center',
  160.             }, {
  161.                 field: 'OrderID',
  162.                 title: 'Order ID',
  163.             }, {
  164.                 field: 'Country',
  165.                 title: 'Country',
  166.                 template: function(row) {
  167.                     return row.Country + ' ' + row.ShipCountry;
  168.                 },
  169.             }, {
  170.                 field: 'date'ate',
  171.                 title: 'Ship Date',
  172.                 type: 'date',
  173.                 format: 'MM/DD/YYYY',
  174.             }, {
  175.                 field: 'CompanyName',
  176.                 title: 'Company Name',
  177.             }, {
  178.             // callback function support for column rendering
  179. s',
  180.                 // callback function support for column rendering
  181.                 template: function(row) {
  182.                     var status = {
  183.                         1: {
  184.                             'title': 'Pending',
  185.                             'class': ' label-light-success'
  186.                         },
  187.                         2: {
  188.                             'title': '
  189.                        },
  190.                        3: {
  191.                            '         },
  192.                         3: {
  193.                             'title': '
  194.                        },
  195.                        4: {
  196.                            '         },
  197.                         4: {
  198.                             'title': 'Success',
  199.                             'class': ' label-light-success'
  200.                         },
  201.                         5: {
  202.                             'title': 'Info',
  203.                             'class': ' label-light-info'
  204.                         },
  205.                         6: {
  206.                             'title'
  207.                        },
  208.                        7: {
  209.                            '         },
  210.                         7: {
  211.                             'title': 'Warning',
  212.                             'class': ' label-light-warning'
  213.                         },
  214.                     };
  215.                     return '<span class="label font-weight-bold label-lg ' + status[row.Status].class + ' label-inline">' + status[row.Status].title + 'Type'n>';
  216.                 },
  217.             }, {
  218.                 field: 'Type',
  219.           // callback function support for column rendering
  220. se,
  221.                 // callback function support for column rendering
  222.                 template: function(row) {
  223.                     var status = {
  224.                         1: {
  225.                             'title': 'Online',
  226.                             'state': 'danger'
  227.                         },
  228.                         2: {
  229.                             'title': 'Retail',
  230.                             'state': 'primary'
  231.                         },
  232.                         3: {
  233.                             'title': 'Direct',
  234.                             'state': 'success'
  235.                         },
  236.                     };
  237.                     return '<span class="label label-' + status[row.Type].state + ' label-dot mr-2"></span><span class="font-weight-bold text-' + status[row.Type].state + '">' +
  238.                         status[row.Type].title + 'Actions';
  239.                 },
  240.             }, {
  241.                 field: 'Actions',
  242.                 title: 'Actions',
  243.                 sortable: false,
  244.                 width: 125,
  245.                 overflow: 'visible',
  246.                 autoHide: false,
  247.                 template: function() {
  248.                     return '\
  249.                                                         <div class="dropdown dropdown-inline">\
  250.                                                                 <a href="dropdown"t:;" class="btn btn-sm btn-clean btn-icon mr-2" data-toggle="dropdown">\
  251.                                             <svg xmlns="-icon//www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" width="24px" height="24px" viewBox="0 0 24 24" version="1.1">\
  252. xlink" width="24px" height="24px" viewBox="0 0 24 24" version="1.1">\
  253.                                                 <g stroke="none" stroke-width="1" fill="none" fill-rule="evenodd">\
  254.                                                     <rect x="0" y="0" width="24"M5,8.6862915 L5,5 L8.6862915,5 L11.5857864,2.10050506 L14.4852814,5 L19,5 L19,9.51471863 L21.4852814,12 L19,14.4852814 L19,19 L14.4852814,19 L11.5857864,21.8994949 L8.6862915,19 L5,19 L5,15.3137085 L1.6862915,12 L5,8.6862915 Z M12,15 C13.6568542,15 15,13.6568542 15,12 C15,10.3431458 13.6568542,9 12,9 C10.3431458,9 9,10.3431458 9,12 C9,13.6568542 10.3431458,15 12,15 Z"9 C10.3431458,9 9,10.3431458 9,12 C9,13.6568542 10.3431458,15 12,15 Z" fill="#000000"/>\
  255.                                                 </g>\
  256.                                             </svg>\
  257.                                         </span>\
  258.                                     </a>\
  259.                                                                 <div class="dropdown-menu dropdown-menu-sm dropdown-menu-right">\
  260.                                         <ul class="navi flex-column navi-hover py-2">\
  261.                                             <li class="navi-header font-weight-bolder text-uppercase font-size-xs text-primary pb-2">\
  262.                                                 Choose an action:\
  263.                                             </li>\
  264.                                             <li class="navi-item">\
  265.                                                 <a href="#" class="navi-link">\
  266.                                                     <span class="navi-icon"><i class="la la-print"></i></span>\
  267.                                                     <span class="navi-text">Print</span>\
  268.                                                 </a>\
  269.                                             </li>\
  270.                                             <li class="navi-item">\
  271.                                                 <a href="#" class="navi-link">\
  272.                                                     <span class="navi-icon"><i class="la la-copy"></i></span>\
  273.                                                     <span class="navi-text">Copy</span>\
  274.                                                 </a>\
  275.                                             </li>\
  276.                                             <li class="navi-item">\
  277.                                                 <a href="#" class="navi-link">\
  278.                                                     <span class="navi-icon"><i class="la la-file-excel-o"></i></span>\
  279.                                                     <span class="navi-text">Excel</span>\
  280.                                                 </a>\
  281.                                             </li>\
  282.                                             <li class="navi-item">\
  283.                                                 <a href="#" class="navi-link">\
  284.                                                     <span class="navi-icon"><i class="la la-file-text-o"></i></span>\
  285.                                                     <span class="navi-text">CSV</span>\
  286.                                                 </a>\
  287.                                             </li>\
  288.                                             <li class="navi-item">\
  289.                                                 <a href="#" class="navi-link">\
  290.                                                     <span class="navi-icon"><i class="la la-file-pdf-o"></i></span>\
  291.                                                     <span class="navi-text">PDF</span>\
  292.                                                 </a>\
  293.                                             </li>\
  294.                                         </ul>\
  295.                                                                 </div>\
  296.                                                         </div>\
  297.                                                         <a href="javascript:;" class="btn btn-sm btn-clean btn-icon mr-2" title="Edit details">\
  298.                                     <span class="svg-//www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" width="24px" height="24px" viewBox="0 0 24 24" version="1.1">\
  299. xlink" width="24px" height="24px" viewBox="0 0 24 24" stroke-width="\
  300.                                             <g stroke="none" stroke-width="1" fill="none" fill-rule="evenodd">\
  301.                                                 <rect x="0" y="0" width="24" height="24"/>\
  302.                                                 <path d="M8,17.9148182 L8,5.96685884 C8,5.56391781 8.16211443,5.17792052 8.44982609,4.89581508 L10.965708,2.42895648 C11.5426798,1.86322723 12.4640974,1.85620921 13.0496196,2.41308426 L15.5337377,4.77566479 C15.8314604,5.0588212 16,5.45170806 16,5.86258077 L16,17.9148182 C16,18.7432453 15.3284271,19.4148182 14.5,19.4148182 L9.5,19.4148182 C8.67157288,19.4148182 8,18.7432453 8,17.9148182 Z" fill="#000000" fill-rule="nonzero"\ transform="translate(12.000000, 10.707409) rotate(-135.000000) translate(-12.000000, -10.707409) "/>\
  303.                                                 <rect fill="#000000" opacity="0.3" x="5" y="20" width="15" height="2" rx="1"/>\
  304.                                             </g>\
  305.                                         </svg>\
  306.                                     </span>\
  307.                                                         </a>\
  308.                                                         <a href="javascript:;" class="btn btn-sm btn-clean btn-icon" title="Delete">\
  309.                                     <span class="svg-//www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" width="24px" height="24px" viewBox="0 0 24 24" version="1.1">\
  310. xlink" width="24px" height="24px" viewBox="0 0 24 24" stroke-width="\
  311.                                             <g stroke="none" stroke-width="1" fill="none" fill-rule="evenodd">\
  312.                                                 <rect x="0" y="0" width="24" height="24"/>\
  313.                                                 <path d="M6,8 L6,20.5 C6,21.3284271 6.67157288,22 7.5,22 L16.5,22 C17.3284271,22 18,21.3284271 18,20.5 L18,8 L6,8 Z" fill="#000000" fill-rule="nonzero"/>\
  314.                                                 <path d="M14,4.5 L14,4 C14,3.44771525 13.5522847,3 13,3 L11,3 C10.4477153,3 10,3.44771525 10,4 L10,4.5 L5.5,4.5 C5.22385763,4.5 5,4.72385763 5,5 L5,5.5 C5,5.77614237 5.22385763,6 5.5,6 L18.5,6 C18.7761424,6 19,5.77614237 19,5.5 L19,5 C19,4.72385763 18.7761424,4.5 18.5,4.5 L14,4.5 Z" fill="#000000" opacity="0.3"/>\
  315.                                             </g>\
  316.                                         </svg>\
  317.                                     </span>\
  318.                                                         </a>\
  319.                                                 ';
  320.                 },
  321.             }],
  322.         });
  323.  
  324.         $('#kt_datatable_search_status').on('change', function() {
  325.             datatable.search($(this).val().toLowerCase(), 'Status');
  326.         });
  327.  
  328.         $('#kt_datatable_search_type').on('change', function() {
  329.             datatable.search($(this).val().toLowerCase(), 'Type');
  330.         });
  331.  
  332.         $('#kt_datatable_search_status, #kt// Public functions
  333. pe').selectpicker();
  334.     };
  335.  
  336.     return// init dmeo
  337.  Public functions
  338.         init: function() {
  339.             // init dmeo
  340.             demo();
  341.         },
  342.     };
  343. }();
  344.  
  345. jQuery

Raw Paste


Login or Register to edit or fork this paste. It's free.