File: //home/bk/__backup/api/Suppliers.php
<?php
require_once('Mgc.php');
class Suppliers extends Mgc {
public $categories = array();
/*Выбираем все склады*/
public function get_suppliers($filter = array()) {
$limit = 100;
$page = 1;
$category_id_filter = '';
$category_join = '';
$visible_filter = '';
$product_id_filter = '';
$product_join = '';
$visible_supplier_filter = '';
$features_filter = '';
$other_filter = '';
if(isset($filter['limit'])) {
$limit = max(1, intval($filter['limit']));
}
if(isset($filter['page'])) {
$page = max(1, intval($filter['page']));
}
$sql_limit = $this->db->placehold(' LIMIT ?, ? ', ($page-1)*$limit, $limit);
if(isset($filter['visible'])) {
$visible_filter = $this->db->placehold('AND p.visible=?', intval($filter['visible']));
}
if(isset($filter['visible_supplier'])) {
$visible_supplier_filter = $this->db->placehold('AND s.visible=?', intval($filter['visible_supplier']));
}
if(isset($filter['product_id'])) {
$product_id_filter = $this->db->placehold('AND p.id in (?@)', (array)$filter['product_id']);
$product_join = $this->db->placehold("LEFT JOIN __products p ON p.supplier_id=s.id");
}
if(!empty($filter['category_id'])) {
$category_join = $this->db->placehold("LEFT JOIN __products p ON p.supplier_id=s.id LEFT JOIN __products_categories pc ON p.id = pc.product_id");
$category_id_filter = $this->db->placehold("AND pc.category_id in(?@) $visible_filter", (array)$filter['category_id']);
}
if(!empty($filter['features'])) {
foreach($filter['features'] as $feature=>$value) {
$features_filter .= $this->db->placehold('AND p.id in (SELECT product_id FROM __options WHERE feature_id=? AND translit in(?@) ) ', $feature, (array)$value);
}
if (empty($category_join)) {
$features_filter .= $visible_filter;
$category_join = $this->db->placehold("LEFT JOIN __products p ON (p.supplier_id=s.id)");
}
}
if (!empty($filter['other_filter'])) {
$other_filter = "AND (";
if (in_array("featured", $filter['other_filter'])) {
$other_filter .= "p.featured=1 OR ";
}
if (in_array("discounted", $filter['other_filter'])) {
$other_filter .= "(SELECT 1 FROM __variants pv WHERE pv.product_id=p.id AND pv.compare_price>0 LIMIT 1) = 1 OR ";
}
$other_filter = substr($other_filter, 0, -4).")";
if (empty($category_join)) {
$other_filter .= $visible_filter;
$category_join = $this->db->placehold("LEFT JOIN __products p ON (p.supplier_id=s.id)");
}
}
$lang_sql = $this->languages->get_query(array('object'=>'supplier'));
// Выбираем все поставщикы
$query = $this->db->placehold("SELECT
DISTINCT s.id,
s.url,
s.image,
s.last_modify,
s.visible,
s.position,
$lang_sql->fields
FROM __suppliers s
$lang_sql->join
$category_join
$product_join
WHERE
1
$category_id_filter
$features_filter
$visible_supplier_filter
$product_id_filter
$other_filter
ORDER BY s.position
$sql_limit
");
// echo $query;
// exit;
$this->db->query($query);
//var_dump($this->db->results());
return $this->db->results();
}
function get_categories($supp_id){
$this->db->query('SELECT s.*,c.name as cname FROM __categories_suppliers s LEFT JOIN __categories c ON c.id=s.cat_id WHERE s.supplier_id=? ', $supp_id);
$cats = $this->db->results();
$categories = array();
foreach ($cats as $k=> $cat){
$categories[$cat->parent_id][$cat->sup_id] = $cat;
//var_dump($categories);
}
// exit;
return $categories;
foreach ($cats as $k=> $cat){
if((int)$cat->parent_id==0){
$categories[(string)$cat->sup_id] = $cat;
$categories[(string)$cat->sup_id]->level = 1;
unset($cats[$k]);
}
}
foreach ($cats as $k=> $cat){
if($cat->parent_id!=0 && isset($categories[(int)$cat->parent_id])){
$categories[(string)$cat->parent_id]->childs[(int)$cat->sup_id] = $cat;
$categories[(string)$cat->parent_id]->level=2;
unset($cats[$k]);
}
else{
//var_dump();
// echo " error need 3d level ".$cat->parent_id.$cat->title.PHP_EOL;
}
}
foreach ($cats as $k=> $cat){
if(isset($cat->childs)){
foreach($cat->childs as $k1=>$v){
if((int)$k1==(string)$cat->parent_id){
$categories[$k]->childs[(int)$k1] = $cat;
$categories[(string)$cat->parent_id]->level=3;
unset($cats[$k]);
}
}
}
}
// var_dump($categories);exit;
return $categories;
}
public function count_suppliers($filter = array()) {
$category_id_filter = '';
$category_join = '';
$visible_filter = '';
$product_id_filter = '';
$product_join = '';
$visible_supplier_filter = '';
$features_filter = '';
$other_filter = '';
if(isset($filter['visible'])) {
$visible_filter = $this->db->placehold('AND p.visible=?', intval($filter['visible']));
}
if(isset($filter['visible_supplier'])) {
$visible_supplier_filter = $this->db->placehold('AND s.visible=?', intval($filter['visible_supplier']));
}
if(isset($filter['product_id'])) {
$product_id_filter = $this->db->placehold('AND p.id in (?@)', (array)$filter['product_id']);
$product_join = $this->db->placehold("LEFT JOIN __products p ON p.supplier_id=s.id");
}
if(!empty($filter['category_id'])) {
$category_join = $this->db->placehold("LEFT JOIN __products p ON p.supplier_id=s.id LEFT JOIN __products_categories pc ON p.id = pc.product_id");
$category_id_filter = $this->db->placehold("AND pc.category_id in(?@) $visible_filter", (array)$filter['category_id']);
}
if(!empty($filter['features'])) {
foreach($filter['features'] as $feature=>$value) {
$features_filter .= $this->db->placehold('AND p.id in (SELECT product_id FROM __options WHERE feature_id=? AND translit in(?@) ) ', $feature, (array)$value);
}
if (empty($category_join)) {
$features_filter .= $visible_filter;
$category_join = $this->db->placehold("LEFT JOIN __products p ON (p.supplier_id=s.id)");
}
}
if (!empty($filter['other_filter'])) {
$other_filter = "AND (";
if (in_array("featured", $filter['other_filter'])) {
$other_filter .= "p.featured=1 OR ";
}
if (in_array("discounted", $filter['other_filter'])) {
$other_filter .= "(SELECT 1 FROM __variants pv WHERE pv.product_id=p.id AND pv.compare_price>0 LIMIT 1) = 1 OR ";
}
$other_filter = substr($other_filter, 0, -4).")";
if (empty($category_join)) {
$other_filter .= $visible_filter;
$category_join = $this->db->placehold("LEFT JOIN __products p ON (p.supplier_id=s.id)");
}
}
$lang_sql = $this->languages->get_query(array('object'=>'supplier'));
// Выбираем все поставщикы
$query = $this->db->placehold("SELECT
count(distinct s.id) as count
FROM __suppliers s
$lang_sql->join
$category_join
$product_join
WHERE
1
$category_id_filter
$features_filter
$visible_supplier_filter
$product_id_filter
$other_filter
");
$this->db->query($query);
return $this->db->result('count');
}
/*Выбираем конкретный поставщик*/
public function get_supplier($id) {
if (empty($id)) {
return false;
}
if(is_int($id)) {
$filter = $this->db->placehold('AND s.id = ?', intval($id));
} else {
$id = $this->translit_alpha($id);
$filter = $this->db->placehold('AND s.url = ?', $id);
}
$lang_sql = $this->languages->get_query(array('object'=>'supplier'));
$query = "SELECT
s.*,
$lang_sql->fields
FROM __suppliers s
$lang_sql->join
WHERE
1
$filter
LIMIT 1
";
// echo($query);
$this->db->query($query);
return $this->db->result();
}
/*Добавление поставщика*/
public function add_supplier($supplier) {
$supplier = (object)$supplier;
if(isset($supplier->url)){
$supplier->url = preg_replace("/[\s]+/ui", '', $supplier->url);
$supplier->url = strtolower(preg_replace("/[^0-9a-z]+/ui", '', $supplier->url));
}else{
$supplier->url = '';
}
if(empty($supplier->url)) {
$supplier->url = $this->translit_alpha($supplier->name);
}
while($this->get_supplier((string)$supplier->url)) {
if(preg_match('/(.+)([0-9]+)$/', $supplier->url, $parts)) {
$supplier->url = $parts[1].''.($parts[2]+1);
} else {
$supplier->url = $supplier->url.'2';
}
}
// Проверяем есть ли мультиязычность и забираем описания для перевода
$result = $this->languages->get_description($supplier, 'supplier');
$this->db->query("INSERT INTO __suppliers SET ?%", $supplier);
//die($supplier);
$id = $this->db->insert_id();
$this->db->query("UPDATE __suppliers SET position=id WHERE id=? LIMIT 1", $id);
// Если есть описание для перевода. Указываем язык для обновления
if(!empty($result->description)) {
$this->languages->action_description($id, $result->description, 'supplier');
}
return $id;
}
/*Обновление поставщика*/
public function update_supplier($id, $supplier) {
$supplier = (object)$supplier;
// Проверяем есть ли мультиязычность и забираем описания для перевода
$result = $this->languages->get_description($supplier, 'supplier');
$query = $this->db->placehold("UPDATE __suppliers SET ?% WHERE id=? LIMIT 1", $supplier, intval($id));
$this->db->query($query);
// Если есть описание для перевода. Указываем язык для обновления
if(!empty($result->description)) {
$this->languages->action_description($id, $result->description, 'supplier', $this->languages->lang_id());
}
return $id;
}
/*Обновление поставщика*/
public function update_cat_supplier($id, $supplier) {
$supplier = (object)$supplier;
$query = $this->db->placehold("UPDATE __categories_suppliers SET ?% WHERE id=? LIMIT 1", $supplier, intval($id));
$this->db->query($query);
return $id;
}
/*Удаление поставщика*/
public function delete_supplier($id) {
if(!empty($id)) {
$this->image->delete_image($id, 'image', 'suppliers', $this->config->original_suppliers_dir, $this->config->resized_suppliers_dir);
$query = $this->db->placehold("DELETE FROM __suppliers WHERE id=? LIMIT 1", $id);
$this->db->query($query);
$query = $this->db->placehold("UPDATE __products SET supplier_id=NULL WHERE supplier_id=?", $id);
$this->db->query($query);
$this->db->query("DELETE FROM __lang_suppliers WHERE supplier_id=?", $id);
}
}
}