PHP use_class函数代码示例

function setProductDescription2($products_id, $focus = null)
{
    use_class('element');
    $q = tep_db_query("SELECT * FROM products_description2 WHERE products_id={$products_id}");
    $pd2 = tep_db_fetch_array($q);
    $elements_used = $this->retrieveElementsUsed($products_id);
    if (!is_null($focus) && !is_array($focus)) {
        $focus = explode(',', $focus);
    }
    $need_tobe_filled_c = is_null($focus) || in_array('c', $focus) && ($pd2['clasp_type'] == '' || $pd2['clasp_type'] == 0) ? true : false;
    $need_tobe_filled_s = is_null($focus) || in_array('s', $focus) && ($pd2['setting_type'] == '' || $pd2['setting_type'] == 0) ? true : false;
    if ($need_tobe_filled_c || $need_tobe_filled_s) {
        $sda = array();
        foreach ($elements_used as $eid) {
            $el = new element($eid);
            if ($need_tobe_filled_c && !isset($sda['clasp_type']) && $sda['clasp_type'] == '') {
                $sda['clasp_type'] = $el->attributes['clasp']['id'];
            }
            if ($need_tobe_filled_s && !isset($sda['setting_type']) && $sda['setting_type'] == '') {
                $sda['setting_type'] = $el->attributes['setting']['id'];
            }
        }
        if (count($sda) > 0) {
            if (tep_db_num_rows($q) > 0) {
                tep_db_perform('products_description2', $sda, 'update', "products_id={$products_id}");
            } else {
                $sda['products_id'] = $products_id;
                tep_db_perform('products_description2', $sda);
            }
        }
    }
}

