\\192.168.1.120\www\html\mod\app\Models\CattleSales.php
\\192.168.1.120\www\html\mod\app\Models\CattlePurchasing.php
\\192.168.1.120\www\html\mod\app\Models\SileageSales.php
\\192.168.1.120\www\html\mod\app\Models\SileagePurchasing.php
\\192.168.1.120\www\html\mod\app\Models\FodderSales.php
\\192.168.1.120\www\html\mod\app\Models\FodderPurchasing.php
\\192.168.1.120\www\html\mod\app\Models\EquipmentSales.php
\\192.168.1.120\www\html\mod\app\Models\EquipmentPurchasing.php
\\192.168.1.120\www\html\mod\app\Models\AdvertMaster.php
\\192.168.1.120\www\html\mod\app\Models\AITechBookings.php

\\192.168.1.120\www\html\mod\app\Http\Requests\AdvertSilFoddSaleRequest.php
\\192.168.1.120\www\html\mod\app\Http\Requests\AdvertSilFoddPurchRequest.php
\\192.168.1.120\www\html\mod\app\Http\Requests\AdvertEquipRequest.php
\\192.168.1.120\www\html\mod\app\Http\Requests\AdvertCattleRequest.php
\\192.168.1.120\www\html\mod\app\Http\Requests\AIBookingRequest.php
\\192.168.1.120\www\html\mod\app\Http\Requests\AIFeedbackRequest.php
\\192.168.1.120\www\html\mod\app\Http\Requests\PDCheckRequest.php

\\192.168.1.120\www\html\mod\app\Http\Controllers\AdvertisementsController.php
\\192.168.1.120\www\html\mod\app\Http\Controllers\HomeController.php
\\192.168.1.120\www\html\mod\app\Http\Controllers\Admin\DocApprovalsController.php
\\192.168.1.120\www\html\mod\app\Http\Controllers\AIFeedbackController.php
\\192.168.1.120\www\html\mod\app\Http\Controllers\AIBookingController.php
\\192.168.1.120\www\html\mod\app\Http\Controllers\PDCheckController.php


\\192.168.1.120\www\html\mod\resources\views\layouts\app.blade.php
\\192.168.1.120\www\html\mod\resources\views\advertmaster\advert_master_search.blade.php
\\192.168.1.120\www\html\mod\resources\views\home.blade.php
\\192.168.1.120\www\html\mod\resources\views\advertmaster\advert_dtl_view.blade.php

\\192.168.1.120\www\html\mod\resources\views\layouts\components\cattleDtlView.blade.php
\\192.168.1.120\www\html\mod\resources\views\layouts\components\equDtlView.blade.php
\\192.168.1.120\www\html\mod\resources\views\layouts\components\feedDtlView.blade.php

\\192.168.1.120\www\html\mod\resources\lang\en\messages.php
\\192.168.1.120\www\html\mod\resources\lang\en\validation.php

\\192.168.1.120\www\html\mod\app\Providers\AppServiceProvider.php

Create t12_00images


ALTER TABLE `t00_00adverts_master` ADD `title` VARCHAR(200) NOT NULL AFTER `discontinued`;

UPDATE `t00_00adverts_master` SET `title`= (`advert_id`) WHERE `title` = '';

INSERT INTO `s01_fxdval` (`rowno`, `val_id`, `val_des_en`, `val_des_si`, `val_des_ta`, `val_type`, `val_ord`) VALUES (NULL, 'DRY', 'Dry', 'Dry_si', 'Dry_ta', 'PARENTING_STATUS', '3');

INSERT INTO `s01_fxdval` (`rowno`, `val_id`, `val_des_en`, `val_des_si`, `val_des_ta`, `val_type`, `val_ord`) VALUES (NULL, 'HEF', 'Heifer', 'Heifer_si', 'Heifer_ta', 'PARENTING_STATUS', '4');

INSERT INTO `s01_fxdval` (`rowno`, `val_id`, `val_des_en`, `val_des_si`, `val_des_ta`, `val_type`, `val_ord`) VALUES (NULL, 'CALF', 'Calf', 'Calf_si', 'Calf_ta', 'PARENTING_STATUS', '5');

UPDATE `s01_01svcs_engaged` SET `engd_svc_en` = 'Fodder Cultivator' WHERE `s01_01svcs_engaged`.`type_code` = 'FODDER';

UPDATE `s01_01svcs_engaged` SET `engd_svc_en` = 'Silage Enterpriser' WHERE `s01_01svcs_engaged`.`type_code` = 'SILAGE';

UPDATE `s01_00prodsvcs` SET `product_name_en` = 'AI Service', `product_name_si` = 'AI Service_SI', `product_name_ta` = 'AI Service_TA', `created_at` = NULL, `updated_at` = NULL WHERE `s01_00prodsvcs`.`prodsvc_id` = 'SERV_AI';

ALTER TABLE `t05_02aitech_bookings` ADD `tentative_delday` DATE NOT NULL AFTER `pd_comments`;

ALTER TABLE `t01_02cattle_salebreeds` ADD `available_bal` INT NOT NULL AFTER `sold_status`;

