Index: branches/version-2/data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_Calendar.php =================================================================== --- branches/version-2/data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_Calendar.php (revision 17143) +++ branches/version-2/data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_Calendar.php (revision 17143) @@ -0,0 +1,165 @@ +setTplMainpage($bloc_file); + } + + /** + * Page のプロセス. + * + * @return void + */ + function process() { + if (defined("MOBILE_SITE") && MOBILE_SITE) { + $objView = new SC_MobileView(); + } else { + $objView = new SC_SiteView(); + } + + // 定休日取得取得 + $this->arrHoliday = $this->lfGetHoliday(); + + // カレンダーデータ取得 + $this->arrCalendar = $this->lfGetCalendar(2); + + $objView->assignobj($this); + $objView->display($this->tpl_mainpage); + } + + /** + * モバイルページを初期化する. + * + * @return void + */ + function mobileInit() { + $this->tpl_mainpage = MOBILE_TEMPLATE_DIR . "frontparts/" + . BLOC_DIR . 'best5.tpl'; + } + + /** + * Page のプロセス(モバイル). + * + * @return void + */ + function mobileProcess() { + $this->process(); + } + + /** + * デストラクタ. + * + * @return void + */ + function destroy() { + parent::destroy(); + } + + // カレンダー情報取得 + function lfGetCalendar($disp_month = 1){ + + for ($j = 0; $j <= $disp_month-1; ++$j) { + $year = date('Y'); + $month = date('n') + $j; + if ($month > 12) { + $month = $month%12; + $year = $year + $month%12; + } + + $Month = new Calendar_Month_Weekdays($year, $month, 0); + $Month->build(); + $i = 0; + while ($Day = $Month->fetch()) { + if ($month == $Day->month) { + $arrCalendar[$j][$i]['in_month'] = true; + } else { + $arrCalendar[$j][$i]['in_month'] = false; + } + $arrCalendar[$j][$i]['first'] = $Day->first; + $arrCalendar[$j][$i]['last'] = $Day->last; + $arrCalendar[$j][$i]['empty'] = $Day->empty; + $arrCalendar[$j][$i]['year'] = $year; + $arrCalendar[$j][$i]['month'] = $month; + $arrCalendar[$j][$i]['day'] = $Day->day; + if ($this->lfCheckHoliday($month, $Day->day) || $Day->first || $Day->last) { + $arrCalendar[$j][$i]['holiday'] = true; + } else { + $arrCalendar[$j][$i]['holiday'] = false; + } + ++$i; + } + } + + return $arrCalendar; + } + + // 休日取得 + function lfGetHoliday() { + $objQuery = new SC_Query(); + $objQuery->setorder("rank DESC"); + + $where = "del_flg <> 1"; + $arrRet = $objQuery->select("month, day", "dtb_holiday", $where); + foreach ($arrRet AS $key=>$val) { + $arrHoliday[$val['month']][] = $val['day']; + } + return $arrHoliday; + } + + // 休日チェック + function lfCheckHoliday($month, $day) { + if (!empty($this->arrHoliday[$month])) { + if (in_array($day, $this->arrHoliday[$month])) { + return true; + } + } + return false; + } + +} +?> Index: branches/version-2/data/class/pages/admin/basis/LC_Page_Admin_Basis_Holiday.php =================================================================== --- branches/version-2/data/class/pages/admin/basis/LC_Page_Admin_Basis_Holiday.php (revision 17143) +++ branches/version-2/data/class/pages/admin/basis/LC_Page_Admin_Basis_Holiday.php (revision 17143) @@ -0,0 +1,217 @@ +tpl_mainpage = 'basis/holiday.tpl'; + $this->tpl_subnavi = 'basis/subnavi.tpl'; + $this->tpl_subno = 'holiday'; + $this->tpl_subtitle = '定休日登録'; + $this->tpl_mainno = 'basis'; + } + + /** + * Page のプロセス. + * + * @return void + */ + function process() { + $conn = new SC_DBConn(); + $objView = new SC_AdminView(); + $objSess = new SC_Session(); + $objQuery = new SC_Query(); + $objDb = new SC_Helper_DB_Ex(); + + $objDate = new SC_Date(); + $this->arrMonth = $objDate->getMonth(); + $this->arrDay = $objDate->getDay(); + + // 認証可否の判定 + SC_Utils_Ex::sfIsSuccess($objSess); + + if (!isset($_POST['mode'])) $_POST['mode'] = ""; + + // 要求判定 + switch($_POST['mode']) { + // 編集処理 + case 'edit': + // POST値の引き継ぎ + $this->arrForm = $_POST; + // 入力文字の変換 + $this->arrForm = $this->lfConvertParam($this->arrForm); + + // エラーチェック + $this->arrErr = $this->lfErrorCheck(); + if(count($this->arrErr) <= 0) { + if($_POST['holiday_id'] == "") { + $this->lfInsertClass($this->arrForm); // 新規作成 + } else { + $this->lfUpdateClass($this->arrForm); // 既存編集 + } + // 再表示 + $this->reload(); + } else { + // POSTデータを引き継ぐ + $this->tpl_holiday_id = $_POST['holiday_id']; + } + break; + // 削除 + case 'delete': + $objDb->sfDeleteRankRecord("dtb_holiday", "holiday_id", $_POST['holiday_id'], "", true); + // 再表示 + $this->reload(); + break; + // 編集前処理 + case 'pre_edit': + // 編集項目をDBより取得する。 + $where = "holiday_id = ?"; + $arrRet = $objQuery->select("title, month, day", "dtb_holiday", $where, array($_POST['holiday_id'])); + // 入力項目にカテゴリ名を入力する。 + $this->arrForm['title'] = $arrRet[0]['title']; + $this->arrForm['month'] = $arrRet[0]['month']; + $this->arrForm['day'] = $arrRet[0]['day']; + // POSTデータを引き継ぐ + $this->tpl_holiday_id = $_POST['holiday_id']; + break; + case 'down': + $objDb->sfRankDown("dtb_holiday", "holiday_id", $_POST['holiday_id']); + // 再表示 + $this->reload(); + break; + case 'up': + $objDb->sfRankUp("dtb_holiday", "holiday_id", $_POST['holiday_id']); + // 再表示 + $this->reload(); + break; + default: + break; + } + + // 規格の読込 + $where = "del_flg <> 1"; + $objQuery->setorder("rank DESC"); + $this->arrHoliday = $objQuery->select("holiday_id, title, month, day", "dtb_holiday", $where); + + $objView->assignobj($this); + $objView->display(MAIN_FRAME); + } + + /** + * デストラクタ. + * + * @return void + */ + function destroy() { + parent::destroy(); + } + + /* DBへの挿入 */ + function lfInsertClass($arrData) { + $objQuery = new SC_Query(); + // INSERTする値を作成する。 + $sqlval['title'] = $arrData['title']; + $sqlval['month'] = $arrData['month']; + $sqlval['day'] = $arrData['day']; + $sqlval['creator_id'] = $_SESSION['member_id']; + $sqlval['rank'] = $objQuery->max("dtb_holiday", "rank") + 1; + $sqlval['update_date'] = "Now()"; + $sqlval['create_date'] = "Now()"; + // INSERTの実行 + $ret = $objQuery->insert("dtb_holiday", $sqlval); + return $ret; + } + + /* DBへの更新 */ + function lfUpdateClass($arrData) { + $objQuery = new SC_Query(); + // UPDATEする値を作成する。 + $sqlval['title'] = $arrData['title']; + $sqlval['month'] = $arrData['month']; + $sqlval['day'] = $arrData['day']; + $sqlval['update_date'] = "Now()"; + $where = "holiday_id = ?"; + // UPDATEの実行 + $ret = $objQuery->update("dtb_holiday", $sqlval, $where, array($_POST['holiday_id'])); + return $ret; + } + + /* 取得文字列の変換 */ + function lfConvertParam($array) { + // 文字変換 + $arrConvList['title'] = "KVa"; + $arrConvList['month'] = "n"; + $arrConvList['day'] = "n"; + + foreach ($arrConvList as $key => $val) { + // POSTされてきた値のみ変換する。 + if(isset($array[$key])) { + $array[$key] = mb_convert_kana($array[$key] ,$val); + } + } + return $array; + } + + /* 入力エラーチェック */ + function lfErrorCheck() { + $objErr = new SC_CheckError(); + $objErr->doFunc(array("タイトル", "title", SMTEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK")); + $objErr->doFunc(array("月", "month", INT_LEN), array("SELECT_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK")); + $objErr->doFunc(array("日", "day", INT_LEN), array("SELECT_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK")); + if(!isset($objErr->arrErr['date'])) { + $objQuery = new SC_Query(); + $where = "del_flg = 0 AND month = ? AND day = ?"; + $arrval = array($_POST['month'], $_POST['day']); + if (!empty($_POST['holiday_id'])) { + $where .= " AND holiday_id <> ?"; + $arrval[] = $_POST['holiday_id']; + } + $arrRet = $objQuery->select("count(holiday_id)", "dtb_holiday", $where, $arrval); + // 編集中のレコード以外に同じ日付が存在する場合 + if ($arrRet[0]['count'] > 0) { + $objErr->arrErr['date'] = "※ 既に同じ日付の登録が存在します。
"; + } + } + return $objErr->arrErr; + } +} +?>