Ejemplos de users_detail_mgr::passwordDecrypt en PHP

Ejemplo n.º 1

Archivo: reserve_his_data_relation.php Proyecto: honda-kyoto/UMS-Kyoto

* Authors      : mie tsutsui
* Date         : 2013.01.10
* Last Update  : 2013.01.10
* Copyright    :
***********************************************************/
set_include_path('.:/usr/share/pear:/var/www/phplib');
require_once "mgr/users_detail_mgr.class.php";
$oMgr = new users_detail_mgr();
$sql = "\nSELECT\n    user_id,\n    list_no,\n    staffcode,\n    wardcode,\n    professioncode,\n    gradecode,\n    kananame,\n    kanjiname,\n    password,\n    TO_CHAR(validstartdate, 'YYYY/MM/DD') AS validstartdate,\n    TO_CHAR(validenddate, 'YYYY/MM/DD') AS validenddate,\n    deptcode,\n    appcode,\n    deptgroupcode,\n    history_note,\n    his_history_kbn,\n    make_id,\n    update_id\nFROM\n    user_his_reserve\nWHERE\n    del_flg = '0' AND\n    send_date <= now()::date\n";
$aryRsv = $oMgr->oDb->getAll($sql);
if (is_array($aryRsv)) {
    foreach ($aryRsv as $aryData) {
        $aryData['edit_mode'] = "";
        $aryData['immediate_flg'] = "1";
        if ($aryData['password'] != "") {
            $aryData['password'] = $oMgr->passwordDecrypt($aryData['password']);
        }
        // 更新
        $ret = $oMgr->updateUserHisData($aryData);
        if (!$ret) {
            Debug_Trace("HIS連携予約データ反映に失敗しました。", 521);
            Debug_Trace($aryData);
            exit;
        }
        $oMgr->oDb->begin();
        // 削除フラグ１を立てる
        $sql = "UPDATE user_his_reserve SET del_flg = '1' WHERE user_id = " . $aryData['user_id'] . " AND list_no = " . $aryData['list_no'];
        $oMgr->oDb->query($sql);
        $oMgr->oDb->end();
    }
}