コード例 #1
0
 public static function formData($id = null)
 {
     global $lC_Database, $lC_DateTime;
     $result = array();
     if (isset($id) && is_numeric($id)) {
         $lC_ObjectInfo = new lC_ObjectInfo(lC_Products_Admin::get($id));
         $Qdata = $lC_Database->query('select pa.value as products_date_available from :table_product_attributes pa, :table_templates_boxes tb where tb.code = :code and tb.modules_group = :modules_group and tb.id = pa.id');
         $Qdata->bindTable(':table_product_attributes', TABLE_PRODUCT_ATTRIBUTES);
         $Qdata->bindTable(':table_templates_boxes', TABLE_TEMPLATES_BOXES);
         $Qdata->bindValue(':code', 'date_available');
         $Qdata->bindValue(':modules_group', 'product_attributes');
         $Qdata->execute();
         $lC_ObjectInfo->set('products_date_available', $Qdata->value('products_date_available'));
         $result['pDate'] = $lC_ObjectInfo->get('products_date_available');
         $Qdata->freeResult();
     }
     return $result;
 }
コード例 #2
0
ファイル: coupons.php プロジェクト: abhiesa-tolexo/loaded7
 public function __construct()
 {
     global $lC_Database, $lC_Language, $cInfo;
     $this->_page_title = $lC_Language->get('heading_title');
     $action = isset($_GET['action']) && empty($_GET['action']) === false ? preg_replace('/[^a-z\\s]/', '', $_GET['action']) : NULL;
     switch ($action) {
         case 'save':
             if (is_numeric($_GET[$this->_module])) {
                 $cInfo = new lC_ObjectInfo(lC_Coupons_Admin::get($_GET[$this->_module]));
                 $Qcd = $lC_Database->query('select * from :table_coupons_description where coupons_id = :coupons_id');
                 $Qcd->bindTable(':table_coupons_description', TABLE_COUPONS_DESCRIPTION);
                 $Qcd->bindInt(':coupons_id', $cInfo->get('coupons_id'));
                 $Qcd->execute();
                 $name = array();
                 while ($Qcd->next()) {
                     $name[$Qcd->valueInt('language_id')] = $Qcd->value('name');
                 }
                 $cInfo->set('name', $name);
             }
             break;
     }
 }
コード例 #3
0
ファイル: edit.php プロジェクト: rajeshb001/itpl_loaded7
  @package    catalog::admin::applications
  @author     Loaded Commerce
  @copyright  Copyright 2003-2014 Loaded Commerce, LLC
  @copyright  Portions Copyright 2003 osCommerce
  @copyright  Template built on Developr theme by DisplayInline http://themeforest.net/user/displayinline under Extended license 
  @license    https://github.com/loadedcommerce/loaded7/blob/master/LICENSE.txt
  @version    $Id: edit.php v1.0 2013-08-08 datazen $
*/
$lC_ObjectInfo = new lC_ObjectInfo(lC_Products_Admin::get($_GET['pID']));
$Qdata = $lC_Database->query('select str_to_date(pa.value, "%Y-%m-%d") as products_date_available from :table_product_attributes pa, :table_templates_boxes tb where tb.code = :code and tb.modules_group = :modules_group and tb.id = pa.id');
$Qdata->bindTable(':table_product_attributes', TABLE_PRODUCT_ATTRIBUTES);
$Qdata->bindTable(':table_templates_boxes', TABLE_TEMPLATES_BOXES);
$Qdata->bindValue(':code', 'date_available');
$Qdata->bindValue(':modules_group', 'product_attributes');
$Qdata->execute();
$lC_ObjectInfo->set('products_date_available', $Qdata->value('products_date_available'));
?>
<h1><?php 
echo lc_link_object(lc_href_link_admin(FILENAME_DEFAULT, $lC_Template->getModule()), $lC_Template->getPageTitle());
?>
</h1>
<?php 
if ($lC_MessageStack->exists($lC_Template->getModule())) {
    echo $lC_MessageStack->get($lC_Template->getModule());
}
?>
<div class="infoBoxHeading"><?php 
echo lc_icon_admin('edit.png') . ' ' . $lC_ObjectInfo->getProtected('products_name');
?>
</div>
<div class="infoBoxContent">