Jump to content

winuser2003

Members
  • Posts

    110
  • Joined

  • Last visited

Posts posted by winuser2003

  1. 42 minutes ago, ginerjm said:

    Are you Really going to make me search thru your code to find this line?  No thanks.

    Obviously the guy who did this thought he was doing something very clever instead of just writing out the Cell lines he built a structure and looped thru it just to make maintenance difficult.  Yes - the k value if going out of range.  You probably have to add a couple entries to those arrays.

    No definitely not.... I will try adding a couple entries to the array and see what happens

  2. 41 minutes ago, Barand said:

    You are outputting 7 data cells (indexes 0 - 6)

                $cells = [$brandname, $storename, $r['checkin_time'], $r['checkout_time'], $r['robot_num'], $r['date'], $r['total']];
                foreach ($cells as $k => $v) {
                    $this->Cell($this->widths[$k], 5, $v, 0, 0, 0, 0, $this->aligns[$k]);
                }

    In the class constructor, only 6 widths and alignments (0 - 5) are specified, so index 6 is missing for those arrays

            $this->widths = [25,65,30,20,20,20];
            $this->aligns = ['L','L','L','R','R','R'];
        

     

    So this is where I need to make the adjustment?

  3. is this because because of the width? this is the error I got

    Notice: Undefined offset: 6 in /var/www/html/pmapp/reporttest/pm_bill_pdf.php on line 141
    
    Fatal error: Uncaught Exception: FPDF error: Some data has already been output, can't send PDF file (output started at /var/www/html/pmapp/reporttest/pm_bill_pdf.php:141) in /var/www/html/pmapp/reporttest/fpdf/fpdf.php:271 Stack trace: #0 /var/www/html/pmapp/reporttest/fpdf/fpdf.php(1049): FPDF->Error() #1 /var/www/html/pmapp/reporttest/fpdf/fpdf.php(999): FPDF->_checkoutput() #2 /var/www/html/pmapp/reporttest/pm_bill_pdf.php(163): FPDF->Output() #3 {main} thrown in /var/www/html/pmapp/reporttest/fpdf/fpdf.php on line 271

     

  4. Just showing my changes, its just showing 1 error now on line 141

    <?php
    ini_set('display_errors', 1);
    session_start();
    if (!isset($_SESSION['user_id'])) {
        header("Location: pm_login.php");
        exit;
    }
    
    include '../reporttest/fpdf/fpdf.php';
    include 'db_inc.php';
    $conn = pdoConnect();
    
    class PMpdf extends fpdf
    {
        protected $today;
        protected $headbase;
        protected $db;
        protected $month;
        protected $monthname;
        protected $brand;
        protected $state;
        protected $store;
        protected $widths;
        protected $aligns;
                                                                                                        
        //constructor
        public function __construct($db, $month, $brand, $state, $store)
        {
            parent::__construct('P', 'mm', 'Letter');
            $this->today = date('jS M Y');
            $this->monthname = (new DateTime("{$month}-01"))->format('F Y');
            $this->db = $db;
            $this->month = $month;
            $this->brand = $brand;
            $this->statecode = $state;
            $this->store = $store;
            $this->SetMargins(20, 10, 15);
            $this->widths = [25,65,30,20,20,20];
            $this->aligns = ['L','L','L','R','R','R'];
        }
    
        //Page header
        public function Header()
        {        
            $this->Image('badger_logo.PNG', 18, 10, 40);
            $this->SetX(90);
            $this->SetFont('Helvetica', '', 18);
            $this->Cell(90, 8, "PM Total Hours", 0, 2, 'C');
            $this->SetFontSize(14);
            $this->Cell(90, 8, $this->monthname, 0, 1, 'C');
            $this->SetFont('','B',8);
            $this->Ln(5);
            $heads = ['Brand Name', 'Store', 'Robot', 'Date', 'Duration', 'Store Hrs'];
            foreach ($heads as $k => $h) {
                $this->Cell($this->widths[$k], 5, $h, 'TB', 0, $this->aligns[$k]);
            }
            $this->Ln(5);
            $this->headbase = $this->GetY();
            $this->SetFont('','');
        }
        
        //Page footer
        public function Footer()
        {
            $this->setY(-18);
            $this->setX(20);
            $this->SetFont('Helvetica', '', 8);
            $this->Cell(90,5,'( '.$this->today.' )', 'T', 0);
            $this->Cell(0,5,$this->PageNo().' of {nb}', 'T', 0, 'R');
        }
        
        public function createSummaryReport()
        {
            $where = ['v.checkin_time LIKE ?', 'a.user_id = ?'];
            $params = [$this->month . '%', $_SESSION['user_id'] ];
            $whereclause = '';
    
            if ($this->brand) {
                $where[] = "s.client_id = ?";
                $params[] = $this->brand;
            }
            if ($this->statecode) {
                $where[] = "s.state = ?";
                $params[] = $this->statecode;
            }
            if ($this->store) {
                $where[] = "v.store_num = ?";
                $params[] = $this->store;
            }
    
            $tdata = '';
    
    
            $whereclause = 'WHERE ' . join(' AND ', $where);
            
            $res = $this->db->prepare("SELECT c.brand
                                        , CONCAT(LPAD(s.store_num,4,'0'), ' ', s.store_address) as store
                                        , v.robot_num
                                        , v.checkin_time
                                        , v.checkout_time
                                        , date_format(v.checkin_time, '%m/%d/%Y') as date
                                        , round(timestampdiff(SECOND, checkin_time, checkout_time)/3600,2) as total
                                   FROM pm_visit v
                                        JOIN 
                                        store s USING (store_num)
                                        JOIN 
                                        client c USING (client_id)
                                        JOIN
                                        user_client_access a USING (client_id)
                                   $whereclause   
                                   ORDER BY brand, store, robot_num
                                  ");
            $res->execute($params);
            $prevs='';
            $prevb = '';
            $stotal = $btotal = 0;
            foreach ($res as $r) {
                $brandname = $r['brand']==$prevb ? '' : $r['brand'];
                $storename = $r['store']==$prevs ? '' : $r['store'];
                $saveb = $r['brand'];
                $saves = $r['store'];
                array_shift($r);
                array_shift($r);
                if ($saveb <> $prevb) {
                    if ($prevb) {
                        $this->Cell($this->widths[5], 5, number_format($stotal, 2), 0, 1, $this->aligns[5]);
                        $this->Cell(180 - $this->widths[5], 5, $prevb, 0, 0, 'R', 1);
                        $this->Cell($this->widths[5], 5, number_format($btotal, 2), 'TB', 1, $this->aligns[5], 0);
                        $stotal = $btotal = 0;
                        $this->AddPage();
                    }
                }
                elseif ($saves <> $prevs) {
                    $this->Cell($this->widths[5], 5, number_format($stotal, 2), 0, 1, $this->aligns[5]);
                    $stotal = 0;
                }
                else $this->Ln();
                
                $cells = [$brandname, $storename, $r['checkin_time'], $r['checkout_time'], $r['robot_num'], $r['date'], $r['total']];
                foreach ($cells as $k => $v) {
                    $this->Cell($this->widths[$k], 5, $v, 0, 0, 0, 0, $this->aligns[$k]);
                }
                 
                $stotal += $r['total'];
                $btotal += $r['total'];
                $prevb = $saveb;
                $prevs = $saves;
            }
            if ($btotal) {
                $this->Cell($this->widths[5], 5, number_format($stotal, 2), 0, 1, 'R');
                $this->Cell(180 - $this->widths[5], 5, $prevb, 0, 0, 'R', 1);
                $this->Cell($this->widths[5], 5, number_format($btotal, 2), 'TB', 1, 'R', 0);
            }
        }
    }
    
    $pdf = new PMpdf($conn, $_GET['ym'], $_GET['brand'], $_GET['state'], $_GET['store']);
    $pdf->AliasNbPages();
    $pdf->SetFillColor(200);
    $pdf->SetDrawColor(120);
    $pdf->addPage();
    $pdf->createSummaryReport();
    $pdf->output();  
    ?>

     

  5. 38 minutes ago, ginerjm said:

    Are these 2 new cols already in your db so that your query can retrieve them?  If so - then you just need to add their CELL outputs in the right place to output them such as after the CELL call for the Date field/column.  

    Seems like a simple problem with an easy solution so I have to wonder why you are asking.  Are you not a coder perhaps?

    Yes the 2 cols are in the database already, I am just looking for the right spot to add the cell outputs to the code is all.  Yes, its a simple problem I believe. I am a coder yes, but not as experienced.

  6. Hi,

    An old friend of mine coded this, so I am just trying to work with his script he helped me out with is all. I am just weeding through how he has everything setup. I will try your suggestion and thank you for your help... 

  7. Hi,

    I have a print to pdf script written that allows a specific chart I have to be printed to PDF. I just need to add 2 more columns to this table. I am not used to the print to pdf function so this is why I am asking. Let me introduce what the report currently shows as far as its headers.

    image.png.010a87a4dcf22cb1ba3df67230084944.png

     

    What I would like to add to these headers is a check in and check out column

    image.thumb.png.fc5ec8ad02edb67716d1499f84293484.png

     

    The Print to PDF code is as follows:

    <?php
    ini_set('display_errors', 1);
    session_start();
    if (!isset($_SESSION['user_id'])) {
        header("Location: pm_login.php");
        exit;
    }
    
    include '../reporttest/fpdf/fpdf.php';
    include 'db_inc.php';
    $conn = pdoConnect();
    
    class PMpdf extends fpdf
    {
        protected $today;
        protected $headbase;
        protected $db;
        protected $month;
        protected $monthname;
        protected $brand;
        protected $state;
        protected $store;
        protected $widths;
        protected $aligns;
                                                                                                        
        //constructor
        public function __construct($db, $month, $brand, $state, $store)
        {
            parent::__construct('P', 'mm', 'Letter');
            $this->today = date('jS M Y');
            $this->monthname = (new DateTime("{$month}-01"))->format('F Y');
            $this->db = $db;
            $this->month = $month;
            $this->brand = $brand;
            $this->statecode = $state;
            $this->store = $store;
            $this->SetMargins(20, 10, 15);
            $this->widths = [25,65,30,20,20,20];
            $this->aligns = ['L','L','L','R','R','R'];
        }
    
        //Page header
        public function Header()
        {        
            $this->Image('badger_logo.PNG', 18, 10, 40);
            $this->SetX(90);
            $this->SetFont('Helvetica', '', 18);
            $this->Cell(90, 8, "PM Total Hours", 0, 2, 'C');
            $this->SetFontSize(14);
            $this->Cell(90, 8, $this->monthname, 0, 1, 'C');
            $this->SetFont('','B',8);
            $this->Ln(5);
            $heads = ['Brand Name', 'Store', 'Robot', 'Date', 'Duration', 'Store Hrs'];
            foreach ($heads as $k => $h) {
                $this->Cell($this->widths[$k], 5, $h, 'TB', 0, $this->aligns[$k]);
            }
            $this->Ln(5);
            $this->headbase = $this->GetY();
            $this->SetFont('','');
        }
        
        //Page footer
        public function Footer()
        {
            $this->setY(-18);
            $this->setX(20);
            $this->SetFont('Helvetica', '', 8);
            $this->Cell(90,5,'( '.$this->today.' )', 'T', 0);
            $this->Cell(0,5,$this->PageNo().' of {nb}', 'T', 0, 'R');
        }
        
        public function createSummaryReport()
        {
            $where = ['v.checkin_time LIKE ?', 'a.user_id = ?'];
            $params = [$this->month . '%', $_SESSION['user_id'] ];
            $whereclause = '';
    
            if ($this->brand) {
                $where[] = "s.client_id = ?";
                $params[] = $this->brand;
            }
            if ($this->statecode) {
                $where[] = "s.state = ?";
                $params[] = $this->statecode;
            }
            if ($this->store) {
                $where[] = "v.store_num = ?";
                $params[] = $this->store;
            }
    
            $tdata = '';
    
    
            $whereclause = 'WHERE ' . join(' AND ', $where);
            
            $res = $this->db->prepare("SELECT c.brand
                                        , CONCAT(LPAD(s.store_num,4,'0'), ' ', s.store_address) as store
                                        , v.robot_num
                                        , date_format(v.checkin_time, '%m/%d/%Y') as date
                                        , round(timestampdiff(SECOND, checkin_time, checkout_time)/3600,2) as total
                                   FROM pm_visit v
                                        JOIN 
                                        store s USING (store_num)
                                        JOIN 
                                        client c USING (client_id)
                                        JOIN
                                        user_client_access a USING (client_id)
                                   $whereclause   
                                   ORDER BY brand, store, robot_num
                                  ");
            $res->execute($params);
            $prevs='';
            $prevb = '';
            $stotal = $btotal = 0;
            foreach ($res as $r) {
                $brandname = $r['brand']==$prevb ? '' : $r['brand'];
                $storename = $r['store']==$prevs ? '' : $r['store'];
                $saveb = $r['brand'];
                $saves = $r['store'];
                array_shift($r);
                array_shift($r);
                if ($saveb <> $prevb) {
                    if ($prevb) {
                        $this->Cell($this->widths[5], 5, number_format($stotal, 2), 0, 1, $this->aligns[5]);
                        $this->Cell(180 - $this->widths[5], 5, $prevb, 0, 0, 'R', 1);
                        $this->Cell($this->widths[5], 5, number_format($btotal, 2), 'TB', 1, $this->aligns[5], 0);
                        $stotal = $btotal = 0;
                        $this->AddPage();
                    }
                }
                elseif ($saves <> $prevs) {
                    $this->Cell($this->widths[5], 5, number_format($stotal, 2), 0, 1, $this->aligns[5]);
                    $stotal = 0;
                }
                else $this->Ln();
                
                $cells = [$brandname, $storename, $r['robot_num'], $r['date'], $r['total']];
                foreach ($cells as $k => $v) {
                    $this->Cell($this->widths[$k], 5, $v, 0, 0, $this->aligns[$k]);
                }
                 
                $stotal += $r['total'];
                $btotal += $r['total'];
                $prevb = $saveb;
                $prevs = $saves;
            }
            if ($btotal) {
                $this->Cell($this->widths[5], 5, number_format($stotal, 2), 0, 1, 'R');
                $this->Cell(180 - $this->widths[5], 5, $prevb, 0, 0, 'R', 1);
                $this->Cell($this->widths[5], 5, number_format($btotal, 2), 'TB', 1, 'R', 0);
            }
        }
    }
    
    $pdf = new PMpdf($conn, $_GET['ym'], $_GET['brand'], $_GET['state'], $_GET['store']);
    $pdf->AliasNbPages();
    $pdf->SetFillColor(200);
    $pdf->SetDrawColor(120);
    $pdf->addPage();
    $pdf->createSummaryReport();
    $pdf->output();  
    ?>

     

    Can you please advise where I would need to alter the code to add-in the columns? Thank you for your time and suggestions. Let me know if I need to provide more information.

  8. 29 minutes ago, Barand said:

    2. If you want  a breakdown by "issue" then your visit_item data needs an issue code. You cannot rely on freeform text - minor mis-spellings corrupt the data. You probably also need a table defining the issues that can arise for each item. Instead of comment text, the tech would select from a menu. You data capture app is in for some significant changes.

    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.

  9. Answer to Question 3

    image.png.d891493da7c2a14e85a48c6a3ade2502.png

     

    For comments on 1 and 2 your absolutely correct. 

    20 minutes ago, Barand said:

    1. For your

    • Save as CSV
    • Email report
    • Print report

    You are going to need image files for each of the signatures if they are to be included (via image URL). You will also need to master PDFs for the printed versions.

    Not sure how this would be approached code wise

    21 minutes ago, Barand said:

    2. If you want  a breakdown by "issue" then your visit_item data needs an issue code. You cannot rely on freeform text - minor mis-spellings corrupt the data. You probably also need a table defining the issues that can arise for each item. Instead of comment text, the tech would select from a menu. You data capture app is in for some significant changes.

    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.

  10. 2 hours ago, Barand said:

    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; }

    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>

     

  11. 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

    image.png.382b570f88790a498cca6c46077a08b2.png

    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.

     

  12. 3 hours ago, Barand said:

    As an aside, below is a comparison of different versions of the drawImage function.

    The one on the left looks for successive points that are more than 30 pixels apart and assumes the pen was lifted if they are.

    The one on the right just joins everything, as now.

    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!  

  13. 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 */;

     

  14. 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>

     

  15. 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

     

×
×
  • 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.