PHP delete_prev_data_second_rand_reserveの例

コード例 #1

ファイル: populate_second_appt_reserve.php プロジェクト: MUN06/Lok-Sabha-Election-16th

//$i=execUpdate($sql19);
mysqli_autocommit($link, FALSE);
$sql = "insert into second_rand_table_reserve (groupid,assembly,pcname,personcd,person_name,person_designation,post_status,post_stat,officecd,office_name,office_address,post_office,subdivision,police_stn,district,pincode,dc_venue, dc_address,dc_date,dc_time,rc_venue) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
$stmt = mysqli_prepare($link, $sql);
mysqli_stmt_bind_param($stmt, 'issssssssssssssssssss', $grp_id, $for_ass, $for_pc, $pp_code, $pp_name, $pp_desig, $post_status, $post_stat, $pp_ofc_cd, $pp_office, $ofc_add, $postofc, $subdiv, $ps, $dist, $pin, $dcvenue, $dc_addr, $dc_dateD, $dc_time, $rcvenue);
$rec = 0;
extract($_GET);
$group_id = isset($_GET['group_id']) ? decode($_GET['group_id']) : "";
$forassembly = isset($_GET['assembly']) ? decode($_GET['assembly']) : "";
$forpc = $_GET['pc_cd'];
$sql1 = "update personnela set training2_sch='' where forpc='{$pc_cd}'";
$ret1 = execUpdate($sql1);
$sql19 = "update personnela join second_training on personnela.forpc=second_training.for_pc and personnela.forassembly=second_training.assembly and personnela.booked=second_training.party_reserve set personnela.training2_sch=second_training.schedule_cd where  personnela.groupid>=second_training.start_sl and personnela.groupid<=second_training.end_sl and second_training.for_pc='{$pc_cd}'";
$ret = execUpdate($sql19);
//$forpc='40';
$del_ret = delete_prev_data_second_rand_reserve($forassembly, $forpc, $group_id);
$rec_set_hdr = second_appointment_letter_reserve($group_id, $forassembly, $forpc);
if (rowCount($rec_set_hdr) > 0) {
    for ($n = 0; $n < rowCount($rec_set_hdr); $n++) {
        $rec_arr_hdr = getRows($rec_set_hdr);
        $grp_id = $rec_arr_hdr['groupid'];
        $for_ass = $rec_arr_hdr['assemblycd'] . "-" . $rec_arr_hdr['assemblyname'];
        $for_pc = $rec_arr_hdr['pccd'] . "-" . $rec_arr_hdr['pcname'];
        //$polling_station=$rec_arr_hdr['psno'].", ".$rec_arr_hdr['psname'];
        $dc = $rec_arr_hdr['dc_venue'] != '' ? $rec_arr_hdr['dc_venue'] . ", " . $rec_arr_hdr['dc_addr'] : "";
        $dc_date = $rec_arr_hdr['dc_date'] != '' ? $rec_arr_hdr['dc_date'] : "";
        $dc_dateD = $rec_arr_hdr['dc_dateD'] != '' ? $rec_arr_hdr['dc_dateD'] : "";
        $dc_time = $rec_arr_hdr['dc_time'] != '' ? $rec_arr_hdr['dc_time'] : "";
        $rcvenue = $rec_arr_hdr['rcvenue'] != '' ? $rec_arr_hdr['rcvenue'] : "";
        $dcvenue = $rec_arr_hdr['dc_venue'];
        $dc_addr = $rec_arr_hdr['dc_addr'];

コード例 #2

ファイル: ajax-reserve-replacement.php プロジェクト: MUN06/Lok-Sabha-Election-16th

            $selected = 0;
            $res1 = update_personnel_replacement($old_p_id, 0, '', $forpc, 'C', $selected, '', '');
            if ($res1 == 1) {
                echo "Changed";
            }
            $res2 = reserve_replacement_log($new_p_id, $old_p_id, $forassembly, $groupid, $usercd);
        }
    }
}
if ($opn == 'reserve_appletter') {
    $old_p_id = isset($_GET["old_p_id"]) ? $_GET["old_p_id"] : "";
    $new_p_id = isset($_GET["new_p_id"]) ? $_GET["new_p_id"] : "";
    $forassembly = isset($_GET["forassembly"]) ? $_GET["forassembly"] : "";
    $forpc = isset($_GET["forpc"]) ? $_GET["forpc"] : "";
    $groupid = isset($_GET["groupid"]) ? $_GET["groupid"] : "";
    delete_prev_data_second_rand_reserve($old_p_id, $new_p_id);
    include_once 'inc/commit_con.php';
    mysqli_autocommit($link, FALSE);
    $sql = "insert into second_rand_table_reserve (groupid,assembly,pcname,personcd,person_name,person_designation,post_status,post_stat,officecd,office_name,office_address,post_office,subdivision,police_stn,district,pincode,dc_venue, dc_address,dc_date,dc_time,rc_venue) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
    $stmt = mysqli_prepare($link, $sql);
    mysqli_stmt_bind_param($stmt, 'issssssssssssssssssss', $grp_id, $for_ass, $for_pc, $pp_code, $pp_name, $pp_desig, $post_status, $post_stat, $pp_ofc_cd, $pp_office, $ofc_add, $postofc, $subdiv, $ps, $dist, $pin, $dcvenue, $dc_addr, $dc_dateD, $dc_time, $rcvenue);
    $rec_set_hdr = second_appointment_letter_reserve($new_p_id);
    if (rowCount($rec_set_hdr) > 0) {
        for ($n = 0; $n < rowCount($rec_set_hdr); $n++) {
            $rec_arr_hdr = getRows($rec_set_hdr);
            $grp_id = $rec_arr_hdr['groupid'];
            $for_ass = $rec_arr_hdr['assemblycd'] . "-" . $rec_arr_hdr['assemblyname'];
            $for_pc = $rec_arr_hdr['pccd'] . "-" . $rec_arr_hdr['pcname'];
            $dc = $rec_arr_hdr['dc_venue'] != '' ? $rec_arr_hdr['dc_venue'] . ", " . $rec_arr_hdr['dc_addr'] : "";
            $dc_date = $rec_arr_hdr['dc_date'] != '' ? $rec_arr_hdr['dc_date'] : "";
            $dc_dateD = $rec_arr_hdr['dc_dateD'] != '' ? $rec_arr_hdr['dc_dateD'] : "";