function generateKeywords($product_id)
{
    use_class('styles');
    use_class('Product');
    use_class('ProductAttribute');
    $class_s = new styles();
    $keywords = array();
    $product = new Product($product_id);
    $language_id = 2;
    //Step 1 (Brand)
    if ($product->brand_id == 24) {
        $keywords = array(strtolower($product->brand_name), 'eli', 'silberschmuck', '925', 'junger', 'modischer', 'trendy', 'fashion');
    } elseif ($product->brand_id == 3) {
        $keywords = array(strtolower($product->brand_name), 'vergoldet', 'golden', 'gold', 'vermeil');
    } elseif ($product->brand_id == 7) {
        $keywords = array(strtolower($product->brand_name), 'perlenschmuck', 'brautschmuck', 'hochzeit');
    }
    //Step 2 (Symbol)
    $symbol = $class_s->getProductStyle($product_id);
    if ($symbol['Symbol'] > 0) {
        $style = new ProductAttribute($symbol['Symbol']);
        if ($symbol['Symbol'] != '') {
            array_push($keywords, strtolower($style->displayAttributeName($product_id, ProductAttribute::GROUP_ID_SYMBOL, $language_id)));
        }
    }
    //Step 3 (Basic)
    array_push($keywords, 'günstiger', 'frau', 'freundin', 'geschenk', 'juwelier');
    //Step 4 (Material)
    $materials = array();
    $q = "SELECT ptpm.products_materials_id AS id" . " , material_name AS name" . " FROM products_to_products_materials ptpm" . " INNER JOIN products_materials pm" . " ON pm.products_materials_id = ptpm.products_materials_id" . " WHERE ptpm.products_id = {$product_id}";
    $r = tep_db_query($q);
    while ($row = tep_db_fetch_array($r)) {
        $materials[$row['id']] = $row['name'];
    }
    foreach ($materials as $key => $value) {
        if ($key == 4 || $key == 2) {
            list($material_name2, $material_name1, $material_name3) = split(",", $value);
            array_push($keywords, strtolower($material_name2), 'glamourös', 'funkelnd', 'glitzernd', 'strass', 'festlich', 'elegant');
        } else {
            list($material_name2, $material_name1, $material_name3) = split(",", $value);
            array_push($keywords, strtolower($material_name2));
        }
    }
    //Step 5 (Color)
    $color = $product->getColors($language_id);
    array_push($keywords, strtolower($color));
    //Step 6 (Rest of the products)
    array_push($keywords, 'basic', 'klassik', 'klassisch', 'schlicht', 'elegant', 'zeitlos', 'sportlich', 'dezent', 'filigran', 'zart', 'schlicht');
    $final_k = implode(',', $keywords);
    //echo $pid." = ".$final_k;
    $sda = array();
    $sda['products_head_keywords_tag'] = $final_k;
    tep_db_perform('products_description', $sda, 'update', "products_id={$product_id} AND language_id={$language_id}");
}

 public function getMembersGroup()
 {
     use_class('minierp_users');
     $class_mu = new minierp_users();
     if (!is_null($this->id)) {
         $q = "SELECT * FROM minierp_groups_members WHERE minierp_groups_id={$this->id}";
         $r = tep_db_query($q);
         if (tep_db_num_rows($r) > 0) {
             while ($row = tep_db_fetch_array($r)) {
                 $users_id[] = $row['minierp_users_id'];
             }
             $users_ids = implode(",", $users_id);
             $members = $class_mu->retrieveList('id IN (' . $users_ids . ')');
             return $members;
         }
     }
     return false;
 }

 function setParams($products_id, $param_code)
 {
     use_class('products_minierp');
     $class_pm = new products_minierp();
     if ($param_code == 'M') {
         $param_id_arrays = $class_pm->loadProductMaterials($products_id);
         $field_name = 'material';
     } elseif ($param_code == 'C') {
         $param_id_arrays = $class_pm->loadColorPattern($products_id);
         $field_name = 'color';
     } else {
         $param_id_arrays = array();
         $field_name = '';
     }
     if ($field_name != '') {
         if (count($param_id_arrays) == 0) {
             $sda = array($field_name => '');
             tep_db_perform('jng_sp_catalog', $sda, 'update', "products_id = {$products_id}");
         } else {
             use_class('jng_sp_catalog');
             $class_jc = new jng_sp_catalog();
             $q = tep_db_query("SELECT jng_sp_catalog_id, jng_sp_id FROM jng_sp_catalog WHERE products_id = {$products_id}");
             $sp_list = array();
             while ($row = tep_db_fetch_array($q)) {
                 $sp_list[$row['jng_sp_catalog_id']] = $row['jng_sp_id'];
             }
             foreach ($sp_list as $catalog_id => $jng_sp_id) {
                 $sp_params_raw = $this->load($jng_sp_id, $param_code);
                 $sp_params = array();
                 foreach ($sp_params_raw as $spr) {
                     if (in_array($spr['param_id'], $param_id_arrays)) {
                         $sp_params[] = $spr['param_value'];
                     }
                 }
                 $sda = array($field_name => implode(', ', $sp_params));
                 $class_jc->updateField($catalog_id, $sda);
             }
         }
     }
 }

function loadProductRow($pid, $spid, $pos, $curgroup_id)
{
    global $class_jc, $header;
    use_class('Product');
    $product = new Product($pid);
    $sp_catalog = $class_jc->retrieveCatalog($spid, "jc.products_id = '{$pid}'");
    $cols = array();
    foreach ($header as $hk => $hv) {
        $value = '';
        switch ($hk) {
            case 'img':
                $value .= $product->displayImage(IMAGE_SIZE_THUMBNAIL_1, IMAGE_SIZE_THUMBNAIL_1);
                break;
            case 'name':
                $value .= '<strong>' . $product->brand_name . '</strong>';
                $value .= '<br /><a href="?open=product-detail&amp;products_id=' . $product->id . '" target="_blank">' . $product->id . ' / ' . $product->code . '</a>';
                break;
            case 'imgup':
                $img_reupload = $sp_catalog[0]['image_uploaded'] == '0' ? 'checked="checked" ' : '';
                $tooltip = $sp_catalog[0]['image_uploaded'] == '0' ? "Uncheck to exclude this product image when generate catalog" : "Check to include this product image when generate catalog";
                $value = '<input type="checkbox" name="imguploaded" value="0" title="' . $tooltip . '" ' . $img_reupload . '/>';
                break;
            case 'prcup':
                $price_reupload = $sp_catalog[0]['price_uploaded'] == '0' ? 'checked="checked" ' : '';
                $tooltip = $sp_catalog[0]['price_uploaded'] == '0' ? "Uncheck to exclude this product data when generate catalog" : "Check to include this product data when generate catalog";
                $value = '<input type="checkbox" name="priceuploaded" value="0" title="' . $tooltip . '" ' . $price_reupload . '/>';
                break;
        }
        if ($value == '') {
            $value = '&nbsp;';
        }
        $cols[$hk] = $value;
    }
    $productrow = '<tr id="temp-' . $pid . '">';
    foreach ($cols as $ck => $cv) {
        $productrow .= '<td class="' . $ck . '">' . $cv . '</td>';
    }
    $productrow .= '</tr>';
    return $productrow;
}

