function get($id)
{
$id = getID($id);
static $q = null;
\cf\createStaticQuery($q, "SELECT IFNULL(code,id) AS id, file, file_name, file FROM cf_file WHERE id=:id");
return \cf\query2array($q, array('id' => $id));
}
function get($id)
{
$id = getID($id);
static $q = null;
\cf\createStaticQuery($q, "SELECT id, code, name, action, method, template FROM cf_form WHERE id=:id");
$form = \cf\query2array($q, array('id' => $id));
if ($form['template']) {
$form['template'] = \cf\query2array("\n\t\t\tSELECT name, subject, recipient, body \n\t\t\tFROM cf_mail_templates \n\t\t\tWHERE id=:id", array('id' => $form['template']));
} else {
$form['template'] = false;
}
static $qFields = null;
\cf\createStaticQuery($qFields, "\n\t\tSELECT code,type,name,fmt,descr,mandatory,max_length,min_length,value\n\t\tFROM cf_form_field\n\t\tWHERE form_id=:id\n\t\tORDER BY sort_order\n\t");
$form['fields'] = \cf\query2arrays($qFields, array('id' => $id), false, 'code');
foreach ($form['fields'] as &$f) {
$f['code'] = $form['code'] . '[' . $f['code'] . ']';
if ($f['type'] == 'radio' || $f['type'] == 'checkbox') {
$f['options'] = array();
foreach (explode(';', $f['fmt']) as $option) {
$f['options'][] = trim($option);
}
}
}
return $form;
}
public static function get($id)
{
$id = self::getID($id);
if (!$id) {
return false;
}
static $q = null;
if (!$q) {
\cf\createStaticQuery($q, 'SELECT * FROM cf_page WHERE id=:id');
}
$page = \cf\query2array($q, array('id' => $id));
if (!$page['code']) {
$page['code'] = $page['id'];
}
$parent = $page['parent_id'] ? self::get($page['parent_id']) : null;
$page['path'] = ($parent ? $parent['path'] : '') . '/' . ($page['permalink'] ? $page['permalink'] : $page['id']);
if (!$page['link']) {
$page['link'] = $page['path'];
}
$page['branch'] = array_merge($parent ? $parent['branch'] : array(), array($page));
$page['parent'] = false;
if (count($page['branch']) > 1) {
$page['parent'] =& $page['branch'][count($page['branch']) - 2];
}
$page['root'] =& $page['branch'][0];
return $page;
}
function get($id, $rootID = null)
{
static $q = null;
\cf\createStaticQuery($q, '
SELECT id, IFNULL(code,id) AS code, parent_id, name, menu_name, link, short_txt, title, keywords, descr, icon, hidden, sort_order
FROM cf_page
WHERE id=:id
');
$page = $parent = \cf\query2array($q, array('id' => getID($id)));
if (empty($page)) {
return false;
}
$path = $branch = array();
$depth = 0;
$rootID = getID($rootID);
while (true) {
if ($parent['id'] == $rootID) {
break;
}
$path[] = $parent['code'];
$branch[] = $parent;
++$depth;
if (!$parent['parent_id']) {
break;
}
$parent = get($parent['parent_id'], $rootID);
}
$page['path'] = '/' . implode('/', array_reverse($path));
$page['parent'] = count($branch) > 1 ? $branch[1] : null;
$page['branch'] = array_reverse($branch);
$page['depth'] = $depth;
return $page;
}
function getAction($id, $params = array())
{
$action = \cf\query2array('
SELECT * FROM cf_admin_action WHERE id=:id', array('id' => $id));
$action['params'] = array();
$action['params_query'] = '';
if ($action['params_id']) {
$action['params'] = \cf\query2arrays('
SELECT name, type_id AS type, title, default_val AS value, mandatory, max_length, min_length, fmt, default_val, tree_id, list_id
FROM cf_admin_action_param
WHERE params_id=:id
ORDER BY sort_order', array('id' => $action['params_id']));
$action['params_query'] = \cf\query2var('SELECT query FROM cf_admin_action_params WHERE id=:id', array('id' => $action['params_id']));
if (!empty($params) && $action['params_query']) {
$values = \cf\query2array($action['params_query'], $params);
for ($i = 0; $i < count($action['params']); ++$i) {
if (array_key_exists($action['params'][$i]['name'], $values)) {
$action['params'][$i]['value'] = $values[$action['params'][$i]['name']];
if ($action['params'][$i]['type'] == 'File') {
$action['params'][$i]['is_image'] = @getimagesize($_SERVER['DOCUMENT_ROOT'] . '/' . $action['params'][$i]['value']) != false;
}
}
}
}
for ($i = 0; $i < count($action['params']); ++$i) {
$p = $action['params'][$i];
$action['params'][$i]['options'] = explode(';', $p['fmt']);
$action['params'][$i]['dict_value'] = false;
if ($p['tree_id'] || $p['list_id']) {
$v = getView($p['tree_id'] ? $p['tree_id'] : $p['list_id']);
$action['params'][$i]['view'] = $v;
$action['params'][$i]['dict_value'] = \cf\query2var('SELECT ' . $v['name_field'] . ' FROM ' . (preg_match('/^\\w+$/', $v['query']) ? $v['query'] : '(' . $v['query'] . ') t') . ' WHERE ' . $v['primary_key_field'] . '=:id', array('id' => $p['value']));
}
}
}
return $action;
}
cf\api\admin\doAction('product_in_group_add', array('group_id' => $catMatch[$fromCat]['to_id'], 'product_id' => $pid, 'sort_order' => 500));
}
}
global $addedCount;
++$addedCount;
return $pid;
}
}
$stop = false;
$offersCount = 0;
$addedCount = 0;
$updatedCount = 0;
$deletedCount = 0;
$foundIDs = array();
try {
$settings = cf\query2array("SELECT * FROM cf_import_yml WHERE id=:id", array('id' => $ymlID));
$sellerID = $settings['seller'];
$newState = $settings['new_state'];
$_SERVER['DOCUMENT_ROOT'] = getcwd() . "/../../../..";
$delFile = false;
if ($argc > 2) {
//second argument is a TMP file path to load data from
$settings['url'] = $argv[2];
$delFile = true;
}
$fieldsMatch = array('NAME' => array(), 'MODEL' => array(), 'TYPEPREFIX' => array(), 'DESCRIPTION' => array(), 'URL' => array('link'), 'PRICE' => array('price'), 'VENDOR' => array('manufacturer_id'), 'VENDORCODE' => array('article'));
$fieldsMatch[strtoupper($settings['name_from'])][] = 'name';
if ($settings['model_from']) {
$fieldsMatch[strtoupper($settings['model_from'])][] = 'model';
}
if ($settings['short_descr_from']) {
}
$user = cf\User::getLoggedIn();
if (!$user && !defined('NO_AUTH')) {
forward('login.php');
}
if (!defined('SMARTY_DIR')) {
define('SMARTY_DIR', cf\Config::smarty_dir);
}
require_once SMARTY_DIR . 'Smarty.class.php';
$smarty = new Smarty();
$smarty->compile_check = true;
$smarty->debugging = false;
$smarty->addPluginsDir(cf\Config::path . 'components/');
$root_url = substr($_SERVER['REQUEST_URI'], 0, stripos($_SERVER['REQUEST_URI'], 'admin') + 6);
if ($user) {
$uprofile = cf\query2array("SELECT desktop_url,hide_navigation FROM cf_users WHERE id=:id", array('id' => $user->id()));
if ($uprofile['desktop_url']) {
if ($root_url == $_SERVER['REQUEST_URI'] || $root_url . 'index.php' == $_SERVER['REQUEST_URI']) {
forward($uprofile['desktop_url']);
}
$root_url = $uprofile['desktop_url'];
}
$smarty->assign('uprofile', $uprofile);
}
$smarty->assign('root_url', $root_url);
date_default_timezone_set('Europe/Moscow');
$smarty->assign('user', $user);
$smarty->assign('siteName', cf\Config::site);
$mainmenu = cf\api\admin\getCategories();
$smarty->assign('mainmenu', $mainmenu);
class MainMenu
<?php
if (strlen($pathInfo['notfound'])) {
$news = cf\query2array("\n\t\tSELECT * FROM cf_news WHERE id=:id OR code=:id", array('id' => $pathInfo['notfound']));
$page['keywords'] = $news['tag_meta_keywords'];
$page['descr'] = $news['tag_meta_descr'];
$page['title'] = $news['tag_title'];
$page['name'] = $news['name'];
$page['template'] = 'article';
$crumbs[] = array('name' => $news['name']);
$pageText = $news['txt'];
$productIDs = cf\query2vector("\n\t\tSELECT product_id AS id FROM cf_products_in_news WHERE news_id=:newsid ORDER BY sort_order\n\t", array('newsid' => $news['id']));
$products = array();
foreach ($productIDs as $pid) {
$products[] = cf\api\shop\getProduct($pid);
}
$smarty->assign('products', prepareProducts($products));
return true;
}
$smarty->assign('newslist', cf\query2arrays("\n\tSELECT IFNULL(code,cf_news.id) AS code,name,image,short_txt \n\tFROM cf_news \n\tINNER JOIN cf_news_in_category ON cf_news.id=cf_news_in_category.news_id\n\tWHERE cf_news_in_category.category_id = :pid\n\tORDER BY dt DESC\n", array('pid' => $page['id'])));
function getImage($id)
{
$image = \cf\query2array("\r\n\t\tSELECT * FROM cf_gallery_images WHERE id=:id", array('id' => $id));
$image['albums'] = \cf\query2arrays("\r\n\t\tSELECT cf_gallery_albums.id, IFNULL(cf_gallery_albums.code,cf_gallery_albums.id) AS code, name, image, hidden \r\n\t\tFROM cf_gallery_image_in_album \r\n\t\tINNER JOIN cf_gallery_albums ON album_id=cf_gallery_albums.id\r\n\t\tWHERE image_id=:id", array('id' => $id));
return $image;
}
