28-08-2017 **insert amount shadure in inst master for 4 n 5th inst** INSERT INTO `installment_master` (`id`, `scheme_code`, `installment_no`, `installment_amount`, `interest_rate`, `from_date`, `to_date`) VALUES (NULL, '2', '4', '313700', '18', '2017-08-11', '2017-09-10'), (NULL, '2', '5', '3200', '18', '2017-09-11', '2017-10-10'); UPDATE `indi_installment_schedule` SET `to_date`=`from_date` WHERE installment_id= 4 and installment_no=4 UPDATE `indi_installment_schedule` SET `from_date`=`allotment_date` WHERE installment_id= 4 and installment_no=4 DELETE FROM `manual_inst_payment` WHERE `form_id`=0 //400000 AMOUNT UPDATE `payment_installment` SET `amount` = '8400', `authstatus` = 'MAN', `pay_id` = '2' WHERE `payment_installment`.`id` = 399; UPDATE `payment_installment` SET `bankid` = 'DEPOSITED 419900 RS AT ONCE BY RTGS' WHERE `payment_installment`.`id` = 399; UPDATE `payment_installment` SET `beankrefno` = '', `amount` = '8400', `bankid` = 'DEPOSITED 419900 RS AT ONCE BY RTGS', `authstatus` = 'MAN', `pay_id` = '3' WHERE `payment_installment`.`id` = 400; INSERT INTO `payment_installment` (`id`, `app_id`, `refno`, `beankrefno`, `amount`, `bankid`, `banmerchkid`, `trandate`, `authstatus`, `transtatus`, `icode`, `classcode`, `refund_status`, `pay_id`, `bdchallanno`) VALUES (NULL, '1412', 'ALLA 2017 060 9500 4845 205', '', '313700', 'DEPOSITED 419900 RS AT ONCE BY RTGS', '', '2017-06-09', 'MAN', 'Y', '', '', '', '4', ''), (NULL, '1412', 'ALLA 2017 060 9500 4845 205', '', '3200', 'DEPOSITED 419900 RS AT ONCE BY RTGS', '', '2017-06-09', 'MAN', 'Y', '', '', '', '5', ''); INSERT INTO `installment_detail` (`id`, `app_id`, `installment_id`, `interest`, `installment_pay_flag`) VALUES (NULL, '1412', '4', '0', '1'), (NULL, '1412', '5', '0', '1'); //19-09-2017 SELECT distinct(adhar),app_id,app_name1,FatherName,PhoneM,category,payment_flag,approve_flag FROM `applicant_form_detail` WHERE approve_flag ='A' group by adhar order by payment_flag, app_id UPDATE `survey_data` SET `adhar_old`=adhar //20-09-2017 SELECT `app_id`,`app_name1`,`FatherName`,`adhar`,`PhoneM`, COUNT(`adhar`) FROM applicant_form_detail GROUP BY `adhar` HAVING COUNT(`adhar`)>1 //last installment not paid SELECT * FROM `manual_inst_payment` where `installment_no`=5 and form_id not in (SELECT app_id FROM `payment_installment` where `pay_id`=4) //lottery_pm 26-09-2017 UPDATE `applicant_form_detail` SET `pati_patni` = '0', `aashrit` = '0', `tincome` = '172000', `d_name1` = 'Shubham', `category_1` = '5', `d_name2` = '', `category_2` = '', `d_name3` = '', `category_3` = '' WHERE `applicant_form_detail`.`app_id` = 349; UPDATE `applicant_form_detail` SET `date_death1`='1999-01-01', `date_death2`='1970-01-01', `date_death3`='1970-01-01' WHERE `adhar`= '518718644745' --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 10-05-2017 6th schedule updation INSERT INTO `installment_master` (`id`, `scheme_code`, `installment_no`, `installment_amount`, `interest_rate`, `from_date`, `to_date`) VALUES (NULL, '2', '6', '3200', '18', '2017-10-11', '2017-11-10'), (NULL, '2', '7', '3200', '18', '2017-11-11', '2017-12-10') INSERT INTO `installment_master` (`id`, `scheme_code`, `installment_no`, `installment_amount`, `interest_rate`) VALUES (NULL, '2', '6', '3200', '18'), (NULL, '2', '7', '3200', '18') lottery pm=-------------------------------------------------------------------------------------------------------------------------------- //reject double entry due to refresh (10 candidates) UPDATE `applicant_form_detail` SET `approve_flag`='R' where app_id in (2,203,204,209,213,892,996,1001,1131,1169) UPDATE `applicant_form_detail` SET `app_name1`='test',`FatherName`='test',`adhar`='000000000000',`PhoneM`='0000000000' ,`rejection_remark`='test entry' WHERE app_id in (2,203,204,209,213,892,996,1001,1131,1169) UPDATE `applicant_form_detail` SET `rejection_remark`='test entry - 1' WHERE `app_id`=2 UPDATE `applicant_form_detail` SET `rejection_remark`='test entry - 205' WHERE `app_id` in (203,204) UPDATE `applicant_form_detail` SET `rejection_remark`='test entry - 208' WHERE `app_id`=209 UPDATE `applicant_form_detail` SET `rejection_remark`='test entry - 214' WHERE `app_id`=213 UPDATE `applicant_form_detail` SET `rejection_remark`='test entry - 890' WHERE `app_id`=892 UPDATE `applicant_form_detail` SET `rejection_remark`='test entry - 997' WHERE `app_id`=996 UPDATE `applicant_form_detail` SET `rejection_remark`='test entry - 1000' WHERE `app_id`=1001 UPDATE `applicant_form_detail` SET `rejection_remark`='test entry - 1127' WHERE `app_id`=1131 UPDATE `applicant_form_detail` SET `rejection_remark`='test entry - 1169' WHERE `app_id`=1168 SELECT * FROM `applicant_form_detail` WHERE `category`=22 and approve_flag<>'R' and payment_flag <>0 //0 UPDATE `applicant_form_detail` SET `payment_flag`=1 where category=22 and approve_flag<>'R' //1822 UPDATE `applicant_form_detail` SET category=2 where approve_flag<>'R' and category=22 and payment_flag=1 //1822 UPDATE `applicant_form_detail` SET `category` = '2' WHERE `applicant_form_detail`.`app_id` = 911; UPDATE `applicant_form_detail` SET `category` = '6' WHERE `applicant_form_detail`.`app_id` = 2273; UPDATE `applicant_form_detail` SET `category` = '5' WHERE `applicant_form_detail`.`app_id` = 3341; UPDATE `applicant_form_detail` SET `category` = '5' WHERE `applicant_form_detail`.`app_id` = 3346; 13-11-2017--------------------------------------------------------------- UPDATE `applicant_form_detail_extra` SET `caste` = '2' WHERE `applicant_form_detail_extra`.`app_id` = 911; //22-11-2017 satori magri 8th installment schedule-------------------------------------------------------------------------------------------- INSERT INTO `installment_master` (`id`, `scheme_code`, `installment_no`, `installment_amount`, `interest_rate`, `from_date`, `to_date`) VALUES (8, 2, '8', '3200', '18', '0000-00-00', '0000-00-00') INSERT INTO `installment_master` (`id`, `scheme_code`, `installment_no`, `installment_amount`, `interest_rate`, `from_date`, `to_date`) VALUES (9, 2, '9', '3200', '18', '0000-00-00', '0000-00-00') INSERT INTO `installment_master` (`id`, `scheme_code`, `installment_no`, `installment_amount`, `interest_rate`, `from_date`, `to_date`) VALUES (10, 2, '10', '3200', '18', '0000-00-00', '0000-00-00') INSERT INTO `installment_master` (`id`, `scheme_code`, `installment_no`, `installment_amount`, `interest_rate`, `from_date`, `to_date`) VALUES (11, 2, '11', '3200', '18', '0000-00-00', '0000-00-00') INSERT INTO `installment_master` (`id`, `scheme_code`, `installment_no`, `installment_amount`, `interest_rate`, `from_date`, `to_date`) VALUES (12, 2, '12', '3200', '18', '0000-00-00', '0000-00-00') INSERT INTO `installment_master` (`id`, `scheme_code`, `installment_no`, `installment_amount`, `interest_rate`, `from_date`, `to_date`) VALUES (13, 2, '13', '3200', '18', '0000-00-00', '0000-00-00') INSERT INTO `installment_master` (`id`, `scheme_code`, `installment_no`, `installment_amount`, `interest_rate`, `from_date`, `to_date`) VALUES (14, 2, '14', '3200', '18', '0000-00-00', '0000-00-00') INSERT INTO `installment_master` (`id`, `scheme_code`, `installment_no`, `installment_amount`, `interest_rate`, `from_date`, `to_date`) VALUES (15, 2, '15', '3200', '18', '0000-00-00', '0000-00-00') INSERT INTO `installment_master` (`id`, `scheme_code`, `installment_no`, `installment_amount`, `interest_rate`, `from_date`, `to_date`) VALUES (16, 2, '16', '3200', '18', '0000-00-00', '0000-00-00') INSERT INTO `installment_master` (`id`, `scheme_code`, `installment_no`, `installment_amount`, `interest_rate`, `from_date`, `to_date`) VALUES (17, 2, '17', '3200', '18', '0000-00-00', '0000-00-00') INSERT INTO `installment_master` (`id`, `scheme_code`, `installment_no`, `installment_amount`, `interest_rate`, `from_date`, `to_date`) VALUES (18, 2, '18', '3200', '18', '0000-00-00', '0000-00-00') INSERT INTO `installment_master` (`id`, `scheme_code`, `installment_no`, `installment_amount`, `interest_rate`, `from_date`, `to_date`) VALUES (19, 2, '19', '3200', '18', '0000-00-00', '0000-00-00') INSERT INTO `installment_master` (`id`, `scheme_code`, `installment_no`, `installment_amount`, `interest_rate`, `from_date`, `to_date`) VALUES (20, 2, '20', '3200', '18', '0000-00-00', '0000-00-00') INSERT INTO `installment_master` (`id`, `scheme_code`, `installment_no`, `installment_amount`, `interest_rate`, `from_date`, `to_date`) VALUES (21, 2, '21', '3200', '18', '0000-00-00', '0000-00-00') INSERT INTO `installment_master` (`id`, `scheme_code`, `installment_no`, `installment_amount`, `interest_rate`, `from_date`, `to_date`) VALUES (22, 2, '22', '3200', '18', '0000-00-00', '0000-00-00') INSERT INTO `installment_master` (`id`, `scheme_code`, `installment_no`, `installment_amount`, `interest_rate`, `from_date`, `to_date`) VALUES (23, 2, '23', '3200', '18', '0000-00-00', '0000-00-00') INSERT INTO `installment_master` (`id`, `scheme_code`, `installment_no`, `installment_amount`, `interest_rate`, `from_date`, `to_date`) VALUES (24, 2, '24', '3200', '18', '0000-00-00', '0000-00-00') INSERT INTO `installment_master` (`id`, `scheme_code`, `installment_no`, `installment_amount`, `interest_rate`, `from_date`, `to_date`) VALUES (25, 2, '25', '3200', '18', '0000-00-00', '0000-00-00') INSERT INTO `installment_master` (`id`, `scheme_code`, `installment_no`, `installment_amount`, `interest_rate`, `from_date`, `to_date`) VALUES (26, 2, '26', '3200', '18', '0000-00-00', '0000-00-00') INSERT INTO `installment_master` (`id`, `scheme_code`, `installment_no`, `installment_amount`, `interest_rate`, `from_date`, `to_date`) VALUES (27, 2, '27', '3200', '18', '0000-00-00', '0000-00-00') INSERT INTO `installment_master` (`id`, `scheme_code`, `installment_no`, `installment_amount`, `interest_rate`, `from_date`, `to_date`) VALUES (28, 2, '28', '3200', '18', '0000-00-00', '0000-00-00') // rejected applicants UPDATE `applicant_form_detail` SET `approve_flag`='R',`rejection_remark`='Rejected due to not paid three installments regularly' WHERE `app_id` in (4338,1124,1119,4034, 2066, 3325, 3746, 4288, 3880)