Jump to content

winuser2003

Members
  • Posts

    101
  • Joined

  • Last visited

Everything posted by winuser2003

  1. do you want me to create a new thread? There is no deadline on this type of work either... I have started it, which I believe export to csv is quite easy... I will start new threads based on features I would need assistance with. we can close this signature thread as completed.
  2. Can you help me get a start on the concept I proposed? or do you have a better concept we could think about using?
  3. So the code gets refactored providing a drop down of options the tech can choose from when observing situations. For example in the app within the phone, I believe there is a drop down that consist of different issues that can be selected from. Once selected, this option is reflected into the DB. I believe that part is achieved already. I believe one of the item numbers hold this information.
  4. Answer to Question 3 For comments on 1 and 2 your absolutely correct. Not sure how this would be approached code wise I agree, unless there is a better approach to all this.. Again, my concept was just that a concept. I am sure you get the idea of the goal by now regardless of how its approached or what the design looks like, its just making it work I basically so the clarity of information is alot more organized / clearer / and self explanatory.
  5. that worked to achieve what needs to be achieved would i need to update the PHP version? or can what we want to accomplish here be done in pre PHP 5.6?
  6. added this code --- got the error -- Parse error: syntax error, unexpected '*' in C:\xampp\htdocs3\pmapp\sigtest02.php on line 60 <?php mysqli_report(MYSQLI_REPORT_ERROR|MYSQLI_REPORT_STRICT); $conn = mysqli_connect("localhost", "winuser2003", "homer123", "pmapp"); $tdata = ''; $res = $conn->query("SELECT id, first_name, last_name, tech_phonenum, store_name, store_num, store_address, manager_name, robot_num, checkin_time, item_one, item_two, item_three, item_four, item_five, item_six, item_seven, item_eight, item_nine, item_ten, item_eleven, item_twelve, item_thirteen, item_fourteen, item_fifteen, item_sixteen, item_seventeen, item_eighteen, item_nineteen, item_twenty, item_twentyone, item_twentytwo, tech_general_comment, checkout_time, manager_sign_x, manager_sign_y FROM pmvisit"); foreach ($res as $r) { $tdata .= "<tr><td>{$r['id']}</td> <td>{$r['first_name']}</td> <td>{$r['last_name']}</td> <td>{$r['tech_phonenum']}</td> <td>{$r['store_name']}</td> <td>{$r['store_num']}</td> <td>{$r['store_address']}</td> <td>{$r['manager_name']}</td> <td>{$r['robot_num']}</td> <td>{$r['checkin_time']}</td> <td>{$r['item_one']}</td> <td>{$r['item_two']}</td> <td>{$r['item_three']}</td> <td>{$r['item_four']}</td> <td>{$r['item_five']}</td> <td>{$r['item_six']}</td> <td>{$r['item_seven']}</td> <td>{$r['item_eight']}</td> <td>{$r['item_nine']}</td> <td>{$r['item_ten']}</td> <td>{$r['item_eleven']}</td> <td>{$r['item_twelve']}</td> <td>{$r['item_thirteen']}</td> <td>{$r['item_fourteen']}</td> <td>{$r['item_fifteen']}</td> <td>{$r['item_sixteen']}</td> <td>{$r['item_seventeen']}</td> <td>{$r['item_eighteen']}</td> <td>{$r['item_nineteen']}</td> <td>{$r['item_twenty']}</td> <td>{$r['item_twentyone']}</td> <td>{$r['item_twentytwo']}</td> <td>{$r['tech_general_comment']}</td> <td>{$r['checkout_time']}</td> <td>" . drawImage($r['manager_sign_x'], $r['manager_sign_y']) . "</td>\n"; } function drawImage($xcoords, $ycoords) { $xa = $xcoords[0]=='[' ? json_decode($xcoords, 1) : explode(',', $xcoords); // put x coords into an array $ya = $ycoords[0]=='[' ? json_decode($ycoords, 1) : explode(',', $ycoords); // put x coords into an array $w = max($xa)+10; // get the max coord values so we know the size $h = max($ya)+10; $path = ''; $px = $py = -31; // ensure we Move to first point foreach ($xa as $i => $x) { // loop through arrays $y = $ya[$i]; // pairing the ith x with the ith y $dx = $x-$px; $dy = $y-$py; $px = $x; $py = $y; $act = (sqrt($dx**2 + $dy**2) > 30) ? 'M' : 'L'; // check distance between successive points $path .= "$act $x $y "; // define line to x y } // create svg object $w x $h to display image $im = "<svg width='$w' height='$h'> <path d='$path' stroke='#000' stroke-width='2' fill='none'/> </svg>"; return $im; } ?> <!DOCTYPE html> <html> <head> <style type="text/css"> table { border-collapse: collapse; width: 60%; } th { background-color: blue; color: white; padding: 10px; text-align: left; } td { padding: 4px 20px;; } </style> </head> <body> <table border="1" style="width: 60%;"> <tr><th>ID</th> <th>First name</th> <th>Last name</th> <th>Tech Phone Number</th> <th>Store Name</th> <th>Store Number</th> <th>Store Address</th> <th>Manager's Name</th> <th>Robot Number</th> <th>Checkin Time</th> <th>Bumper Tie Rod Mounting Screws</th> <th>Inspect/Clean Caster and Drv Wheel</th> <th>Inspect Bumper Damage</th> <th>Remove Motor Cble Ties / inspect frayed cables</th> <th>Inspect Screws/Parts in tray area</th> <th>Vaccum Cooling Air Inlets for PC</th> <th>Visual Cable Inspection / Connections</th> <th>12V Power Port Inspection</th> <th>Lidar Drv Belt Inspect</th> <th>Backdoor Alignment Check</th> <th>Charging Connector Contact Condition</th> <th>Trim lwr right cover under lidar</th> <th>Tighten GO Button nut</th> <th>Align WiFi Antenna</th> <th>Center Camera Alignment Check</th> <th>Lidar Rotation Check</th> <th>Googly Eyes Check</th> <th>Cleaned Non-Optical Cover Surfaces</th> <th>Clean all Optical Imaging Components</th> <th>Inspect Dock Connector / Height / Contact Condition</th> <th>Dock and Fudicals Cleaned</th> <th>Dock and Park Tape</th> <th>Technician General Comments</th> <th>Checkout Time</th> <th>Manager Signature</th> <tr> <?=$tdata?> </table> </body> </html>
  7. Concept Version 1 : - Export Report to CSV file - Print Report Option - View Issues ONLY Report - eMail Report Option - Ability to perform different types of searches - Sorting arrows to sort data - Count Report towards the bottom Just the first concept I had in mind and wanted your thoughts. One of the biggest parts of the report is the issues and the counts. Again, this is first concept and wanted your thoughts. I am not sure if its possible to create a cron job to send out the report every so often, like once a month etc... not sure how that would be approached.
  8. How do we then remain the signature on the left side be used as the standard? My colleague told me something about the print and signature... this is 2 different ways of showing the signature. He said though the print version eventually turns into the signature version. Your signature on the left side looks much and far better!
  9. I agree, I like that much better! the flow is alot more logical thanks for that!
  10. Here is the original table --- has dummy data in it -- phpMyAdmin SQL Dump -- version 4.5.1 -- http://www.phpmyadmin.net -- -- Host: 127.0.0.1 -- Generation Time: Feb 20, 2020 at 09:12 PM -- Server version: 10.1.19-MariaDB -- PHP Version: 5.5.38 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!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 utf8mb4 */; -- -- Database: `pmapp` -- -- -------------------------------------------------------- -- -- Table structure for table `pmvisit` -- CREATE TABLE `pmvisit` ( `id` int(6) UNSIGNED NOT NULL, `first_name` varchar(30) NOT NULL, `last_name` varchar(30) NOT NULL, `tech_phonenum` varchar(30) NOT NULL, `store_name` varchar(30) NOT NULL, `store_num` varchar(10) NOT NULL, `store_address` varchar(70) NOT NULL, `manager_name` varchar(60) NOT NULL, `robot_num` varchar(60) NOT NULL, `checkin_time` varchar(80) NOT NULL, `item_one` varchar(255) NOT NULL, `item_two` varchar(255) NOT NULL, `item_three` varchar(255) NOT NULL, `item_four` varchar(255) NOT NULL, `item_five` varchar(255) NOT NULL, `item_six` varchar(255) NOT NULL, `item_seven` varchar(255) NOT NULL, `item_eight` varchar(255) NOT NULL, `item_nine` varchar(255) NOT NULL, `item_ten` varchar(255) NOT NULL, `item_eleven` varchar(255) NOT NULL, `item_twelve` varchar(255) NOT NULL, `item_thirteen` varchar(255) NOT NULL, `item_fourteen` varchar(255) NOT NULL, `item_fifteen` varchar(255) NOT NULL, `item_sixteen` varchar(255) NOT NULL, `item_seventeen` varchar(255) NOT NULL, `item_eighteen` varchar(255) NOT NULL, `item_nineteen` varchar(255) NOT NULL, `item_twenty` varchar(255) NOT NULL, `item_twentyone` varchar(255) NOT NULL, `item_twentytwo` varchar(255) NOT NULL, `tech_general_comment` varchar(80) NOT NULL, `manager_comments` varchar(80) NOT NULL, `manager_sign_x` text NOT NULL, `manager_sign_y` text NOT NULL, `checkout_time` varchar(80) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `pmvisit` -- INSERT INTO `pmvisit` (`id`, `first_name`, `last_name`, `tech_phonenum`, `store_name`, `store_num`, `store_address`, `manager_name`, `robot_num`, `checkin_time`, `item_one`, `item_two`, `item_three`, `item_four`, `item_five`, `item_six`, `item_seven`, `item_eight`, `item_nine`, `item_ten`, `item_eleven`, `item_twelve`, `item_thirteen`, `item_fourteen`, `item_fifteen`, `item_sixteen`, `item_seventeen`, `item_eighteen`, `item_nineteen`, `item_twenty`, `item_twentyone`, `item_twentytwo`, `tech_general_comment`, `manager_comments`, `manager_sign_x`, `manager_sign_y`, `checkout_time`) VALUES (25, 'eric ', 'han ', '8593339433', 'Stop&Shop', '1345', '1234 asdf', 'asdf', '456456', '02-20-2020 - 15:03', 'Screw missing', 'Bumper bent', 'Screw missing', 'Bumper bent', 'Screw missing', 'Screw missing', 'Screw missing', 'Screw missing', 'Screw missing', 'Screw missing', 'Bumper bent', 'Bumper bent', 'Bumper bent', 'Bumper bent', 'Screw missing', 'Screw missing', 'Screw missing', 'Screw missing', 'Screw missing', 'Screw missing', 'Screw missing', 'Screw missing', 'Done', '', '60, 62, 68, 74, 83, 92, 102, 113, 124, 130, 140, 148, 154, 159, 160, 160, 160, 160, 156, 150, 137, 123, 106, 90, 75, 61, 49, 40, 35, 32, 31, 31, 31, 35, 42, 49, 62, 77, 95, 112, 128, 144, 157, 167, 172, 171, 170, 166, 162, 155, 150, 144, 141, 139, 136, 136, 136, 141, 147, 155, 164, 173, 181, 186, 193, 199, 208, 214, 215, 216, 213, 205, 197, 193, 191, 191, 194, 199, 209, 214, 224, 237, 253, 272, 288, 303, 319, 330, 340, 346, 349, 351, 351, 351, 350, 350, 350, 350, 351, 351, 352, 354, 356, 356, 358, 358', '79, 80, 84, 86, 89, 90, 90, 90, 90, 86, 79, 74, 69, 64, 61, 57, 54, 50, 47, 46, 46, 46, 49, 54, 60, 68, 77, 85, 92, 99, 107, 116, 124, 131, 137, 141, 143, 144, 144, 139, 134, 128, 121, 116, 113, 113, 113, 113, 115, 118, 121, 126, 129, 132, 136, 138, 141, 143, 144, 144, 143, 139, 135, 130, 126, 122, 119, 118, 117, 117, 119, 125, 130, 135, 138, 139, 137, 132, 127, 123, 115, 109, 101, 93, 87, 80, 76, 71, 67, 63, 59, 56, 54, 51, 51, 50, 49, 48, 47, 46, 46, 43, 42, 41, 39, 39', '02-20-2020 - 15:04'), (26, 'eric ', 'han ', '8593339433', 'Stop&Shop', '5465', '345 asdf', 'dsfasdf', '456456', '02-20-2020 - 15:05', 'Screw missing', 'Screw missing', 'Done', 'Done', 'Screw missing', 'Screw missing', 'Screw missing', 'Screw missing', 'Screw missing', 'Bumper bent', 'Screw missing', 'Screw missing', 'Screw missing', 'Screw missing', 'Screw missing', 'Screw missing', 'Done', 'Screw missing', 'Done', 'Screw missing', 'Screw missing', 'Done', 'Screw missing', 'ZzXc', '260, 259, 259, 257, 255, 250, 245, 240, 235, 228, 224, 220, 215, 209, 202, 195, 187, 179, 170, 164, 157, 150, 145, 138, 131, 126, 118, 108, 103, 95, 87, 81, 76, 70, 65, 61, 57, 54, 50, 49, 48, 46, 45, 45, 45, 45, 46, 47, 49, 52, 56, 61, 67, 75, 85, 98, 113, 126, 142, 156, 169, 182, 194, 204, 211, 218, 224, 230, 235, 242, 249, 255, 262, 269, 278, 285, 296, 308, 321, 335, 349, 360, 371, 380, 386, 389, 394, 394, 395, 395, 395, 395, 395, 395, 394, 394, 393, 392, 391, 389, 388, 385, 382, 380, 377, 376, 374, 372, 369, 366, 363, 361, 360, 359, 357, 356, 353, 349, 344, 340, 333, 326, 319, 311, 304, 298, 289, 279, 269, 259, 249, 240, 233, 226, 222, 217, 212, 207, 200, 194, 187, 178, 168, 156, 144, 133, 123, 113, 103, 94, 88, 80, 74, 69, 66, 63, 62, 58, 57, 56, 56, 55, 54, 54', '25, 27, 29, 33, 36, 41, 46, 53, 60, 68, 73, 80, 87, 93, 100, 105, 110, 115, 119, 121, 123, 124, 124, 124, 124, 124, 124, 123, 122, 121, 121, 118, 117, 114, 111, 108, 105, 102, 99, 97, 95, 92, 89, 85, 84, 82, 79, 77, 76, 75, 74, 73, 72, 72, 72, 72, 72, 72, 72, 72, 72, 72, 74, 77, 79, 82, 85, 88, 91, 94, 97, 99, 102, 105, 106, 109, 109, 110, 110, 110, 110, 109, 105, 102, 99, 97, 94, 93, 93, 92, 90, 88, 85, 82, 77, 74, 71, 68, 64, 61, 57, 52, 49, 46, 43, 42, 40, 39, 38, 38, 38, 38, 38, 38, 38, 39, 39, 41, 42, 43, 45, 47, 48, 50, 51, 52, 54, 54, 56, 58, 58, 60, 61, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 60, 59, 57, 56, 54, 51, 49, 47, 46, 46, 44, 43, 43, 42, 41, 41, 40, 40, 40, 40', '02-20-2020 - 15:06'), (27, 'eric ', 'han ', '8593339433', 'Stop&Shop', '4565', '123 sdfdsf', 'asdfdsaf', '54564564', '02-20-2020 - 15:07', 'Done', 'Screw missing', 'Screw missing', 'Bumper bent', 'Bumper bent', 'Screw missing', 'Bumper bent', 'Screw missing', 'Screw missing', 'Screw missing', 'Screw missing', 'Bumper bent', 'Screw missing', 'Done', 'Screw missing', 'Screw missing', 'Screw missing', 'Screw missing', 'Screw missing', 'Bumper bent', 'Screw missing', 'Screw missing', 'Bumper bent', '', '275, 273, 271, 263, 255, 244, 232, 220, 210, 199, 188, 177, 165, 155, 145, 136, 127, 120, 111, 104, 100, 95, 92, 90, 88, 86, 83, 82, 80, 79, 78, 78, 78, 79, 79, 82, 83, 85, 86, 89, 91, 93, 96, 100, 103, 107, 113, 120, 127, 136, 144, 152, 160, 168, 175, 182, 191, 198, 206, 214, 222, 229, 239, 247, 256, 263, 271, 277, 284, 291, 296, 300, 304, 309, 312, 316, 318, 322, 325, 328, 331, 332, 333, 333, 334, 336, 336, 336, 336, 336, 336, 336, 336, 335, 334, 332, 331, 330, 328, 325, 323, 317, 314, 308, 304, 299, 294, 291, 288, 284, 283, 280, 275, 271, 264, 259, 252, 244, 236, 228, 219, 211, 204, 198, 190, 180, 170, 162, 156, 148, 141, 134, 131, 128, 126, 123, 120, 115, 110, 104, 98, 94, 91, 90, 89, 90, 91, 93, 94, 96, 97, 98, 99, 100, 102, 104, 106, 109, 112, 114, 115, 116, 116, 116, 116, 116, 116, 116, 116, 116, 116, 116, 117, 118, 121, 123, 125, 126, 126, 127, 128, 128, 129, 132, 135, 137, 141, 142, 143, 144, 145, 147, 148, 151, 154, 155, 157, 159, 160, 162, 163, 164, 166, 169, 170, 170, 171, 171, 173, 175, 179, 183, 189, 196, 201, 204, 210, 213, 216, 217, 218, 221, 222, 226, 229, 233, 237, 239, 240, 241, 241, 241, 242, 243, 243, 244, 244, 245, 245, 245, 245, 245, 243, 243, 241, 239, 236, 232, 229, 225, 221, 219, 216, 213, 208, 205, 201, 197, 192, 191, 189, 188, 187, 185, 183, 181, 180, 179, 178, 178, 178, 178, 179, 181, 184, 187, 189, 192, 197, 203, 210, 219, 228, 239, 248, 260, 269, 277, 285, 292, 298, 302, 306, 309, 310, 311, 309, 305, 301, 295, 291, 283, 275, 266, 258, 249, 238, 225, 212, 199, 186, 174, 161, 151, 142, 132, 124, 119, 114, 111, 110, 115, 123, 134, 147, 163, 181, 199, 220, 237, 254, 273, 288, 303, 318, 331, 341, 350, 356, 360, 362, 363, 364, 364, 364', '50, 53, 56, 61, 67, 73, 80, 86, 93, 99, 102, 105, 106, 107, 109, 109, 109, 109, 109, 107, 107, 105, 104, 102, 100, 98, 95, 92, 89, 88, 86, 85, 83, 81, 80, 78, 75, 74, 72, 71, 70, 70, 69, 68, 67, 67, 66, 66, 66, 66, 66, 66, 68, 71, 73, 77, 80, 84, 88, 90, 95, 98, 100, 102, 105, 105, 106, 106, 106, 106, 104, 102, 99, 94, 90, 84, 79, 74, 69, 65, 60, 58, 57, 56, 54, 50, 48, 45, 41, 35, 32, 28, 25, 21, 19, 16, 15, 12, 11, 10, 9, 8, 8, 8, 8, 8, 10, 11, 13, 15, 17, 19, 20, 22, 23, 25, 26, 29, 30, 30, 30, 30, 30, 30, 30, 29, 28, 28, 28, 28, 28, 28, 29, 29, 29, 29, 29, 29, 29, 29, 29, 29, 29, 29, 29, 29, 29, 28, 28, 27, 26, 26, 26, 26, 26, 27, 28, 29, 31, 31, 31, 32, 33, 35, 36, 38, 40, 42, 44, 45, 47, 48, 51, 53, 56, 57, 58, 58, 59, 59, 59, 60, 60, 60, 62, 62, 62, 62, 63, 63, 64, 67, 69, 72, 76, 78, 79, 81, 82, 83, 85, 85, 88, 90, 90, 91, 91, 92, 92, 93, 94, 94, 96, 96, 96, 97, 98, 99, 99, 99, 100, 102, 102, 105, 106, 109, 111, 112, 114, 114, 115, 116, 117, 118, 119, 121, 122, 122, 123, 124, 125, 126, 127, 128, 130, 132, 133, 135, 136, 137, 138, 139, 139, 140, 142, 142, 142, 142, 142, 142, 142, 142, 142, 141, 141, 141, 140, 139, 138, 137, 136, 135, 134, 134, 133, 131, 131, 131, 130, 129, 128, 127, 126, 124, 123, 121, 120, 119, 118, 117, 117, 117, 117, 117, 117, 117, 118, 121, 124, 128, 131, 135, 139, 142, 143, 144, 146, 146, 146, 146, 146, 146, 146, 146, 146, 145, 144, 144, 142, 142, 142, 143, 143, 144, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 146, 146, 146, 146, 145, 145', '02-20-2020 - 15:08'), (28, 'eric ', 'han ', '8593339433', 'Stop&Shop', '4565', '1324 asdf', 'adsf', '456456546', '02-20-2020 - 15:08', 'Screw missing', 'Screw missing', 'Screw missing', 'Screw missing', 'Screw missing', 'Screw missing', 'Bumper bent', 'Screw missing', 'Screw missing', 'Screw missing', 'Screw missing', 'Bumper bent', 'Screw missing', 'Screw missing', 'Screw missing', 'Screw missing', 'Screw missing', 'Bumper bent', 'Screw missing', 'Screw missing', 'Screw missing', 'Bumper bent', 'Screw missing', '', '102, 102, 102, 103, 104, 104, 104, 104, 104, 104, 104, 104, 104, 105, 105, 107, 108, 108, 109, 110, 110, 111, 113, 116, 119, 122, 127, 133, 138, 143, 147, 154, 157, 161, 165, 167, 170, 171, 173, 175, 176, 177, 179, 180, 181, 181, 182, 184, 186, 188, 191, 196, 199, 203, 206, 208, 209, 212, 215, 217, 219, 222, 222, 225, 225, 226, 227, 229, 230, 233, 236, 237, 241, 247, 252, 257, 262, 267, 270, 274, 278, 281, 283, 284, 288, 290, 293, 295, 296, 298, 299, 300, 301, 303, 306, 308, 311, 315, 320, 323, 328, 333, 334, 337, 339, 340, 341, 343, 341, 341, 340, 339, 338, 337, 336, 336, 336, 336, 336, 337, 340, 342, 343, 344, 345, 345, 346, 346, 346, 344, 342, 341, 340, 338, 334, 328, 321, 312, 302, 289, 275, 260, 247, 234, 224, 217, 210, 206, 201, 199, 198, 198, 198, 198, 198, 198, 198, 199, 201, 201, 204, 205, 207, 208, 211, 212, 212, 212, 214, 214, 215, 216, 217, 220, 223, 229, 235, 242, 250, 259, 269, 278, 287, 294, 301, 305, 308, 310, 311, 312, 313, 314, 316, 318, 319, 321, 324, 326, 327, 328, 330, 333, 334, 338, 345, 350, 356, 361, 365, 368, 369, 363, 357, 349, 342, 333, 322, 310, 297, 286, 270, 257, 244, 234, 226, 217, 209, 202, 194, 189, 185, 180, 176, 171, 168, 164, 161, 158, 154, 150, 144, 137, 130, 121, 112, 102, 93, 84, 76, 68, 62, 57, 52, 49, 48, 45, 43, 42, 41, 40, 39, 39', '36, 37, 43, 47, 54, 61, 67, 75, 83, 90, 99, 107, 114, 120, 126, 132, 135, 139, 141, 141, 142, 142, 139, 133, 127, 120, 111, 101, 92, 82, 74, 64, 56, 47, 39, 33, 29, 26, 24, 22, 21, 20, 20, 20, 20, 22, 25, 30, 36, 44, 53, 63, 74, 84, 92, 102, 110, 119, 127, 131, 137, 142, 143, 145, 146, 146, 146, 143, 140, 135, 129, 125, 119, 112, 105, 99, 92, 85, 79, 74, 69, 65, 63, 61, 58, 56, 54, 54, 53, 52, 52, 52, 53, 53, 53, 53, 53, 51, 47, 43, 35, 28, 24, 18, 13, 8, 4, 1, 6, 11, 17, 23, 30, 37, 45, 51, 58, 65, 70, 77, 84, 88, 93, 97, 100, 103, 105, 106, 108, 111, 113, 114, 116, 117, 120, 122, 123, 123, 123, 123, 123, 122, 120, 119, 117, 117, 117, 116, 115, 114, 114, 113, 110, 106, 102, 96, 89, 83, 78, 73, 66, 59, 52, 47, 40, 36, 33, 30, 28, 27, 27, 27, 27, 27, 27, 27, 27, 28, 28, 29, 29, 29, 29, 30, 30, 31, 31, 32, 33, 34, 34, 35, 37, 38, 38, 38, 40, 41, 42, 42, 43, 44, 45, 46, 46, 47, 48, 48, 48, 48, 48, 51, 55, 60, 65, 70, 75, 81, 86, 91, 94, 96, 98, 100, 101, 102, 103, 104, 105, 106, 106, 107, 107, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109', '02-20-2020 - 15:09'), (29, 'eric ', 'han ', '8593339433', 'Stop&Shop', '4565', '1324 asdf', 'adsf', '456456546', '02-20-2020 - 15:08', 'Screw missing', 'Screw missing', 'Screw missing', 'Screw missing', 'Screw missing', 'Screw missing', 'Bumper bent', 'Screw missing', 'Screw missing', 'Screw missing', 'Screw missing', 'Bumper bent', 'Screw missing', 'Screw missing', 'Screw missing', 'Screw missing', 'Screw missing', 'Bumper bent', 'Screw missing', 'Screw missing', 'Screw missing', 'Bumper bent', 'Screw missing', '', '102, 102, 102, 103, 104, 104, 104, 104, 104, 104, 104, 104, 104, 105, 105, 107, 108, 108, 109, 110, 110, 111, 113, 116, 119, 122, 127, 133, 138, 143, 147, 154, 157, 161, 165, 167, 170, 171, 173, 175, 176, 177, 179, 180, 181, 181, 182, 184, 186, 188, 191, 196, 199, 203, 206, 208, 209, 212, 215, 217, 219, 222, 222, 225, 225, 226, 227, 229, 230, 233, 236, 237, 241, 247, 252, 257, 262, 267, 270, 274, 278, 281, 283, 284, 288, 290, 293, 295, 296, 298, 299, 300, 301, 303, 306, 308, 311, 315, 320, 323, 328, 333, 334, 337, 339, 340, 341, 343, 341, 341, 340, 339, 338, 337, 336, 336, 336, 336, 336, 337, 340, 342, 343, 344, 345, 345, 346, 346, 346, 344, 342, 341, 340, 338, 334, 328, 321, 312, 302, 289, 275, 260, 247, 234, 224, 217, 210, 206, 201, 199, 198, 198, 198, 198, 198, 198, 198, 199, 201, 201, 204, 205, 207, 208, 211, 212, 212, 212, 214, 214, 215, 216, 217, 220, 223, 229, 235, 242, 250, 259, 269, 278, 287, 294, 301, 305, 308, 310, 311, 312, 313, 314, 316, 318, 319, 321, 324, 326, 327, 328, 330, 333, 334, 338, 345, 350, 356, 361, 365, 368, 369, 363, 357, 349, 342, 333, 322, 310, 297, 286, 270, 257, 244, 234, 226, 217, 209, 202, 194, 189, 185, 180, 176, 171, 168, 164, 161, 158, 154, 150, 144, 137, 130, 121, 112, 102, 93, 84, 76, 68, 62, 57, 52, 49, 48, 45, 43, 42, 41, 40, 39, 39', '36, 37, 43, 47, 54, 61, 67, 75, 83, 90, 99, 107, 114, 120, 126, 132, 135, 139, 141, 141, 142, 142, 139, 133, 127, 120, 111, 101, 92, 82, 74, 64, 56, 47, 39, 33, 29, 26, 24, 22, 21, 20, 20, 20, 20, 22, 25, 30, 36, 44, 53, 63, 74, 84, 92, 102, 110, 119, 127, 131, 137, 142, 143, 145, 146, 146, 146, 143, 140, 135, 129, 125, 119, 112, 105, 99, 92, 85, 79, 74, 69, 65, 63, 61, 58, 56, 54, 54, 53, 52, 52, 52, 53, 53, 53, 53, 53, 51, 47, 43, 35, 28, 24, 18, 13, 8, 4, 1, 6, 11, 17, 23, 30, 37, 45, 51, 58, 65, 70, 77, 84, 88, 93, 97, 100, 103, 105, 106, 108, 111, 113, 114, 116, 117, 120, 122, 123, 123, 123, 123, 123, 122, 120, 119, 117, 117, 117, 116, 115, 114, 114, 113, 110, 106, 102, 96, 89, 83, 78, 73, 66, 59, 52, 47, 40, 36, 33, 30, 28, 27, 27, 27, 27, 27, 27, 27, 27, 28, 28, 29, 29, 29, 29, 30, 30, 31, 31, 32, 33, 34, 34, 35, 37, 38, 38, 38, 40, 41, 42, 42, 43, 44, 45, 46, 46, 47, 48, 48, 48, 48, 48, 51, 55, 60, 65, 70, 75, 81, 86, 91, 94, 96, 98, 100, 101, 102, 103, 104, 105, 106, 106, 107, 107, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109', '02-20-2020 - 15:09'), (30, 'eric ', 'han ', '8593339433', 'Stop&Shop', '4565', '1324 asdf', 'adsf', '456456546', '02-20-2020 - 15:08', 'Screw missing', 'Screw missing', 'Screw missing', 'Screw missing', 'Screw missing', 'Screw missing', 'Bumper bent', 'Screw missing', 'Screw missing', 'Screw missing', 'Screw missing', 'Bumper bent', 'Screw missing', 'Screw missing', 'Screw missing', 'Screw missing', 'Screw missing', 'Bumper bent', 'Screw missing', 'Screw missing', 'Screw missing', 'Bumper bent', 'Screw missing', '', '102, 102, 102, 103, 104, 104, 104, 104, 104, 104, 104, 104, 104, 105, 105, 107, 108, 108, 109, 110, 110, 111, 113, 116, 119, 122, 127, 133, 138, 143, 147, 154, 157, 161, 165, 167, 170, 171, 173, 175, 176, 177, 179, 180, 181, 181, 182, 184, 186, 188, 191, 196, 199, 203, 206, 208, 209, 212, 215, 217, 219, 222, 222, 225, 225, 226, 227, 229, 230, 233, 236, 237, 241, 247, 252, 257, 262, 267, 270, 274, 278, 281, 283, 284, 288, 290, 293, 295, 296, 298, 299, 300, 301, 303, 306, 308, 311, 315, 320, 323, 328, 333, 334, 337, 339, 340, 341, 343, 341, 341, 340, 339, 338, 337, 336, 336, 336, 336, 336, 337, 340, 342, 343, 344, 345, 345, 346, 346, 346, 344, 342, 341, 340, 338, 334, 328, 321, 312, 302, 289, 275, 260, 247, 234, 224, 217, 210, 206, 201, 199, 198, 198, 198, 198, 198, 198, 198, 199, 201, 201, 204, 205, 207, 208, 211, 212, 212, 212, 214, 214, 215, 216, 217, 220, 223, 229, 235, 242, 250, 259, 269, 278, 287, 294, 301, 305, 308, 310, 311, 312, 313, 314, 316, 318, 319, 321, 324, 326, 327, 328, 330, 333, 334, 338, 345, 350, 356, 361, 365, 368, 369, 363, 357, 349, 342, 333, 322, 310, 297, 286, 270, 257, 244, 234, 226, 217, 209, 202, 194, 189, 185, 180, 176, 171, 168, 164, 161, 158, 154, 150, 144, 137, 130, 121, 112, 102, 93, 84, 76, 68, 62, 57, 52, 49, 48, 45, 43, 42, 41, 40, 39, 39', '36, 37, 43, 47, 54, 61, 67, 75, 83, 90, 99, 107, 114, 120, 126, 132, 135, 139, 141, 141, 142, 142, 139, 133, 127, 120, 111, 101, 92, 82, 74, 64, 56, 47, 39, 33, 29, 26, 24, 22, 21, 20, 20, 20, 20, 22, 25, 30, 36, 44, 53, 63, 74, 84, 92, 102, 110, 119, 127, 131, 137, 142, 143, 145, 146, 146, 146, 143, 140, 135, 129, 125, 119, 112, 105, 99, 92, 85, 79, 74, 69, 65, 63, 61, 58, 56, 54, 54, 53, 52, 52, 52, 53, 53, 53, 53, 53, 51, 47, 43, 35, 28, 24, 18, 13, 8, 4, 1, 6, 11, 17, 23, 30, 37, 45, 51, 58, 65, 70, 77, 84, 88, 93, 97, 100, 103, 105, 106, 108, 111, 113, 114, 116, 117, 120, 122, 123, 123, 123, 123, 123, 122, 120, 119, 117, 117, 117, 116, 115, 114, 114, 113, 110, 106, 102, 96, 89, 83, 78, 73, 66, 59, 52, 47, 40, 36, 33, 30, 28, 27, 27, 27, 27, 27, 27, 27, 27, 28, 28, 29, 29, 29, 29, 30, 30, 31, 31, 32, 33, 34, 34, 35, 37, 38, 38, 38, 40, 41, 42, 42, 43, 44, 45, 46, 46, 47, 48, 48, 48, 48, 48, 51, 55, 60, 65, 70, 75, 81, 86, 91, 94, 96, 98, 100, 101, 102, 103, 104, 105, 106, 106, 107, 107, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109', '02-20-2020 - 15:09'), (31, 'erci ', 'han ', '8593339433', 'Giant Martin', '1232', 'asdfasdf', 'sdfadsf', '456456456', '02-20-2020 - 15:10', 'Screw missing', 'Done', 'Screw missing', 'Screw missing', 'Screw missing', 'Done', 'Screw missing', 'Bumper bent', 'Bumper bent', 'Screw missing', 'Screw missing', 'Screw missing', 'Screw missing', 'Screw missing', 'Bumper bent', 'Done', 'Screw missing', 'Done', 'Done', 'Done', 'Screw missing', 'Screw missing', 'Screw missing', '', '53, 56, 59, 66, 71, 78, 84, 88, 95, 103, 108, 113, 117, 119, 121, 121, 122, 122, 124, 125, 126, 127, 128, 128, 128, 128, 128, 128, 128, 127, 127, 128, 132, 135, 140, 143, 144, 145, 146, 151, 151, 265, 262, 259, 253, 246, 242, 238, 228, 221, 214, 208, 207, 206, 206, 208, 211, 221, 232, 244, 256, 270, 278, 288, 294, 296, 296, 296, 256, 255, 251, 246, 242, 237, 233, 230, 228, 227, 223, 220, 219, 218, 218, 216, 214, 211, 208, 203, 200, 200, 194, 193, 192, 191, 190, 188, 187, 186, 184, 183, 182, 182, 181, 181, 181, 181, 181, 181, 186, 197, 207, 218, 232, 245, 258, 268, 278, 289, 301, 306, 314, 318, 319, 319', '44, 46, 51, 57, 64, 72, 79, 85, 91, 97, 103, 107, 112, 114, 117, 118, 119, 120, 115, 109, 103, 98, 91, 84, 78, 72, 68, 64, 63, 61, 60, 59, 57, 55, 53, 51, 50, 50, 49, 49, 49, 31, 35, 40, 47, 54, 59, 67, 73, 77, 81, 86, 87, 87, 88, 90, 91, 92, 92, 92, 92, 92, 92, 92, 92, 92, 91, 91, 52, 56, 63, 73, 82, 91, 99, 105, 113, 118, 124, 127, 130, 130, 131, 130, 128, 125, 124, 119, 117, 115, 112, 110, 107, 103, 98, 91, 86, 79, 73, 65, 58, 52, 48, 45, 43, 41, 40, 39, 39, 42, 45, 49, 51, 55, 59, 62, 66, 68, 72, 72, 74, 74, 74, 74', '02-20-2020 - 15:11'); -- -- Indexes for dumped tables -- -- -- Indexes for table `pmvisit` -- ALTER TABLE `pmvisit` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `pmvisit` -- ALTER TABLE `pmvisit` MODIFY `id` int(6) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32; /*!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 */;
  11. I can put them back in, not a big deal... then run some new dummy data against it when he runs the phone app. We do need those items like in my original post when we were talking about the date times. - We need this data for reporting <?php mysqli_report(MYSQLI_REPORT_ERROR|MYSQLI_REPORT_STRICT); $conn = mysqli_connect("localhost", "winuser2003", "homer123", "pmapp"); $tdata = ''; $res = $conn->query("SELECT id, first_name, last_name, tech_phonenum, store_name, store_num, store_address, manager_name, robot_num, checkin_time, item_one, item_two, item_three, item_four, item_five, item_six, item_seven, item_eight, item_nine, item_ten, item_eleven, item_twlve, item_thirteen, item_fourteen, item_fifteen, item_sixteen, item_seventenn, item_eighteen, item_nineteen, item_twenty, item_twentyone, item_twentytwo, tech_general_comment, checkout_time, manager_sign_x, manager_sign_y FROM pmvisit"); foreach ($res as $r) { $tdata .= "<tr><td>{$r['id']}</td> <td>{$r['first_name']}</td> <td>{$r['last_name']}</td> <td>{$r['tech_phonenum']}</td> <td>{$r['store_name']}</td> <td>{$r['store_num']}</td> <td>{$r['store_address']}</td> <td>{$r['manager_name']}</td> <td>{$r['robot_num']}</td> <td>{$r['checkin_time']}</td> <td>{$r['item_one']}</td> <td>{$r['item_two']}</td> <td>{$r['item_three']}</td> <td>{$r['item_four']}</td> <td>{$r['item_five']}</td> <td>{$r['item_six']}</td> <td>{$r['item_seven']}</td> <td>{$r['item_eight']}</td> <td>{$r['item_nine']}</td> <td>{$r['item_ten']}</td> <td>{$r['item_eleven']}</td> <td>{$r['item_twlve']}</td> <td>{$r['item_thirteen']}</td> <td>{$r['item_fourteen']}</td> <td>{$r['item_fifteen']}</td> <td>{$r['item_sixteen']}</td> <td>{$r['item_seventenn']}</td> <td>{$r['item_eighteen']}</td> <td>{$r['item_nineteen']}</td> <td>{$r['item_twenty']}</td> <td>{$r['item_twentyone']}</td> <td>{$r['item_twentytwo']}</td> <td>{$r['tech_general_comment']}</td> <td>{$r['checkout_time']}</td> <td>" . drawImage($r['manager_sign_x'], $r['manager_sign_y']) . "</td>\n"; } function drawImage($xcoords, $ycoords) { $xa = $xcoords[0]=='[' ? json_decode($xcoords, 1) : explode(',', $xcoords); // put x coords into an array $ya = $ycoords[0]=='[' ? json_decode($ycoords, 1) : explode(',', $ycoords); // put x coords into an array $w = max($xa)+1; // get the max coord values so we know the size $h = max($ya)+1; // define the path $path = "M $xa[0] $ya[0] "; // move to the first x,y position unset($xa[0], $ya[0]); // remove the the first items from the array foreach ($xa as $i => $x) { // loop through arrays $y = $ya[$i]; // pairing the ith x with the ith y $path .= "L $x $y "; // define line to x y } // create svg object $w x $h to display image $im = "<svg width='$w' height='$h'> <path d='$path' stroke='#000' stroke-width='2' fill='none'/> </svg>"; return $im; } ?> <!DOCTYPE html> <html> <head> <style type="text/css"> table { border-collapse: collapse; width: 60%; } th { background-color: blue; color: white; padding: 10px; text-align: left; } td { padding: 4px 20px;; } </style> </head> <body> <table border="1" style="width: 60%;"> <tr><th>ID</th> <th>First name</th> <th>Last name</th> <th>Tech Phone Number</th> <th>Store Name</th> <th>Store Number</th> <th>Store Address</th> <th>Manager's Name</th> <th>Robot Number</th> <th>Checkin Time</th> <th>Bumper Tie Rod Mounting Screws</th> <th>Inspect/Clean Caster and Drv Wheel</th> <th>Inspect Bumper Damage</th> <th>Remove Motor Cble Ties / inspect frayed cables</th> <th>Inspect Screws/Parts in tray area</th> <th>Vaccum Cooling Air Inlets for PC</th> <th>Visual Cable Inspection / Connections</th> <th>12V Power Port Inspection</th> <th>Lidar Drv Belt Inspect</th> <th>Backdoor Alignment Check</th> <th>Charging Connector Contact Condition</th> <th>Trim lwr right cover under lidar</th> <th>Tighten GO Button nut</th> <th>Align WiFi Antenna</th> <th>Center Camera Alignment Check</th> <th>Lidar Rotation Check</th> <th>Googly Eyes Check</th> <th>Cleaned Non-Optical Cover Surfaces</th> <th>Clean all Optical Imaging Components</th> <th>Inspect Dock Connector / Height / Contact Condition</th> <th>Dock and Fudicals Cleaned</th> <th>Dock and Park Tape</th> <th>Technician General Comments</th> <th>Checkout Time</th> <th>Manager Signature</th> <tr> <?=$tdata?> </table> </body> </html>
  12. I will have to readd those back in, because per your comment earlier, I believe I missed understood and removed them out. I can readd them back if you want me to, however they will be empty as you know. I do apologize.
  13. So the table visit_item is empty as you know -- phpMyAdmin SQL Dump -- version 4.5.1 -- http://www.phpmyadmin.net -- -- Host: 127.0.0.1 -- Generation Time: Feb 20, 2020 at 06:48 PM -- Server version: 10.1.19-MariaDB -- PHP Version: 5.5.38 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!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 utf8mb4 */; -- -- Database: `pmapp` -- -- -------------------------------------------------------- -- -- Table structure for table `pmvisit` -- CREATE TABLE `pmvisit` ( `id` int(6) UNSIGNED NOT NULL, `first_name` varchar(30) NOT NULL, `last_name` varchar(30) NOT NULL, `tech_phonenum` varchar(30) NOT NULL, `store_name` varchar(30) NOT NULL, `store_num` varchar(10) NOT NULL, `store_address` varchar(70) NOT NULL, `manager_name` varchar(60) NOT NULL, `robot_num` varchar(60) NOT NULL, `checkin_time` varchar(80) NOT NULL, `tech_general_comment` varchar(80) NOT NULL, `manager_comments` varchar(80) NOT NULL, `manager_sign_x` text NOT NULL, `manager_sign_y` text NOT NULL, `checkout_time` varchar(80) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `pmvisit` -- INSERT INTO `pmvisit` (`id`, `first_name`, `last_name`, `tech_phonenum`, `store_name`, `store_num`, `store_address`, `manager_name`, `robot_num`, `checkin_time`, `tech_general_comment`, `manager_comments`, `manager_sign_x`, `manager_sign_y`, `checkout_time`) VALUES (1, 'eric ', 'han ', '8593339433', 'Giant Martin', '4525', '123 asdf', 'sadfdsaf', '523523', '02-11-2020 - 17:20', 'None', 'XZc', '[44, 44, 44, 45, 45, 45, 45, 45, 45, 43, 42, 41, 40, 39, 39, 39, 37, 37, 37, 37, 37, 37, 37, 39, 40, 43, 47, 47, 49, 51, 52, 52, 53, 54, 55, 57, 58, 59, 64, 68, 73, 80, 85, 89, 93, 94, 94, 95, 95, 95, 93, 91, 89, 87, 85, 83, 81, 79, 75, 75, 72, 69, 66, 63, 60, 57, 55, 52, 50, 47, 45, 43, 41, 41, 41, 123, 124, 124, 123, 122, 119, 117, 111, 105, 100, 94, 89, 85, 82, 78, 76, 75, 73, 73, 72, 72, 72, 72, 75, 77, 79, 81, 83, 83, 87, 91, 95, 101, 109, 118, 127, 137, 144, 150, 153, 155, 155, 155, 155, 155, 155, 154, 154, 153, 150, 147, 147, 145, 144, 144, 144, 144, 144, 149, 152, 155, 158, 163, 167, 170, 176, 184, 191, 197, 201, 203, 204, 205, 206, 206, 206, 205, 203, 203, 202, 202, 202, 202, 202, 202, 202, 204, 207, 210, 213, 219, 220, 222, 223, 224, 226, 228, 230, 234, 237, 242, 246, 252, 259, 269, 278, 287, 293, 301, 309, 316, 325, 333, 340, 345, 345, 343, 341, 341, 339, 335, 332, 329, 327, 327, 327, 327, 328, 328, 329, 329, 332, 332, 335, 336, 338, 339, 343, 343, 346, 346]', '[39, 45, 50, 58, 72, 86, 91, 97, 102, 106, 108, 111, 112, 114, 114, 112, 108, 102, 98, 92, 86, 81, 75, 69, 65, 60, 56, 55, 53, 50, 50, 48, 48, 48, 48, 48, 46, 46, 47, 48, 51, 53, 55, 58, 60, 61, 62, 66, 70, 76, 80, 84, 86, 89, 93, 94, 97, 99, 101, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 72, 72, 71, 69, 68, 65, 64, 62, 61, 61, 61, 61, 61, 61, 62, 64, 64, 66, 68, 71, 76, 81, 86, 92, 94, 96, 100, 102, 102, 104, 104, 104, 104, 104, 101, 98, 94, 91, 86, 84, 80, 78, 76, 74, 73, 72, 71, 70, 69, 71, 75, 76, 82, 86, 92, 95, 98, 102, 105, 108, 108, 110, 111, 111, 111, 110, 106, 102, 98, 94, 91, 88, 84, 82, 79, 77, 74, 71, 70, 68, 68, 66, 66, 65, 64, 63, 62, 62, 59, 58, 57, 57, 56, 56, 56, 56, 58, 58, 60, 61, 63, 64, 66, 68, 68, 68, 68, 68, 65, 63, 59, 55, 51, 50, 47, 47, 48, 50, 51, 52, 55, 57, 58, 60, 59, 58, 57, 56, 55, 55, 54, 53, 52, 51, 50, 50, 48, 47, 47, 46, 46]', '02-11-2020 - 17:21'), (2, 'erich ', 'han ', '8593339433', 'Giant Martin', '7588', '123 sadf', 'sadfadsf', '57252', '02-11-2020 - 17:22', 'Bumper bent', '', '[21, 28, 37, 48, 55, 68, 79, 89, 99, 102, 104, 106, 106, 41, 43, 52, 61, 71, 80, 88, 94, 97, 101, 102, 102, 25, 28, 30, 32, 34, 35, 35, 35, 37, 37, 37, 37, 39, 39, 40, 42, 44, 45, 47, 51, 55, 55, 134, 138, 142, 147, 150, 154, 156, 157, 159, 160, 160, 160, 160, 155, 152, 148, 145, 145, 142, 142, 141, 141, 144, 147, 149, 151, 155, 156, 157, 160, 160, 161, 162, 165, 165, 165, 165, 209, 209, 213, 213, 212, 211, 210, 210, 210, 210, 210, 210, 210, 210, 210, 210, 210, 210, 210, 210, 210, 304, 300, 293, 286, 279, 271, 262, 256, 253, 248, 245, 244, 243, 243, 243, 244, 245, 247, 251, 255, 260, 266, 273, 281, 302, 310, 317, 322, 325, 325, 327, 327]', '[48, 47, 47, 47, 47, 47, 47, 47, 47, 47, 47, 48, 48, 75, 75, 75, 75, 75, 75, 75, 75, 75, 75, 75, 75, 53, 54, 60, 64, 76, 84, 90, 96, 102, 106, 111, 112, 114, 115, 115, 115, 115, 115, 115, 115, 115, 115, 41, 43, 46, 50, 53, 58, 62, 68, 70, 76, 81, 87, 92, 97, 102, 104, 107, 107, 105, 102, 96, 92, 70, 66, 61, 59, 56, 54, 52, 50, 50, 48, 48, 48, 47, 47, 47, 37, 37, 61, 62, 66, 68, 69, 73, 78, 82, 87, 92, 97, 101, 104, 107, 109, 110, 111, 112, 112, 37, 37, 40, 46, 50, 55, 61, 65, 69, 73, 76, 80, 83, 86, 87, 90, 90, 94, 95, 95, 96, 96, 96, 96, 94, 91, 88, 84, 84, 83, 82, 82]', '02-11-2020 - 17:23'), (3, 'eric ', 'han ', '8593339433', 'Giant Martin', '5235', '123 sdf', 'asdfdsaf', '52357', '02-11-2020 - 17:24', 'Screw missing', '', '[61, 62, 66, 75, 86, 100, 111, 120, 129, 133, 136, 136, 59, 60, 69, 80, 91, 101, 111, 118, 121, 122, 122, 60, 60, 61, 62, 63, 65, 65, 65, 65, 65, 65, 65, 65, 65, 65, 64, 65, 69, 78, 85, 93, 103, 107, 113, 116, 119, 119, 121, 122, 123, 124, 124, 161, 161, 162, 163, 166, 169, 171, 173, 175, 178, 178, 179, 179, 179, 177, 175, 173, 171, 170, 169, 168, 166, 165, 163, 163, 163, 163, 163, 163, 168, 173, 178, 183, 186, 189, 191, 191, 212, 212, 211, 211, 211, 212, 212, 212, 212, 212, 212, 212, 212, 212, 212, 213, 213, 213, 213, 216, 216, 300, 299, 298, 294, 289, 282, 280, 273, 268, 263, 261, 259, 258, 258, 258, 260, 262, 265, 270, 277, 284, 293, 311, 320, 327, 329, 333, 334, 334]', '[34, 34, 35, 37, 38, 39, 39, 39, 39, 39, 40, 40, 64, 64, 64, 64, 64, 64, 64, 64, 63, 63, 63, 40, 43, 46, 51, 56, 58, 65, 71, 76, 82, 86, 91, 94, 97, 99, 100, 100, 100, 99, 95, 92, 91, 89, 88, 88, 88, 88, 88, 88, 88, 88, 88, 43, 42, 42, 44, 45, 48, 52, 57, 60, 66, 72, 77, 83, 90, 95, 101, 104, 107, 109, 109, 109, 107, 104, 102, 98, 94, 89, 82, 76, 70, 65, 58, 55, 51, 48, 47, 47, 38, 38, 55, 56, 58, 65, 68, 71, 76, 82, 87, 94, 99, 104, 108, 110, 112, 112, 112, 108, 108, 30, 30, 32, 35, 38, 41, 48, 52, 57, 60, 66, 68, 71, 74, 76, 79, 81, 81, 82, 83, 83, 83, 83, 80, 79, 79, 78, 78, 78]', '02-11-2020 - 17:25'), (4, 'eric ', 'han ', '8593339433', 'Giant Martin', '5255', '123 asdf', 'sdfadsf', '57252', '02-11-2020 - 17:25', '23', '', '[73, 73, 73, 77, 83, 90, 98, 101, 102, 104, 105, 107, 108, 109, 109, 111, 111, 111, 111, 111, 109, 105, 99, 91, 84, 68, 61, 51, 46, 40, 36, 32, 31, 32, 33, 40, 49, 62, 76, 91, 108, 127, 143, 163, 174, 184, 191, 198, 201, 201, 201, 201, 201, 201, 201, 199, 199, 198, 196, 196, 195, 194, 194, 194, 194, 195, 197, 199, 208, 219, 235, 252, 266, 283, 294, 302, 309, 312, 312, 311, 309, 309, 303, 293, 283, 276, 270, 269, 263, 263, 263, 264, 267, 273, 280, 288, 298, 307, 317, 327, 334, 343, 350, 359, 363, 367, 372, 374, 378, 379, 382, 388, 393, 399, 407, 415, 423, 427]', '[76, 76, 79, 83, 84, 86, 86, 86, 86, 86, 84, 84, 83, 79, 76, 74, 69, 65, 62, 58, 56, 53, 51, 50, 50, 50, 56, 60, 68, 74, 80, 87, 94, 99, 105, 112, 117, 120, 123, 125, 125, 125, 122, 114, 109, 102, 98, 93, 90, 87, 84, 82, 81, 80, 80, 80, 80, 80, 80, 81, 81, 84, 86, 87, 89, 90, 90, 92, 92, 92, 92, 86, 82, 75, 69, 65, 61, 58, 58, 58, 58, 57, 57, 57, 57, 59, 62, 64, 65, 66, 68, 68, 70, 73, 75, 77, 80, 84, 88, 92, 96, 100, 102, 104, 104, 104, 104, 102, 99, 96, 93, 86, 81, 73, 66, 57, 48, 42]', '02-11-2020 - 17:26'), (5, 'eric ', 'asdf', '8593339433', 'Giant Martin', '5235', '234 sdf', 'sadf', '525', '02-12-2020 - 12:00', 'comments', '', '[60, 70, 137, 147, 152, 156, 156, 156, 125, 121, 120, 119, 116, 115, 111, 109, 108, 106, 106, 106, 108, 111, 114, 121, 127, 132, 134, 139, 145, 156, 165, 176, 183, 192, 197, 199, 199, 194, 187, 180, 173, 168, 163, 160, 158, 158, 158, 158, 163, 169, 177, 188, 199, 214, 228, 245, 257, 268, 277, 284, 289, 291, 289, 288, 284, 279, 276, 271, 269, 265, 263, 262, 262, 262, 262, 263, 266, 274, 282, 289, 296, 301, 305, 307, 307, 307, 307, 307, 307, 307, 311, 314, 317, 321, 327, 334, 339, 343, 346, 360, 369, 376, 381, 388]', '[75, 81, 79, 72, 68, 62, 58, 51, 27, 27, 27, 29, 32, 34, 40, 47, 55, 63, 69, 76, 83, 87, 91, 94, 96, 96, 94, 87, 79, 70, 60, 50, 40, 30, 22, 17, 14, 14, 20, 27, 36, 44, 53, 61, 68, 75, 76, 79, 81, 83, 83, 82, 74, 68, 60, 50, 41, 34, 27, 22, 19, 16, 16, 20, 25, 32, 37, 44, 50, 56, 62, 66, 68, 70, 72, 72, 70, 66, 58, 51, 45, 40, 37, 34, 34, 35, 37, 40, 44, 47, 50, 51, 51, 51, 51, 48, 45, 41, 38, 26, 19, 12, 7, 1]', '02-12-2020 - 12:01'), (6, 'eric ', 'asdf', '8593339433', 'Giant Martin', '5235', '234 sdf', 'sadf', '525', '02-12-2020 - 12:00', 'comments', '', '[60, 70, 137, 147, 152, 156, 156, 156, 125, 121, 120, 119, 116, 115, 111, 109, 108, 106, 106, 106, 108, 111, 114, 121, 127, 132, 134, 139, 145, 156, 165, 176, 183, 192, 197, 199, 199, 194, 187, 180, 173, 168, 163, 160, 158, 158, 158, 158, 163, 169, 177, 188, 199, 214, 228, 245, 257, 268, 277, 284, 289, 291, 289, 288, 284, 279, 276, 271, 269, 265, 263, 262, 262, 262, 262, 263, 266, 274, 282, 289, 296, 301, 305, 307, 307, 307, 307, 307, 307, 307, 311, 314, 317, 321, 327, 334, 339, 343, 346, 360, 369, 376, 381, 388]', '[75, 81, 79, 72, 68, 62, 58, 51, 27, 27, 27, 29, 32, 34, 40, 47, 55, 63, 69, 76, 83, 87, 91, 94, 96, 96, 94, 87, 79, 70, 60, 50, 40, 30, 22, 17, 14, 14, 20, 27, 36, 44, 53, 61, 68, 75, 76, 79, 81, 83, 83, 82, 74, 68, 60, 50, 41, 34, 27, 22, 19, 16, 16, 20, 25, 32, 37, 44, 50, 56, 62, 66, 68, 70, 72, 72, 70, 66, 58, 51, 45, 40, 37, 34, 34, 35, 37, 40, 44, 47, 50, 51, 51, 51, 51, 48, 45, 41, 38, 26, 19, 12, 7, 1]', '02-12-2020 - 12:01'), (7, 'eric ', 'han ', '8593339433', 'Giant Martin', '5354', '123 sadf', 'asdf', '53267423', '02-12-2020 - 12:05', 'Bumper bent', '', '[73, 73, 73, 75, 78, 81, 85, 93, 102, 108, 120, 133, 145, 160, 171, 180, 186, 191, 191, 191, 191, 191, 191, 188, 183, 175, 168, 160, 152, 141, 134, 129, 124, 122, 122, 127, 138, 153, 189, 206, 219, 225, 228, 230, 227, 222, 217, 213, 210, 208, 206, 206, 206, 207, 208, 209, 213, 217, 220, 225, 228, 235, 238, 241, 241, 241, 235, 235, 232, 228, 228, 229, 230, 230, 233, 235, 240, 245, 252, 259, 266, 274, 278, 285, 291, 299, 306, 311, 314, 315, 316, 317, 317, 320, 321, 321]', '[102, 104, 107, 110, 115, 117, 120, 120, 120, 120, 115, 108, 100, 92, 86, 76, 70, 64, 60, 58, 56, 55, 55, 56, 59, 66, 75, 86, 95, 107, 116, 123, 129, 131, 132, 132, 130, 124, 105, 94, 84, 76, 73, 71, 75, 80, 86, 91, 98, 102, 107, 110, 112, 112, 112, 110, 105, 99, 94, 86, 81, 75, 69, 68, 66, 68, 76, 82, 87, 94, 95, 96, 96, 95, 93, 89, 83, 76, 66, 60, 52, 47, 40, 36, 32, 26, 22, 20, 17, 17, 16, 16, 16, 15, 15, 15]', '02-12-2020 - 12:06'), (8, 'eric ', 'han ', '8593339433', 'Stop&Shop', '5454', '234 dsfg', 'dfgdfg', '4532453', '02-13-2020 - 09:45', 'Screw missing', '', '[80, 81, 87, 92, 99, 110, 117, 129, 139, 149, 159, 168, 173, 176, 180, 180, 180, 180, 175, 171, 162, 142, 134, 128, 126, 123, 121, 121, 121, 122, 128, 136, 147, 159, 176, 192, 207, 220, 233, 241, 246, 249, 248, 246, 242, 240, 236, 233, 229, 228, 228, 228, 228, 228, 230, 237, 243, 253, 261, 271, 282, 291, 298, 303, 301, 297, 294, 291, 290, 287, 286, 285, 289, 293, 300, 305, 310, 313, 317, 318, 318, 318, 315, 311, 309, 305, 303, 301, 299, 298, 297, 296, 295, 294, 293, 293, 293, 293, 294, 297, 299, 302, 304, 306, 307, 308, 309, 309]', '[98, 99, 103, 105, 106, 106, 108, 108, 105, 102, 96, 89, 82, 73, 64, 58, 50, 44, 38, 36, 35, 42, 49, 58, 61, 68, 74, 78, 80, 83, 86, 88, 88, 88, 85, 78, 71, 64, 57, 51, 45, 42, 41, 40, 40, 42, 46, 49, 53, 53, 56, 57, 58, 59, 60, 62, 62, 62, 62, 61, 56, 54, 51, 47, 47, 47, 49, 53, 54, 59, 61, 62, 55, 49, 41, 32, 22, 14, 9, 7, 10, 16, 22, 29, 35, 42, 45, 49, 51, 52, 52, 51, 47, 44, 41, 36, 35, 34, 34, 34, 34, 34, 34, 34, 34, 34, 34, 34]', '02-13-2020 - 09:46'), (9, 'eric ', 'han ', '8593339433', 'Giant Martin', '5254', '1324 asdf', 'sadfads', '77586565', '02-13-2020 - 14:28', 'Screw missing', '', '[106, 108, 110, 116, 123, 129, 138, 145, 156, 168, 178, 186, 188, 189, 189, 188, 186, 181, 178, 174, 170, 169, 170, 183, 195, 207, 219, 228, 238, 245, 249, 250, 249, 247, 243, 235, 231, 226, 221, 220, 221, 228, 237, 251, 269, 283, 293, 301, 302, 304, 302, 293, 290, 285, 282, 283, 293, 300, 314, 327, 335, 345, 354, 359, 360, 360]', '[47, 51, 56, 60, 62, 65, 67, 69, 70, 72, 73, 75, 76, 76, 77, 80, 82, 86, 90, 95, 97, 99, 98, 93, 87, 84, 82, 80, 80, 80, 82, 84, 86, 90, 95, 104, 109, 114, 120, 122, 123, 123, 118, 111, 102, 94, 85, 79, 74, 72, 75, 84, 89, 97, 101, 101, 95, 86, 78, 67, 59, 52, 46, 41, 41, 41]', '02-13-2020 - 14:28'), (10, 'eric ', 'han ', '8593339433', 'Stop&Shop', '5635', '1234 sadf', 'asdf', '4573645', '02-13-2020 - 15:06', 'Screw missing', '', '[47, 48, 50, 55, 63, 74, 86, 98, 109, 119, 129, 136, 142, 144, 144, 145, 145, 61, 64, 70, 79, 87, 99, 110, 123, 133, 141, 147, 151, 153, 153, 56, 55, 55, 55, 55, 55, 55, 55, 55, 57, 59, 60, 62, 63, 63, 63, 64, 65, 68, 75, 83, 94, 103, 111, 119, 127, 135, 142, 147, 151, 152, 153, 153, 180, 182, 185, 187, 191, 193, 197, 202, 207, 210, 213, 214, 216, 217, 217, 217, 217, 215, 213, 210, 205, 203, 201, 199, 198, 196, 194, 194, 194, 194, 194, 197, 199, 202, 206, 207, 210, 214, 215, 216, 217, 218, 219, 219, 274, 274, 270, 270, 270, 270, 270, 270, 270, 271, 271, 272, 273, 273, 273, 274, 274, 274, 274, 274, 274, 363, 362, 358, 350, 342, 331, 322, 315, 308, 302, 300, 299, 299, 301, 301, 302, 303, 304, 306, 307, 310, 313, 318, 324, 331, 338, 347, 347]', '[38, 38, 38, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 40, 40, 40, 87, 87, 87, 86, 85, 82, 82, 79, 77, 76, 74, 73, 72, 72, 38, 39, 42, 47, 50, 55, 61, 69, 76, 82, 90, 96, 101, 104, 106, 107, 108, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 55, 55, 57, 58, 62, 65, 69, 75, 82, 87, 92, 97, 101, 104, 108, 111, 113, 115, 119, 121, 124, 125, 126, 128, 128, 128, 126, 124, 119, 105, 98, 89, 82, 75, 69, 63, 59, 56, 54, 54, 53, 53, 53, 53, 55, 55, 72, 73, 75, 76, 80, 84, 87, 92, 96, 102, 107, 111, 115, 118, 120, 123, 124, 125, 125, 50, 49, 53, 58, 64, 72, 80, 86, 94, 105, 108, 113, 114, 117, 118, 120, 122, 123, 123, 124, 124, 124, 124, 124, 124, 124, 124, 124]', '02-13-2020 - 15:07'), (11, 'eric ', 'han ', '8593339433', 'Giant Martin', '5455', '1234 sadf', 'sadfsdf', '453453', '02-13-2020 - 15:07', 'Screw missing', '', '[57, 58, 63, 67, 74, 82, 89, 96, 107, 112, 117, 129, 141, 147, 151, 155, 159, 162, 163, 164, 164, 68, 73, 78, 86, 92, 101, 108, 115, 121, 125, 126, 130, 132, 133, 136, 137, 140, 141, 142, 142, 66, 66, 66, 66, 66, 66, 66, 66, 66, 66, 67, 68, 68, 69, 70, 70, 71, 72, 74, 77, 80, 86, 93, 100, 106, 114, 118, 121, 126, 126, 129, 131, 132, 132, 190, 191, 192, 193, 194, 196, 197, 197, 198, 199, 199, 200, 200, 200, 200, 200, 200, 200, 200, 200, 199, 199, 198, 196, 196, 196, 196, 196, 198, 202, 207, 212, 215, 218, 220, 221, 221, 222, 223, 223, 273, 273, 275, 274, 274, 273, 273, 273, 272, 272, 271, 270, 269, 268, 267, 267, 267, 267, 267, 267, 267, 389, 388, 387, 384, 381, 377, 377, 375, 374, 373, 372, 371, 370, 367, 366, 362, 360, 358, 353, 349, 346, 342, 339, 337, 336, 336, 336, 336, 336, 337, 339, 341, 341, 343, 344, 347, 349, 351, 355, 358, 362, 368, 373, 380, 383, 387, 390, 393, 394, 394]', '[55, 55, 55, 55, 55, 55, 55, 55, 54, 54, 54, 54, 54, 54, 54, 54, 54, 54, 54, 54, 54, 90, 90, 90, 90, 90, 90, 88, 87, 86, 86, 86, 85, 85, 85, 84, 84, 83, 83, 82, 82, 57, 58, 62, 66, 71, 75, 79, 84, 88, 91, 95, 100, 104, 107, 109, 110, 110, 111, 111, 112, 113, 114, 114, 114, 114, 114, 114, 114, 112, 109, 108, 106, 105, 105, 58, 61, 63, 65, 68, 71, 74, 77, 80, 82, 85, 89, 91, 94, 95, 98, 101, 104, 106, 108, 110, 111, 112, 111, 110, 106, 102, 94, 85, 76, 67, 58, 51, 45, 42, 41, 40, 40, 40, 40, 46, 46, 65, 67, 69, 71, 74, 78, 82, 86, 92, 97, 104, 112, 118, 123, 126, 129, 130, 131, 131, 58, 58, 59, 59, 61, 62, 63, 64, 65, 65, 66, 67, 68, 69, 71, 74, 77, 80, 87, 91, 95, 100, 104, 110, 114, 119, 124, 128, 130, 132, 134, 135, 136, 136, 136, 137, 137, 137, 137, 137, 135, 133, 130, 126, 125, 122, 122, 120, 120, 120]', '02-13-2020 - 15:08'), (12, 'eric ', 'han ', '8593339433', 'Giant Martin', '5425', '2345 afadsf', 'sadfasdf', '55746', '02-14-2020 - 16:23', 'Bumper bent', '', '[106, 106, 107, 107, 107, 110, 112, 117, 124, 132, 143, 154, 167, 181, 195, 205, 213, 214, 214, 213, 205, 192, 175, 159, 142, 127, 116, 109, 105, 101, 101, 101, 101, 105, 110, 117, 127, 139, 154, 169, 181, 189, 196, 197, 187, 170, 144, 123, 105, 97, 91, 100, 112, 124, 137, 147, 156, 166, 175, 183, 193, 204, 215, 225, 232, 235, 235, 236, 235, 229, 218, 213, 203, 197, 192, 192, 199, 210, 229, 251, 272, 291, 307, 319, 325, 325, 319, 314, 309, 305, 303, 302, 302, 301, 301, 303, 310, 315, 323, 331, 335, 336, 337, 337, 337, 337, 337, 338, 338, 338, 338, 338, 338, 337, 335, 331, 326, 323, 323, 323, 323, 324, 327, 330, 335, 341, 349, 355, 362, 371, 378, 384, 387, 388, 388, 388, 385, 379, 372, 364, 357, 349, 342, 339, 333, 331, 327, 325, 325, 325, 329, 332, 341, 348, 357, 364, 367, 368, 369, 370, 371, 374, 374]', '[46, 47, 48, 51, 56, 60, 65, 72, 77, 81, 86, 87, 88, 88, 88, 86, 81, 78, 73, 67, 59, 54, 48, 44, 44, 44, 45, 49, 54, 59, 64, 68, 74, 78, 83, 85, 88, 90, 90, 90, 86, 83, 79, 78, 78, 84, 91, 99, 107, 111, 114, 109, 100, 92, 83, 75, 68, 64, 60, 59, 59, 59, 59, 59, 62, 63, 64, 65, 68, 73, 78, 85, 91, 94, 97, 98, 95, 90, 82, 73, 64, 55, 48, 43, 41, 40, 44, 48, 53, 58, 64, 66, 68, 69, 70, 69, 66, 62, 58, 55, 53, 52, 52, 54, 58, 64, 68, 74, 79, 82, 85, 87, 90, 91, 93, 95, 95, 95, 94, 92, 87, 81, 74, 68, 62, 58, 54, 51, 48, 48, 48, 48, 49, 50, 52, 55, 60, 67, 72, 78, 83, 87, 88, 90, 90, 90, 88, 84, 80, 74, 66, 58, 47, 39, 32, 28, 24, 22, 21, 21, 21, 21, 21]', '02-14-2020 - 16:25'), (13, 'eric ', 'han ', '8593339433', 'Giant Martin', '4355', '123 asdf', 'aaasdfads', '54623436', '02-17-2020 - 10:45', '23', '', '[83, 83, 84, 90, 98, 107, 121, 133, 147, 161, 168, 172, 174, 174, 174, 172, 170, 165, 161, 156, 149, 145, 135, 129, 121, 112, 106, 100, 92, 87, 80, 76, 76, 75, 75, 75, 76, 78, 79, 81, 84, 90, 97, 107, 118, 130, 145, 153, 158, 155, 147, 137, 129, 121, 114, 110, 109, 109, 111, 114, 118, 125, 132, 145, 159, 179, 198, 219, 233, 246, 253, 255, 252, 243, 231, 218, 214, 206, 203, 202, 202, 209, 216, 225, 233, 244, 251, 257, 263, 269, 279, 291, 302, 313, 323, 328, 331, 333, 333, 331, 325, 317, 305, 293, 284, 278, 273, 270, 268, 267, 267, 268, 270, 276, 279, 284, 292, 304, 317, 336, 351, 364, 374, 380, 384, 385, 385, 381, 369, 356, 339, 321, 306, 293, 281, 274, 268, 266, 266, 266, 267, 273, 283, 295, 309, 323, 336, 344, 347, 348, 345, 342, 334, 321, 305, 290, 281, 273, 270, 268, 268, 269, 271, 274, 281, 287, 295, 302, 309, 317, 321, 329, 333, 337, 338, 341, 342, 343, 344, 345, 346, 348, 349, 351, 352, 352]', '[64, 66, 66, 66, 68, 68, 68, 68, 64, 60, 56, 53, 52, 49, 46, 43, 41, 38, 36, 34, 34, 33, 33, 33, 35, 39, 43, 49, 56, 64, 72, 78, 84, 90, 94, 95, 95, 96, 96, 96, 96, 96, 94, 90, 83, 79, 72, 66, 66, 66, 72, 78, 88, 95, 103, 110, 114, 116, 118, 118, 118, 118, 117, 112, 107, 97, 89, 80, 74, 68, 66, 64, 64, 66, 70, 74, 78, 81, 82, 82, 81, 74, 66, 58, 52, 47, 44, 44, 44, 44, 51, 60, 66, 78, 88, 98, 111, 122, 132, 140, 146, 150, 150, 150, 144, 137, 128, 118, 107, 95, 83, 74, 64, 56, 52, 49, 49, 49, 54, 60, 68, 76, 83, 89, 94, 98, 102, 106, 110, 110, 110, 110, 106, 102, 96, 91, 87, 83, 81, 79, 76, 72, 70, 68, 66, 66, 66, 66, 66, 68, 70, 72, 74, 77, 79, 81, 83, 85, 85, 84, 83, 81, 77, 72, 66, 60, 54, 48, 44, 40, 39, 36, 35, 34, 34, 34, 34, 34, 34, 34, 34, 33, 33, 33, 33, 33]', '02-17-2020 - 10:48'), (14, 'eric ', 'han ', '8593339433', 'Giant Martin', '4536', '345 sdfdf', 'sdfg', '5864', '02-17-2020 - 10:54', '23', '', '[80, 84, 90, 96, 105, 116, 126, 139, 153, 164, 172, 179, 181, 181, 181, 175, 170, 157, 139, 118, 103, 95, 87, 84, 81, 81, 81, 82, 87, 95, 102, 111, 128, 145, 184, 202, 218, 225, 231, 233, 225, 215, 207, 191, 185, 178, 174, 173, 173, 178, 191, 212, 242, 267, 300, 335, 354, 369, 376, 379, 379, 377, 372, 365, 357, 354, 350, 349, 344, 337, 333, 332, 334, 340, 347, 352, 356, 359, 360, 361, 362, 364, 364, 364, 362, 357, 346, 334, 319, 304, 288, 275, 264, 255, 250, 249, 248, 248, 248, 248, 248, 248, 253, 258, 263, 267, 270, 275, 284, 293, 304, 317, 328, 338, 347, 352, 357, 366, 377, 391, 401, 413, 413]', '[103, 103, 104, 105, 105, 105, 104, 99, 93, 86, 80, 72, 68, 64, 60, 54, 49, 43, 41, 38, 38, 38, 42, 46, 50, 53, 57, 62, 66, 72, 74, 78, 78, 78, 78, 77, 72, 68, 66, 66, 68, 70, 74, 82, 89, 99, 104, 107, 109, 111, 114, 114, 113, 107, 97, 84, 77, 70, 70, 68, 68, 68, 68, 68, 68, 70, 70, 72, 78, 84, 88, 89, 88, 81, 74, 68, 64, 62, 60, 60, 60, 64, 68, 72, 77, 85, 94, 102, 109, 116, 122, 126, 130, 132, 132, 132, 127, 119, 112, 103, 95, 87, 80, 72, 66, 62, 56, 53, 49, 45, 43, 42, 42, 42, 42, 42, 42, 43, 44, 46, 48, 49, 49]', '02-17-2020 - 10:56'), (16, 'eric ', 'han ', '8593339433', 'Giant Martin', '5454', '123 sdf', 'asdf', '456345', '02-18-2020 - 10:09', 'Screw missing', '', '43, 46, 50, 57, 62, 69, 76, 84, 90, 96, 104, 111, 117, 121, 122, 122, 44, 47, 55, 68, 77, 86, 96, 106, 112, 115, 115, 40, 40, 40, 40, 37, 37, 37, 37, 36, 34, 34, 34, 34, 33, 33, 33, 33, 32, 34, 36, 40, 46, 55, 66, 74, 81, 89, 95, 101, 106, 107, 107, 127, 128, 130, 132, 135, 139, 143, 148, 148, 150, 151, 153, 154, 154, 154, 154, 152, 151, 150, 149, 147, 145, 144, 143, 141, 140, 140, 140, 140, 141, 143, 147, 153, 157, 162, 165, 171, 176, 179, 182, 184, 184, 212, 212, 215, 212, 211, 210, 208, 208, 206, 205, 202, 201, 201, 200, 199, 199, 199, 199, 315, 314, 311, 309, 302, 297, 288, 282, 275, 269, 267, 263, 261, 260, 260, 261, 262, 267, 271, 275, 281, 289, 296, 301, 309, 316, 322, 326, 327, 329, 330, 330, 330', '21, 20, 19, 19, 19, 19, 19, 19, 20, 21, 22, 23, 23, 23, 23, 23, 64, 64, 64, 62, 61, 58, 56, 55, 53, 53, 53, 22, 24, 28, 35, 41, 48, 58, 65, 74, 82, 87, 92, 96, 98, 99, 100, 101, 102, 103, 104, 104, 105, 105, 105, 105, 105, 105, 105, 103, 103, 103, 103, 34, 34, 36, 40, 45, 51, 56, 63, 67, 73, 80, 86, 90, 94, 98, 101, 104, 106, 106, 107, 108, 109, 109, 109, 106, 103, 100, 96, 91, 84, 79, 72, 65, 60, 55, 51, 48, 45, 43, 42, 41, 41, 29, 29, 48, 51, 55, 60, 63, 70, 77, 83, 90, 97, 100, 106, 109, 111, 112, 112, 38, 38, 40, 41, 47, 53, 59, 66, 72, 80, 86, 91, 96, 101, 102, 106, 110, 117, 120, 121, 124, 124, 124, 124, 122, 119, 116, 113, 112, 110, 110, 109, 109', '02-18-2020 - 10:10'), (17, 'eric ', 'han ', '8593339433', 'Giant Martin', '4554', '123 asdf', 'asdfasdf', '456345', '02-18-2020 - 10:20', 'Screw missing', '', '61, 62, 64, 66, 73, 79, 84, 92, 100, 107, 112, 118, 121, 122, 123, 123, 123, 123, 123, 123, 121, 118, 114, 110, 108, 105, 103, 102, 99, 96, 92, 88, 86, 83, 80, 75, 69, 64, 58, 52, 47, 44, 40, 36, 34, 32, 30, 29, 29, 29, 29, 29, 31, 32, 36, 40, 45, 49, 56, 62, 70, 79, 85, 90, 96, 101, 104, 105, 108, 108, 109, 109, 109, 109, 109, 108, 105, 100, 95, 91, 88, 85, 82, 80, 77, 76, 72, 70, 67, 64, 61, 58, 57, 56, 56, 56, 56, 56, 56, 58, 61, 62, 64, 65, 68, 71, 76, 82, 89, 94, 100, 109, 117, 123, 127, 129, 130, 130, 130, 130, 128, 127, 125, 125, 125, 124, 124, 125, 127, 129, 132, 134, 135, 137, 137, 137, 137, 136, 134, 129, 126, 121, 116, 110, 106, 103, 102, 101, 98, 97, 97, 97, 102, 107, 115, 125, 135, 144, 152, 159, 168, 174, 182, 192, 202, 212, 223, 231, 239, 242, 243, 240, 231, 218, 206, 199, 190, 184, 181, 180, 180, 181, 187, 194, 206, 215, 222, 226, 227, 227, 224, 220, 215, 209, 203, 195, 190, 189, 192, 195, 199, 200, 204, 205, 207, 208, 203, 200, 198, 197, 196, 196, 197, 200, 201, 203, 207, 208, 210, 211, 214, 215, 214, 213, 211, 210, 209, 207, 204, 200, 196, 193, 189, 188, 187, 187, 187, 188, 189, 192, 194, 196, 200, 207, 217, 228, 239, 249, 260, 272, 276, 280, 282, 282, 339, 339, 338, 337, 334, 330, 325, 315, 306, 297, 289, 284, 279, 276, 275, 273, 273, 273, 275, 279, 282, 288, 294, 302, 310, 319, 328, 337, 348, 355, 359, 362, 363, 365, 366, 368, 369, 369', '56, 57, 57, 58, 58, 58, 58, 58, 58, 57, 55, 52, 51, 49, 47, 46, 43, 40, 37, 33, 28, 24, 20, 17, 15, 13, 13, 13, 13, 13, 14, 17, 19, 22, 26, 31, 36, 41, 46, 50, 54, 56, 59, 63, 64, 67, 71, 73, 76, 79, 81, 84, 86, 87, 89, 90, 90, 90, 90, 90, 90, 90, 90, 90, 89, 87, 87, 87, 85, 84, 83, 80, 77, 76, 74, 71, 67, 64, 62, 62, 62, 62, 62, 62, 64, 64, 68, 70, 74, 78, 83, 89, 95, 101, 108, 114, 119, 123, 126, 128, 132, 133, 134, 135, 135, 135, 135, 133, 129, 125, 118, 112, 106, 99, 93, 86, 79, 74, 68, 65, 60, 58, 55, 54, 53, 52, 51, 52, 57, 60, 65, 71, 79, 88, 96, 104, 111, 117, 122, 127, 131, 136, 140, 143, 144, 144, 144, 144, 141, 138, 130, 121, 110, 97, 85, 74, 63, 55, 49, 42, 38, 37, 36, 34, 34, 34, 34, 34, 34, 34, 34, 34, 34, 35, 37, 39, 43, 44, 45, 45, 46, 46, 46, 46, 46, 44, 44, 43, 43, 44, 48, 52, 57, 64, 69, 75, 79, 80, 80, 78, 74, 72, 69, 67, 66, 66, 71, 74, 78, 81, 82, 83, 83, 83, 83, 81, 79, 78, 76, 76, 74, 73, 76, 77, 80, 81, 84, 88, 92, 97, 102, 109, 116, 123, 128, 133, 135, 138, 139, 139, 139, 139, 139, 135, 129, 124, 117, 110, 103, 94, 90, 86, 84, 84, 51, 50, 50, 50, 50, 53, 57, 63, 70, 77, 85, 91, 98, 105, 111, 118, 124, 130, 135, 139, 142, 145, 146, 146, 146, 144, 139, 133, 123, 116, 107, 100, 93, 87, 81, 78, 76, 76', '02-18-2020 - 10:21'), (18, 'eric ', 'han ', '8593339433', 'Stop&Shop', '4635', '123 asdf', 'sadf', '452423', '02-18-2020 - 10:48', 'Done', '', '55, 58, 63, 67, 71, 77, 81, 88, 93, 100, 104, 109, 112, 112, 63, 67, 74, 81, 88, 96, 101, 107, 110, 112, 113, 113, 59, 59, 59, 61, 63, 63, 63, 63, 63, 63, 63, 62, 61, 61, 61, 59, 59, 58, 58, 60, 63, 72, 76, 83, 87, 93, 98, 105, 107, 109, 109, 132, 132, 133, 136, 138, 139, 141, 142, 143, 145, 145, 145, 145, 145, 145, 145, 144, 143, 142, 141, 139, 138, 137, 137, 137, 137, 137, 138, 139, 142, 146, 149, 152, 154, 156, 159, 162, 164, 168, 171, 171, 171, 189, 189, 190, 190, 190, 189, 189, 187, 187, 187, 186, 186, 186, 186, 186, 186, 186, 280, 279, 276, 275, 273, 269, 264, 260, 256, 252, 249, 248, 245, 242, 240, 239, 239, 238, 238, 237, 237, 237, 238, 239, 242, 247, 252, 258, 264, 271, 277, 279, 282, 283, 285, 286, 287, 288, 288', '58, 58, 58, 58, 58, 58, 58, 58, 58, 58, 58, 58, 58, 58, 82, 82, 82, 82, 82, 82, 82, 82, 82, 82, 82, 82, 65, 66, 70, 72, 77, 80, 85, 88, 91, 94, 95, 97, 98, 100, 101, 103, 104, 104, 105, 105, 105, 105, 105, 105, 105, 105, 103, 102, 102, 101, 101, 60, 62, 65, 68, 71, 74, 78, 81, 84, 88, 91, 94, 95, 98, 100, 101, 102, 103, 104, 105, 106, 104, 103, 99, 95, 90, 85, 78, 73, 67, 61, 57, 52, 49, 48, 46, 45, 44, 43, 43, 42, 42, 47, 47, 64, 66, 69, 73, 78, 82, 87, 91, 94, 97, 98, 100, 101, 102, 102, 44, 44, 45, 45, 46, 48, 51, 53, 55, 57, 60, 60, 63, 66, 68, 69, 72, 74, 76, 78, 80, 81, 82, 83, 84, 84, 84, 84, 84, 84, 82, 81, 80, 79, 79, 79, 79, 78, 78', '02-18-2020 - 10:49'), (19, 'eric ', 'han ', '8593339433', 'Stop&Shop', '4545', '123 sadf', 'asdf', '45436456', '02-18-2020 - 10:50', 'Screw missing', '', '64, 66, 72, 79, 87, 94, 103, 112, 119, 128, 134, 139, 142, 144, 144, 145, 144, 143, 139, 135, 130, 127, 123, 121, 118, 114, 108, 101, 94, 87, 78, 68, 58, 51, 44, 36, 29, 25, 20, 17, 15, 15, 15, 16, 18, 21, 24, 30, 35, 42, 49, 57, 67, 75, 80, 88, 94, 100, 104, 108, 111, 113, 114, 112, 109, 105, 100, 96, 96, 95, 91, 86, 84, 79, 73, 70, 68, 65, 64, 63, 62, 62, 63, 63, 64, 67, 71, 75, 81, 86, 93, 100, 107, 115, 123, 130, 134, 139, 145, 149, 152, 154, 158, 160, 161, 162, 164, 164, 166, 168, 170, 171, 172, 173, 173, 174, 174, 174, 174, 174, 174, 174, 174, 174, 174, 174, 174, 174, 174, 174, 174, 174, 174, 174, 174, 172, 170, 168, 164, 163, 160, 155, 152, 150, 149, 148, 146, 143, 143, 142, 142, 142, 143, 147, 154, 160, 170, 180, 188, 198, 205, 211, 213, 217, 218, 220, 222, 223, 224, 224, 224, 223, 219, 217, 213, 208, 202, 198, 195, 194, 193, 197, 205, 209, 217, 224, 225, 225, 223, 222, 221, 221, 220, 220, 219, 218, 217, 216, 216, 215, 216, 216, 217, 216, 212, 208, 204, 199, 193, 188, 186, 183, 182, 182, 181, 184, 189, 194, 200, 208, 216, 225, 232, 242, 250, 258, 266, 272, 279, 284, 286, 290, 292, 296, 300, 302, 304, 307, 309, 310, 311, 311, 308, 303, 298, 290, 281, 273, 264, 257, 251, 248, 246, 246, 245, 247, 249, 251, 254, 258, 266, 275, 285, 295, 308, 321, 333, 342, 353, 361, 366, 369, 370, 370, 370, 370, 370', '94, 93, 92, 90, 86, 85, 82, 78, 74, 70, 66, 62, 59, 56, 54, 54, 52, 51, 48, 46, 46, 45, 45, 45, 45, 45, 45, 47, 51, 55, 59, 65, 70, 76, 82, 89, 96, 103, 111, 117, 124, 129, 131, 136, 137, 139, 140, 140, 140, 137, 131, 125, 118, 112, 105, 98, 92, 86, 82, 77, 75, 72, 71, 70, 71, 72, 74, 76, 79, 79, 83, 87, 89, 93, 97, 101, 103, 107, 110, 113, 115, 116, 118, 119, 119, 121, 122, 122, 122, 122, 122, 122, 120, 118, 117, 115, 115, 114, 114, 112, 112, 112, 111, 110, 109, 109, 107, 106, 102, 99, 95, 90, 86, 82, 78, 73, 70, 67, 64, 60, 58, 55, 54, 52, 51, 50, 51, 54, 60, 64, 71, 79, 87, 97, 107, 116, 125, 133, 140, 146, 151, 155, 157, 158, 158, 158, 154, 149, 143, 136, 126, 117, 106, 97, 88, 77, 68, 59, 54, 49, 46, 42, 42, 40, 40, 41, 42, 42, 43, 44, 45, 46, 48, 51, 55, 59, 63, 67, 70, 71, 72, 71, 68, 65, 64, 61, 61, 60, 61, 63, 64, 65, 65, 66, 66, 68, 69, 69, 70, 70, 70, 69, 70, 73, 79, 86, 93, 102, 113, 122, 128, 134, 139, 140, 141, 139, 135, 129, 124, 117, 111, 105, 100, 95, 90, 86, 82, 79, 75, 72, 70, 66, 65, 63, 60, 59, 57, 55, 54, 53, 52, 51, 51, 57, 61, 70, 78, 87, 96, 106, 117, 124, 130, 134, 136, 138, 140, 141, 141, 141, 141, 139, 135, 129, 121, 113, 103, 94, 84, 76, 69, 63, 59, 57, 55, 54, 54', '02-18-2020 - 10:51'), (20, 'eric ', 'han ', '8593339433', 'Giant Martin', '5454', '123 asdsdf', 'asdf', '4564654', '02-18-2020 - 11:01', 'Screw missing', '', '60, 60, 60, 62, 64, 66, 70, 75, 79, 87, 93, 99, 107, 111, 117, 121, 125, 125, 126, 127, 127, 126, 122, 116, 106, 97, 87, 80, 71, 66, 60, 53, 48, 44, 42, 40, 39, 38, 38, 39, 40, 42, 44, 47, 50, 53, 54, 59, 64, 69, 75, 82, 90, 95, 101, 104, 105, 105, 104, 103, 99, 91, 84, 72, 60, 48, 38, 27, 19, 15, 11, 10, 10, 10, 14, 22, 30, 39, 48, 58, 66, 78, 89, 99, 110, 121, 128, 135, 141, 144, 145, 145, 145, 145, 145, 144, 142, 141, 140, 139, 136, 134, 132, 128, 122, 112, 101, 92, 80, 72, 68, 64, 65, 68, 73, 78, 84, 89, 93, 99, 104, 112, 119, 127, 133, 135, 138, 139, 140, 142, 144, 148, 150, 153, 157, 161, 165, 168, 171, 175, 176, 178, 179, 180, 181, 181, 181, 178, 171, 163, 159, 154, 151, 147, 145, 144, 144, 144, 144, 146, 150, 155, 164, 172, 181, 187, 195, 200, 203, 205, 206, 207, 208, 209, 210, 212, 213, 213, 214, 215, 216, 216, 214, 212, 209, 206, 205, 202, 200, 198, 199, 201, 204, 207, 210, 216, 220, 224, 230, 234, 235, 234, 232, 225, 219, 215, 208, 205, 201, 197, 195, 193, 193, 195, 197, 201, 206, 213, 222, 226, 236, 245, 255, 262, 268, 274, 277, 278, 278, 280, 280, 281, 281, 282, 283, 284, 285, 286, 288, 289, 290, 291, 293, 294, 295, 295, 296, 297, 299, 300, 300, 301, 301, 302, 305, 306, 307, 308, 309, 309, 310, 311, 311, 312, 312, 313, 313, 313, 306, 297, 290, 280, 269, 262, 252, 247, 241, 238, 235, 235, 235, 237, 238, 241, 244, 251, 260, 271, 283, 297, 311, 320, 335, 350, 360, 369, 376, 377, 377, 376, 372, 368, 367, 367, 366, 365, 364, 362, 359, 353, 350, 344, 338, 333, 325, 319, 314, 310, 306, 305, 301, 300, 297, 297, 297, 297, 297, 299, 301, 303, 309, 315, 320, 328, 337, 349, 362, 375, 388, 400, 407, 411, 413, 414, 411, 411', '70, 71, 73, 76, 77, 78, 78, 78, 77, 73, 68, 63, 56, 52, 45, 40, 35, 32, 29, 27, 26, 24, 24, 22, 22, 22, 25, 31, 36, 41, 46, 52, 56, 62, 68, 72, 77, 83, 86, 90, 93, 95, 98, 99, 99, 99, 99, 99, 96, 92, 88, 84, 79, 75, 70, 67, 66, 65, 64, 64, 64, 68, 74, 83, 92, 102, 113, 123, 132, 139, 148, 152, 156, 157, 159, 160, 160, 160, 157, 152, 146, 139, 130, 122, 111, 101, 92, 81, 71, 63, 57, 53, 51, 49, 48, 48, 48, 48, 48, 48, 50, 53, 57, 62, 68, 78, 90, 102, 115, 125, 132, 137, 137, 131, 120, 107, 94, 81, 66, 52, 39, 27, 18, 10, 7, 4, 4, 4, 4, 5, 7, 11, 15, 18, 22, 26, 31, 33, 36, 39, 40, 43, 45, 49, 54, 59, 65, 75, 86, 100, 110, 119, 126, 132, 134, 134, 133, 130, 124, 116, 107, 95, 83, 74, 65, 60, 55, 52, 51, 51, 51, 51, 51, 51, 51, 51, 51, 50, 50, 50, 50, 51, 54, 56, 60, 64, 66, 70, 74, 77, 77, 76, 74, 73, 71, 69, 69, 69, 68, 68, 68, 69, 73, 80, 87, 94, 104, 111, 119, 125, 129, 132, 133, 133, 133, 131, 129, 125, 119, 113, 106, 100, 94, 89, 82, 78, 74, 73, 72, 71, 70, 70, 69, 69, 68, 67, 67, 66, 64, 64, 63, 63, 61, 60, 60, 59, 58, 57, 54, 53, 52, 52, 51, 50, 48, 47, 47, 44, 43, 42, 42, 41, 40, 40, 39, 39, 38, 39, 45, 52, 62, 71, 82, 92, 103, 113, 121, 129, 135, 140, 141, 143, 144, 144, 144, 144, 143, 140, 136, 131, 127, 120, 114, 108, 101, 95, 90, 86, 84, 80, 76, 73, 72, 71, 71, 71, 71, 71, 72, 73, 75, 78, 81, 84, 88, 93, 96, 99, 101, 104, 107, 109, 113, 115, 117, 120, 122, 125, 127, 129, 132, 133, 134, 134, 134, 133, 130, 126, 122, 117, 114, 111, 110, 109, 106, 106', '02-18-2020 - 11:02'), (21, 'eric ', 'han ', '8593339433', 'Stop&Shop', '5635', '134 adsf', 'asdf', '876576', '02-18-2020 - 12:49', 'Screw missing', '', '48, 48, 49, 50, 53, 56, 60, 65, 69, 76, 82, 90, 98, 108, 117, 121, 125, 127, 127, 128, 128, 128, 128, 127, 125, 121, 117, 111, 107, 102, 99, 95, 93, 90, 87, 84, 79, 74, 69, 64, 60, 56, 52, 48, 43, 39, 34, 30, 27, 27, 26, 26, 26, 27, 29, 31, 35, 41, 45, 50, 58, 68, 75, 83, 87, 91, 95, 97, 97, 97, 97, 97, 97, 96, 95, 93, 92, 91, 90, 89, 88, 87, 86, 81, 76, 75, 72, 68, 66, 64, 63, 63, 63, 65, 66, 67, 68, 69, 71, 76, 83, 92, 99, 107, 116, 120, 125, 129, 131, 134, 136, 136, 137, 137, 137, 137, 137, 138, 139, 140, 141, 143, 144, 146, 148, 150, 152, 153, 153, 153, 153, 153, 150, 147, 144, 143, 142, 141, 139, 137, 136, 136, 136, 137, 142, 146, 151, 157, 162, 169, 175, 180, 182, 186, 191, 195, 198, 202, 206, 211, 214, 217, 218, 216, 212, 206, 201, 198, 197, 196, 198, 203, 209, 211, 212, 211, 208, 205, 203, 201, 200, 200, 201, 201, 201, 201, 199, 198, 198, 197, 197, 195, 193, 191, 190, 187, 186, 186, 184, 184, 184, 182, 182, 182, 189, 192, 197, 203, 210, 218, 226, 235, 243, 250, 257, 261, 266, 270, 271, 273, 275, 275, 277, 278, 280, 280, 281, 280, 279, 274, 270, 267, 264, 261, 258, 255, 254, 253, 253, 253, 254, 257, 260, 263, 266, 270, 272, 279, 289, 297, 307, 316, 323, 328, 331, 332, 332, 333, 333', '45, 47, 48, 51, 54, 58, 61, 63, 64, 67, 68, 68, 68, 68, 66, 65, 61, 59, 58, 57, 53, 50, 47, 44, 40, 36, 31, 28, 27, 26, 25, 25, 25, 25, 26, 29, 32, 37, 42, 49, 55, 61, 69, 78, 88, 95, 104, 110, 117, 120, 123, 126, 127, 128, 130, 130, 131, 131, 131, 131, 129, 126, 123, 118, 115, 112, 109, 108, 107, 105, 104, 102, 98, 96, 94, 92, 90, 88, 87, 87, 87, 87, 87, 92, 97, 101, 108, 115, 122, 130, 137, 144, 149, 153, 154, 157, 158, 158, 158, 156, 148, 140, 131, 118, 106, 96, 86, 76, 69, 62, 55, 52, 49, 47, 46, 45, 44, 44, 44, 44, 44, 45, 48, 53, 60, 69, 77, 89, 99, 112, 124, 135, 144, 153, 159, 162, 162, 162, 155, 145, 134, 120, 107, 95, 84, 74, 66, 58, 53, 50, 47, 46, 46, 46, 46, 46, 46, 46, 46, 46, 46, 46, 46, 46, 48, 49, 50, 52, 52, 52, 52, 50, 49, 47, 47, 49, 52, 56, 60, 64, 65, 66, 67, 68, 70, 71, 75, 77, 79, 81, 84, 88, 93, 99, 107, 115, 122, 128, 133, 137, 140, 145, 146, 147, 137, 132, 126, 117, 110, 101, 94, 84, 77, 69, 63, 58, 54, 49, 47, 44, 43, 42, 39, 39, 39, 38, 38, 38, 40, 46, 52, 58, 63, 73, 82, 91, 100, 108, 115, 118, 122, 125, 126, 127, 127, 127, 124, 119, 112, 103, 95, 86, 79, 73, 69, 66, 64, 64, 64', '02-18-2020 - 12:50'), (22, 'eric ', 'han ', '8593339433', 'Giant Martin', '4564', '2435 adsf', 'asdf', '4564', '02-18-2020 - 16:52', 'Screw missing', '', '48, 49, 52, 57, 64, 73, 86, 98, 111, 123, 134, 142, 147, 149, 149, 75, 81, 89, 99, 111, 120, 128, 132, 133, 134, 136, 136, 52, 52, 52, 52, 52, 54, 55, 57, 59, 62, 64, 65, 65, 65, 68, 71, 78, 88, 101, 115, 132, 147, 159, 166, 168, 170, 170, 157, 161, 164, 167, 171, 177, 184, 192, 199, 203, 207, 209, 210, 210, 209, 206, 199, 195, 195, 193, 190, 188, 186, 186, 184, 184, 184, 184, 187, 190, 193, 200, 206, 213, 219, 224, 230, 233, 236, 237, 237, 257, 257, 242, 242, 240, 240, 239, 238, 238, 237, 236, 236, 236, 235, 235, 235, 235, 235, 237, 237, 316, 315, 308, 302, 296, 289, 281, 276, 271, 268, 268, 268, 268, 272, 276, 285, 296, 309, 324, 343, 343', '47, 47, 47, 49, 49, 50, 50, 50, 50, 50, 50, 50, 50, 50, 50, 82, 84, 84, 84, 84, 83, 81, 81, 81, 81, 80, 80, 56, 61, 68, 74, 77, 80, 84, 90, 95, 101, 106, 108, 109, 110, 111, 113, 113, 113, 113, 113, 112, 110, 109, 107, 106, 106, 106, 40, 41, 44, 49, 53, 58, 64, 70, 75, 81, 89, 93, 100, 106, 112, 118, 123, 126, 127, 128, 128, 128, 127, 123, 117, 109, 101, 92, 84, 76, 69, 62, 56, 52, 47, 45, 43, 43, 42, 41, 41, 37, 37, 60, 64, 68, 70, 76, 80, 85, 93, 102, 111, 120, 128, 136, 143, 148, 150, 153, 153, 56, 55, 57, 61, 66, 73, 79, 84, 90, 95, 98, 101, 105, 108, 109, 111, 111, 109, 102, 93, 93', '02-18-2020 - 16:52'), (23, 'eric ', 'han ', '8593339433', 'Giant Martin', '4122', '123 sdf', 'asdf', '546456', '02-18-2020 - 17:09', 'Screw missing', '', '42, 43, 46, 51, 57, 64, 73, 82, 87, 97, 102, 105, 109, 109, 111, 111, 111, 111, 109, 107, 105, 103, 100, 97, 94, 90, 85, 81, 80, 76, 72, 66, 63, 58, 54, 50, 45, 41, 38, 35, 33, 32, 32, 32, 32, 33, 34, 35, 37, 38, 43, 50, 57, 66, 70, 77, 84, 89, 91, 92, 92, 93, 92, 92, 92, 91, 91, 88, 87, 86, 83, 82, 75, 72, 68, 65, 60, 57, 54, 52, 49, 49, 48, 48, 48, 50, 53, 58, 63, 64, 70, 76, 86, 95, 103, 112, 119, 124, 131, 135, 140, 143, 143, 145, 145, 145, 144, 144, 143, 142, 142, 142, 141, 141, 141, 141, 140, 140, 141, 143, 144, 146, 148, 148, 148, 148, 148, 144, 143, 140, 138, 136, 134, 132, 131, 129, 129, 128, 128, 130, 138, 148, 161, 173, 186, 195, 203, 210, 214, 215, 216, 216, 217, 217, 217, 217, 217, 217, 216, 215, 211, 208, 205, 205, 205, 204, 205, 209, 217, 227, 229, 236, 236, 237, 237, 233, 227, 222, 221, 219, 218, 217, 217, 215, 214, 214, 213, 214, 214, 215, 214, 213, 212, 209, 205, 201, 197, 193, 191, 189, 188, 188, 186, 185, 184, 183, 182, 182, 184, 188, 191, 198, 204, 209, 217, 224, 229, 235, 243, 248, 255, 261, 267, 273, 277, 283, 287, 288, 293, 296, 297, 299, 300, 301, 301, 299, 293, 286, 279, 270, 260, 254, 248, 246, 245, 245, 245, 247, 250, 252, 256, 262, 268, 275, 282, 294, 304, 314, 324, 333, 341, 347, 352, 355, 356, 356, 356, 356, 356', '93, 93, 93, 93, 94, 94, 94, 94, 91, 87, 81, 79, 75, 73, 70, 68, 67, 66, 63, 60, 57, 56, 52, 50, 48, 45, 45, 43, 43, 43, 43, 43, 43, 46, 50, 53, 59, 67, 73, 80, 87, 93, 100, 103, 105, 107, 108, 108, 108, 109, 109, 109, 109, 107, 104, 99, 97, 94, 90, 90, 89, 88, 87, 86, 85, 85, 84, 84, 84, 84, 85, 86, 93, 98, 102, 107, 114, 119, 126, 133, 140, 147, 153, 157, 162, 164, 165, 165, 165, 163, 157, 152, 145, 137, 130, 122, 117, 110, 104, 100, 96, 91, 89, 84, 82, 79, 76, 75, 72, 71, 69, 68, 66, 65, 64, 63, 63, 62, 67, 73, 79, 87, 94, 102, 109, 115, 120, 126, 128, 130, 131, 131, 131, 130, 127, 123, 117, 111, 102, 92, 81, 68, 55, 45, 33, 25, 20, 15, 13, 13, 13, 14, 14, 15, 16, 17, 18, 21, 24, 27, 33, 37, 40, 43, 44, 44, 44, 38, 33, 26, 22, 18, 15, 13, 14, 18, 23, 29, 32, 34, 35, 35, 36, 39, 41, 42, 42, 42, 43, 43, 46, 47, 51, 56, 63, 71, 80, 91, 99, 106, 114, 122, 129, 136, 141, 145, 147, 148, 147, 140, 135, 127, 120, 115, 107, 100, 93, 87, 80, 76, 71, 67, 63, 60, 59, 56, 54, 53, 51, 49, 48, 47, 46, 46, 45, 47, 51, 58, 64, 72, 83, 93, 101, 108, 112, 113, 115, 116, 116, 117, 117, 117, 117, 116, 113, 109, 105, 99, 94, 88, 82, 75, 71, 66, 62, 59, 56, 54, 54', '02-18-2020 - 17:10'), (24, 'eric ', 'han ', '8593339433', 'Stop&Shop', '5465', '234 dsaf', 'asdf', '45645', '02-19-2020 - 10:54', 'Screw missing', '', '48, 47, 49, 50, 52, 54, 56, 59, 62, 67, 68, 70, 72, 73, 73, 74, 75, 75, 75, 75, 73, 72, 71, 69, 67, 64, 62, 61, 60, 59, 58, 57, 55, 54, 53, 50, 48, 44, 41, 38, 36, 33, 31, 30, 28, 27, 26, 26, 26, 26, 27, 27, 28, 29, 32, 34, 37, 43, 47, 52, 55, 60, 61, 64, 65, 67, 68, 68, 68, 68, 68, 69, 69, 70, 70, 70, 70, 70, 69, 67, 64, 60, 56, 53, 49, 46, 43, 41, 41, 39, 39, 38, 38, 41, 45, 49, 56, 60, 66, 71, 75, 78, 80, 82, 84, 86, 87, 87, 89, 90, 91, 92, 93, 94, 95, 98, 101, 104, 107, 108, 110, 112, 112, 112, 112, 109, 107, 102, 97, 92, 86, 81, 74, 71, 68, 67, 66, 64, 63, 62, 62, 62, 64, 70, 75, 83, 92, 99, 105, 110, 114, 116, 118, 120, 121, 125, 129, 132, 134, 135, 135, 133, 129, 129, 126, 125, 130, 136, 141, 147, 152, 155, 157, 158, 158, 158, 158, 158, 156, 154, 152, 149, 148, 148, 149, 152, 153, 154, 153, 151, 146, 142, 140, 137, 136, 137, 137, 138, 139, 140, 140, 141, 141, 142, 143, 143, 144, 144, 143, 141, 136, 131, 126, 122, 120, 117, 115, 114, 113, 112, 111, 112, 113, 117, 122, 129, 137, 145, 153, 163, 171, 173, 176, 178, 179, 179, 179, 179, 176, 172, 168, 163, 157, 153, 148, 146, 144, 144, 145, 147, 150, 154, 160, 167, 174, 182, 190, 194, 194, 236, 237, 239, 244, 251, 255, 261, 268, 275, 282, 287, 294, 299, 303, 307, 310, 310, 310, 310, 310, 310, 310, 309, 309, 309, 309, 309, 307, 304, 301, 298, 294, 292, 291, 289, 288, 287, 287, 287, 288, 288, 290, 292, 292, 295, 298, 301, 305, 308, 315, 322, 327, 334, 339, 342, 344, 346, 350, 351, 354, 354, 354, 355, 355, 355, 355, 353, 352, 351, 350, 348, 344, 340, 337, 332, 330, 327, 325, 322, 319, 316, 314, 312, 311, 311, 311, 311, 312, 312, 313, 314, 316, 317, 321, 324, 327, 330, 335, 341, 346, 349, 352, 354, 357, 359, 360, 360, 360, 360, 360, 360, 360, 360, 359, 358, 355, 352, 347, 342, 335, 331, 327, 322, 318, 317, 317, 316, 316, 317, 318, 319, 320, 323, 326, 331, 337, 344, 349, 353, 355, 355, 356, 356, 355, 355, 355, 354, 352, 352, 354, 356, 356, 357, 360, 360, 360, 362, 364, 365, 367, 368, 369, 372, 374, 378, 382, 386, 389, 392, 393, 395, 395, 396, 396, 396, 398, 398, 397, 397, 396, 396, 396, 396, 397, 399, 400, 401, 403, 403, 404, 404, 405, 406, 406, 407, 408, 409, 409, 409, 410, 410, 410, 411, 411, 411, 411, 411, 411, 411, 411, 411, 411, 411, 411', '61, 61, 63, 63, 63, 63, 63, 63, 63, 61, 61, 60, 58, 56, 55, 54, 51, 50, 48, 46, 43, 41, 40, 39, 36, 34, 32, 32, 31, 31, 31, 31, 31, 33, 36, 41, 45, 52, 59, 66, 71, 78, 82, 86, 91, 94, 94, 96, 97, 98, 99, 100, 100, 100, 100, 100, 100, 99, 98, 96, 95, 93, 93, 91, 89, 87, 84, 82, 79, 76, 74, 72, 69, 66, 64, 63, 62, 61, 61, 64, 69, 75, 82, 88, 95, 103, 109, 113, 118, 122, 123, 125, 120, 114, 105, 97, 86, 76, 66, 56, 49, 43, 38, 36, 33, 31, 31, 30, 30, 30, 30, 30, 30, 30, 30, 31, 32, 35, 37, 39, 43, 48, 54, 61, 70, 78, 87, 95, 103, 110, 117, 122, 127, 128, 130, 129, 124, 119, 112, 105, 96, 86, 74, 62, 53, 45, 36, 31, 28, 25, 24, 24, 24, 24, 24, 26, 27, 29, 30, 30, 31, 34, 37, 38, 40, 42, 42, 39, 36, 34, 32, 32, 32, 32, 33, 34, 36, 38, 40, 42, 44, 45, 45, 46, 46, 45, 45, 45, 49, 52, 56, 62, 64, 67, 68, 67, 65, 64, 63, 62, 61, 61, 60, 59, 58, 57, 57, 60, 64, 70, 78, 88, 97, 106, 113, 121, 126, 128, 132, 136, 137, 137, 134, 129, 123, 115, 107, 98, 87, 76, 67, 58, 51, 47, 45, 43, 42, 41, 44, 51, 59, 68, 78, 87, 97, 105, 112, 115, 115, 116, 116, 115, 111, 106, 102, 95, 90, 86, 86, 111, 111, 111, 109, 105, 102, 94, 89, 83, 77, 72, 66, 60, 52, 45, 38, 33, 26, 20, 15, 12, 9, 6, 5, 4, 2, 1, 1, 7, 12, 20, 27, 33, 39, 46, 52, 57, 63, 67, 69, 71, 74, 76, 77, 78, 78, 79, 79, 79, 79, 78, 76, 73, 69, 68, 65, 63, 59, 57, 54, 51, 47, 44, 41, 38, 36, 34, 33, 32, 32, 33, 37, 42, 47, 55, 61, 68, 74, 81, 90, 99, 107, 115, 121, 126, 129, 132, 133, 134, 134, 134, 134, 132, 129, 124, 118, 113, 109, 104, 99, 96, 93, 90, 86, 84, 81, 78, 74, 71, 69, 68, 66, 65, 64, 64, 64, 66, 69, 72, 77, 81, 88, 95, 102, 105, 109, 113, 114, 117, 118, 118, 118, 118, 114, 108, 103, 96, 89, 82, 78, 74, 74, 73, 73, 77, 84, 91, 100, 106, 111, 115, 116, 116, 111, 104, 96, 87, 80, 72, 67, 65, 63, 63, 63, 65, 68, 72, 75, 78, 80, 84, 86, 90, 95, 99, 103, 105, 107, 103, 99, 95, 88, 81, 74, 70, 64, 60, 56, 53, 53, 52, 52, 52, 53, 54, 56, 56, 57, 58, 58, 60, 63, 64, 65, 67, 68, 70, 72, 75, 77, 79, 80, 81, 81', '02-19-2020 - 10:55'); -- -- Indexes for dumped tables -- -- -- Indexes for table `pmvisit` -- ALTER TABLE `pmvisit` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `pmvisit` -- ALTER TABLE `pmvisit` MODIFY `id` int(6) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25; /*!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 */; I can attach the pm_visit. Here is the test data --> its all test data
  14. Okay just so I am on the same page - create another table under the same DB with the items I took out to reference those? correct?
  15. I took out the items and I probably messed this up bad, I am trying though... Here is what I did... Code Change: <?php mysqli_report(MYSQLI_REPORT_ERROR|MYSQLI_REPORT_STRICT); $conn = mysqli_connect("localhost", "winuser2003", "homer123", "pmapp"); $tdata = ''; $res = $conn->query("SELECT id, first_name, last_name, SUM(i.pass_fail=0) as `Defect Count`, ..., manager_sign_x, manager_sign_y FROM pmvisit"); foreach ($res as $r) { $tdata .= "<tr><td>{$r['id']}</td> <td>{$r['first_name']}</td> <td>{$r['last_name']}</td> <td>{$r['tech_phonenum']}</td> <td>{$r['store_name']}</td> <td>{$r['store_num']}</td> <td>{$r['store_address']}</td> <td>{$r['manager_name']}</td> <td>{$r['robot_num']}</td> <td>{$r['checkin_time']}</td> <td>{$r['tech_general_comment']}</td> <td>{$r['manager_comments']}</td> <td>{$r['checkout_time']}</td> <td>" . drawImage($r['manager_sign_x'], $r['manager_sign_y']) . "</td>\n"; } LEFT JOIN pmvisit_item i ON v.id = i.visit_id AND pass_fail = 0 GROUP BY v.id function drawImage($xcoords, $ycoords) { $xa = $xcoords[0]=='[' ? json_decode($xcoords, 1) : explode(',', $xcoords); // put x coords into an array $ya = $ycoords[0]=='[' ? json_decode($ycoords, 1) : explode(',', $ycoords); // put x coords into an array $w = max($xa)+1; // get the max coord values so we know the size $h = max($ya)+1; // define the path $path = "M $xa[0] $ya[0] "; // move to the first x,y position unset($xa[0], $ya[0]); // remove the the first items from the array foreach ($xa as $i => $x) { // loop through arrays $y = $ya[$i]; // pairing the ith x with the ith y $path .= "L $x $y "; // define line to x y } // create svg object $w x $h to display image $im = "<svg width='$w' height='$h'> <path d='$path' stroke='#000' stroke-width='2' fill='none'/> </svg>"; return $im; } ?> <!DOCTYPE html> <html> <head> <style type="text/css"> table { border-collapse: collapse; width: 60%; } th { background-color: blue; color: white; padding: 10px; text-align: left; } td { padding: 4px 20px;; } </style> </head> <body> <table border="1" style="width: 60%;"> <tr><th>ID</th> <th>First name</th> <th>Last name</th> <th>Tech Phone Number</th> <th>Store Name</th> <th>Store Number</th> <th>Store Address</th> <th>Manager's Name</th> <th>Manager's Comments</th> <th>Robot Number</th> <th>Checkin Time</th> <th>Technician General Comments</th> <th>Checkout Time</th> <th>Manager Signature</th> <tr> <?=$tdata?> </table> </body> </html> Database Update : I appreciate you helping me with this... your method from what I can tell from your post would make it easier... just need help getting there.
  16. Okay let me refactor the DB labels a little better, I think he did that to test the connection to the mobile app. I will update you when I complete this task
  17. Yes yes I know, the collegue working on the mobile app did it that way, and for the life of me I have no clue why. Probably too lazy to make it right. this my output with the code ?> <!DOCTYPE html> <html> <head> <style type="text/css"> table { border-collapse: collapse; width: 60%; } th { background-color: blue; color: white; padding: 10px; text-align: left; } td { padding: 4px 20px;; Result : Checkin time a bit off Checkout time a bit off.... I made the adjustment from 60 to 20, I think its too much data. Correct me please if I am wrong.
  18. so we pulled some paper docs and did notice that signatures were primarlily on average one path meaning.... like a doctor or what I call "chicken scratch." Over 90% of the documentation would have reference 1 path so I think we are fine the way we are. Not many signatures have 2 names it looks like. You made the comment "its rare" and your right. Next Question: How do I get this time stamp to look a bit more correct? I know ( correct me if I am wrong ) there is CSS styling... but for the life of me I cannot get the timestamp to look correct. <?php mysqli_report(MYSQLI_REPORT_ERROR|MYSQLI_REPORT_STRICT); $conn = mysqli_connect("localhost", "winuser2003", "homer123", "pmapp"); $tdata = ''; $res = $conn->query("SELECT id, first_name, last_name, tech_phonenum, store_name, store_num, store_address, manager_name, robot_num, checkin_time, item_one, item_two, item_three, item_four, item_five, item_six, item_seven, item_eight, item_nine, item_ten, item_eleven, item_twlve, item_thirteen, item_fourteen, item_fifteen, item_sixteen, item_seventenn, item_eighteen, item_nineteen, item_twenty, item_twentyone, item_twentytwo, tech_general_comment, checkout_time, manager_sign_x, manager_sign_y FROM pmvisit"); foreach ($res as $r) { $tdata .= "<tr><td>{$r['id']}</td> <td>{$r['first_name']}</td> <td>{$r['last_name']}</td> <td>{$r['tech_phonenum']}</td> <td>{$r['store_name']}</td> <td>{$r['store_num']}</td> <td>{$r['store_address']}</td> <td>{$r['manager_name']}</td> <td>{$r['robot_num']}</td> <td>{$r['checkin_time']}</td> <td>{$r['item_one']}</td> <td>{$r['item_two']}</td> <td>{$r['item_three']}</td> <td>{$r['item_four']}</td> <td>{$r['item_five']}</td> <td>{$r['item_six']}</td> <td>{$r['item_seven']}</td> <td>{$r['item_eight']}</td> <td>{$r['item_nine']}</td> <td>{$r['item_ten']}</td> <td>{$r['item_eleven']}</td> <td>{$r['item_twlve']}</td> <td>{$r['item_thirteen']}</td> <td>{$r['item_fourteen']}</td> <td>{$r['item_fifteen']}</td> <td>{$r['item_sixteen']}</td> <td>{$r['item_seventenn']}</td> <td>{$r['item_eighteen']}</td> <td>{$r['item_nineteen']}</td> <td>{$r['item_twenty']}</td> <td>{$r['item_twentyone']}</td> <td>{$r['item_twentytwo']}</td> <td>{$r['tech_general_comment']}</td> <td>{$r['checkout_time']}</td> <td>" . drawImage($r['manager_sign_x'], $r['manager_sign_y']) . "</td>\n"; } function drawImage($xcoords, $ycoords) { $xa = $xcoords[0]=='[' ? json_decode($xcoords, 1) : explode(',', $xcoords); // put x coords into an array $ya = $ycoords[0]=='[' ? json_decode($ycoords, 1) : explode(',', $ycoords); // put x coords into an array $w = max($xa)+1; // get the max coord values so we know the size $h = max($ya)+1; // define the path $path = "M $xa[0] $ya[0] "; // move to the first x,y position unset($xa[0], $ya[0]); // remove the the first items from the array foreach ($xa as $i => $x) { // loop through arrays $y = $ya[$i]; // pairing the ith x with the ith y $path .= "L $x $y "; // define line to x y } // create svg object $w x $h to display image $im = "<svg width='$w' height='$h'> <path d='$path' stroke='#000' stroke-width='2' fill='none'/> </svg>"; return $im; } ?> <!DOCTYPE html> <html> <head> <style type="text/css"> table { border-collapse: collapse; width: 60%; } th { background-color: blue; color: white; padding: 10px; text-align: left; } td { padding: 4px 60px;; } </style> </head> <body> <table border="1" style="width: 60%;"> <tr><th>ID</th> <th>First name</th> <th>Last name</th> <th>Tech Phone Number</th> <th>Store Name</th> <th>Store Number</th> <th>Store Address</th> <th>Manager's Name</th> <th>Robot Number</th> <th>Checkin Time</th> <th>Bumper Tie Rod Mounting Screws</th> <th>Inspect/Clean Caster and Drv Wheel</th> <th>Inspect Bumper Damage</th> <th>Remove Motor Cble Ties / inspect frayed cables</th> <th>Inspect Screws/Parts in tray area</th> <th>Vaccum Cooling Air Inlets for PC</th> <th>Visual Cable Inspection / Connections</th> <th>12V Power Port Inspection</th> <th>Lidar Drv Belt Inspect</th> <th>Backdoor Alignment Check</th> <th>Charging Connector Contact Condition</th> <th>Trim lwr right cover under lidar</th> <th>Tighten GO Button nut</th> <th>Align WiFi Antenna</th> <th>Center Camera Alignment Check</th> <th>Lidar Rotation Check</th> <th>Googly Eyes Check</th> <th>Cleaned Non-Optical Cover Surfaces</th> <th>Clean all Optical Imaging Components</th> <th>Inspect Dock Connector / Height / Contact Condition</th> <th>Dock and Fudicals Cleaned</th> <th>Dock and Park Tape</th> <th>Technician General Comments</th> <th>Checkout Time</th> <th>Manager Signature</th> <tr> <?=$tdata?> </table> </body> </html> Next: I would like to add arrows for filters / and maybe build a search out... would you be able to assist me with this? I will be glad to donate more for your assistance.
  19. How would I be able to build something that tells someone else they are on that specific URL? I am working to collect more data for better understanding of the issue... please be patient.
  20. Good Point, let me look at that Update: Your right look at the Screenshot How would that be fixed code wise?
  21. All, Thank you for your help with this specific project and its been ongoing for a while now. I been doing alot of consulting of where I should start I will do my best to explain this.... Lets say your in a office with 2 groups of 10 people. Those 10 people jump on the same websites everyday. The problem is no 2 people should be on the same website if one is working on it. a notification should pop up at some point and say "user ID X is currently working on this page please wait..." or something relevant to that. Once that person is done working on that webpage then the person making attempts can finally access it. Below is a statement from another consultant Basically, we work with robots and the control panel is through the web interface we use. Each robot has an ID as well as the people working on them also have ID's which is usually there email. I would prefer however to do this in a CSV or DB The problem is we do not want 2 people working on the same robot at the sametime. Today there is nothing that notifies us if someone else is working on that robot or not. You will see in the statement he mentions "Multi-View" which is a custom UI that uses tampermonkey chrome plugin to overlay a better interface over the actual interface. I hope this description is not to vague, if it is please let me know and I will try to go way more indepth of what is needed for this project.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.