<?php

ini_set('memory_limit', '256M');
set_time_limit(0);
$mt_start = microtime();
global $db;
require_once '../confy.php';
require_once '../functions.php';
require_once '../functions-2.php';
tep_db_connect();
use_class('logger');
$logger = new logger('cron', 'daily-counter');
use_class('jng_sp');
use_class('jng_sp_orders');
use_class('jng_sp_catalog');
$class_sp = new jng_sp();
$class_jo = new jng_sp_orders();
$class_jc = new jng_sp_catalog();
$sp_data = $class_sp->retrieveList();
//////////////////////////////
// SP PRODUCTS SOLD COUNTER //
//////////////////////////////
$logger->write('1 - Product Sold Counter');
//TODO: The calculation is still based on jng_sp_catalog, which means SP with no
//catalog (like buyvip/retails) will not be included in this calculation!
foreach ($sp_data as $sp_list) {
    $class_jo->productsSoldCounter($sp_list['jng_sp_id']);
}
unset($sp);
/* WE STOP CALCULATING VC USING OLD METHOD
 * NEW VC CALCULATION IS NOT IN ORDER BASED, BUT IN SP BASED

     if ($booked > 0) {
         $messagebox->add("<strong>Clear Bin Failed</strong><br />Clear Bin is not allowed if On Stock and Booked by Real Order &gt; 0");
     } else {
         $class_bin->removeProductFromBox($bins_id);
         if ($bin['p_stock'] > 0) {
             $class_pm->stockReduce($jng_warehouses_id, $products_id, $articles_id, $bin['p_stock'], "REDUCE by {$session_userinfo['username']}");
         }
         header("Location: ?open=products-stock-detail&binid={$bin['bins_id']}" . ($hidemenuscript != '' ? '&hidemenu=true' : ''));
         exit;
     }
 } elseif ($_POST['me_action'] == 'SETBIN') {
     $bins_id = tep_db_prepare_input($_POST['bins_id']);
     $bin = $class_bin->retrieveBinDetail($bins_id);
     $ean = tep_db_prepare_input($_POST['ean']);
     $qty = tep_db_prepare_input($_POST['qty']);
     use_class('products_ean');
     $class_ean = new products_ean();
     $article = $class_ean->getProductArticle($ean);
     if ($article['products_id'] == '0') {
         $messagebox->add("<strong>Manual Bin In Failed: UNKNOWN EAN</strong><br />Please check if correct EAN Label is used");
     } else {
         $segment = $class_bin->retrieveSegmentDetail($bin['bin_segments_id']);
         $jng_warehouses_id = $segment['warehouses_id'];
         $products_id = $article['products_id'];
         $articles_id = $article['products_articles_id'];
         $stock = $class_pm->stockRetrieveDetail($jng_warehouses_id, $products_id, $articles_id);
         $bin_current = $class_bin->getBinProductStock($stock['products_stock_id']);
         if (is_null($bin_current)) {
             $class_pm->stockAdd($jng_warehouses_id, $products_id, $articles_id, $qty, "MANUAL BIN-IN by {$session_userinfo['username']}");
             $class_bin->bookBinForProduct($bins_id, $stock['products_stock_id']);
             header("Location: ?open=products-stock-detail&id={$stock['products_stock_id']}" . ($hidemenuscript != '' ? '&hidemenu=true' : ''));

<?php

#########################################
#  Author  : D3W4 & SAHAT               #
#  Created : May 8, 2012 8:46:25 PM    #
#########################################
use_class('notifications');
$notifications = new notifications();
if (isset($_GET['sender']) && $_GET['sender'] != '') {
    $sender = tep_db_prepare_input($_GET['sender']);
    $filter = "AND posted_by = '{$sender}'";
}
if (isset($_POST['me_action'])) {
    if ($_POST['me_action'] == 'DELETENOTIFICATIONS') {
        $ids = $_POST['ids'];
        list($notifications_id, $not_class) = split('-', $ids);
        $notifications->delete($notifications_id);
        $result = array();
        $result['notifications_id'] = $notifications_id;
        $result['not_class'] = $not_class;
        ajaxReturn($result);
        exit;
    } elseif ($_POST['me_action'] == 'CLOSEFEEDBACK') {
        $ids = $_POST['ids'];
        list($notifications_id, $not_class) = split('-', $ids);
        $notifications->closeOpenFeedback($notifications_id);
        $result = array();
        $result['ids'] = $ids;
        $result['notifications_id'] = $notifications_id;
        ajaxReturn($result);
        exit;

 * @created Sep 24, 2013 3:09:23 PM
 */
