function delete_temp_app_letter($usercd) { $sql = "delete from tmp_app_let where usercode='{$usercd}'"; $i = execInsert($sql); connection_close(); return $i; }
function save_Termination($ter_id, $PersonalID, $TerminationCause, $DateofTermination, $Remarks, $usercd) { $sql = "insert into termination (personal_id,termination_cause,termination_date,remarks,users_id) values ("; $sql .= "'{$PersonalID}','{$TerminationCause}','{$DateofTermination}','{$Remarks}','{$usercd}')"; $i = execInsert($sql); connection_close(); return $i; }
<?php date_default_timezone_set('Asia/Calcutta'); include_once 'inc/db_trans.inc.php'; $pc_cd = isset($_GET['pc_cd']) ? $_GET['pc_cd'] : ""; //$pc_cd='39'; $sql0 = "delete from second_appt where pccd='{$pc_cd}'"; $i = execDelete($sql0); $sql1 = "INSERT INTO second_appt( assembly, pccd, groupid ,mem_no) SELECT forassembly, forpc, groupid,count(*) FROM personnela WHERE booked = 'P' and forpc='{$pc_cd}' GROUP BY forassembly, groupid "; $i = execInsert($sql1); $sql2 = "UPDATE second_appt JOIN personnela ON second_appt.assembly=personnela.forassembly and second_appt.groupid=personnela.groupid\r\n SET second_appt.pr_personcd = personnela.personcd,second_appt.pr_name = personnela.officer_name,second_appt.`pr_designation` =personnela.off_desg,second_appt.`pr_officecd`= personnela.officecd,second_appt.`pr_status`='PR',second_appt.pr_post_stat='Presiding Officer'\r\nWHERE personnela.forpc = '{$pc_cd}' and personnela.booked = 'P' and personnela.poststat = 'PR' "; $i = execUpdate($sql2); $sql3 = "UPDATE second_appt JOIN personnela ON second_appt.assembly=personnela.forassembly and \r\nsecond_appt.groupid=personnela.groupid SET second_appt.p1_personcd = personnela.personcd,second_appt.p1_name = personnela.officer_name,second_appt.`p1_designation`=personnela.off_desg,second_appt.`p1_officecd`=personnela.officecd, second_appt.`p1_status`='P1',second_appt.p1_post_stat='1st Polling Officer' \r\nWHERE personnela.forpc = '{$pc_cd}' and personnela.booked = 'P' and personnela.poststat = 'P1'"; $i = execUpdate($sql3); $sql4 = "UPDATE second_appt JOIN personnela ON second_appt.assembly=personnela.forassembly and \r\nsecond_appt.groupid=personnela.groupid SET second_appt.p2_personcd = personnela.personcd,second_appt.p2_name = personnela.officer_name,second_appt.`p2_designation` \r\n=personnela.off_desg,second_appt.`p2_officecd`= personnela.officecd,second_appt.`p2_status`='P2',second_appt.p2_post_stat='2nd Polling Officer'\r\nWHERE personnela.forpc = '{$pc_cd}' and personnela.booked = 'P' and personnela.poststat = 'P2'"; $i = execUpdate($sql4); $sql5 = "UPDATE second_appt JOIN personnela ON second_appt.assembly=personnela.forassembly and \r\nsecond_appt.groupid=personnela.groupid SET second_appt.p3_personcd = personnela.personcd,second_appt.p3_name = personnela.officer_name,second_appt.`p3_designation` \r\n=personnela.off_desg,second_appt.`p3_officecd`= personnela.officecd,second_appt.`p3_status`='P3',second_appt.p3_post_stat='3rd Polling Officer'\r\nWHERE personnela.forpc = '{$pc_cd}' and personnela.booked = 'P' and personnela.poststat = 'P3'"; $i = execUpdate($sql5); $sql6 = "UPDATE second_appt JOIN personnela ON second_appt.assembly=personnela.forassembly and \r\nsecond_appt.groupid=personnela.groupid SET second_appt.pa_personcd = personnela.personcd,second_appt.pa_name = personnela.officer_name,second_appt.`pa_designation`=personnela.off_desg, second_appt.`pa_officecd`= personnela.officecd,second_appt.`pa_status`='PA', second_appt.pa_post_stat='Addl. 2nd Polling Officer-1' \r\nWHERE personnela.forpc = '{$pc_cd}' and personnela.booked = 'P' and personnela.poststat = 'PA'"; $i = execUpdate($sql6); $sql7 = "UPDATE second_appt JOIN personnela ON second_appt.assembly=personnela.forassembly and \r\nsecond_appt.groupid=personnela.groupid SET second_appt.pb_personcd = personnela.personcd,second_appt.pb_name = personnela.officer_name,second_appt.`pb_designation`=personnela.off_desg,second_appt.`pb_officecd`= personnela.officecd,second_appt.`pb_status`='PB',second_appt.pa_post_stat='Addl. 2nd Polling Officer-2' \r\nWHERE personnela.forpc = '{$pc_cd}' and personnela.booked = 'P' and personnela.poststat = 'PB'"; $i = execUpdate($sql7); $sql8 = "UPDATE second_appt JOIN office ON second_appt.pr_officecd = office.officecd SET second_appt.pr_officename = office.office,second_appt.`pr_officeaddress`= concat(office.address1,',',office.address2),second_appt.pr_postoffice=office.postoffice,second_appt.pr_pincode=office.pin, second_appt.pr_subdivision=office.subdivisioncd WHERE second_appt.pccd='{$pc_cd}' and second_appt.pr_status = 'PR'"; $i = execUpdate($sql8); $sql9 = "UPDATE second_appt JOIN office ON second_appt.p1_officecd = office.officecd SET second_appt.p1_officename = office.office,second_appt.`p1_officeaddress`= concat(office.address1,',',office.address2),second_appt.p1_postoffice=office.postoffice,second_appt.p1_pincode=office.pin ,second_appt.p1_subdivision=office.subdivisioncd WHERE second_appt.pccd='{$pc_cd}' and second_appt.p1_status = 'P1' "; $i = execUpdate($sql9); $sql10 = "UPDATE second_appt JOIN office ON second_appt.p2_officecd = office.officecd SET second_appt.p2_officename = office.office,second_appt.`p2_officeaddress`= concat(office.address1,',',office.address2),second_appt.p2_postoffice=office.postoffice,second_appt.p2_pincode=office.pin,second_appt.p2_subdivision=office.subdivisioncd WHERE second_appt.pccd='{$pc_cd}' and second_appt.p2_status = 'P2' "; $i = execUpdate($sql10); $sql11 = "UPDATE second_appt JOIN office ON second_appt.p3_officecd = office.officecd SET second_appt.p3_officename = office.office,second_appt.`p3_officeaddress`= concat(office.address1,',',office.address2),second_appt.p3_postoffice=office.postoffice,second_appt.p3_pincode=office.pin, second_appt.p3_subdivision=office.subdivisioncd WHERE second_appt.pccd='{$pc_cd}' and second_appt.p3_status = 'P3' "; $i = execUpdate($sql11); $sql12 = "UPDATE second_appt JOIN office ON second_appt.pa_officecd = office.officecd SET second_appt.pa_officename = office.office,second_appt.`pa_officeaddress`= concat(office.address1,',',office.address2),second_appt.pa_postoffice=office.postoffice,second_appt.pa_pincode=office.pin , second_appt.pa_subdivision=office.subdivisioncd WHERE second_appt.pccd='{$pc_cd}' and second_appt.pa_status = 'PA' ";
function save_training2_schedule($schedule_cd, $forpc, $assembly, $party_reserve, $start_sl, $end_sl, $training_venue, $training_dt, $training_time, $usercd) { $sql = "insert into second_training (schedule_cd,for_pc,assembly,party_reserve,start_sl,end_sl,training_venue,training_dt,training_time,\tusercode) values ('{$schedule_cd}','{$forpc}','{$assembly}','{$party_reserve}','{$start_sl}','{$end_sl}','{$training_venue}','{$training_dt}','{$training_time}','{$usercd}')"; $i = execInsert($sql); return $i; }
function save_po_ed($personnel, $pc, $ed_pb, $usercd) { $sql = "insert into po_ed (personcd, pccd, ed_pb, usercode) values ('{$personnel}','{$pc}','{$ed_pb}','{$usercd}')"; $i = execInsert($sql); return $i; }
function save_user_permission($user_cd, $menu_cd, $submenu_cd) { $sql = "insert into user_permission (user_cd,menu_cd,submenu_cd) values ('{$user_cd}','{$menu_cd}','{$submenu_cd}')"; $i = execInsert($sql); return $i; }
function save_dcrc_party($assembly, $member, $party_req, $dcrc_code, $subdivision, $pc, $dc_date, $dc_time, $usercd) { $sql = "insert into dcrc_party (dcrcgrp, assemblycd, number_of_member, partyindcrc, subdivisioncd, forpc, dc_date, dc_time, usercode) values ('{$dcrc_code}','{$assembly}','{$member}','{$party_req}','{$subdivision}','{$pc}','{$dc_date}','{$dc_time}','{$usercd}')"; $i = execInsert($sql); return $i; }
function save_training_schedule($schedule_code, $training_venue, $training_type, $training_dt, $training_time, $post_status, $no_pp, $usercode) { $sql = "insert into training_schedule (schedule_code,training_venue,training_type,training_dt,training_time,post_status, no_pp, usercode) values ('{$schedule_code}','{$training_venue}','{$training_type}','{$training_dt}','{$training_time}','{$post_status}', '{$no_pp}','{$usercode}')"; $i = execInsert($sql); return $i; }