PHP Debug_Print函數代碼示例

 function insertMlistData(&$request)
 {
     $this->oDb->begin();
     // ユーザID取得
     $mlist_id = $this->oDb->getSequence('mlist_id_seq');
     // 基本情報
     $args = $this->getSqlArgs();
     $args['MLIST_ID'] = $this->sqlItemInteger($mlist_id);
     $args['MLIST_NAME'] = $this->sqlItemChar($request['mlist_name']);
     $args['MLIST_ACC'] = $this->sqlItemChar($request['mlist_acc']);
     $args['SENDER_KBN'] = $this->sqlItemChar($request['sender_kbn']);
     $args['MLIST_KBN'] = $this->sqlItemChar($request['mlist_kbn']);
     $args['NOTE'] = $this->sqlItemChar($request['note']);
     $args['USAGE'] = $this->sqlItemChar($request['usage']);
     $sql = $this->getQuery('INSERT_MLIST_HEAD', $args);
     $ret = $this->oDb->query($sql);
     if (!$ret) {
         Debug_Print($sql);
         $this->oDb->rollback();
         return false;
     }
     //
     // 管理者データ
     //
     if (is_array($request['admin_id'])) {
         $args = $this->getSqlArgs();
         $args['MLIST_ID'] = $this->sqlItemInteger($mlist_id);
         foreach ($request['admin_id'] as $no => $user_id) {
             $args['LIST_NO'] = $this->sqlItemInteger($no);
             $args['USER_ID'] = $this->sqlItemInteger($user_id);
             $sql = $this->getQuery('INSERT_MLIST_ADMIN', $args);
             $ret = $this->oDb->query($sql);
             if (!$ret) {
                 Debug_Print($sql);
                 $this->oDb->rollback();
                 return false;
             }
             // 管理者ロールを割り當てる
             $ret = $this->setUserAdminRole($user_id, ROLE_ID_MLIST_ADMIN);
             if (!$ret) {
                 Debug_Print($sql);
                 $this->oDb->rollback();
                 return false;
             }
         }
     }
     // 一旦トランザクション終了
     $this->oDb->end();
     //
     // メールアカウント連攜
     //
     if ($request['mlist_acc'] != "") {
         $this->addMailingList($request);
     }
     $request['mlist_id'] = $mlist_id;
     return true;
 }

 function insertVpnData(&$request)
 {
     $this->oDb->begin();
     // ユーザID取得
     $vpn_id = $this->oDb->getSequence('vpn_id_seq');
     // 基本情報
     $args = $this->getSqlArgs();
     $args['VPN_ID'] = $this->sqlItemInteger($vpn_id);
     $args['VPN_KBN'] = $this->sqlItemChar($request['vpn_kbn']);
     $args['VPN_NAME'] = $this->sqlItemChar($request['vpn_name']);
     $args['GROUP_NAME'] = $this->sqlItemChar($request['group_name']);
     $args['GROUP_CODE'] = $this->sqlItemChar($request['group_code']);
     $args['USAGE'] = $this->sqlItemChar($request['usage']);
     $args['NOTE'] = $this->sqlItemChar($request['note']);
     $sql = $this->getQuery('INSERT_VPN_HEAD', $args);
     $ret = $this->oDb->query($sql);
     if (!$ret) {
         Debug_Print($sql);
         $this->oDb->rollback();
         return false;
     }
     //
     // 管理者データ
     //
     if (is_array($request['admin_id'])) {
         $args = $this->getSqlArgs();
         $args['VPN_ID'] = $this->sqlItemInteger($vpn_id);
         foreach ($request['admin_id'] as $no => $user_id) {
             $args['LIST_NO'] = $this->sqlItemInteger($no);
             $args['USER_ID'] = $this->sqlItemInteger($user_id);
             $sql = $this->getQuery('INSERT_VPN_ADMIN', $args);
             $ret = $this->oDb->query($sql);
             if (!$ret) {
                 Debug_Print($sql);
                 $this->oDb->rollback();
                 return false;
             }
             // 管理者ロールを割り當てる
             $ret = $this->setUserAdminRole($user_id, ROLE_ID_VPN_ADMIN);
             if (!$ret) {
                 Debug_Print($sql);
                 $this->oDb->rollback();
                 return false;
             }
         }
     }
     // トランザクション終了
     $this->oDb->end();
     // AD連攜はなし←登録済みのはず
     $request['vpn_id'] = $vpn_id;
     return true;
 }

 function changeSbcFlg($request)
 {
     $args = $this->getSqlArgs();
     $args['APP_ID'] = $this->sqlItemInteger($request['app_id']);
     $args['USE_SBC'] = $this->sqlItemFlg(@$request['use_sbc']);
     $sql = $this->getQuery('UPDATE_APP_USE_SBC', $args);
     $ret = $this->oDb->query($sql);
     if (!$ret) {
         Debug_Print($sql);
         return false;
     }
     return true;
 }

 function cancelMlistEntry($mlist_id, $entry_no)
 {
     $args = $this->getSqlArgs();
     $args[0] = $mlist_id;
     $args[1] = $entry_no;
     $args['ENTRY_STATUS'] = $this->sqlItemChar(ENTRY_STATUS_CANCEL);
     $sql = $this->getQuery('CANCEL_MLIST_HEAD_ENTRY', $args);
     $ret = $this->oDb->query($sql);
     if (!$ret) {
         Debug_Print($sql);
         return false;
     }
     return true;
 }

 function deleteData($request)
 {
     $vlan_id = $request['vlan_id'];
     $user_id = $request['list_no'];
     // 削除
     $args = $this->getSqlArgs();
     $args[0] = $vlan_id;
     $args[1] = $user_id;
     $sql = $this->getQuery('DELETE_DATA', $args);
     $ret = $this->oDb->query($sql);
     if (!$ret) {
         Debug_Print($sql);
         return false;
     }
     return true;
 }

 function insertGuestData(&$request)
 {
     $request['mac_addr'] = $this->getFlatMacAddr($request['mac_addr']);
     $request['wireless_id'] = microtime(true);
     $request['password'] = $this->createPassword();
     $user_id = $this->getSessionData('LOGIN_USER_ID');
     $password = $this->passwordEncrypt($request['password']);
     $this->oDb->begin();
     // ユーザID取得
     $guest_id = $this->oDb->getSequence('guest_id_seq');
     // 基本情報
     $args = $this->getSqlArgs();
     $args['GUEST_ID'] = $this->sqlItemInteger($guest_id);
     $args['GUEST_NAME'] = $this->sqlItemChar($request['guest_name']);
     $args['COMPANY_NAME'] = $this->sqlItemChar($request['company_name']);
     $args['BELONG_NAME'] = $this->sqlItemChar($request['belong_name']);
     $args['TELNO'] = $this->sqlItemChar($request['telno']);
     $args['MAC_ADDR'] = $this->sqlItemChar($request['mac_addr']);
     $args['WIRELESS_ID'] = $this->sqlItemChar($request['wireless_id']);
     $args['PASSWORD'] = $this->sqlItemChar($password);
     $args['USAGE'] = $this->sqlItemChar($request['usage']);
     $args['NOTE'] = $this->sqlItemChar($request['note']);
     $sql = $this->getQuery('INSERT_GUEST_HEAD', $args);
     $ret = $this->oDb->query($sql);
     if (!$ret) {
         Debug_Print($sql);
         $this->oDb->rollback();
         return false;
     }
     // エントリーテーブルを更新
     $ret = $this->updateUserEntryFlg($user_id, 'guest_entry_flg');
     if (!$ret) {
         $this->oDb->rollback();
         return false;
     }
     // トランザクション終了
     $this->oDb->end();
     // AD連攜
     $this->relationAd($request);
     $request['guest_id'] = $guest_id;
     return true;
 }

 function deleteGuestData($guest_id)
 {
     // 削除する前にデータを取得
     $aryGuest = $this->getGuestData($guest_id);
     //$mac_addr = $aryGuest['mac_addr'];
     $wireless_id = $aryGuest['wireless_id'];
     // 基本情報
     $args = $this->getSqlArgs();
     $args[0] = $guest_id;
     $sql = $this->getQuery('DELETE_GUEST_HEAD', $args);
     $ret = $this->oDb->query($sql);
     if (!$ret) {
         Debug_Print($sql);
         $this->oDb->rollback();
         return false;
     }
     // 同期
     $this->deleteAd($wireless_id);
     return true;
 }

 function updateVpnMembersData(&$request)
 {
     $vpn_id = $request['vpn_id'];
     $vpn_user_id = $request['vpn_user_id'];
     // パスワード暗號化
     $passwd = $this->passwordEncrypt($request['passwd']);
     // 更新前にDBデータを取得し比較
     $aryTmp = $this->getVpnMembersData($request['vpn_id'], $request['vpn_user_id']);
     $aryTmp['passwd'] = $this->passwordDecrypt($aryTmp['passwd']);
     $this->oDb->begin();
     $args = $this->getSqlArgs();
     $args['VPN_ID'] = $this->sqlItemInteger($vpn_id);
     $args['VPN_USER_ID'] = $this->sqlItemChar($vpn_user_id);
     $args['MAIL_ADDR'] = $this->sqlItemChar($request['mail_addr']);
     $args['PASSWD'] = $this->sqlItemChar($passwd);
     $args['KANJINAME'] = $this->sqlItemChar($request['kanjiname']);
     $args['KANANAME'] = $this->sqlItemChar($request['kananame']);
     $args['COMPANY'] = $this->sqlItemChar($request['company']);
     $args['CONTACT'] = $this->sqlItemChar($request['contact']);
     $args['EXPIRY_DATE'] = $this->sqlItemChar($request['expiry_date']);
     $args['NOTE'] = $this->sqlItemChar($request['note']);
     $sql = $this->getQuery('UPDATE_VPN_MEMBERS_LIST', $args);
     $ret = $this->oDb->query($sql);
     if (!$ret) {
         Debug_Print($sql);
         $this->oDb->rollback();
         return false;
     }
     $this->oDb->end();
     // 有効期限・メールアドレス・パスワードの何れかが変更されたらAD連攜する
     if ($aryTmp['expiry_date'] != $request['expiry_date'] || $aryTmp['mail_addr'] != $request['mail_addr'] || $aryTmp['passwd'] != $request['passwd']) {
         // AD連攜
         if ($aryTmp['vpn_kbn'] == VPN_KBN_VPN) {
             $this->modifyVpnMembers($request);
         } else {
             $this->modifyPasslogicMembers($request);
         }
     }
     return true;
 }

 function rejectAppEntry($request)
 {
     $app_id = $request['app_id'];
     $entry_no = $request['entry_no'];
     $agree_note = $request['agree_note'];
     // 申請內容によって処理わけ
     $aryEnt = $this->getAppHead($app_id, $entry_no);
     $entry_kbn = $aryEnt['entry_kbn'];
     $entry_id = $aryEnt['entry_id'];
     $args = $this->getSqlArgs();
     $args[0] = $app_id;
     $args[1] = $entry_no;
     $args['AGREE_NOTE'] = $this->sqlItemChar($agree_note);
     $args['ENTRY_STATUS'] = $this->sqlItemChar(ENTRY_STATUS_REJECT);
     $sql = $this->getQuery('REJECT_APP_HEAD_ENTRY', $args);
     $ret = $this->oDb->query($sql);
     if (!$ret) {
         Debug_Print($sql);
         return false;
     }
     // メール送信
     $this->sendRejectMail($entry_id, $entry_kbn);
     return true;
 }

 function makeEditLog($user_id, $log_kbn, $mode_name = "", $reserve_flg = "0", $reflect_date = "")
 {
     //
     return true;
     $log_user_id = $this->getSessionData('LOGIN_USER_ID');
     $ctrl_id = "";
     if ($mode_name != "") {
         $ctrl_id = $this->getCtrlId($mode_name);
     }
     $args = array();
     $args['USER_ID'] = $this->sqlItemInteger($user_id);
     $args['LOG_KBN'] = $this->sqlItemChar($log_kbn);
     $args['CTRL_ID'] = $this->sqlItemInteger($ctrl_id);
     $args['LOG_USER_ID'] = $this->sqlItemInteger($log_user_id);
     $args['RESERVE_FLG'] = $this->sqlItemFlg($reserve_flg);
     $args['REFLECT_DATE'] = $this->sqlItemChar($reflect_date);
     $sql = $this->getQuery("INSERT_EDIT_LOG", $args);
     $ret = $this->oDb->query($sql);
     if (!$ret) {
         Debug_Print($sql);
         return false;
     }
     return true;
 }

 function updateVpnData($request)
 {
     // ID
     $vpn_id = $request['vpn_id'];
     $aryOld = $this->getVpnData($vpn_id);
     $this->oDb->begin();
     // 基本情報
     $args = $this->getSqlArgs();
     $args['VPN_ID'] = $this->sqlItemInteger($vpn_id);
     $args['VPN_KBN'] = $this->sqlItemChar($request['vpn_kbn']);
     $args['VPN_NAME'] = $this->sqlItemChar($request['vpn_name']);
     $args['GROUP_NAME'] = $this->sqlItemChar($request['group_name']);
     $args['GROUP_CODE'] = $this->sqlItemChar($request['group_code']);
     $args['USAGE'] = $this->sqlItemChar($request['usage']);
     $args['NOTE'] = $this->sqlItemChar($request['note']);
     $sql = $this->getQuery('UPDATE_VPN_HEAD', $args);
     $ret = $this->oDb->query($sql);
     if (!$ret) {
         Debug_Print($sql);
         $this->oDb->rollback();
         return false;
     }
     //
     // 管理者データ
     //
     // 一旦論理削除
     $args = $this->getSqlArgs();
     $args['VPN_ID'] = $this->sqlItemInteger($vpn_id);
     $args['USER_ID'] = $this->sqlItemInteger($user_id);
     $sql = $this->getQuery('DELETE_VPN_ADMIN_DATA', $args);
     $ret = $this->oDb->query($sql);
     if (!$ret) {
         Debug_Print($sql);
         $this->oDb->rollback();
         return false;
     }
     if (is_array($request['admin_id'])) {
         $args = $this->getSqlArgs();
         $args['VPN_ID'] = $this->sqlItemInteger($vpn_id);
         foreach ($request['admin_id'] as $no => $user_id) {
             $args['LIST_NO'] = $this->sqlItemInteger($no);
             $args['USER_ID'] = $this->sqlItemInteger($user_id);
             // 存在チェック
             $sql = $this->getQuery('EXISTS_VPN_ADMIN', $args);
             $list_no = $this->oDb->getOne($sql);
             if ($list_no == "") {
                 $sql_id = "INSERT_VPN_ADMIN";
             } else {
                 $sql_id = "UPDATE_VPN_ADMIN";
             }
             $sql = $this->getQuery($sql_id, $args);
             $ret = $this->oDb->query($sql);
             if (!$ret) {
                 Debug_Print($sql);
                 $this->oDb->rollback();
                 return false;
             }
             // 管理者ロールを割り當てる
             $ret = $this->setUserAdminRole($user_id, ROLE_ID_VPN_ADMIN);
             if (!$ret) {
                 Debug_Print($sql);
                 $this->oDb->rollback();
                 return false;
             }
         }
     }
     // 一旦トランザクション終了
     $this->oDb->end();
     return true;
 }

 function insertUserHisData($user_id, &$request, $no = "", $key = "")
 {
     if ($key == "") {
         $no = "0";
         $send_date = $request['send_date'];
         $staffcode = $request['staffcode'];
         $kanjiname = $request['kanjiname'];
         $kananame = $request['kananame'];
         $password = $request['password'];
         $wardcode = $request['wardcode'];
         $professioncode = $request['professioncode'];
         $gradecode = $request['gradecode'];
         $appcode = $request['appcode'];
         $deptcode = $request['deptcode'];
         $deptgroupcode = $request['deptgroupcode'];
         $validstartdate = $request['validstartdate'];
         $validenddate = $request['validenddate'];
     } else {
         $send_date = $request['sub_send_date'][$key];
         $staffcode = $request['sub_staffcode'][$key];
         $kanjiname = $request['sub_kanjiname'][$key];
         $kananame = $request['sub_kananame'][$key];
         $password = $request['sub_password'][$key];
         $wardcode = $request['sub_wardcode'][$key];
         $professioncode = $request['sub_professioncode'][$key];
         $gradecode = $request['sub_gradecode'][$key];
         $appcode = $request['sub_appcode'][$key];
         $deptcode = $request['sub_deptcode'][$key];
         $deptgroupcode = $request['sub_deptgroupcode'][$key];
         $validstartdate = $request['sub_validstartdate'][$key];
         $validenddate = $request['sub_validenddate'][$key];
     }
     $password = $this->passwordEncrypt($password);
     list($start_y, $start_m, $start_d) = explode("/", $validstartdate);
     $validstartdate = sprintf("%04d-%02d-%02d", $start_y, $start_m, $start_d);
     list($end_y, $end_m, $end_d) = explode("/", $validenddate);
     $validenddate = sprintf("%04d-%02d-%02d", $end_y, $end_m, $end_d);
     list($send_y, $send_m, $send_d) = explode("/", $send_date);
     $send_date = sprintf("%04d-%02d-%02d", $send_y, $send_m, $send_d);
     $args = $this->getSqlArgs();
     $args['USER_ID'] = $this->sqlItemInteger($user_id);
     $args['LIST_NO'] = $this->sqlItemInteger($no);
     $args['STAFFCODE'] = $this->sqlItemChar($staffcode);
     $args['WARDCODE'] = $this->sqlItemChar($wardcode);
     $args['PROFESSIONCODE'] = $this->sqlItemChar($professioncode);
     $args['GRADECODE'] = $this->sqlItemChar($gradecode);
     $args['KANANAME'] = $this->sqlItemChar($kananame);
     $args['KANJINAME'] = $this->sqlItemChar($kanjiname);
     $args['PASSWORD'] = $this->sqlItemChar($password);
     $args['VALIDSTARTDATE'] = $this->sqlItemChar($validstartdate);
     $args['VALIDENDDATE'] = $this->sqlItemChar($validenddate);
     $args['DEPTCODE'] = $this->sqlItemChar($deptcode);
     $args['APPCODE'] = $this->sqlItemChar($appcode);
     $args['DEPTGROUPCODE'] = $this->sqlItemChar($deptgroupcode);
     $args['SEND_DATE'] = $this->sqlItemChar($send_date);
     $sql = $this->getQuery('INSERT_USER_HIS', $args);
     $ret = $this->oDb->query($sql);
     if (!$ret) {
         Debug_Print($sql);
         return false;
     }
     return true;
 }

 function updateMlistData($request)
 {
     // ID
     $mlist_id = $request['mlist_id'];
     $aryOld = $this->getMlistData($mlist_id);
     $this->oDb->begin();
     // 基本情報
     $args = $this->getSqlArgs();
     $args['MLIST_ID'] = $this->sqlItemInteger($mlist_id);
     $args['MLIST_NAME'] = $this->sqlItemChar($request['mlist_name']);
     $args['MLIST_ACC'] = $this->sqlItemChar($request['mlist_acc']);
     $args['SENDER_KBN'] = $this->sqlItemChar($request['sender_kbn']);
     $args['NOTE'] = $this->sqlItemChar($request['note']);
     $args['USAGE'] = $this->sqlItemChar($request['usage']);
     $sql = $this->getQuery('UPDATE_MLIST_HEAD', $args);
     $ret = $this->oDb->query($sql);
     if (!$ret) {
         Debug_Print($sql);
         $this->oDb->rollback();
         return false;
     }
     //
     // 管理者データ
     //
     // 一旦論理削除
     $args = $this->getSqlArgs();
     $args['MLIST_ID'] = $mlist_id;
     $sql = $this->getQuery('DELETE_MLIST_ADMIN_DATA', $args);
     $ret = $this->oDb->query($sql);
     if (!$ret) {
         Debug_Print($sql);
         $this->oDb->rollback();
         return false;
     }
     if (is_array($request['admin_id'])) {
         $args = $this->getSqlArgs();
         $args['MLIST_ID'] = $this->sqlItemInteger($mlist_id);
         foreach ($request['admin_id'] as $no => $user_id) {
             $args['LIST_NO'] = $this->sqlItemInteger($no);
             $args['USER_ID'] = $this->sqlItemInteger($user_id);
             // 存在チェック
             $sql = $this->getQuery('EXISTS_MLIST_ADMIN', $args);
             $ex_sql = $sql;
             $list_no = $this->oDb->getOne($sql);
             if ($list_no == "") {
                 $sql_id = "INSERT_MLIST_ADMIN";
             } else {
                 $sql_id = "UPDATE_MLIST_ADMIN";
             }
             $sql = $this->getQuery($sql_id, $args);
             $ret = $this->oDb->query($sql);
             if (!$ret) {
                 Debug_Print($sql . $ex_sql);
                 $this->oDb->rollback();
                 return false;
             }
             // 管理者ロールを割り當てる
             $ret = $this->setUserAdminRole($user_id, ROLE_ID_MLIST_ADMIN);
             if (!$ret) {
                 Debug_Print($sql);
                 $this->oDb->rollback();
                 return false;
             }
         }
     }
     // 一旦トランザクション終了
     $this->oDb->end();
     //
     // メールアカウント連攜
     //
     if ($aryOld['mlist_acc'] != $request['mlist_acc']) {
         // アカウントが変わった場合
         $this->editMailingList($aryOld['mlist_acc'], $request['mlist_acc']);
     }
     // 送信者製限が変わった場合
     if ($aryOld['sender_kbn'] != $request['sender_kbn']) {
         $this->editSenderKbn($request);
     }
     return true;
 }

 function deleteData($request)
 {
     // トランザクション開始
     $this->oDb->begin();
     $vlan_id = $request['vlan_id'];
     // 削除
     $args = $this->getSqlArgs();
     $args[0] = $vlan_id;
     $sql = $this->getQuery('DELETE_DATA', $args);
     $ret = $this->oDb->query($sql);
     if (!$ret) {
         Debug_Print($sql);
         $this->oDb->rollback();
         return false;
     }
     $sql = $this->getQuery('DELETE_ADMIN_DATA', $args);
     $ret = $this->oDb->query($sql);
     if (!$ret) {
         Debug_Print($sql);
         $this->oDb->rollback();
         return false;
     }
     // トランザクション終了
     $this->oDb->end();
     return true;
 }

 function deleteMlistData($mlist_id)
 {
     $this->oDb->begin();
     // 基本情報
     $args = $this->getSqlArgs();
     $args[0] = $mlist_id;
     $sql = $this->getQuery('DELETE_MLIST_HEAD', $args);
     $ret = $this->oDb->query($sql);
     if (!$ret) {
         Debug_Print($sql);
         $this->oDb->rollback();
         return false;
     }
     $sql = $this->getQuery('DELETE_MLIST_ADMIN', $args);
     $ret = $this->oDb->query($sql);
     if (!$ret) {
         Debug_Print($sql);
         $this->oDb->rollback();
         return false;
     }
     $sql = $this->getQuery('DELETE_MLIST_MEMBERS', $args);
     $ret = $this->oDb->query($sql);
     if (!$ret) {
         Debug_Print($sql);
         $this->oDb->rollback();
         return false;
     }
     $this->oDb->end();
     // 同期
     $this->delMailingList($mlist_id);
     return true;
 }