set_time_limit(0);
global $db;
require_once '../confy.php';
require_once '../functions.php';
require_once '../functions-2.php';
tep_db_connect();
use_class('logger');
$logger = new logger('cron', 'depot-refill');
//$logger->write('SIMULATION');
//Include Required Classes (and create object when necessary)
use_class('Product');
use_class('products_minierp');
use_class('depot_orders');
use_class('styles');
$class_pm = new products_minierp();
$class_do = new depot_orders();
$class_s = new styles();
$whid = WAREHOUSE_ID_FOR_HANDLING_ORDERS;
$segment_id = SEGMENT_ID_DEFAULT;
//Grab all data that can be retrieved collectively for the whole products
//stock from below function already exclude active booking
$products_stock = $class_pm->stockRetrieveAll($whid, '', true);
//Grab all required Settings
Product::loadDIOHsettings();
//For now we can not run auto cancel in Manobo Local due to the
//sync issues of Depot Orders with Manobo Central
if (!SERVER_IS_LOCAL) {
    //query all auto refill orders currently open
    //and can still be canceled(grouped by article)

$cellsize = 48;
$cellsize_half = $cellsize / 2;
$cellsizecollweek = $cellsize + $margin;
$cell_height_col = 55;
$cell_height = 5;
$pdf->setXY($margin, $ypos);
$pdf->setFont('Arial', 'B', '14');
$pdf->cell(240, 5, 'SALES REPORT WEEKLY PRODUCT KW ' . date('W') . ' (' . date('d.m.Y', strtotime($filter_date)) . ')', 0, 0, 'C');
$pdf->setFont('Arial', '', '10');
$ypos += 10;
$pdf->setXY($cellstart, $ypos);
$firstorder = true;
$no = 1;
$catids = load_config('products-categories-sorting');
if (SERVER_IS_LOCAL) {
    use_class('CategoryTop');
    //load all categories which not sorted
    while ($ct = CategoryTop::getOneByOneAsObject()) {
        if ($ct->getCategoriesTotalCount() > 0) {
            while ($cat = $ct->getCategoriesOneByOneAsObject()) {
                if (!in_array($cat->id, $catids)) {
                    $catids[] = $cat->id;
                }
            }
        }
    }
}
foreach ($catids as $catid) {
    $header = true;
    if (is_array($products[$catid])) {
        foreach ($products[$catid] as $pid => $p) {

<?php

/**
 * Description of top-level-analysis
 *
 * @author IT TEAM BONOFACTUM
 * @created May 9, 2013
 */
use_class('Product');
use_class('products_brand');
$class_pb = new products_brand();
define('REPORT_TABLE_TYPE_CATEGORY', 'Product Category');
define('REPORT_TABLE_TYPE_PRICEGROUP', 'Price Group');
define('REPORT_TABLE_TYPE_BRAND', 'Product Brand');
function buildQueryPriceGroup($alias_key, $begin, $end)
{
    //return " WHEN rc.price >= $begin AND rc.price <= $end THEN '$alias_key'";
    return " WHEN rc.price_before_return >= {$begin} AND rc.price_before_return <= {$end} THEN '{$alias_key}'";
}
function queryData($table_type, $sp, $start_date, $end_date)
{
    global $product_categories_name, $class_pb;
    switch ($table_type) {
        case REPORT_TABLE_TYPE_CATEGORY:
            $join_column_alias = $product_categories_name;
            $join_column = 'ptc.categories_id';
            $join_table = ' LEFT JOIN products_to_categories ptc' . ' ON ptc.products_id = rc.products_id';
            $group_column = 'categories_id';
            break;
        case REPORT_TABLE_TYPE_PRICEGROUP:
            $bgst = Product::getOldProductFunction()->retrieveBestGoodSettings();

/**
 * Description of dailycounterbookkeeping
 *
 * @author IT TEAM BONOFACTUM
 * @created Mar 12, 2014 12:27:59 PM
 */
set_time_limit(0);
ini_set('memory_limit', '512M');
global $db;
require_once '../confy.php';
require_once '../functions.php';
require_once '../functions-2.php';
tep_db_connect();
use_class('logger');
$logger = new logger('cron', 'daily-counter-bookkeeping');
use_class('ReportBookkeeping');
if (isset($_GET['period_start']) && isset($_GET['period_end'])) {
    //WHEN CALLED MANUALLY WITH SPECIFIC PERIOD
    //ONLY DISPLAY RESULT FROM REQUESTED DATA WITHOUT SAVING
    $calc_period_start = isset($_GET['period_start']) ? $_GET['period_start'] : date('Ym');
    $calc_period_end = isset($_GET['period_end']) ? $_GET['period_end'] : date('Ym');
    $year_start = substr($calc_period_start, 0, 4);
    $month_start = substr($calc_period_start, 4, 2);
    $year_end = substr($calc_period_end, 0, 4);
    $month_end = substr($calc_period_end, 4, 2);
    if ($year_end < $year_start || $year_end == $year_start && $month_end < $month_start) {
        die('Period end > Period start!');
    } else {
        for ($y = $year_start; $y <= $year_end; $y++) {
            $m_start = $y == $year_start ? intval($month_start) : 1;
            $m_end = $y == $year_end ? intval($month_end) : 12;

<?php

use_class('production_instruction_manual');
$session_page = 'production-instruction-manual';
if (!isset($_SESSION[$session_page]['picatid']) || $_SESSION[$session_page]['picatid'] == '') {
    $PICAT = 0;
} else {
    $PICAT = $_SESSION[$session_page]['picatid'];
}
$reloadlist = isset($_GET['reloadlist']) && $_GET['reloadlist'] == 'true' ? true : false;
if (isset($_POST['me_action'])) {
    if ($_POST['me_action'] == 'LOADPI') {
        $PICAT = tep_db_prepare_input($_POST['catid']);
        $_SESSION[$session_page]['picatid'] = $PICAT;
        $stab = array();
        $s = array();
        $pi = production_instruction_manual::retrieveList($PICAT);
        if (count($pi) == 0) {
            $pi_table = '<h3 class="red">No Production Instruction is found on database for this category </h3>';
            $action_buttons = '';
        } else {
            $s['qty'] = '<input id="pi-checkall" type="checkbox" />';
            $s['id'] = 'ID';
            $s['active'] = 'Active';
            $s['name'] = 'Name';
            $s['desc'] = 'Description';
            $stab[] = $s;
            foreach ($pi as $row) {
                $s = array();
                $s['qty'] = '<input type="checkbox" name="piids[]" value="' . $row['production_instruction_id'] . '" />';
                $s['id'] = $row['production_instruction_id'];

<?php

global $db;
require_once '../confy.php';
require_once '../functions.php';
require_once '../functions-2.php';
tep_db_connect();
use_class('PHPExcel/PHPExcel');
use_class('Product');
use_class('depot_orders');
use_class('products_minierp');
use_class('elements_suppliers');
$class_do = new depot_orders();
$class_pm = new products_minierp();
$order_date = $_GET['date'];
$order_date_ts = strtotime($order_date);
$supplier_id = $_GET['supplier_id'];
$supplier = new elements_suppliers($supplier_id);
$filename = date('Ymd', $order_date_ts) . '-OutsourcingPO-' . $supplier->getCleanName() . '-' . time() . '.xls';
$order_date_nice = date('d.m.Y', $order_date_ts);
$po_number_sample = date('ymd', $order_date_ts) . '/' . $supplier->id . '/001';
$date_filter_start = $order_date . ' 00:00:00';
$date_filter_end = $order_date . ' 23:59:59';
$jng_company_name = utf8_encode(JNG_ADDRESS_NAME . ' - ' . JNG_COMPANY_SUFFIX);
$jng_address = utf8_encode(JNG_ADDRESS_STREET);
$jng_shipto_recepient = utf8_encode('Ms. Julia Schüssel');
$orders_items = array();
if (isset($_GET['type']) && $_GET['type'] == 'non-refill') {
    $trans_type = depot_orders::TRANS_TYPE_NON_REFILL;
    $trans_id = depot_orders::NONREFILL_OUTSOURCED_ID;
} else {

$content .= '<div id="showopt" class="bold">';
$content .= '<div id="showmore">&raquo; Show <span class="show">' . $show_amount . '</span> more out of <span class="more"></span></div>';
$content .= '<div id="showall">&raquo; Show ALL (<span class="more"></span>)</div>';
$content .= '</div>';
// #showopt
$content .= '<div style="display:none;">';
$content .= '<div id="printstocklist" style="width:500px;height:400px;padding:10px;">';
$content .= '<div id="errornotype" class="ui-corner-all" style="position:absolute;top:35px;left:200px;border:2px solid #f00;padding:10px 20px;color:#f00;display:none;">&laquo; Please Select a Type</div>';
$content .= '<table border="0" cellpadding="0" cellspacing="0">';
$content .= '<tr><td colspan="2"><h3>Stock List Type:</h3></td></tr>';
$content .= '<tr><td><input id="rad-slt-1" type="radio" name="type" value="FULL" /></td><td><label for="rad-slt-1">Full Stock Info</label></td></tr>';
$content .= '<tr><td><input id="rad-slt-2" type="radio" name="type" value="BLANK" /></td><td><label for="rad-slt-2">Blank / No Stock Info</label></td></tr>';
$content .= '<tr><td colspan="2">&nbsp;</td></tr>';
$content .= '<tr><td colspan="2"><h3>Filter by Category:</h3></td></tr>';
$content .= '<tr><td><input id="rad-cat-0" type="radio" name="catid" value="0" /></td><td><label for="rad-cat-0">Show All Elements</label></td></tr>';
use_class('elements_attributes');
$class_ea = new elements_attributes();
$categories = $class_ea->retrieveListData('cat');
foreach ($categories as $cat) {
    $catid = $cat['element_category_id'];
    $checked = $cat['element_category_id'] == '3' ? ' checked="checked"' : '';
    $content .= '<tr><td><input id="rad-cat-' . $catid . '" type="radio" name="catid" value="' . $catid . '"' . $checked . '/></td><td><label for="rad-cat-' . $catid . '">' . $cat['name'] . '</label></td></tr>';
}
$content .= '</table>';
$content .= '<div class="buttons"><input id="printstocklist-action" type="button" value="PRINT" /></div>';
$content .= '</div>';
// #printstocklist
$content .= '</div>';
// #printstocklist hider container
$content .= '<a id="pritnstocklistlinker" class="view_inline" href="#printstocklist"></a>';
$javascript = '