Jump to content

Confused about Graphing Coordinates


winuser2003

Recommended Posts

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

 

Link to comment
Share on other sites

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>

 

Edited by winuser2003
Link to comment
Share on other sites

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

 

Link to comment
Share on other sites

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!  

Link to comment
Share on other sites

This the function used to create the left-hand side images (uses scaleable vector graphics (SVG) )

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

The image on the right was an experiment to create a .png version. I don't think the quality is as good as vector ones.

Edited by Barand
Link to comment
Share on other sites

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.

 

Link to comment
Share on other sites

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>

 

Link to comment
Share on other sites

5 hours ago, winuser2003 said:

Parse error: syntax error, unexpected '*'

You are using an outdated version of PHP (pre v5.6)

Change

$act = (sqrt($dx**2 + $dy**2) > 30) ? 'M' : 'L';                               // check distance between successive points

to

$act = (sqrt($dx*$dx + $dy*$dy) > 30) ? 'M' : 'L';                               // check distance between successive points

 

Link to comment
Share on other sites

With care not to use any features that have been added within the last five years, or any that are about to be removed in later versions (to protect against future updates of your implementation), then it can be achieved.

However, it's always best to be up to date with version used, and as you are pre 5.6, I would recommend an update. (Having said that, I'm a couple of versions behind (7.2) )

Link to comment
Share on other sites

8 hours ago, winuser2003 said:

Just the first concept I had in mind and wanted your thoughts.

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.

 

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.

 

3. What is "BAR number"? I do not see it in the data.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

If by "Issue" you are referring to the various item checks then no change would be required.

For example, it will be possible to filter all those that fail the "Googly Eyes Check" or "the "Lidar Rotation Check". 

If, however, by issue you are referring a lower level of detail within these checks then my earlier comment stands and change is needed.

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

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