Source for file LC_Page_Admin_Products_Trackback.php
Documentation is available at LC_Page_Admin_Products_Trackback.php
* This file is part of EC-CUBE
* Copyright(c) 2000-2007 LOCKON CO.,LTD. All Rights Reserved.
* http://www.lockon.co.jp/
* This program is free software; you can redistribute it and/or
* modify it under the terms of the GNU General Public License
* as published by the Free Software Foundation; either version 2
* of the License, or (at your option) any later version.
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
* You should have received a copy of the GNU General Public License
* along with this program; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
require_once(CLASS_PATH .
"pages/LC_Page.php");
require_once(CLASS_EX_PATH .
"helper_extends/SC_Helper_CSV_Ex.php");
* @author LOCKON CO.,LTD.
$this->tpl_subnavi =
'products/subnavi.tpl';
$this->tpl_subno =
'trackback';
$this->tpl_pager =
TEMPLATE_DIR .
'admin/pager.tpl';
$this->tpl_subtitle =
'トラックバック管理';
$this->arrPageMax =
$masterData->getMasterData("mtb_page_max");
$this->arrTrackBackStatus =
$masterData->getMasterData("mtb_track_back_status");
$objDate->setStartYear(RELEASE_YEAR);
$objDate->setEndYear(DATE("Y"));
$this->arrStartYear =
$objDate->getYear();
$this->arrStartMonth =
$objDate->getMonth();
$this->arrStartDay =
$objDate->getDay();
$objDate->setStartYear(RELEASE_YEAR);
$objDate->setEndYear(DATE("Y"));
$this->arrEndYear =
$objDate->getYear();
$this->arrEndMonth =
$objDate->getMonth();
$this->arrEndDay =
$objDate->getDay();
// トラックバック情報のカラムの取得(viewとの結合のため、テーブルをAと定義しておく)
$select =
"A.trackback_id, A.product_id, A.blog_name, A.title, A.url, ";
$select .=
"A.excerpt, A.status, A.create_date, A.update_date, B.name";
$from =
"dtb_trackback AS A LEFT JOIN dtb_products AS B ON A.product_id = B.product_id ";
foreach ($_POST as $key =>
$val) {
if (ereg("^search_", $key)) {
$this->arrHidden[$key] =
$val;
if (!isset
($_POST['mode'])) $_POST['mode'] =
"";
if ($_POST['mode'] ==
"delete") {
$objQuery->exec("UPDATE dtb_trackback SET del_flg = 1, update_date = now() WHERE trackback_id = ?", array($_POST['trackback_id']));
if ($_POST['mode'] ==
'search' ||
$_POST['mode'] ==
'csv' ||
$_POST['mode'] ==
'delete'){
$where=
"A.del_flg = 0 AND B.del_flg = 0";
foreach ($_POST as $key =>
$val) {
$where.=
" AND A.blog_name ILIKE ? ";
case 'search_blog_title':
$where.=
" AND A.title ILIKE ? ";
$where.=
" AND A.url ILIKE ? ";
if (isset
($_POST['search_status'])) {
$where.=
" AND A.status = ? ";
$where.=
" AND B.name ILIKE ? ";
case 'search_product_code':
$where.=
" AND B.product_id IN (SELECT product_id FROM dtb_products_class WHERE product_code ILIKE ? )";
if (isset
($_POST['search_startyear']) && isset
($_POST['search_startmonth']) && isset
($_POST['search_startday'])) {
$date =
sfGetTimestamp($_POST['search_startyear'], $_POST['search_startmonth'], $_POST['search_startday']);
$where.=
" AND A.create_date >= ? ";
if (isset
($_POST['search_startyear']) && isset
($_POST['search_startmonth']) && isset
($_POST['search_startday'])) {
$date =
sfGetTimestamp($_POST['search_endyear'], $_POST['search_endmonth'], $_POST['search_endday']);
$where.=
" AND A.create_date <= cast('$end_date' as date) ";
$order =
"A.create_date DESC";
$page_max =
$_POST['search_page_max'];
if (!isset
($arrval)) $arrval =
array();
$linemax =
$objQuery->count($from, $where, $arrval);
$this->tpl_linemax =
$linemax;
isset
($_POST['search_pageno']) ?
$_POST['search_pageno'] :
"";
$objNavi =
new SC_PageNavi($this->tpl_pageno, $linemax, $page_max,
"fnNaviSearchPage", NAVI_PMAX);
$this->arrPagenavi =
$objNavi->arrPagenavi;
$startno =
$objNavi->start_row;
$objQuery->setlimitoffset($page_max, $startno);
$objQuery->setorder($order);
$this->arrTrackback =
$objQuery->select($select, $from, $where, $arrval);
if ($_POST['mode'] ==
'csv'){
$option =
"ORDER BY A.trackback_id";
$head =
SC_Utils_Ex::sfGetCSVList($objCSV->arrTRACKBACK_CVSTITLE);
$data =
$objCSV->lfGetTrackbackCSV($where, '', $arrval);
$objView->assignobj($this);
$objView->display(MAIN_FRAME);
$objErr->doFunc(array("投稿者", "search_startyear", "search_startmonth", "search_startday"), array("CHECK_DATE"));
$objErr->doFunc(array("開始日", "search_startyear", "search_startmonth", "search_startday"), array("CHECK_DATE"));
$objErr->doFunc(array("終了日", "search_endyear", "search_endmonth", "search_endday"), array("CHECK_DATE"));
$objErr->doFunc(array("開始日", "終了日", "search_startyear", "search_startmonth", "search_startday", "search_endyear", "search_endmonth", "search_endday"), array("CHECK_SET_TERM"));
$objErr->doFunc(array("おすすめレベル", "recommend_level"), array("SELECT_CHECK"));
$objErr->doFunc(array("タイトル", "title", STEXT_LEN), array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK"));
$objErr->doFunc(array("コメント", "comment", LTEXT_LEN), array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK"));
Documentation generated on Tue, 28 Apr 2009 18:11:43 +0900 by phpDocumentor 1.4.2