INSERT INTO `vendors` (`vendor_id`, `vendor_name`, `vendor_mobile_num`, `email`, `password`, `balance`, `hourly_rate`, `carton_cost`, `pallet_cost`, `stock_move_cost`, `appliance_cost`, `furniture_cost`, `hazardous_goods_cost`, `others_cost`, `installation_cost`, `unwrapping_cost`, `fragile_cost`, `stair_cost`, `lift_cost`, `apply_km_rate`, `apply_cubic_rate`, `account_status_id`, `remember_token`, `email_verified_at`, `created_at`, `updated_at`) VALUES
(30, 'amren', '64123098765', 'amren@gmail.com', '$2y$10$2F66kbjBsYALifC85yEBj.tpVfov6se1zn.xVqdIRtXbimecq0DiO', '160.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', 1, 0, 2, NULL, NULL, '2022-05-07 13:24:41', '2022-05-07 13:24:41'),
(31, 'amit', '640000000000', 'amit@gmail.com', '$2y$10$2F66kbjBsYALifC85yEBj.tpVfov6se1zn.xVqdIRtXbimecq0DiO', '0.00', '10.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '10.00', '0.00', 1, 0, 2, NULL, NULL, '2022-05-07 13:24:41', '2022-05-07 13:24:41'),
(32, 'Bhavik', '64855689413689', 'abc@def.com', '$2y$10$2F66kbjBsYALifC85yEBj.tpVfov6se1zn.xVqdIRtXbimecq0DiO', '1500.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '100.00', '200.00', '0.00', '100.00', '0.00', 1, 0, 2, NULL, NULL, '2022-05-07 13:24:41', '2022-05-07 13:24:41'),
(33, 'ankita', '640987456123', 'admin99@gmail.com', '$2y$10$2F66kbjBsYALifC85yEBj.tpVfov6se1zn.xVqdIRtXbimecq0DiO', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '1.46', '0.00', '0.00', '0.00', 1, 0, 2, NULL, NULL, '2022-05-07 13:24:41', '2022-05-07 13:24:41'),
(50, 'Bhavikgujral', '648556894136', 'demo@vendor.com', '$2y$10$2F66kbjBsYALifC85yEBj.tpVfov6se1zn.xVqdIRtXbimecq0DiO', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '100.00', '50.00', '0.00', '100.00', '200.00', 1, 0, 2, NULL, NULL, '2022-05-07 13:24:41', '2022-05-07 13:24:41'),
(64, 'Bhaviknewvendor', '648146981188', 'abc@demo.com', '$2y$10$2F66kbjBsYALifC85yEBj.tpVfov6se1zn.xVqdIRtXbimecq0DiO', '2100.50', '100.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '100.00', '100.00', '0.00', '100.00', '0.00', 1, 0, 2, NULL, NULL, '2022-05-07 13:24:41', '2022-05-07 13:24:41'),
(70, 'anjana', '641122336655', 'anjana1@gmail.com', '$2y$10$2F66kbjBsYALifC85yEBj.tpVfov6se1zn.xVqdIRtXbimecq0DiO', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', 1, 0, 2, NULL, NULL, '2022-05-07 13:24:41', '2022-05-07 13:24:41'),
(72, 'Trust Movers', '6402108192662', 'mayer@trustmovers.co.nz', '$2y$10$uGvrvurK0IDDvlUqbx4iNOOI6W8PpcQtruqZPY7XaWJmLoRka2ZjO', '4830.15', '0.00', '25.00', '25.00', '25.00', '25.00', '25.00', '25.00', '25.00', '20.00', '20.00', '20.00', '0.00', '0.00', 1, 0, 1, NULL, NULL, '2022-05-07 13:24:41', '2022-05-07 13:24:41'),
(73, 'Harvey Norman, Mt Wellington ( Furniture)', '640210485799', 'sahil.rana@nz.harveynorman.com', '$2y$10$DiRqiiaM66PBLF.FkKVmdOYE/IQgr9PMXXYgx0.tvRNUfK0velPu.', '22293.07', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '17.45', '17.45', '0.00', '20.00', '20.00', 1, 0, 1, NULL, NULL, '2022-05-07 13:45:24', '2022-05-07 13:45:24'),
(74, 'Trenz Bathroom (Hamilton) Limited', '640212548139', 'Emily@trenzbathroom.co.nz', '$2y$10$BNM7Z/z1iiMlI1UK5AMgKOq4bwviTNMLZ1/U4ng6mvE2VFkYap/gC', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '30.00', '18.00', '0.00', '0.00', '0.00', 0, 1, 1, NULL, NULL, '2022-05-07 13:53:30', '2022-05-07 13:53:30'),
(75, 'Abhi Tech test', '640223203270', 'meetabhishekdas@gmail.com', '$2y$10$2F66kbjBsYALifC85yEBj.tpVfov6se1zn.xVqdIRtXbimecq0DiO', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '10.00', '10.00', '0.00', '0.00', '0.00', 1, 0, 2, NULL, NULL, '2022-05-07 13:24:41', '2022-05-07 13:24:41'),
(76, 'Harvey Norman Mt Wellington  (Electrical)', '64021805562', 'mtwellington.office@nz.harveynorman.com', '$2y$10$jNec22slmbSH6x.Mv78DYuuC/ZAdjVLljpvf4ZlU2KQxz1ZUZTdE6', '2501.80', '0.00', '25.00', '25.00', '25.00', '25.00', '25.00', '25.00', '25.00', '20.00', '17.00', '0.00', '0.00', '0.00', 1, 0, 1, NULL, NULL, '2022-05-07 14:03:05', '2022-05-07 14:03:05'),
(82, 'BHAVIK', '648556894136', 'bhavik.indianmesh@gmail.com', '$2y$10$2F66kbjBsYALifC85yEBj.tpVfov6se1zn.xVqdIRtXbimecq0DiO', '16400.00', '0.00', '25.00', '25.00', '25.00', '25.00', '25.00', '25.00', '25.00', '14.00', '14.00', '14.00', '1.00', '15.00', 1, 0, 1, NULL, NULL, '2022-05-07 14:19:18', '2022-05-07 14:19:18'),
(83, 'Harvey Norman Mt Roskill (Electrical)', '6402108401195', 'Kent.Unwin@nz.harveynorman.com', '$2y$10$QMsaDxmoG0Q.iVvGbukOD.pg7ZQkRHfr9j0nZeW3JwV17WxgViHXC', '3095.71', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '20.00', '15.00', '0.00', '0.00', '0.00', 1, 0, 1, NULL, NULL, '2022-05-07 14:26:54', '2022-05-07 14:26:54'),
(84, 'Harvey Norman Mt Wellington ( Bedding)', '646495703440', 'nick.dhawan@nz.harveynorman.com', '$2y$10$bmXzWltPni0VTAKdx1p6IOx/bd8OICUsw5m6KjWkMm1Ws2rZ6ocke', '1088.50', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '30.00', '25.00', '0.00', '0.00', '0.00', 1, 1, 1, NULL, NULL, '2022-05-07 14:41:16', '2022-05-07 14:41:16'),
(85, 'testing vendor', '64123456789', 'testingvendor@demo.com', '$2y$10$2F66kbjBsYALifC85yEBj.tpVfov6se1zn.xVqdIRtXbimecq0DiO', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '100.00', '100.00', '0.00', '100.00', '0.00', 1, 0, 2, NULL, NULL, '2022-05-07 13:24:41', '2022-05-07 13:24:41'),
(86, 'Design Concepts Auckland', '64223173445', 'richard@designconcepts.co.nz', '$2y$10$KtYUuy8cO66e009umeuw0OaE85pd5q4zTZ7KwWzEzoJNz33swTBZ2', '466.90', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '27.00', '20.00', '0.00', '0.00', '0.00', 0, 1, 1, NULL, NULL, '2022-05-07 15:09:58', '2022-05-07 15:09:58'),
(87, 'Mayur', '642108192662', 'mayurverma987@gmail.com', '$2y$10$2F66kbjBsYALifC85yEBj.tpVfov6se1zn.xVqdIRtXbimecq0DiO', '0.00', '0.00', '15.00', '15.00', '15.00', '15.00', '15.00', '15.00', '15.00', '25.00', '20.00', '0.00', '4.00', '15.00', 1, 0, 1, NULL, NULL, '2022-05-07 15:21:46', '2022-05-07 15:21:46'),
(89, 'Online8', '642102416175', 'info@online8.co.nz', '$2y$10$jahrlIlUehug5QZ2e0lZi.EKjFrjpTQG5c1xSdtR1uGxphntH5rAa', '4981.94', '0.00', '25.00', '25.00', '25.00', '25.00', '25.00', '25.00', '25.00', '20.00', '17.00', '0.00', '1.00', '15.00', 1, 0, 1, NULL, NULL, '2022-05-07 15:26:50', '2022-05-07 15:26:50'),
(90, 'HARVEY NORMAN Furniture (WESTGATE,AUCKLAND)', '64210328300', 'gagandeep.brar@nz.harveynorman.com', '$2y$10$kjdQ/Ug5UAhpjFkebQX.q.EBsnDPE2XyFxRNNhVO6HeF8sU4uce1u', '1347.22', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '25.00', '21.00', '0.00', '20.00', '0.00', 1, 0, 1, NULL, NULL, '2022-05-07 15:34:45', '2022-05-07 15:34:45'),
(91, 'Harvey Norman ( Pukekohe ) Auckland', '64211710909', 'rohan.singh@nz.harveynorman.com', '$2y$10$7RTKs/1ByYEBdMbaQpjAEOa.UDBMjBuhhveB3u6j4NaEDZcQ3U3wa', '683.65', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', 0, 1, 1, NULL, NULL, '2022-05-07 15:38:11', '2022-05-07 15:38:11'),
(92, 'I Furniture ( Auckland )', '640220666288', 'info@ifurniture.co.nz', '$2y$10$kV1.9hBv4idh11El.gkWGegSOQ2AfSw2aTjroJu/ODAmJseJPLu2W', '1494.45', '0.00', '2.00', '2.00', '2.00', '2.00', '2.00', '2.00', '2.00', '1.00', '1.00', '1.00', '0.00', '0.00', 1, 1, 1, NULL, NULL, '2022-05-07 15:45:30', '2022-05-07 15:45:30'),
(93, 'V Wood', '640211160360', 'kuljit@vwood.nz', '$2y$10$rnk0tE66GTHzR0OAEmpN4.BU6kiPs70ckyz5D5esL99x7X8T40OHe', '1096.50', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '26.00', '26.00', '26.00', '0.00', '0.00', 1, 0, 1, NULL, NULL, '2022-05-07 15:55:04', '2022-05-07 15:55:04'),
(94, 'Test from Adithya', '640272365587', 'andrew.moll@spectreum.co.nz', '$2y$10$RYYSByeSJt6MSNiMwnkleudMh94nkIena2aCHkVXKukyJM5OALdMy', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '35.00', '35.00', '35.00', '50.00', '50.00', 1, 0, 1, NULL, NULL, '2022-05-07 16:10:05', '2022-05-07 16:10:05'),
(95, 'Harvey Norman Bedding ( Westgate, Auckland )', '640212059401', 'sandy.khattra@nz.harveynorman.com', '$2y$10$v5YS0605uxNMbIdUAQ7uheJO7XQ6Q6TQlJ9puTOYwZFWpmDL6xeCu', '4814.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '25.00', '20.00', '0.00', '20.00', '20.00', 1, 1, 1, NULL, NULL, '2022-05-07 16:16:56', '2022-05-07 16:16:56'),
(99, 'newvendor', '641234567890', 'ab@ab.com', '$2y$10$2F66kbjBsYALifC85yEBj.tpVfov6se1zn.xVqdIRtXbimecq0DiO', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '25.00', '25.00', '25.00', '0.00', '0.00', 1, 0, 1, NULL, NULL, '2022-05-07 16:31:35', '2022-05-07 16:31:35'),
(101, 'anjana rana', '649090909090', 'anjanahps@gmail.com', '$2y$10$2F66kbjBsYALifC85yEBj.tpVfov6se1zn.xVqdIRtXbimecq0DiO', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '30.00', '30.00', '30.00', '15.00', '15.00', 1, 1, 1, NULL, NULL, '2022-05-07 16:38:33', '2022-05-07 16:38:33'),
(102, 'anjana hps', '641234123412', 'suraj@testing212.com', '$2y$10$2F66kbjBsYALifC85yEBj.tpVfov6se1zn.xVqdIRtXbimecq0DiO', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '35.00', '28.00', '0.00', '20.00', '20.00', 1, 1, 1, NULL, NULL, '2022-05-07 16:51:20', '2022-05-07 16:51:20'),
(103, 'demo test', '64123', 'sura1j@testing22.com', '$2y$10$2F66kbjBsYALifC85yEBj.tpVfov6se1zn.xVqdIRtXbimecq0DiO', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '40.00', '30.00', '0.00', '20.00', '20.00', 1, 1, 1, NULL, NULL, '2022-05-07 16:58:57', '2022-05-07 16:58:57'),
(104, 'testingb', '641234561212', 'ab@jan.com', '$2y$10$2F66kbjBsYALifC85yEBj.tpVfov6se1zn.xVqdIRtXbimecq0DiO', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '60.00', '30.00', '0.00', '0.00', '0.00', 1, 1, 1, NULL, NULL, '2022-05-07 17:02:41', '2022-05-07 17:02:41'),
(105, 'anjana', '641234512345', 'anjana12@gmail.com', '$2y$10$2F66kbjBsYALifC85yEBj.tpVfov6se1zn.xVqdIRtXbimecq0DiO', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '20.00', '18.00', '0.00', '20.00', '20.00', 1, 0, 1, NULL, NULL, '2022-05-26 13:13:09', '2022-05-26 13:13:09'),
(107, 'anjana', '641212123333', 'km1@demo.com', '$2y$10$2F66kbjBsYALifC85yEBj.tpVfov6se1zn.xVqdIRtXbimecq0DiO', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '20.00', '18.00', '0.00', '20.00', '20.00', 1, 0, 1, NULL, NULL, '2022-05-26 13:13:09', '2022-05-26 13:13:09'),
(110, 'a', '641234567777', 'a@o.com', '$2y$10$2F66kbjBsYALifC85yEBj.tpVfov6se1zn.xVqdIRtXbimecq0DiO', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '20.00', '18.00', '0.00', '20.00', '20.00', 1, 0, 1, NULL, NULL, '2022-05-26 13:13:09', '2022-05-26 13:13:09'),
(114, 'newtestvendor', '641111111111', 'aa@aq.com', '$2y$10$2F66kbjBsYALifC85yEBj.tpVfov6se1zn.xVqdIRtXbimecq0DiO', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '27.00', '20.00', '0.00', '0.00', '0.00', 0, 1, 1, NULL, NULL, '2022-05-07 15:09:58', '2022-05-07 15:09:58'),
(115, 'cubicvendor', '648585858585', 'test@testnew.com', '$2y$10$2F66kbjBsYALifC85yEBj.tpVfov6se1zn.xVqdIRtXbimecq0DiO', '0.00', '0.00', '15.00', '15.00', '15.00', '15.00', '15.00', '15.00', '15.00', '25.00', '20.00', '0.00', '4.00', '15.00', 1, 0, 1, NULL, NULL, '2022-05-07 15:21:46', '2022-05-07 15:21:46'),
(117, 'OSIM  New Zealand', '640212999177', 'yobi@osim.co.nz', '$2y$10$/dhA.RTBsNoG1ZyHAnlO2u9NTBLvop40DrZ.DbscHR4YxXEoQbCw6', '0.00', '0.00', '25.00', '25.00', '25.00', '25.00', '25.00', '25.00', '25.00', '20.00', '17.00', '0.00', '1.00', '15.00', 1, 0, 1, NULL, NULL, '2022-05-07 15:26:50', '2022-05-07 15:26:50'),
(118, 'LifeStyle Furniture, Hamilton', '6402108381664', 'hamilton@lifestylefurniture.co.nz', '$2y$10$DrtoKGexGry4EjFhrwVAouzhmdOiZALd5fyQlk8esOscUaaccrIHK', '1164.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '25.00', '21.00', '0.00', '20.00', '0.00', 1, 0, 1, NULL, NULL, '2022-05-07 15:34:45', '2022-05-07 15:34:45'),
(119, 'Harvey Norman Lincoln, Auckland', '640211689295', 'khush.Hundal@nz.harveynorman.com', '$2y$10$6Y6qv1SfY7lkK/uNwu53DemQmLs9EcoHs/XZEWkIwwP5Hvkw/yVWC', '1286.46', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', 0, 1, 1, NULL, NULL, '2022-05-07 15:38:11', '2022-05-07 15:38:11'),
(120, 'Budget Beds, Auckland', '640223242529', 'info@budgetbeds.co.nz', '$2y$10$leRoP9S3OBXepQhbn3JFNuZxuOaiiESEe6KWio1fkObzXUXokmJr.', '285.00', '0.00', '2.00', '2.00', '2.00', '2.00', '2.00', '2.00', '2.00', '1.00', '1.00', '1.00', '0.00', '0.00', 1, 1, 1, NULL, NULL, '2022-05-07 15:45:30', '2022-05-07 15:45:30'),
(121, 'Jory Henley Furniture, Auckland', '64092585092', 'logistic@joryhenley.co.nz', '$2y$10$bdmPXGz6Fke4uUXAWX6BGe411W803tMdJfcdlXf0vGl4RWO6G.LDG', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '26.00', '26.00', '26.00', '0.00', '0.00', 1, 0, 1, NULL, NULL, '2022-05-07 15:55:04', '2022-05-07 15:55:04'),
(122, 'Le Forge, Auckland', '646496223140', 'matt@leforge.co.nz', '$2y$10$gDg8e0vvr6TCvuoa/rpvuOYFGuqZ7gnjTzZFdVYwZnItTKKNt.6j2', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '35.00', '35.00', '35.00', '50.00', '50.00', 1, 0, 1, NULL, NULL, '2022-05-07 16:10:05', '2022-05-07 16:10:05'),
(123, 'Aspire Furniture, Tauranga', '640277373806', 'warehouse@aspirefurniture.co.nz', '$2y$10$lebb1lkVLQGd8sgYIJgQ6eQvzMyx/YSaqJe0ddJ29ue4hTBXzt7wC', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '25.00', '20.00', '0.00', '20.00', '20.00', 1, 1, 1, NULL, NULL, '2022-05-07 16:16:56', '2022-05-07 16:16:56'),
(124, 'Bed Stop Glenfield', '64094425025', 'glenfield@bedstop.co.nz', '$2y$10$/xk1tfUvGoGH7Ziuy8PcB.vy3pWBCQTvwgw/8xUsteSL2zWsBDmY.', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '25.00', '25.00', '25.00', '0.00', '0.00', 1, 0, 1, NULL, NULL, '2022-05-07 16:31:35', '2022-05-07 16:31:35'),
(125, 'Bed Stop Newmarket', '64094425025', 'newmarket@bedstop.co.nz', '$2y$10$/xk1tfUvGoGH7Ziuy8PcB.vy3pWBCQTvwgw/8xUsteSL2zWsBDmY.', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '30.00', '30.00', '30.00', '15.00', '15.00', 1, 1, 1, NULL, NULL, '2022-05-07 16:38:33', '2022-05-07 16:38:33'),
(126, 'Bed Stop Westgate', '64094425025', 'westgate@bedstop.co.nz', '$2y$10$/xk1tfUvGoGH7Ziuy8PcB.vy3pWBCQTvwgw/8xUsteSL2zWsBDmY.', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '35.00', '28.00', '0.00', '20.00', '20.00', 1, 1, 1, NULL, NULL, '2022-05-07 16:51:20', '2022-05-07 16:51:20');