ALTER TABLE `t03_02silage_salefeed` ADD `price_per_kg` DECIMAL(10,2) NOT NULL AFTER `packaging`;

ALTER TABLE `t03_02silage_salefeed` CHANGE `price_per_kg` `price_per_kg` DECIMAL(10,2) NOT NULL DEFAULT '0.00';

ALTER TABLE `t03_02silage_salefeed` ADD `available_bal` DECIMAL(10,3) NOT NULL AFTER `sold_status`;

ALTER TABLE `t06_02equip_sale_categories` ADD `brand_name` VARCHAR(50) NOT NULL AFTER `equip_price`;

ALTER TABLE `m01_04user_cattle` CHANGE `monthly_yield` `monthly_yield` DECIMAL(10,2) NOT NULL COMMENT 'daily yield value';

ALTER TABLE `t01_02cattle_salebreeds` DROP `image_path`;

ALTER TABLE `t04_02fodder_salefeed` DROP `image_path`;

ALTER TABLE `t04_02fodder_salefeed` ADD `dist_id` VARCHAR(10) NOT NULL AFTER `comments`, ADD `ds_div_id` VARCHAR(10) NOT NULL AFTER `dist_id`, ADD `avail_bal` INT NOT NULL AFTER `ds_div_id`, ADD `expected_date` DATE NOT NULL AFTER `avail_bal`, ADD `harvested_date` DATE NOT NULL AFTER `expected_date`, ADD `price_perkg` DECIMAL(10,2) NOT NULL AFTER `harvested_date`, ADD `havested` CHAR(1) NOT NULL AFTER `price_perkg`, ADD `chopped` CHAR(1) NOT NULL AFTER `havested`, ADD `loaded` CHAR(1) NOT NULL AFTER `chopped`, ADD `transported` CHAR(1) NOT NULL AFTER `loaded`;

INSERT INTO `u03_00_uri_list` (`uri_id`, `uri`, `uri_des`, `uri_name`, `url_method`, `method`, `class_id`, `allow_mob_access`, `allow_web_access`, `is_active`, `created_at`, `updated_at`) VALUES ('URI00047', 'fodd_sale_adsave', '', 'fodd_sale_advert_create', 'POST', 'createFoddSaleAd', 'ADFEEDSALE', '1', '0', '1', NULL, NULL);

INSERT INTO `u02_01_user_role_uri` (`role_id`, `uri_id`, `created_at`, `updated_at`) VALUES ('USER', 'URI00047', '2020-03-03 11:35:00', NULL);

ALTER TABLE `t04_02fodder_salefeed` CHANGE `avail_bal` `avail_bal` DECIMAL(10,3) NOT NULL;

INSERT INTO `u03_00_uri_list` (`uri_id`, `uri`, `uri_des`, `uri_name`, `url_method`, `method`, `class_id`, `allow_mob_access`, `allow_web_access`, `is_active`, `created_at`, `updated_at`) VALUES ('URI00048', 'update_foddsale', '', 'update_foddsale', 'PUT', 'updateFodderSaleAd', 'ADFEEDSALE', '1', '0', '1', NULL, NULL);

INSERT INTO `u02_01_user_role_uri` (`role_id`, `uri_id`, `created_at`, `updated_at`) VALUES ('USER', 'URI00048', '2020-03-03 16:10:00', NULL);

UPDATE `u03_00_uri_list` SET `uri` = 'update_catlbreed/{renew?}', `uri_name` = 'update_cattle_breed', `created_at` = NULL, `updated_at` = NULL WHERE `u03_00_uri_list`.`uri_id` = 'URI00010';

ALTER TABLE `t06_02equip_sale_categories` DROP `image_path`;

ALTER TABLE `t06_02equip_sale_categories` ADD `avail_bal` INT NOT NULL AFTER `equip_comments`;

INSERT INTO `u03_00_uri_list` (`uri_id`, `uri`, `uri_des`, `uri_name`, `url_method`, `method`, `class_id`, `allow_mob_access`, `allow_web_access`, `is_active`, `created_at`, `updated_at`) VALUES ('URI00049', 'update_apprvfeed_sellad', '', 'update_apprvfeed_sellad', 'PUT', 'updateApprovedFeedSellAd', 'ADFEEDSALE', '1', '0', '1', NULL, NULL);

UPDATE `u03_00_uri_list` SET `uri` = 'update_aprvsilage_saleadv', `uri_name` = 'update_aprvsilage_saleadv', `method` = 'updateApprovedSilageSaleAdv', `created_at` = NULL, `updated_at` = NULL WHERE `u03_00_uri_list`.`uri_id` = 'URI00049';

INSERT INTO `u02_01_user_role_uri` (`role_id`, `uri_id`, `created_at`, `updated_at`) VALUES ('USER', 'URI00049', '2020-03-05 13:10:00', NULL);

UPDATE `u03_00_uri_list` SET `uri` = 'update_foddsale/{renew?}' WHERE `u03_00_uri_list`.`uri_id` = 'URI00048';