ALTER TABLE `t05_01aisvc_vetranges` CHANGE `vet_range` `vetrange_id` VARCHAR(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL;

\\192.168.1.120\www\html\mod\app\Http\Controllers\RegisterController.php

\\192.168.1.120\www\html\mod\app\Http\Controllers\Admin\AdminRegisterController.php

\\192.168.1.120\www\html\mod\app\Http\Controllers\Admin\ServiceEngagedController.php

\\192.168.1.120\www\html\mod\app\Http\Controllers\Admin\CattleBreedController.php

\\192.168.1.120\www\html\mod\app\Http\Controllers\Admin\EquipmentCategoryController.php

\\192.168.1.120\www\html\mod\app\Http\Controllers\Admin\FeedTypeController.php

\\192.168.1.120\www\html\mod\app\Http\Controllers\Admin\SemenTypeController.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_dtl_view.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\registerusers\reguser_details_view.blade.php

\\192.168.1.120\www\html\mod\resources\views\svcsengaged\svcs_engaged_form.blade.php

\\192.168.1.120\www\html\mod\resources\views\cattlebreed\cattlebreed_form.blade.php

\\192.168.1.120\www\html\mod\resources\views\equipmentcate\equipmentcate_form.blade.php

\\192.168.1.120\www\html\mod\resources\views\feedtype\feedtype_form.blade.php

\\192.168.1.120\www\html\mod\resources\views\sementype\sementype_form.blade.php



\\192.168.1.120\www\html\mod\app\Models\AiSvcVetranges.php

\\192.168.1.120\www\html\mod\app\Models\VSRanges.php

\\192.168.1.120\www\html\mod\app\Models\AISvc.php



-------------------------------------------------------
testing  2020-12-18
-------------------------------------------------------------------------------------
Approved Advertisement
-------------------------------------------------------------------------------------
SELECT * FROM `t00_00adverts_master` 
JOIN t10_00docapprovals ON t10_00docapprovals.ref_doc_no = t00_00adverts_master.advert_id 
WHERE t10_00docapprovals.ref_doc_type = 'ADVRT' 
AND t10_00docapprovals.approval_status = 'A'
AND `t00_00adverts_master`.expires_on > CURDATE()
AND `discontinued` = 0

--------------------------------------------------------------------------------------------
Pending  Advertisment
---------------------------------------------------------------------------------------------
SELECT * FROM `t00_00adverts_master` 
JOIN t10_00docapprovals ON t10_00docapprovals.ref_doc_no = t00_00adverts_master.advert_id 
WHERE t10_00docapprovals.ref_doc_type = 'ADVRT' 
AND t10_00docapprovals.approval_status = 'P'
AND `t00_00adverts_master`.expires_on > CURDATE()
AND `discontinued` = 0