function delete_prev_data_second_rand_reserve($personcd, $new_p_id) { $sql = "delete from second_rand_table_reserve where personcd='{$personcd}' or personcd='{$new_p_id}'"; $i = execDelete($sql); //print $sql; exit; connection_close(); return $i; }
function delete_Termination($delcode) { $sql = "delete from termination where termination_id='{$delcode}'"; $i = execDelete($sql); connection_close(); return $i; }
<?php date_default_timezone_set('Asia/Calcutta'); include_once 'inc/db_trans.inc.php'; $sql = "delete from second_appt where per_poststat<>'PR'"; $i = execDelete($sql); $sql29 = "insert into second_appt (`pers_off`,per_poststat,`groupid`,`assembly`,`assembly_name`,`mem_no`,`pccd`,`pcname`,`pr_personcd`,`p1_personcd`,`p2_personcd`,`p3_personcd`, `pa_personcd`,`pb_personcd`,`pr_name`,`p1_name`,`p2_name`,`p3_name`,`pa_name`,`pb_name`,`pr_designation`,`p1_designation`,`p2_designation`,`p3_designation`,`pa_designation`,`pb_designation`,`pr_status`,`p1_status`,`p2_status`,`p3_status`,`pa_status`,`pb_status`,pr_post_stat,p1_post_stat,p2_post_stat,p3_post_stat,pa_post_stat,pb_post_stat, `pr_officecd`,`p1_officecd`,`p2_officecd`,`p3_officecd`,`pa_officecd`,`pb_officecd`,`pr_officename`,`p1_officename`,`p2_officename`, `p3_officename`,`pa_officename`,`pb_officename`,`pr_officeaddress`,`p1_officeaddress`,`p2_officeaddress`,`p3_officeaddress`, `pa_officeaddress`,`pb_officeaddress`,`pr_postoffice`,`p1_postoffice`,`p2_postoffice`,`p3_postoffice`,`pa_postoffice`, `pb_postoffice`,`pr_subdivision`,`p1_subdivision`,`p2_subdivision`,`p3_subdivision`,`pa_subdivision`,`pb_subdivision`, `pr_policestn`,`p1_policestn`,`p2_policestn`,p3_policestn,`pa_policestn`,`pb_policestn`,`district`,`pr_pincode`,`p1_pincode`, `p2_pincode`,`p3_pincode`,`pa_pincode`,`pb_pincode`,`dcrcgrp`,`dc_venue`,`dc_address`,`dc_date`,dc_time,`rc_venue`,`traingcode`, `training_venue`,`venuecode`,`venue_addr1`,`venue_addr2`,`training_date`,`training_time`,polldate,polltime) \r\nselect distinct p1_officecd,p1_status,`groupid`,`assembly`,`assembly_name`,`mem_no`,`pccd`,`pcname`,`pr_personcd`,`p1_personcd`,`p2_personcd`,\r\n`p3_personcd`, `pa_personcd`,`pb_personcd`,`pr_name`,`p1_name`,`p2_name`,`p3_name`,`pa_name`,`pb_name`,`pr_designation`,`p1_designation`,\r\n`p2_designation`,`p3_designation`,`pa_designation`,`pb_designation`,`pr_status`,`p1_status`,`p2_status`,`p3_status`,`pa_status`,`pb_status`, pr_post_stat,p1_post_stat,p2_post_stat,p3_post_stat,pa_post_stat,pb_post_stat, `pr_officecd`,`p1_officecd`,`p2_officecd`,`p3_officecd`,`pa_officecd`,`pb_officecd`,`pr_officename`,`p1_officename`,`p2_officename`, `p3_officename`,`pa_officename`,`pb_officename`,`pr_officeaddress`,`p1_officeaddress`,`p2_officeaddress`,`p3_officeaddress`, `pa_officeaddress`,`pb_officeaddress`,`pr_postoffice`,`p1_postoffice`,`p2_postoffice`,`p3_postoffice`,`pa_postoffice`, `pb_postoffice`,`pr_subdivision`,`p1_subdivision`,`p2_subdivision`,`p3_subdivision`,`pa_subdivision`,`pb_subdivision`, `pr_policestn`,`p1_policestn`,`p2_policestn`,p3_policestn,`pa_policestn`,`pb_policestn`,`district`,`pr_pincode`,`p1_pincode`, `p2_pincode`,`p3_pincode`,`pa_pincode`,`pb_pincode`,`dcrcgrp`,`dc_venue`,`dc_address`,`dc_date`,dc_time,`rc_venue`,`traingcode`, `training_venue`,`venuecode`,`venue_addr1`,`venue_addr2`,`training_date`,`training_time`,polldate,polltime\r\nfrom second_appt"; $i = execUpdate($sql29); $sql30 = "insert into second_appt (`pers_off`,per_poststat,`groupid`,`assembly`,`assembly_name`,`mem_no`,`pccd`,`pcname`,`pr_personcd`,`p1_personcd`,`p2_personcd`,`p3_personcd`, `pa_personcd`,`pb_personcd`,`pr_name`,`p1_name`,`p2_name`,`p3_name`,`pa_name`,`pb_name`,`pr_designation`,`p1_designation`,`p2_designation`,`p3_designation`,`pa_designation`,`pb_designation`,`pr_status`,`p1_status`,`p2_status`,`p3_status`,`pa_status`,`pb_status`, pr_post_stat,p1_post_stat,p2_post_stat,p3_post_stat,pa_post_stat,pb_post_stat, `pr_officecd`,`p1_officecd`,`p2_officecd`,`p3_officecd`,`pa_officecd`,`pb_officecd`,`pr_officename`,`p1_officename`,`p2_officename`, `p3_officename`,`pa_officename`,`pb_officename`,`pr_officeaddress`,`p1_officeaddress`,`p2_officeaddress`,`p3_officeaddress`, `pa_officeaddress`,`pb_officeaddress`,`pr_postoffice`,`p1_postoffice`,`p2_postoffice`,`p3_postoffice`,`pa_postoffice`, `pb_postoffice`,`pr_subdivision`,`p1_subdivision`,`p2_subdivision`,`p3_subdivision`,`pa_subdivision`,`pb_subdivision`, `pr_policestn`,`p1_policestn`,`p2_policestn`,p3_policestn,`pa_policestn`,`pb_policestn`,`district`,`pr_pincode`,`p1_pincode`, `p2_pincode`,`p3_pincode`,`pa_pincode`,`pb_pincode`,`dcrcgrp`,`dc_venue`,`dc_address`,`dc_date`,dc_time,`rc_venue`,`traingcode`, `training_venue`,`venuecode`,`venue_addr1`,`venue_addr2`,`training_date`,`training_time`,polldate,polltime) \r\nselect distinct p2_officecd,p2_status,`groupid`,`assembly`,`assembly_name`,`mem_no`,`pccd`,`pcname`,`pr_personcd`,`p1_personcd`,`p2_personcd`,\r\n`p3_personcd`, `pa_personcd`,`pb_personcd`,`pr_name`,`p1_name`,`p2_name`,`p3_name`,`pa_name`,`pb_name`,`pr_designation`,`p1_designation`,\r\n`p2_designation`,`p3_designation`,`pa_designation`,`pb_designation`,`pr_status`,`p1_status`,`p2_status`,`p3_status`,`pa_status`,`pb_status`, pr_post_stat,p1_post_stat,p2_post_stat,p3_post_stat,pa_post_stat,pb_post_stat, `pr_officecd`,`p1_officecd`,`p2_officecd`,`p3_officecd`,`pa_officecd`,`pb_officecd`,`pr_officename`,`p1_officename`,`p2_officename`, `p3_officename`,`pa_officename`,`pb_officename`,`pr_officeaddress`,`p1_officeaddress`,`p2_officeaddress`,`p3_officeaddress`, `pa_officeaddress`,`pb_officeaddress`,`pr_postoffice`,`p1_postoffice`,`p2_postoffice`,`p3_postoffice`,`pa_postoffice`, `pb_postoffice`,`pr_subdivision`,`p1_subdivision`,`p2_subdivision`,`p3_subdivision`,`pa_subdivision`,`pb_subdivision`, `pr_policestn`,`p1_policestn`,`p2_policestn`,p3_policestn,`pa_policestn`,`pb_policestn`,`district`,`pr_pincode`,`p1_pincode`, `p2_pincode`,`p3_pincode`,`pa_pincode`,`pb_pincode`,`dcrcgrp`,`dc_venue`,`dc_address`,`dc_date`,dc_time,`rc_venue`,`traingcode`, `training_venue`,`venuecode`,`venue_addr1`,`venue_addr2`,`training_date`,`training_time` ,polldate,polltime\r\nfrom second_appt"; $i = execUpdate($sql30); $sql31 = "insert into second_appt (`pers_off`,per_poststat,`groupid`,`assembly`,`assembly_name`,`mem_no`,`pccd`,`pcname`,`pr_personcd`,`p1_personcd`,`p2_personcd`,`p3_personcd`, `pa_personcd`,`pb_personcd`,`pr_name`,`p1_name`,`p2_name`,`p3_name`,`pa_name`,`pb_name`,`pr_designation`,`p1_designation`,`p2_designation`,`p3_designation`,`pa_designation`,`pb_designation`,`pr_status`,`p1_status`,`p2_status`,`p3_status`,`pa_status`,`pb_status`, pr_post_stat,p1_post_stat,p2_post_stat,p3_post_stat,pa_post_stat,pb_post_stat, `pr_officecd`,`p1_officecd`,`p2_officecd`,`p3_officecd`,`pa_officecd`,`pb_officecd`,`pr_officename`,`p1_officename`,`p2_officename`, `p3_officename`,`pa_officename`,`pb_officename`,`pr_officeaddress`,`p1_officeaddress`,`p2_officeaddress`,`p3_officeaddress`, `pa_officeaddress`,`pb_officeaddress`,`pr_postoffice`,`p1_postoffice`,`p2_postoffice`,`p3_postoffice`,`pa_postoffice`, `pb_postoffice`,`pr_subdivision`,`p1_subdivision`,`p2_subdivision`,`p3_subdivision`,`pa_subdivision`,`pb_subdivision`, `pr_policestn`,`p1_policestn`,`p2_policestn`,p3_policestn,`pa_policestn`,`pb_policestn`,`district`,`pr_pincode`,`p1_pincode`, `p2_pincode`,`p3_pincode`,`pa_pincode`,`pb_pincode`,`dcrcgrp`,`dc_venue`,`dc_address`,`dc_date`,dc_time,`rc_venue`,`traingcode`, `training_venue`,`venuecode`,`venue_addr1`,`venue_addr2`,`training_date`,`training_time`,polldate,polltime) \r\nselect distinct p3_officecd,p3_status,`groupid`,`assembly`,`assembly_name`,`mem_no`,`pccd`,`pcname`,`pr_personcd`,`p1_personcd`,`p2_personcd`,\r\n`p3_personcd`, `pa_personcd`,`pb_personcd`,`pr_name`,`p1_name`,`p2_name`,`p3_name`,`pa_name`,`pb_name`,`pr_designation`,`p1_designation`,\r\n`p2_designation`,`p3_designation`,`pa_designation`,`pb_designation`,`pr_status`,`p1_status`,`p2_status`,`p3_status`,`pa_status`,`pb_status`, pr_post_stat,p1_post_stat,p2_post_stat,p3_post_stat,pa_post_stat,pb_post_stat, `pr_officecd`,`p1_officecd`,`p2_officecd`,`p3_officecd`,`pa_officecd`,`pb_officecd`,`pr_officename`,`p1_officename`,`p2_officename`, `p3_officename`,`pa_officename`,`pb_officename`,`pr_officeaddress`,`p1_officeaddress`,`p2_officeaddress`,`p3_officeaddress`, `pa_officeaddress`,`pb_officeaddress`,`pr_postoffice`,`p1_postoffice`,`p2_postoffice`,`p3_postoffice`,`pa_postoffice`, `pb_postoffice`,`pr_subdivision`,`p1_subdivision`,`p2_subdivision`,`p3_subdivision`,`pa_subdivision`,`pb_subdivision`, `pr_policestn`,`p1_policestn`,`p2_policestn`,p3_policestn,`pa_policestn`,`pb_policestn`,`district`,`pr_pincode`,`p1_pincode`, `p2_pincode`,`p3_pincode`,`pa_pincode`,`pb_pincode`,`dcrcgrp`,`dc_venue`,`dc_address`,`dc_date`,dc_time,`rc_venue`,`traingcode`, `training_venue`,`venuecode`,`venue_addr1`,`venue_addr2`,`training_date`,`training_time`,polldate,polltime\r\nfrom second_appt "; $i = execUpdate($sql31); $sql32 = "insert into second_appt (`pers_off`,per_poststat,`groupid`,`assembly`,`assembly_name`,`mem_no`,`pccd`,`pcname`,`pr_personcd`,`p1_personcd`,`p2_personcd`,`p3_personcd`, `pa_personcd`,`pb_personcd`,`pr_name`,`p1_name`,`p2_name`,`p3_name`,`pa_name`,`pb_name`,`pr_designation`,`p1_designation`,`p2_designation`,`p3_designation`,`pa_designation`,`pb_designation`,`pr_status`,`p1_status`,`p2_status`,`p3_status`,`pa_status`,`pb_status`, pr_post_stat,p1_post_stat,p2_post_stat,p3_post_stat,pa_post_stat,pb_post_stat, `pr_officecd`,`p1_officecd`,`p2_officecd`,`p3_officecd`,`pa_officecd`,`pb_officecd`,`pr_officename`,`p1_officename`,`p2_officename`, `p3_officename`,`pa_officename`,`pb_officename`,`pr_officeaddress`,`p1_officeaddress`,`p2_officeaddress`,`p3_officeaddress`, `pa_officeaddress`,`pb_officeaddress`,`pr_postoffice`,`p1_postoffice`,`p2_postoffice`,`p3_postoffice`,`pa_postoffice`, `pb_postoffice`,`pr_subdivision`,`p1_subdivision`,`p2_subdivision`,`p3_subdivision`,`pa_subdivision`,`pb_subdivision`, `pr_policestn`,`p1_policestn`,`p2_policestn`,p3_policestn,`pa_policestn`,`pb_policestn`,`district`,`pr_pincode`,`p1_pincode`, `p2_pincode`,`p3_pincode`,`pa_pincode`,`pb_pincode`,`dcrcgrp`,`dc_venue`,`dc_address`,`dc_date`,dc_time,`rc_venue`,`traingcode`, `training_venue`,`venuecode`,`venue_addr1`,`venue_addr2`,`training_date`,`training_time`,polldate,polltime) \r\nselect distinct pa_officecd,pa_status,`groupid`,`assembly`,`assembly_name`,`mem_no`,`pccd`,`pcname`,`pr_personcd`,`p1_personcd`,`p2_personcd`,\r\n`p3_personcd`, `pa_personcd`,`pb_personcd`,`pr_name`,`p1_name`,`p2_name`,`p3_name`,`pa_name`,`pb_name`,`pr_designation`,`p1_designation`,\r\n`p2_designation`,`p3_designation`,`pa_designation`,`pb_designation`,`pr_status`,`p1_status`,`p2_status`,`p3_status`,`pa_status`,`pb_status`, pr_post_stat,p1_post_stat,p2_post_stat,p3_post_stat,pa_post_stat,pb_post_stat, `pr_officecd`,`p1_officecd`,`p2_officecd`,`p3_officecd`,`pa_officecd`,`pb_officecd`,`pr_officename`,`p1_officename`,`p2_officename`, `p3_officename`,`pa_officename`,`pb_officename`,`pr_officeaddress`,`p1_officeaddress`,`p2_officeaddress`,`p3_officeaddress`, `pa_officeaddress`,`pb_officeaddress`,`pr_postoffice`,`p1_postoffice`,`p2_postoffice`,`p3_postoffice`,`pa_postoffice`, `pb_postoffice`,`pr_subdivision`,`p1_subdivision`,`p2_subdivision`,`p3_subdivision`,`pa_subdivision`,`pb_subdivision`, `pr_policestn`,`p1_policestn`,`p2_policestn`,p3_policestn,`pa_policestn`,`pb_policestn`,`district`,`pr_pincode`,`p1_pincode`, `p2_pincode`,`p3_pincode`,`pa_pincode`,`pb_pincode`,`dcrcgrp`,`dc_venue`,`dc_address`,`dc_date`,dc_time,`rc_venue`,`traingcode`, `training_venue`,`venuecode`,`venue_addr1`,`venue_addr2`,`training_date`,`training_time`,polldate,polltime\r\nfrom second_appt where mem_no='6' or mem_no='5'"; $i = execUpdate($sql32); $sql33 = "insert into second_appt (`pers_off`,per_poststat,`groupid`,`assembly`,`assembly_name`,`mem_no`,`pccd`,`pcname`,`pr_personcd`,`p1_personcd`,`p2_personcd`,`p3_personcd`, `pa_personcd`,`pb_personcd`,`pr_name`,`p1_name`,`p2_name`,`p3_name`,`pa_name`,`pb_name`,`pr_designation`,`p1_designation`,`p2_designation`,`p3_designation`,`pa_designation`,`pb_designation`,`pr_status`,`p1_status`,`p2_status`,`p3_status`,`pa_status`,`pb_status`, pr_post_stat,p1_post_stat,p2_post_stat,p3_post_stat,pa_post_stat,pb_post_stat, `pr_officecd`,`p1_officecd`,`p2_officecd`,`p3_officecd`,`pa_officecd`,`pb_officecd`,`pr_officename`,`p1_officename`,`p2_officename`, `p3_officename`,`pa_officename`,`pb_officename`,`pr_officeaddress`,`p1_officeaddress`,`p2_officeaddress`,`p3_officeaddress`, `pa_officeaddress`,`pb_officeaddress`,`pr_postoffice`,`p1_postoffice`,`p2_postoffice`,`p3_postoffice`,`pa_postoffice`, `pb_postoffice`,`pr_subdivision`,`p1_subdivision`,`p2_subdivision`,`p3_subdivision`,`pa_subdivision`,`pb_subdivision`, `pr_policestn`,`p1_policestn`,`p2_policestn`,p3_policestn,`pa_policestn`,`pb_policestn`,`district`,`pr_pincode`,`p1_pincode`, `p2_pincode`,`p3_pincode`,`pa_pincode`,`pb_pincode`,`dcrcgrp`,`dc_venue`,`dc_address`,`dc_date`,dc_time,`rc_venue`,`traingcode`, `training_venue`,`venuecode`,`venue_addr1`,`venue_addr2`,`training_date`,`training_time`,polldate,polltime) \r\nselect distinct pb_officecd,pb_status,`groupid`,`assembly`,`assembly_name`,`mem_no`,`pccd`,`pcname`,`pr_personcd`,`p1_personcd`,`p2_personcd`,\r\n`p3_personcd`, `pa_personcd`,`pb_personcd`,`pr_name`,`p1_name`,`p2_name`,`p3_name`,`pa_name`,`pb_name`,`pr_designation`,`p1_designation`,\r\n`p2_designation`,`p3_designation`,`pa_designation`,`pb_designation`,`pr_status`,`p1_status`,`p2_status`,`p3_status`,`pa_status`,`pb_status`, pr_post_stat,p1_post_stat,p2_post_stat,p3_post_stat,pa_post_stat,pb_post_stat, `pr_officecd`,`p1_officecd`,`p2_officecd`,`p3_officecd`,`pa_officecd`,`pb_officecd`,`pr_officename`,`p1_officename`,`p2_officename`, `p3_officename`,`pa_officename`,`pb_officename`,`pr_officeaddress`,`p1_officeaddress`,`p2_officeaddress`,`p3_officeaddress`, `pa_officeaddress`,`pb_officeaddress`,`pr_postoffice`,`p1_postoffice`,`p2_postoffice`,`p3_postoffice`,`pa_postoffice`, `pb_postoffice`,`pr_subdivision`,`p1_subdivision`,`p2_subdivision`,`p3_subdivision`,`pa_subdivision`,`pb_subdivision`, `pr_policestn`,`p1_policestn`,`p2_policestn`,p3_policestn,`pa_policestn`,`pb_policestn`,`district`,`pr_pincode`,`p1_pincode`, `p2_pincode`,`p3_pincode`,`pa_pincode`,`pb_pincode`,`dcrcgrp`,`dc_venue`,`dc_address`,`dc_date`,dc_time,`rc_venue`,`traingcode`, `training_venue`,`venuecode`,`venue_addr1`,`venue_addr2`,`training_date`,`training_time`,polldate,polltime\r\nfrom second_appt where mem_no='6'"; $i = execUpdate($sql33); echo "Completed";
function delete_prev_data_second_rand_reserve($forassembly, $forpc, $group_id) { $sql = "delete from second_rand_table_reserve where (slno<>0 or slno=0)"; if ($forassembly != "0" && $forassembly != "") { $sql .= " and assembly like '{$forassembly}%'"; } elseif ($forpc != "0") { $sql .= " and pcname like '{$forpc}%'"; } if ($group_id != "") { $sql .= " and groupid = '{$group_id}'"; } $i = execDelete($sql); //print $sql; exit; 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 delete_training2_allocation($delcode) { $sql = "update personnela set training2_sch=NULL where training2_sch='{$delcode}'"; $i = execUpdate($sql); $sql = "delete from second_training where schedule_cd='{$delcode}'"; $i = execDelete($sql); return $i; }
function delete_permission($username) { $sql = "delete from user_permission where user_cd='{$username}'"; $i = execDelete($sql); return $i; }
function delete_dcrc($dcrc) { $sql = "delete from dcrc_party where dcrcgrp='{$dcrc}'"; execDelete($sql); $sql1 = "delete from dcrcmaster where dcrcgrp='{$dcrc}'"; $i = execDelete($sql1); connection_close(); return $i; }
function delete_trainingvenue($venue_cd) { $sql = "DELETE FROM training_venue WHERE venue_cd='{$venue_cd}'"; $rs = execDelete($sql); return $rs; }