function reserve_replacement_log($new_p_id, $old_p_id, $ass, $groupid, $usercd)
{
$sql = "insert into relpacement_log_reserve (old_personnel, new_personnel, assemblycd, groupid, usercode) values ";
$sql .= "('{$old_p_id}','{$new_p_id}','{$ass}','{$groupid}','{$usercd}')";
$i = execUpdate($sql);
connection_close();
return $i;
}
function updateUser($id, $uName, $uPass, $head, $gender)
{
if (!isset($uPass)) {
$updateStr = "update bbs_user set uName='{$uName}',uPass='******',gender={$gender},head='{$head}' where uId={$id}";
} else {
$updateStr = "update bbs_user set uName='{$uName}',gender={$gender},head='{$head}' where uId={$id}";
}
$rs = execUpdate($updateStr);
return $rs;
}
function addTopic($title, $content, $uId, $boardId)
{
$format = "%Y/%m/%d %H:%M:%S";
$publishTime = strftime($format);
//获取当前时间
$addStr = "insert into bbs_topic (title,content,publishTime,modifyTime,uId,boardId) values ('{$title}','{$content}','{$publishTime}','{$publishTime}',{$uId},{$boardId})";
$rs = execUpdate($addStr);
//执行操作
return $rs;
//返回执行结果
}
function update_Termination($ter_id, $PersonalID, $TerminationCause, $DateofTermination, $Remarks, $usercd, $posted_date)
{
$sql = "update termination set personal_id='{$PersonalID}',termination_cause='{$TerminationCause}',termination_date='{$DateofTermination}',remarks='{$Remarks}',users_id = '{$usercd}',posted_date = '{$posted_date}' where termination_id='{$ter_id}'";
//echo $sql; exit;
$i = execUpdate($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 deleteReply($replyId)
{
$delStr = "delete from bbs_reply where replyId = {$replyId}";
$rs = execUpdate($delStr);
return $rs;
}
<?php
include_once 'inc/db_trans.inc.php';
include_once 'function/training2_fun.php';
$rec = 0;
include_once 'inc/commit_con.php';
//try {
mysqli_autocommit($link, FALSE);
$sql_empty_sl = "update second_appt set slno=0";
execUpdate($sql_empty_sl);
$sql = "update second_appt set slno=? where pers_off=? and pr_personcd=?";
$stmt = mysqli_prepare($link, $sql);
if ($stmt != false) {
mysqli_stmt_bind_param($stmt, 'iss', $slno, $pers_off, $pr_personcd);
}
$rsRec = fetch_second_apt();
$num_rows = rowCount($rsRec);
if ($num_rows > 0) {
for ($i = 0; $i < $num_rows; $i++) {
$rowRec = getRows($rsRec);
$pers_off = $rowRec['pers_off'];
$pr_personcd = $rowRec['pr_personcd'];
$slno = $i + 1;
mysqli_stmt_execute($stmt);
$rec += mysqli_stmt_affected_rows($stmt);
}
}
if (!mysqli_commit($link)) {
print "Transaction commit failed\n";
exit;
} else {
//$sql17="update second_appt JOIN dcrc_party on second_appt.dcrcgrp=dcrc_party.dcrcgrp and second_appt.pccd=dcrc_party.forpc set second_appt.dc_time=dcrc_party.dc_time, second_appt.dc_date=dcrc_party.dc_date ";
//$i=execUpdate($sql17);
$sql18 = "update second_appt JOIN dcrc_party on second_appt.dcrcgrp=dcrc_party.dcrcgrp and \r\nsecond_appt.pccd=dcrc_party.forpc set second_appt.dc_time=dcrc_party.dc_time, \r\nsecond_appt.dc_date=dcrc_party.dc_date";
$i = execUpdate($sql18);
$sql19 = "update second_appt join second_training on second_appt.pccd=second_training.for_pc and second_appt.assembly=second_training.assembly set second_appt.traingcode=second_training.schedule_cd, second_appt.venuecode=second_training.training_venue , second_appt.training_date=second_training.training_dt, second_appt.training_time=second_training.training_time where second_training.party_reserve='P' and second_appt.groupid>=second_training.start_sl and second_appt.groupid<=second_training.end_sl and second_training.for_pc='{$pc_cd}'";
$i = execUpdate($sql19);
$sql20 = "UPDATE second_appt a JOIN training_venue_2 b ON a.venuecode=b.venue_cd SET a.`training_venue` =b.venuename,a.`venue_addr1` =b.venueaddress1, a.`venue_addr2`=b.venueaddress2 where a.pccd='{$pc_cd}'";
$i = execUpdate($sql20);
$sql21 = "update second_appt a join assembly b on a.assembly=b.assemblycd set a.assembly_name=b.assemblyname where a.pccd='{$pc_cd}'";
$i = execUpdate($sql21);
$sql21 = "update second_appt a join pc b on a.pccd=b.pccd set a.pcname=b.pcname where a.pccd='{$pc_cd}'";
$i = execUpdate($sql21);
$sql22 = "update second_appt a join subdivision b on a.pr_subdivision=b.subdivisioncd set a.pr_subdivision=b.subdivision where a.pccd='{$pc_cd}'";
$i = execUpdate($sql22);
$sql23 = "update second_appt a join subdivision b on a.p1_subdivision=b.subdivisioncd set a.p1_subdivision=b.subdivision where a.pccd='{$pc_cd}'";
$i = execUpdate($sql23);
$sql24 = "update second_appt a join subdivision b on a.p2_subdivision=b.subdivisioncd set a.p2_subdivision=b.subdivision where a.pccd='{$pc_cd}'";
$i = execUpdate($sql24);
$sql25 = "update second_appt a join subdivision b on a.p3_subdivision=b.subdivisioncd set a.p3_subdivision=b.subdivision where a.pccd='{$pc_cd}'";
$i = execUpdate($sql25);
$sql26 = "update second_appt a join subdivision b on a.pa_subdivision=b.subdivisioncd set a.pa_subdivision=b.subdivision where a.pccd='{$pc_cd}'";
$i = execUpdate($sql26);
$sql27 = "update second_appt a join subdivision b on a.pb_subdivision=b.subdivisioncd set a.pb_subdivision=b.subdivision where a.pccd='{$pc_cd}'";
$i = execUpdate($sql27);
$sql271 = "update second_appt a join poll_table b on a.pccd=b.pc_cd set a.polldate=b.poll_date, a.polltime=b.poll_time where a.pccd='{$pc_cd}'";
$i = execUpdate($sql271);
$sql272 = "update second_appt a join district b on substr(a.dcrcgrp,1,2)=b.districtcd set a.district=b.district";
$i = execUpdate($sql272);
$sql28 = "update second_appt join second_appt as a on second_appt.`pr_personcd`=a.`pr_personcd` set second_appt.pers_off= a.pr_officecd, second_appt.per_poststat= a.pr_status where second_appt.pccd='{$pc_cd}'";
$i = execUpdate($sql28);
echo "Completed";
$pp_code = $rec_arr_hdr['personcd'];
$post_status = $rec_arr_hdr['poststat'];
$post_stat = $rec_arr_hdr['poststatus'];
$pp_office = $rec_arr_hdr['office'];
$ofc_add = $rec_arr_hdr['address1'] . ", " . $rec_arr_hdr['address2'];
$postofc = $rec_arr_hdr['postoffice'];
$subdiv = $rec_arr_hdr['subdivision'];
$ps = $rec_arr_hdr['policestation'];
$dist = $rec_arr_hdr['district'];
$pin = $rec_arr_hdr['pin'];
$pp_ofc_address = $rec_arr_hdr['address1'] . ", " . $rec_arr_hdr['address2'] . ", P.O.-" . $rec_arr_hdr['postoffice'] . ", Subdiv.-" . $rec_arr_hdr['subdivision'] . ", P.S.-" . $rec_arr_hdr['policestation'] . ", Dist.-" . $rec_arr_hdr['district'] . ", PIN-" . $rec_arr_hdr['pin'];
$pp_ofc_cd = $rec_arr_hdr['officecd'];
mysqli_stmt_execute($stmt);
$rec += mysqli_stmt_affected_rows($stmt);
}
if (!mysqli_commit($link)) {
print "Transaction commit failed\n";
exit;
}
mysqli_stmt_close($stmt);
mysqli_close($link);
$sql19 = "update second_rand_table_reserve join second_training on substr(second_rand_table_reserve.pcname,1,2)=second_training.for_pc and substr(second_rand_table_reserve.assembly,1,3)=second_training.assembly set second_rand_table_reserve.traingcode=second_training.schedule_cd, second_rand_table_reserve.venuecode=second_training.training_venue , second_rand_table_reserve.training_date=second_training.training_dt, second_rand_table_reserve.training_time=second_training.training_time where second_training.party_reserve='R' and second_rand_table_reserve.groupid>=second_training.start_sl and second_rand_table_reserve.groupid<=second_training.end_sl and second_training.for_pc='{$pc_cd}'";
$i = execUpdate($sql19);
$sql20 = "UPDATE second_rand_table_reserve a JOIN training_venue_2 b ON a.venuecode=b.venue_cd SET a.`training_venue` =b.venuename,a.`venue_addr1` =b.venueaddress1, a.`venue_addr2`=b.venueaddress2 where substr(a.pcname,1,2)='{$pc_cd}'";
$i = execUpdate($sql20);
$sql271 = "update second_rand_table_reserve a join poll_table b on substr(a.pcname,1,2)=b.pc_cd set a.polldate=b.poll_date, a.polltime=b.poll_time where substr(a.pcname,1,2)='{$pc_cd}'";
$i = execUpdate($sql271);
print "{$rec} Record(s) updated successfully\n";
} else {
echo "No valid data found.";
}
$old_pass = $_REQUEST['old_pass'];
$new_pass = $_REQUEST['new_pass'];
$re_new_pass = $_REQUEST['re_new_pass'];
if ($action == 'Submit') {
$sql = "select count(*) as cnt from contact_master where user_id='{$user_id}' and user_pwd='{$old_pass}' ";
//echo "$sql<br>";
$result = execSelect($sql);
$row = getRows($result);
$cnt = $row['cnt'];
if ($cnt > 0) {
if ($new_pass == $re_new_pass) {
$sql_up = "update contact_master set ";
$sql_up .= " user_pwd='{$new_pass}'";
$sql_up .= " where user_id='{$user_id}'";
//echo"$sql_up<br>";
execUpdate($sql_up);
$msg = "Password changed successfully";
} else {
$msg = "Wrong New Password & Re-Enter Password ....";
}
} else {
if ($cnt <= 0) {
$msg = "User Not Exists/Old Password is wrong ";
}
}
}
?>
<script language="javascript">
function check1()
{
if(document.form1.user.value=='')
$a1 = execUpdate($sql27);
$sql271 = "update second_appt a join poll_table b on a.pccd=b.pc_cd set a.polldate=b.poll_date, a.polltime=b.poll_time where a.pccd='{$pc_cd}' and a.assembly='{$forassembly}' and a.groupid='{$groupid}'";
$b1 = execUpdate($sql271);
$sql272 = "update second_appt a join district b on substr(a.dcrcgrp,1,2)=b.districtcd set a.district=b.district where a.pccd='{$pc_cd}' and a.assembly='{$forassembly}' and a.groupid='{$groupid}'";
$c1 = execUpdate($sql272);
if ($poststat == 'PR') {
$sql28 = "update second_appt join second_appt as a on second_appt.`pr_personcd`=a.`pr_personcd` set second_appt.pers_off= a.pr_officecd, second_appt.per_poststat= a.pr_status where second_appt.pccd='{$pc_cd}' and a.assembly='{$forassembly}' and a.groupid='{$groupid}'";
$d1 = execUpdate($sql28);
}
if ($poststat == 'P1') {
$sql28 = "update second_appt join second_appt as a on second_appt.`pr_personcd`=a.`pr_personcd` set second_appt.pers_off= a.p1_officecd, second_appt.per_poststat= a.p1_status where second_appt.pccd='{$pc_cd}' and a.assembly='{$forassembly}' and a.groupid='{$groupid}'";
$d1 = execUpdate($sql28);
}
if ($poststat == 'P2') {
$sql28 = "update second_appt join second_appt as a on second_appt.`pr_personcd`=a.`pr_personcd` set second_appt.pers_off= a.p2_officecd, second_appt.per_poststat= a.p2_status where second_appt.pccd='{$pc_cd}' and a.assembly='{$forassembly}' and a.groupid='{$groupid}'";
$d1 = execUpdate($sql28);
}
if ($poststat == 'P3') {
$sql28 = "update second_appt join second_appt as a on second_appt.`pr_personcd`=a.`pr_personcd` set second_appt.pers_off= a.p3_officecd, second_appt.per_poststat= a.p3_status where second_appt.pccd='{$pc_cd}' and a.assembly='{$forassembly}' and a.groupid='{$groupid}'";
$d1 = execUpdate($sql28);
}
if ($poststat == 'PA') {
$sql28 = "update second_appt join second_appt as a on second_appt.`pr_personcd`=a.`pr_personcd` set second_appt.pers_off= a.pa_officecd, second_appt.per_poststat= a.pa_status where second_appt.pccd='{$pc_cd}' and a.assembly='{$forassembly}' and a.groupid='{$groupid}'";
$d1 = execUpdate($sql28);
}
if ($poststat == 'PB') {
$sql28 = "update second_appt join second_appt as a on second_appt.`pr_personcd`=a.`pr_personcd` set second_appt.pers_off= a.pb_officecd, second_appt.per_poststat= a.pb_status where second_appt.pccd='{$pc_cd}' and a.assembly='{$forassembly}' and a.groupid='{$groupid}'";
$d1 = execUpdate($sql28);
}
echo $a . "-" . $b . "-" . $c . "-" . $d . "-" . $e . "-" . $f . "-" . $g . "-" . $h . "-" . $i . "-" . $j . "-" . $k . "-" . $l . "-" . $m . "-" . $n . "-" . $o . "-" . $p . "-" . $q . "-" . $r . "-" . $s . "-" . $t . "-" . $u . "-" . $v . "-" . $w . "-" . $x . "-" . $y . "-" . $z . "-" . $a1 . "-" . $b1 . "-" . $c1 . "-" . $d1;
}
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;
}
}
//====== third randomisation
if ($opn == 'unlock_thirdrand') {
$sql = "select * from password where password=MD5('{$pass}') and randomise ='3'";
$rs = execSelect($sql);
if (rowCount($rs) > 0) {
//$row=getRows($rs);
echo "unlock";
execUpdate("update password set status='unlock', usercode='{$usercode}', posted_date='{$posted_date}' where randomise='3'");
} else {
echo "Wrong Password !!!";
}
}
if ($opn == 'lock_thirdrand') {
$sql = "update password set status='lock', usercode='{$usercode}', posted_date='{$posted_date}' where randomise='3'";
$i = execUpdate($sql);
if ($i > 0) {
echo "lock";
}
}
if ($opn == 'state_thirdrand') {
$sql = "select status from password where randomise ='3'";
$rs = execSelect($sql);
if (rowCount($rs) > 0) {
$row = getRows($rs);
if ($row['status'] == 'unlock') {
echo "false";
} else {
echo "true";
}
}
function update_user($user_cd, $password, $category, $district_cd, $subdiv, $parliament)
{
$sql = "update user set password='******',category='{$category}',districtcd='{$district_cd}',subdivisioncd='{$subdiv}',parliamentcd='{$parliament}' where code='{$user_cd}'";
$i = execUpdate($sql);
return $i;
}
function update_polling_stn($psno, $postfix, $assembly, $psname, $usercd, $posted_date)
{
$sql = "update pollingstation set psfix='{$postfix}',psname='{$psname}',usercode='{$usercd}',posted_date='{$posted_date}' where psno='{$psno}' and forassembly='{$assembly}'";
$i = execUpdate($sql);
return $i;
}
function update_trainingvenue($venue_cd, $subdiv_cd, $venuename, $venueaddress1, $venueaddress2, $maximumcapacity, $usercd, $posted_date)
{
$sql = "update training_venue set subdivisioncd='{$subdiv_cd}',venuename='{$venuename}',venueaddress1='{$venueaddress1}',venueaddress2='{$venueaddress2}',maximumcapacity='{$maximumcapacity}',usercode = '{$usercd}', posted_date = '{$posted_date}' where venue_cd='{$venue_cd}'";
//echo $sql; exit;
$i = execUpdate($sql);
return $i;
}
