$conditions = NULL;
$conditions[] = "iffree=1";
} elseif (isset($_GET['page']) && $_GET['page'] == 'all') {
setvar("Page", 'all');
$conditions = NULL;
}
if (isset($_GET['category'])) {
if ($_GET['category'] != 0) {
setvar("parent_id", $_GET['category']);
$conditions[] = "Product.category_id=" . $_GET['category'];
}
}
$conditions[] = "Product.status=1 ";
if (isset($_GET['p'])) {
if ($_GET['p'] == 'pg-search' && trim($_GET['search']) != '') {
$conditions[] = "Product.name like '%" . trim($_GET['search']) . "%'";
}
}
$joins = null;
if ($device_id != '') {
$joins[] = 'LEFT JOIN ' . $tb_prefix . 'productdevices d ON d.product_id=Product.id';
//$conditions[] = "d.device_id='" . $device_id . "' ";
}
$amount = $product->findCount(null, $conditions, "Product.id");
$page->displaypg = 5;
$page->setPagenav($amount);
$result = $product->findAll("DISTINCT Product.cache_companyname AS companyname,Product.*", $joins, $conditions, "Product.ifcommend desc,Product.id desc", $page->firstcount, $page->displaypg);
$result = $product->formatResultWap($result);
setvar("Items", $result);
setvar("ByPages", $page->getPagenav());
template("index");
<?php
/**
* [PHPB2B] Copyright (C) 2007-2099, Ualink Inc. All Rights Reserved.
* The contents of this file are subject to the License; you may not use this file except in compliance with the License.
*
* @version $Revision: 2075 $
*/
require "../libraries/common.inc.php";
require "room.share.php";
uses("trade", "product");
check_permission("offer");
$product = new Products();
$trade = new Trades();
$trade_controller = new Trade();
$trade_type_names = $trade_controller->getTradeTypes();
$conditions = "member_id = " . $the_memberid;
$amount = $pdb->GetArray("select Trade.type_id as TradeTypeId,count(Trade.id) as CountTrade from " . $trade->getTable(true) . " where " . $conditions . " group by Trade.type_id");
if (is_array($amount)) {
$stats = array();
foreach ($amount as $val) {
$stats[$val['TradeTypeId']] = array("Amount" => $val['CountTrade'], "name" => $trade_type_names[$val['TradeTypeId']]);
}
}
setvar("UserTradeStat", $stats);
setvar("ProductAmount", $product->findCount(null, $conditions, "Product.id"));
template("stat");
$producttype = new Producttypes();
$attachment = new Attachment('pic');
$conditions[] = "member_id = " . $the_memberid;
setvar("Countries", $countries = cache_read("country"));
setvar("ProductSorts", $_PB_CACHE['productsort']);
setvar("ProductTypes", $producttype->findAll('id,name', null, $conditions, "id DESC"));
setvar("Productcategories", $productcategory->getTypeOptions());
$tpl_file = "product";
if (!$company->Validate($companyinfo)) {
flash("pls_complete_company_info", "company.php", 0);
}
if (isset($_POST['save'])) {
$company->newCheckStatus($companyinfo['status']);
if (!empty($_POST['data']['product'])) {
$product->setParams();
$now_product_amount = $product->findCount(null, "created>" . $today_start . " AND member_id=" . $the_memberid);
$check_product_update = $g['product_check'];
if ($check_product_update == 0) {
$product->params['data']['product']['status'] = 1;
} else {
$product->params['data']['product']['status'] = 0;
$message_info = 'msg_wait_check';
}
if (isset($_POST['id'])) {
$id = intval($_POST['id']);
}
if (!empty($_FILES['pic']['name'])) {
$attach_id = empty($id) ? "product-" . $the_memberid . "-" . ($product->getMaxId() + 1) : "product-" . $the_memberid . "-" . $id;
$attachment->rename_file = $attach_id;
$attachment->upload_process();
$product->params['data']['product']['picture'] = $attachment->file_full_url;
if ($_GET['industryid']) {
$conditions[] = "Product.industry_id =" . $_GET['industryid'];
}
if ($_GET['provinceid']) {
$conditions[] = "c.province_code_id =" . $_GET['provinceid'];
}
if ($_GET['FromDate'] && $_GET['FromDate'] != "None" && $_GET['ToDate'] && $_GET['ToDate'] != "None") {
$condition = "Product.created BETWEEN ";
$condition .= Times::dateConvert($_GET['FromDate']);
$condition .= " AND ";
$condition .= Times::dateConvert($_GET['ToDate']);
$conditions[] = $condition;
}
}
}
$amount = $product->findCount($joins, $conditions, "Product.id");
unset($joins);
$joins[] = "LEFT JOIN {$tb_prefix}companies c ON c.id=Product.company_id";
$page->setPagenav($amount);
$fields = "Product.id,Product.company_id AS CompanyID,c.id AS CID,c.name AS companyname,Product.name AS ProductName,Product.status AS ProductStatus,Product.created,Product.if_commend as Ifcommend, Product.state as ProductState,Product.picture as ProductPicture ";
$result = $product->findAll($fields, $joins, $conditions, "Product.id DESC", $page->firstcount, $page->displaypg);
if (!empty($result)) {
for ($i = 0; $i < count($result); $i++) {
$result[$i]['pubdate'] = df($result[$i]['created']);
if (!empty($result[$i]['picture'])) {
$result[$i]['image'] = pb_get_attachmenturl($result[$i]['ProductPicture'], "../", "small");
}
}
}
setvar("Items", $result);
setvar("ByPages", $page->pagenav);
$product = new Products();
$producttype = new Producttypes();
$attachment = new Attachment('pic');
$conditions[] = "member_id = " . $_SESSION['MemberID'];
setvar("ProductSorts", $_PB_CACHE['productsort']);
setvar("ProductTypes", $producttype->findAll('id,name', null, $conditions, "id DESC"));
setvar("Productcategories", $productcategory->getTypeOptions());
$tpl_file = "product";
if (empty($companyinfo)) {
flash("pls_complete_company_info", "company.php", 0);
}
if (isset($_POST['save'])) {
$company->newCheckStatus($companyinfo['status']);
if (!empty($_POST['data']['product'])) {
$product->setParams();
$now_product_amount = $product->findCount(null, "created>" . $today_start . " AND member_id=" . $_SESSION['MemberID']);
$check_product_update = $g['product_check'];
if ($check_product_update == 0) {
$product->params['data']['product']['status'] = 1;
} else {
$product->params['data']['product']['status'] = 0;
$message_info = 'msg_wait_check';
}
if (isset($_POST['id'])) {
$id = intval($_POST['id']);
}
if (!empty($_FILES['pic']['name'])) {
$attach_id = empty($id) ? "product-" . $_SESSION['MemberID'] . "-" . ($product->getMaxId() + 1) : "product-" . $_SESSION['MemberID'] . "-" . $id;
$attachment->rename_file = $attach_id;
$attachment->upload_process();
$product->params['data']['product']['picture'] = $attachment->file_full_url;