HEX
Server: Apache/2.4.46 (Win64) OpenSSL/1.1.1j PHP/8.4.25
System: Windows NT DESKTOP-4TAV2RJ 10.0 build 19045 (Windows 10) AMD64
User: fred (0)
PHP: 8.4.25
Disabled: NONE
$ pwd: C:/xampp/htdocs/
Upload Files
File: C:/xampp/htdocs/spotreport.sql
/*
MySQL Data Transfer
Source Host: localhost
Source Database: tvicheck-st
Target Host: localhost
Target Database: tvicheck-st
Date: 2024/8/10 �U�� 06:27:43
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for spotreport
-- ----------------------------
CREATE TABLE `spotreport` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `po` varchar(20) DEFAULT NULL,
  `company` varchar(20) DEFAULT NULL,
  `colorName` varchar(20) DEFAULT NULL,
  `ddate` datetime DEFAULT NULL,
  `sn` varchar(12) DEFAULT NULL,
  `stdL` float(6,2) DEFAULT NULL,
  `stda` float(6,2) DEFAULT NULL,
  `stdb` float(6,2) DEFAULT NULL,
  `stdSum` float(6,2) DEFAULT NULL,
  `stdD` float(6,2) DEFAULT NULL,
  `rgbS` varchar(6) DEFAULT NULL,
  `fn` int(2) DEFAULT NULL,
  `Filename` varchar(64) DEFAULT NULL,
  `upL` float(6,2) DEFAULT NULL,
  `upa` float(6,2) DEFAULT NULL,
  `upb` float(6,2) DEFAULT NULL,
  `upSum` float(6,2) DEFAULT NULL,
  `upD` float(6,2) DEFAULT NULL,
  `rgbUp` varchar(6) DEFAULT NULL,
  `LoL` float(6,2) DEFAULT NULL,
  `Loa` float(6,2) DEFAULT NULL,
  `Lob` float(6,2) DEFAULT NULL,
  `LoSum` float(6,2) DEFAULT NULL,
  `LoD` float(6,2) DEFAULT NULL,
  `rgbLo` varchar(6) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=193 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `spotreport` VALUES ('164', 'suntory6166c', 'suntory', null, '2024-06-06 09:23:16', '', '47.31', '-60.60', '24.37', null, null, '008644', '21', 'CR-2024-0606-092314.txt', null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `spotreport` VALUES ('165', 'suntory2006c', 'suntory', null, '2024-06-06 09:25:54', '', '77.65', '10.43', '62.02', null, null, 'f0b648', '2', 'CR-2024-0606-092553.txt', null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `spotreport` VALUES ('166', 'suntory1575c', 'suntory', null, '2024-06-06 09:29:43', '', '70.09', '48.61', '63.46', null, null, 'ff8335', '2', 'CR-2024-0606-092942.txt', null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `spotreport` VALUES ('167', 'suntory637c', 'suntory', null, '2024-06-06 09:31:05', '', '73.41', '-28.17', '-27.00', null, null, '22c5e5', '23', 'CR-2024-0606-093104.txt', null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `spotreport` VALUES ('169', '005', 'fw', null, '2024-06-11 12:42:42', '', '82.97', '7.67', '93.86', '15.00', '1.75', 'ffc400', '5', 'CR-2024-0611-124243.txt', '82.36', '9.49', '96.76', '15.20', '1.62', 'ffc200', '84.29', '6.29', '91.45', '15.80', '1.49', 'ffc900');
INSERT INTO `spotreport` VALUES ('170', '9025', 'fw', null, '2024-06-14 16:51:53', '', '83.31', '7.74', '95.00', null, null, 'ffc700', '6', 'CR-2024-0614-165154.txt', null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `spotreport` VALUES ('171', '0085', 'fw', null, '2024-06-14 17:24:14', '', '60.70', '13.41', '36.15', null, null, 'bb8853', '2', 'CR-2024-0614-172134.txt', null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `spotreport` VALUES ('172', '008', 'fw', null, '2024-06-14 17:37:07', 'CM42570002', '59.77', '13.51', '36.81', null, null, 'b9864f', '2', 'CR-2024-0614-173708.txt', null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `spotreport` VALUES ('173', '009', 'fw', null, '2024-06-14 17:52:04', 'CM42570002', '59.77', '13.51', '36.81', null, null, 'b9864f', '2', 'CR-2024-0614-174912.txt', null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `spotreport` VALUES ('174', '001', 'rb', null, '2024-06-25 12:15:23', '', '0.00', '0.00', '0.00', '0.00', '0.00', '000000', '2', 'CR-2024-0625-121524.txt', '0.00', '0.00', '0.00', '0.00', '0.00', '000000', '0.00', '0.00', '0.00', '0.00', '0.00', '000000');
INSERT INTO `spotreport` VALUES ('175', '007L', 'crony', null, '2024-07-05 19:49:48', '', '63.75', '9.68', '24.32', '12.04', '0.97', 'c0925d', '2', 'CR-2024-0418-003955.txt', '69.73', '8.04', '24.21', '9.94', '1.06', 'd0a26b', '55.52', '11.54', '22.26', '7.45', '1.16', 'aa7b4f');
INSERT INTO `spotreport` VALUES ('176', '334', 'fw', null, '2024-07-05 19:49:49', '', '54.87', '9.53', '20.03', null, null, '9f7d61', '2', 'CR-2024-0605-103551.txt', null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `spotreport` VALUES ('177', '0025L', 'crony', null, '2024-07-06 11:55:36', '', '83.39', '7.76', '95.20', '15.56', '1.68', 'ffc600', '6', 'CR-2024-0417-155056.txt', '83.59', '9.48', '97.03', '15.39', '1.66', 'ffc500', '84.37', '6.43', '92.52', '15.82', '1.54', 'ffc900');
INSERT INTO `spotreport` VALUES ('178', 'yy563', 'FW', null, '2024-07-06 11:55:36', '', '52.73', '57.37', '48.06', '9.26', '1.61', 'e34620', '5', 'CR-2024-0310-235848.txt', '49.98', '61.96', '49.44', '9.79', '1.47', 'e03518', '55.01', '52.14', '45.39', '10.13', '1.34', 'e4542a');
INSERT INTO `spotreport` VALUES ('179', 'pp12345', 'FW', null, '2024-07-06 11:55:36', '', '84.65', '-3.44', '4.75', '19.31', '0.35', 'dfd3ae', '2', 'CR-2024-0310-172536.txt', '84.49', '-3.52', '4.73', '19.40', '0.35', 'dfd2ae', '84.30', '-3.17', '5.26', '19.22', '0.36', 'dfd2ad');
INSERT INTO `spotreport` VALUES ('180', '558766', 'FW', null, '2024-07-06 11:55:37', '', '70.25', '8.02', '24.61', '12.71', '0.93', 'd1a46b', '2', 'CR-2024-0307-174942.txt', '71.50', '7.61', '24.08', '12.20', '0.96', 'd4a76f', '70.43', '8.08', '24.81', '12.28', '0.96', 'd2a46b');
INSERT INTO `spotreport` VALUES ('181', 'qq34', '', null, '2024-07-06 11:55:37', '', '63.11', '9.76', '24.17', '9.58', '1.08', 'bf905c', '2', 'CR-2024-0307-155602.txt', '62.61', '11.22', '25.13', '9.71', '1.07', 'c08e5a', '62.68', '11.46', '25.16', '9.64', '1.07', 'c08e5a');
INSERT INTO `spotreport` VALUES ('182', '1234557', 'FW', null, '2024-07-06 11:55:37', '', '83.69', '-3.21', '5.98', '18.70', '0.38', 'ded0aa', '2', 'CR-2024-0310-141415.txt', '83.49', '-3.36', '5.54', '18.78', '0.39', 'ddd0aa', '83.86', '-3.56', '6.24', '18.85', '0.38', 'ded1aa');
INSERT INTO `spotreport` VALUES ('183', '0025s', 'crony', null, '2024-07-06 11:55:37', '', '81.88', '7.74', '93.04', null, null, 'ffc300', '6', 'CR-2024-0417-144534.txt', null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `spotreport` VALUES ('184', 's001', 'FW', null, '2024-07-06 11:55:37', '', '81.99', '-3.81', '3.59', null, null, '000000', '2', 'CR-2024-0328-225914.txt', null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `spotreport` VALUES ('185', '4180', 'fw', null, '2024-07-18 11:25:00', '', '0.00', '0.00', '0.00', '0.00', '0.00', '000000', '2', 'CR-2024-0718-112457.txt', '0.00', '0.00', '0.00', '0.00', '0.00', '000000', '0.00', '0.00', '0.00', '0.00', '0.00', '000000');
INSERT INTO `spotreport` VALUES ('186', '00001', 'cympotek', null, '2024-07-19 10:41:48', '', '72.47', '9.73', '64.74', null, null, 'e0a932', '2', 'CR-2024-0719-104145.txt', null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `spotreport` VALUES ('187', '001', 'sc', null, '2024-07-20 12:08:51', '', '58.91', '44.82', '33.45', '11.20', '1.04', 'e56846', '7', 'CR-2024-0426-081520.txt', '59.21', '44.84', '33.06', '11.05', '1.06', 'e66848', '59.46', '45.14', '34.43', '11.30', '1.06', 'e76946');
INSERT INTO `spotreport` VALUES ('188', '0807', 'fw', null, '2024-08-07 12:19:01', '', '83.29', '7.88', '94.93', '14.61', '1.81', 'ffc500', '5', 'CR-2024-0807-121900.txt', '81.52', '9.61', '96.93', '15.37', '1.65', 'ffbf00', '83.28', '6.44', '91.91', '15.32', '1.56', 'ffc600');
INSERT INTO `spotreport` VALUES ('189', '0807', 'cn', null, '2024-08-07 17:11:40', '', '0.00', '0.00', '0.00', '0.00', '0.00', '000000', '2', 'CR-2024-0807-171141.txt', '0.00', '0.00', '0.00', '0.00', '0.00', '000000', '0.00', '0.00', '0.00', '0.00', '0.00', '000000');
INSERT INTO `spotreport` VALUES ('190', '0808', 'cn', null, '2024-08-07 17:12:01', '', '0.00', '0.00', '0.00', '0.00', '0.00', '000000', '2', 'CR-2024-0807-171202.txt', '0.00', '0.00', '0.00', '0.00', '0.00', '000000', '0.00', '0.00', '0.00', '0.00', '0.00', '000000');
INSERT INTO `spotreport` VALUES ('191', '0809', 'pp', null, '2024-08-09 07:23:39', '', '88.73', '-0.51', '0.55', null, null, 'dedfde', '2', 'CR-2024-0809-072341.txt', null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `spotreport` VALUES ('192', '090', 'fw', null, '2024-08-09 13:45:26', 'CM42570002', '70.77', '8.01', '24.70', null, null, 'cba781', '2', 'CR-2024-0809-134526.txt', null, null, null, null, null, null, null, null, null, null, null, null);
@ Telegram