/****************************************************** ' System :「きゃららFactory」管理者用ページル ' Content:似顔絵情報管理|似顔絵受付リスト '******************************************************/ $top = "../.."; $inc = "$top/inc"; include("$inc/login_check.php"); include("$inc/header.php"); $inc = "$top/../inc"; include("$inc/common.php"); include("$inc/define.php"); include("$inc/database.php"); include("$inc/select.php"); include("$inc/decode.php"); include("$inc/format.php"); // 優先度選択 function select_priority($selected) { echo '', "\n"; echo '', "\n"; } // 写真画像URL取得 $ur_photo = get_system_info('url_photo'); // 似顔絵URL取得 $ur_nigaoe = get_system_info('url_nigaoe'); // メイン処理 set_global('nigaoe', '似顔絵情報管理', '似顔絵受付リスト', BACK_TOP); //to_char(nd_nouki_date - now(),'dd日 HH24時間MI分') $sql = "SELECT * , to_char(nd_appl_date-nd_accept_date, 'dd日 HH24:MI') AS appl, to_char(nd_photo_date-nd_appl_date, 'dd日 HH24:MI') AS photo" .", to_char(nd_assign_date-nd_photo_date, 'dd日 HH24:MI') AS assign, to_char(nd_creation_date-nd_assign_date, 'dd日 HH24:MI') AS creation" . ", to_char(nd_completion_date-nd_creation_date, 'dd日 HH24:MI') AS completion, to_char(nd_dl_mail_date-nd_completion_date, 'dd日 HH24:MI') AS dl_mail" . ", to_char(nd_download_date-nd_dl_mail_date, 'dd日 HH24:MI') AS download" . " FROM t_nigaoe_data WHERE nd_nigaoe_id = $nd_id"; $result = db_exec($sql); if (pg_numrows($result) == 0) system_error("所属名IDが不正", __FILE__); $fetch = pg_fetch_object($result, 0); ?>