/**
* Delete category
*
* @param void
* @return null
*/
function delete_category()
{
if ($this->active_category->isNew()) {
$this->httpError(HTTP_ERR_NOT_FOUND);
}
// if
if ($this->request->isSubmitted()) {
$delete = $this->active_category->delete();
if ($delete && !is_error($delete)) {
if ($this->request->getFormat() == FORMAT_HTML) {
flash_success('Category :category_name has been deleted', array('category_name' => $this->active_category->getName()));
$this->redirectToUrl($this->smarty->get_template_vars('categories_url'));
} else {
$this->serveData($this->active_category, 'category');
}
// if
} else {
if ($this->request->getFormat() == FORMAT_HTML) {
flash_error('Failed to delete :category_name', array('category_name' => $this->active_category->getName()));
$this->redirectToUrl($this->smarty->get_template_vars('categories_url'));
} else {
$this->serveData($delete);
}
// if
}
// if
} else {
$this->httpError(HTTP_ERR_BAD_REQUEST);
}
// if
}
function test_getName()
{
$name = "Work stuff";
$test_Category = new Category($name);
$result = $test_Category->getName();
$this->assertEquals($name, $result);
}
public function index()
{
$type = Param::get('type', self::TYPE_THREAD);
$query = trim_collapse(Param::get('query'));
$page = Param::get('page', 1);
$pagination = new SimplePagination($page, self::RESULTS_PERPAGE);
if (!$query) {
redirect(APP_URL);
}
$results = new stdClass();
switch ($type) {
case self::TYPE_THREAD:
$results = Thread::search($query, $pagination->start_index - 1, $pagination->count + 1);
// Get other info for each thread
foreach ($results->result as $thread) {
$thread->creator = User::getByID($thread->user_id);
$thread->category = Category::getName($thread->category_id);
$thread->replies_count = Comment::countAll($thread->id);
}
break;
case self::TYPE_COMMENT:
$results = Comment::search($query, $pagination->start_index - 1, $pagination->count + 1);
break;
case self::TYPE_USER:
$results = User::search($query, $pagination->start_index - 1, $pagination->count + 1);
break;
default:
throw new PageNotFoundException();
break;
}
$pagination->checkLastPage($results->result);
$pages = ceil($results->total_result / self::RESULTS_PERPAGE);
$title = "Search: '{$query}'";
$this->set(get_defined_vars());
}
public static function getAllCategoriesFromDatabase($dbConn)
{
$categoryIds = readFromDatabase::readEntireColumnFromTable($dbConn, array(self::ID_COLUMN_NAME), self::TABLE_NAME);
$categories = array();
foreach ($categoryIds as $categoryId) {
$category = new Category($dbConn, $categoryId[self::ID_COLUMN_NAME]);
$categories[$category->getId()] = $category->getName();
}
return $categories;
}
function test_getName()
{
//Arrange
$name = "Work stuff";
$test_Category = new Category($name);
//Act
$result = $test_Category->getName();
//Assert
$this->assertEquals($name, $result);
}
protected function modify(Category $category)
{
$q = $this->dao->prepare('UPDATE ' . $this->table() . ' SET NAME = :name, DESCRIPTION = :description, PARENT_CATEGORY_ID = :parentCategoryId, IS_ROOT = :isRoot WHERE ID = :id');
$q->bindValue(':name', $category->getName());
$q->bindValue(':description', $category->getDescription());
$q->bindValue(':parentCategoryId', $category->getParentCategoryId());
$q->bindValue(':isRoot', $category->getIsRoot());
$q->bindValue(':id', $category->id(), PDO::PARAM_INT);
$q->execute();
}
function action_category()
{
if (isset($_GET['id']) && $_GET['id'] > 0) {
$id = DB::esc(intval($_GET['id']));
$category = new Category($id, $this->model);
$this->view->setData(array("category" => $category));
$this->view->setTitle($category->getName());
$this->view->display('category_view.php');
} else {
$this->action_404();
}
}
public function edit(User $currentUser, Category $category)
{
$id = intval($category->getId());
$name = $this->database->quote($category->getName());
$description = $this->database->quote($category->getDescription());
$query = "UPDATE category SET name = '" . $name . "', description = '" . $description . "' WHERE id = " . $id;
$result = $this->database->exec($query);
if ($result) {
return true;
} else {
throw new Exception("Catastrophe base de données.");
}
}
function testUpdate()
{
//Arrange
$name = "Work stuff";
$id = 1;
$test_category = new Category($name, $id);
$test_category->save();
$new_name = "Home stuff";
//Act
$test_category->update($new_name);
//Assert
$this->assertEquals("Home stuff", $test_category->getName());
}
/**
* @param Category $category
* @return WikiaMobileCategoryViewer
*/
public function getItemsCollection(Category $category)
{
$this->wf->profileIn(__METHOD__);
$cacheKey = $this->getItemsCollectionCacheKey($category->getName());
$contents = $this->wg->memc->get($cacheKey);
if (empty($contents)) {
/**
* @var $wikiaMobileCategoryViewer WikiaMobileCategoryViewer
*/
$wikiaMobileCategoryViewer = F::build('WikiaMobileCategoryViewer', array($category));
$contents = $wikiaMobileCategoryViewer->getContents();
$this->wg->memc->set($cacheKey, $contents, self::CACHE_TTL_ITEMSCOLLECTION);
}
$this->wf->profileOut(__METHOD__);
return $contents;
}
protected function getCategoryArray($id_product)
{
/*
$controlFraude = new TPProductoControlFraude($id_product);
return $controlFraude->codigo_producto;
*/
$controlFraude = new Product($id_product);
$categories = $controlFraude->getDefaultCategory();
$category_id = $categories[0];
$category = new Category($category_id);
$name = $category->getName();
if (empty($name)) {
return "default";
}
return $name;
}
public function create($name, $description, $img)
{
$category = new Category($this->db);
$errors = array();
try {
$category->setName($name);
} catch (Exception $e) {
$errors[] = $e->getMessage();
}
try {
$category->setDescription($description);
} catch (Exception $e) {
$errors[] = $e->getMessage();
}
try {
$category->setImg($img);
} catch (Exception $e) {
$errors[] = $e->getMessage();
}
if (count($errors) == 0) {
$name = $this->db->quote($category->getName());
$description = $this->db->quote($category->getDescription());
$img = $this->db->quote($category->getImg());
$query = "INSERT INTO category (name, description, img) VALUES(" . $name . "," . $description . "," . $img . ")";
$res = $this->db->exec($query);
if ($res) {
$id = $this->db->lastInsertId();
if ($id) {
return $this->findById($id);
} else {
$errors[] = "Category not found";
return $errors;
}
} else {
$errors[] = "Internal server error";
return $errors;
}
} else {
return $errors;
}
}
static function findAllCategories()
{
$default_category = new Category('default');
$categories = array();
foreach (Project::findAllProjects() as $project) {
if ($name = $project->getCategory()) {
if (!isset($categories[$name])) {
$category = new Category($name);
$categories[$name] = $category;
} else {
$category = $categories[$name];
}
} else {
$categories[$default_category->getName()] = $default_category;
$category = $default_category;
}
$category->addProject($project);
}
ksort($categories);
return array_values($categories);
}
public function index()
{
$page = Param::get('page', 1);
$filter = Param::get('filter');
// pagination
$pagination = new SimplePagination($page, self::THREADS_PERPAGE);
$threads = Thread::getAll($pagination->start_index - 1, $pagination->count + 1, $filter);
$pagination->checkLastPage($threads);
$total = Thread::countAll($filter);
$pages = ceil($total / self::THREADS_PERPAGE);
// Get other info for each thread
foreach ($threads as $thread) {
$thread->creator = User::getByID($thread->user_id);
$thread->category = Category::getName($thread->category_id);
$thread->replies_count = Comment::countAll($thread->id);
}
// get other variables needed by the view
$title = 'All Threads';
$auth_user = User::getAuthenticated();
$categories = Category::getAll();
$trending = Thread::getTrending(self::TRENDING_LIMIT);
$this->set(get_defined_vars());
}
protected function itemExportCategories($row, $product)
{
// Url in 1.5.2.0 wrong (thickbox_default)
//Categories
$category = new Category($product->id_category_default);
$row['categories'] = $category->getName($this->id_lang);
return $row;
}
$t->is(count($category), 0, 'findOne() called after select(array) returns an empty array if no record is found');
$category1 = new Category();
$category1->setName('cat1');
$category1->save();
$category2 = new Category();
$category2->setName('cat2');
$category2->save();
$finder = sfPropelFinder::from('Category')->
select(array('Id','Name'), sfModelFinder::ASSOCIATIVE);
$category = $finder->findOne();
$t->isa_ok($category, 'array', 'The row returned by findOne() called after select(array) is an array');
$t->is_deeply(array_keys($category), array('Id', 'Name'), 'The row returned by findOne() called after select(array, sfModelFinder::ASSOCIATIVE) is an associative array where the keys are the requested column names');
$t->is($category['Id'], $category1->getId(), 'The row returned by findOne() called after select(array, sfModelFinder::ASSOCIATIVE) is an associative array where the values are the requested column values');
$t->is($category['Name'], $category1->getName(), 'The row returned by findOne() called after select(array, sfModelFinder::ASSOCIATIVE) is an associative array where the values are the requested column values');
$finder = sfPropelFinder::from('Category')->
select(array('Id','Name'), sfModelFinder::SIMPLE);
$category = $finder->findOne();
$t->is_deeply(array_keys($category), array(0, 1), 'The row returned by findOne() called after select(array, sfModelFinder::SIMPLE) is an array with numeric keys');
$t->is($category[0], $category1->getId(), 'The row returned by findOne() called after select(array, sfModelFinder::SIMPLE) is an array where the values are the requested column values');
$t->is($category[1], $category1->getName(), 'The row returned by findOne() called after select(array, sfModelFinder::SIMPLE) is an array where the values are the requested column values');
/*********************************************/
/* sfPropelFinder::select() and withColumn() */
/*********************************************/
$t->diag('sfPropelFinder::select() and withColumn()');
ArticlePeer::doDeleteAll();
<h3 class="title">查看 图片 #<?php
echo $model->id;
?>
</h3>
<?php
$this->widget('zii.widgets.CDetailView', array('data' => $model, 'attributes' => array('id', 'title', array('name' => 'pid', 'value' => Category::getName($model->pid)), array('name' => 'img', 'value' => CHtml::link(CHtml::image('http://7xssk6.com2.z0.glb.clouddn.com/' . $model->img, '图片', array('width' => '150px')), 'http://7xssk6.com2.z0.glb.clouddn.com/' . $model->img, array("target" => "_blank")), 'type' => 'raw'), 'des', 'orderid', array('name' => 'is_show', 'value' => $model->is_show == 1 ? "是" : "否"), 'create_at:datetime', array('name' => 'create_uid', 'value' => User::getName($model->create_uid)))));
function addProducts($client, $ids = array())
{
//update currency
// update_currency();
$default_tz = date_default_timezone_get();
date_default_timezone_set('UTC');
$category = new Category(1, 1);
$sql = "select p.id_product, DATEDIFF(NOW(), p.`date_add`) as 'age'\n from ps_product p\n where p.price > 0 and p.active = 1";
$productScores = array();
$products = Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS($sql);
foreach ($products as $product) {
$productScores[$product['id_product']] = array('age' => $product['age'], 'week_sold' => 0, 'month_sales' => 0, 'year_sales' => 0);
}
$sql = "select p.`id_product`, sum(od.product_quantity) as 'quantity'\n from `ps_product` p\n inner join `ps_order_detail` od on od.product_id = p.id_product\n inner join ps_orders o on o.id_order = od.id_order\n where p.price > 0 \n and p.active = 1\n and o.date_add > now() - INTERVAL 7 DAY\n group by p.id_product";
$week_quantities = Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS($sql);
foreach ($week_quantities as $week_quantity) {
$productScores[$week_quantity['id_product']]['week_sold'] = $week_quantity['quantity'];
}
$sql = "select p.`id_product`, round(sum(od.product_quantity * od.product_price * 55 / o.`conversion_rate`)) as 'month_revenue'\n from `ps_product` p\n inner join `ps_order_detail` od on od.product_id = p.id_product\n inner join ps_orders o on o.id_order = od.id_order\n where p.price > 0 and p.active = 1\n and o.date_add > now() - INTERVAL 30 DAY\n group by p.id_product";
$month_sales = Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS($sql);
foreach ($month_sales as $month_sale) {
$productScores[$month_sale['id_product']]['month_sales'] = $month_sale['month_revenue'];
}
$sql = "select p.`id_product`, round(sum(od.product_quantity * od.product_price * 55 / o.`conversion_rate`)) as 'year_revenue'\n from `ps_product` p\n inner join `ps_order_detail` od on od.product_id = p.id_product\n inner join ps_orders o on o.id_order = od.id_order\n where p.price > 0 and p.active = 1\n and o.date_add > now() - INTERVAL 365 DAY\n group by p.id_product";
$year_sales = Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS($sql);
foreach ($year_sales as $year_sale) {
$productScores[$year_sale['id_product']]['year_sales'] = $year_sale['year_revenue'];
}
foreach ($products as $product) {
$productScores[$product['id_product']]['score'] = getWeekSalesScore($productScores[$product['id_product']]['week_sold']) + getAgeScore($productScores[$product['id_product']]['age']) + getMonthScore($productScores[$product['id_product']]['month_sales']) + getYearScore($productScores[$product['id_product']]['year_sales']);
}
$docs = array();
$link = new Link();
$count = 0;
$update = $client->createUpdate();
foreach ($products as $product) {
if (!empty($ids) && !in_array((int) $product['id_product'], $ids)) {
continue;
}
$productObj = new Product((int) $product['id_product'], true, 1);
print_r('\\n' . 'reindexing ' . $product['id_product']);
if (!$productObj->active) {
deleteProduct($productObj->id, $client);
continue;
}
$doc = $update->createDocument();
$doc->id_product = $productObj->id;
$doc->reference = $productObj->reference;
$doc->name = $productObj->name;
$doc->description = preg_replace('@[\\x00-\\x08\\x0B\\x0C\\x0E-\\x1F]@', ' ', $productObj->description);
$doc->description_short = preg_replace('@[\\x00-\\x08\\x0B\\x0C\\x0E-\\x1F]@', ' ', $productObj->description_short);
$doc->brand_id = $productObj->id_manufacturer;
$doc->brand_name = $productObj->manufacturer_name;
$doc->style_tips = $productObj->description_short;
$doc->alphaNameSort = $productObj->name;
$dbresult = $productObj->getWsCategories();
$catIds = array();
foreach ($dbresult as $catIdRow) {
$catIds[] = $catIdRow['id'];
}
$category_names = array();
foreach ($catIds as $catID) {
$category = new Category((int) $catID);
$category_names[] = $category->getName(1);
}
$doc->cat_name = $category_names;
$doc->cat_id = $catIds;
$doc->tags = $productObj->getTags(1);
$doc->shipping_sla = $productObj->shipping_sla ? $productObj->shipping_sla : 0;
$doc->weight = $productObj->weight ? $productObj->weight : 0.5;
if (isset($productObj->work_type)) {
$doc->work_type = preg_replace('@[\\x00-\\x08\\x0B\\x0C\\x0E-\\x1F]@', ' ', $productObj->work_type ? $productObj->work_type : '');
}
if (isset($productObj->garment_type)) {
$doc->garment_type = preg_replace('@[\\x00-\\x08\\x0B\\x0C\\x0E-\\x1F]@', ' ', $productObj->garment_type ? $productObj->garment_type : '');
}
if (isset($productObj->blouse_length)) {
$doc->blouse_length = $productObj->blouse_length ? $productObj->blouse_length : '';
}
$doc->height = $productObj->height;
$doc->width = $productObj->width;
$atributeQty = Attribute::getAttributeQty($productObj->id);
if ($productObj->quantity > 0 || $atributeQty > 0) {
$doc->inStock = true;
} else {
$doc->inStock = false;
}
$doc->isPlusSize = $productObj->is_plussize ? true : false;
$doc->isRTS = $productObj->is_rts ? true : false;
$doc->quantity = $productObj->quantity ? $productObj->quantity : ($atributeQty ? $atributeQty : 0);
//Indian Price
$doc->offer_price_in = Product::getPriceStatic($productObj->id, true, NULL, 6, NULL, false, true, 1, false, NULL, NULL, IND_ADDRESS_ID);
$doc->offer_price_in_rs = Tools::convertPrice($doc->offer_price_in, 4);
$doc->mrp_in = Product::getPriceStatic($productObj->id, true, NULL, 6, NULL, false, false, 1, false, NULL, NULL, IND_ADDRESS_ID);
if ($doc->mrp_in > $doc->offer_price_in) {
$doc->discount_in = Tools::ps_round(($doc->mrp_in - $doc->offer_price_in) / $doc->mrp_in * 100);
}
//Worldwide Price
$doc->offer_price = $productObj->getPrice();
$doc->offer_price_rs = Tools::convertPrice($doc->offer_price, 4);
$doc->mrp = $productObj->getPriceWithoutReduct();
if ($doc->mrp > $doc->offer_price) {
$doc->discount = Tools::ps_round(($doc->mrp - $doc->offer_price) / $doc->mrp * 100);
}
$date = DateTime::createFromFormat('Y-m-d H:i:s', $productObj->date_add);
$doc->date_add = $date->format("Y-m-d\\TG:i:s\\Z");
$doc->product_link = $productObj->getLink();
$idImage = $productObj->getCoverWs();
if ($idImage) {
$idImage = $productObj->id . '-' . $idImage;
} else {
$idImage = Language::getIsoById(1) . '-default';
}
$doc->image_link_list = $link->getImageLink($productObj->link_rewrite, $idImage, 'list');
$doc->image_link_medium = $link->getImageLink($productObj->link_rewrite, $idImage, 'medium');
$doc->image_link_large = $link->getImageLink($productObj->link_rewrite, $idImage, 'large');
$images = $productObj->getImages(1);
$productImages = array();
foreach ($images as $k => $image) {
$productImages[] = $link->getImageLink($productObj->link_rewrite, $image['id_image'], 'large');
}
$doc->image_links = $productImages;
$doc->sales = $productScores[$product['id_product']]['score'];
$productObj->fabric = trim($productObj->fabric);
$productObj->fabric = preg_replace('/\\s+/', '-', $productObj->fabric);
$doc->fabric = strtolower($productObj->fabric);
$doc->is_customizable = $productObj->is_customizable;
if (isset($productObj->generic_color) && !empty($productObj->generic_color)) {
$colors = explode(',', $productObj->generic_color);
$indexed_colors = array();
foreach ($colors as $color) {
$indexed_colors[] = strtolower(preg_replace('/\\s+/', '-', trim($color)));
}
$doc->color = $indexed_colors;
}
if (isset($productObj->stone) && !empty($productObj->stone)) {
$stones = explode(',', $productObj->stone);
$indexed_stones = array();
foreach ($stones as $stone) {
$indexed_stones[] = strtolower(preg_replace('/\\s+/', '-', trim($stone)));
}
$doc->stone = $indexed_stones;
}
if (isset($productObj->plating) && !empty($productObj->plating)) {
$platings = explode(',', $productObj->plating);
$indexed_platings = array();
foreach ($platings as $plating) {
$indexed_platings[] = strtolower(preg_replace('/\\s+/', '-', trim($plating)));
}
$doc->plating = $indexed_platings;
}
if (isset($productObj->material) && !empty($productObj->material)) {
$materials = explode(',', $productObj->material);
$indexed_materials = array();
foreach ($materials as $material) {
$indexed_materials[] = strtolower(preg_replace('/\\s+/', '-', trim($material)));
}
$doc->material = $indexed_materials;
}
if (isset($productObj->look) && !empty($productObj->look)) {
$looks = explode(',', $productObj->look);
$indexed_looks = array();
foreach ($looks as $look) {
$indexed_looks[] = strtolower(preg_replace('/\\s+/', '-', trim($look)));
}
$doc->look = $indexed_looks;
}
if (isset($productObj->handbag_occasion) && !empty($productObj->handbag_occasion)) {
$handbag_occasions = explode(',', $productObj->handbag_occasion);
$indexed_handbag_occasions = array();
foreach ($handbag_occasions as $handbag_occasion) {
$indexed_handbag_occasions[] = strtolower(preg_replace('/\\s+/', '-', trim($handbag_occasion)));
}
$doc->handbag_occasion = $indexed_handbag_occasions;
}
if (isset($productObj->handbag_style) && !empty($productObj->handbag_style)) {
$handbag_styles = explode(',', $productObj->handbag_style);
$indexed_handbag_styles = array();
foreach ($handbag_styles as $handbag_style) {
$indexed_handbag_styles[] = strtolower(preg_replace('/\\s+/', '-', trim($handbag_style)));
}
$doc->handbag_style = $indexed_handbag_styles;
}
if (isset($productObj->handbag_material) && !empty($productObj->handbag_material)) {
$handbag_materials = explode(',', $productObj->handbag_material);
$indexed_handbag_materials = array();
foreach ($handbag_materials as $handbag_material) {
$indexed_handbag_materials[] = strtolower(preg_replace('/\\s+/', '-', trim($handbag_material)));
}
$doc->handbag_material = $indexed_handbag_materials;
}
$combinaisons = $productObj->getAttributeCombinaisons(1);
$indexed_sizes = array();
foreach ($combinaisons as $k => $combinaison) {
if ($combinaison['group_name'] == 'size' || $combinaison['group_name'] == 'Size') {
$indexed_sizes[] = $combinaison['attribute_name'];
}
}
$doc->size = $indexed_sizes;
$doc->cashback_percentage = $productObj->cashback_percentage;
$docs[] = $doc;
if (++$count == 300) {
$update->addDocuments($docs);
$result = $client->update($update);
echo 'Update query executed' . PHP_EOL;
echo 'Query status: ' . $result->getStatus() . PHP_EOL;
echo 'Query time: ' . $result->getQueryTime() . PHP_EOL;
$count = 0;
$docs = array();
$update = $client->createUpdate();
}
}
$update->addDocuments($docs);
date_default_timezone_set($default_tz);
$result = $client->update($update);
$sql = "update ps_product set indexed = 1 where indexed = 0";
Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS($sql);
}
$products = array('m' => null, 'c' => null);
$catalogs = array();
$ignore_family = false;
//LOOPING FOR PRODUCTS OF A FAMILY
//In this loop we validate product and catalog data and
//rearrange the products in each familiy
$products_processed_status = array();
while ($r_catalog = tep_db_fetch_array($dbqcat)) {
$pid = $r_catalog['products_id'];
$is_mother = $pid == $family->mother;
if (!array_key_exists($pid, $products_processed_status)) {
//Process product data
$product_errors = array();
$pdata = $class_pm->retrieveDetail($pid, 'p,pd,pd2,pci,pei,pnc,cat');
$category = new Category($pdata['categories_id']);
$category_name = $category->getName($lid);
$mat_ids = $class_pm->loadProductMaterials($pid);
$pdata['materials'] = array();
foreach ($mat_ids as $mat_id) {
if ($materials_name[$mat_id] != '') {
$pdata['materials'][] = $materials_name[$mat_id];
}
}
//MATERIALS CHECK
if (count($pdata['materials']) == 0) {
$product_errors[] = 'Product has no Materials';
}
//BRAND CHECK
if ($pdata['p']['products_brand_name'] == '') {
$product_errors[] = 'Product Brand is not yet set';
}
$websites = $product->getWebsiteIds();
if (!inMainStore($websites)) {
$websites = implode(",", $websites);
echo "[wrong website] skip {$id}, websites: {$websites}\n";
$skippedProducts++;
continue;
}
$data = [];
$categoryData = [];
$configProduct = new ConfigurableProduct($product);
$categories = $configProduct->getCategoryIds();
$hasActiveCategories = false;
echo sprintf("(%s) %s %s\n", --$open, str_pad($configProduct->getId(), 5), str_pad($configProduct->getName(), 30));
foreach ($categories as $categoryId) {
$category = new Category($categoryId);
if ($category->isVisible() && strlen($category->getName()) > 0 && !$category->isExcluded()) {
if ($hasActiveCategories) {
$categoryData['alternateCategoryId'][] = $categoryId;
$categoryData['alternateCategoryName'][] = $category->getName();
$categoryData['alternateCategoryTree'][] = $category->getCategoryTree();
} else {
$categoryData['defaultCategoryId'] = $categoryId;
$categoryData['defaultCategoryName'] = $category->getName();
$categoryData['defaultCategoryTree'] = $category->getCategoryTree();
$categoryData['productType'] = $category->getName();
$categoryData['alternateCategoryId'] = [];
$categoryData['alternateCategoryName'] = [];
$categoryData['alternateCategoryTree'] = [];
}
$hasActiveCategories = true;
}
break;
}
if ($this_value !== 'TODO') {
break;
}
}
}
$data[] = $this_value;
//Length
$data[] = "TODO";
//Type
$catIds = $product->getCategories();
$category_names = array();
foreach ($catIds as $catID) {
$category = new Category((int) $catID);
$category_names[] = $category->getName(1);
}
$category_names = array_diff($category_names, array('Home'));
$categories = implode(',', $category_names);
$types = array("Daily Wear" => array("daily", "regular", "casual"), "Eveningwear" => array("lounge"), "Regular" => array("casual", "regular", "daily"), "Casual" => array("casual", "work"), "Party Wear" => array("party"));
$this_value = "TODO";
foreach ($types as $key => $type_a) {
foreach ($type_a as $type) {
if (stripos($categories, $type) !== false) {
$this_value = $key;
break;
}
}
if ($this_value !== "TODO") {
break;
}
Product::initPricesComputation();
header("Cache-Control: no-store, no-cache");
header('Content-Encoding: UTF-8');
header('Content-type: text/csv; charset=UTF-8');
header('Content-Disposition: attachment; filename="indusdiva-products.csv"');
$outstream = fopen("php://output", 'w');
$res = Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS("SELECT id_product from ps_product");
$header = array('SKU', 'Name', 'Active', 'Price', 'Category', 'MRP', 'Brand');
fputcsv($outstream, $header, ',', '"');
foreach ($res as $row) {
$productDetails = array();
$id_product = (int) $row['id_product'];
$product = new Product($id_product, true, 1);
$price = $product->getPrice();
$cat = new Category($product->id_category_default);
$product_category = $cat->getName(1);
$productDetails = array($product->id, $product->name, $product->active, $product->getPrice(), $product_category, $product->getPriceWithoutReduct(), $product->manufacturer_name);
fputcsv($outstream, $productDetails, ',', '"');
}
fclose($outstream);
}
if (Tools::getValue('getProducts')) {
$date_from = Tools::getValue('orders_from');
$date_to = Tools::getValue('orders_to');
if (!is_array($statusArray = Tools::getValue('id_order_state')) or !count($statusArray)) {
$statusFilter = '';
} else {
$statusFilter = "and os.`id_order_state` in (" . implode(',', $statusArray) . ") ";
}
$res = Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS("SELECT SQL_CALC_FOUND_ROWS a.id_order as `order id`, \n pd.product_name as `Product`, \n osl.name as `Status`,\n pd.product_quantity as `Quantity`, \n round(pp.wholesale_price * 55) as `Souring Price`, \n pp.ean13 as `EAN`,\n pp.reference as 'REF',\n pp.supplier_reference as 'SUP_REF',\n vl.value as 'Shipping Estimate'\n FROM `ps_orders` a \n INNER JOIN `ps_order_detail` pd ON (a.id_order = pd.id_order)\n INNER JOIN `ps_product` pp ON (pd.product_id = pp.`id_product`)\n LEFT JOIN `ps_order_history` oh ON (oh.`id_order` = a.`id_order`) \n LEFT JOIN `ps_order_state` os ON (os.`id_order_state` = oh.`id_order_state`)\n INNER JOIN `ps_order_state_lang` osl ON (os.`id_order_state` = osl.`id_order_state`) \n INNER JOIN ps_feature_product fp on (fp.id_product = pp.id_product and fp.id_feature = 8 )\n INNER JOIN ps_feature_value_lang vl on fp.id_feature_value = vl.id_feature_value\n LEFT JOIN `ps_currency_rates` pr ON date(pr.`day`) = date(a.`date_add`)\n WHERE 1 AND oh.`id_order_history` = (SELECT MAX(`id_order_history`) FROM `ps_order_history` moh WHERE moh.`id_order` = a.`id_order` GROUP BY moh.`id_order`) \n " . $statusFilter . "\n and CAST(a.date_add AS DATE) between '" . $date_from . "' and '" . $date_to . "'\n ORDER BY a.date_add DESC");
$header = array('Order ID', 'Product', 'Status', 'Quantity', 'Sourcing Price', 'EAN', 'REF', 'SUPPLIER REFERENCE', 'Shipping Estimate');
<?php
if ($data["category"] != 0) {
?>
<div class="category_title">Kategória: <?php
$cat = new Category($data["category"]);
echo $cat->getName();
?>
</div>
<script>document.title="Kategória: <?php
echo $cat->getName();
?>
- Vitozy Blogja";</script>
<?php
}
foreach ($data["posts"] as $post) {
$post_obj = new Post($post["post_id"]);
?>
<div class="post">
<div class="post_header"><?php
echo $post["title"];
?>
</div>
<div class="post_content">
<img src="images/posts/<?php
echo $post["indeximage"];
?>
">
<?php
echo $post["short_text"];
?>
public function ajaxCall()
{
//sleep(1);
global $smarty, $cookie;
$selectedFilters = $this->getSelectedFilters();
$id_parent = (int) Tools::getValue('id_category', Tools::getValue('id_category_layered', 1));
$id_manufacturer = Tools::getValue('id_manufacturer', false);
$sortInfo = '';
if (Tools::getValue('orderby') && Tools::getValue('orderway')) {
$sortInfo = Tools::getProductsOrder('by', Tools::getValue('orderby')) . ':' . Tools::getProductsOrder('way', Tools::getValue('orderway'));
}
//echo print_r($selectedFilters);
//$products = $this->getProductByFilters($selectedFilters);
$resultSet = $this->getResults($id_parent, $this->search_query, $id_manufacturer, $selectedFilters);
$products = $resultSet->getData();
$products = $products['response']['docs'];
$nbProducts = $resultSet->getNumFound();
$range = 3;
/* how many pages around page selected */
$n = (int) Tools::getValue('n', Configuration::get('PS_PRODUCTS_PER_PAGE'));
$p = Tools::getValue('p', 1);
if ($p < 0) {
$p = 0;
}
if ($p > $nbProducts / $n) {
$p = ceil($nbProducts / $n);
}
$pages_nb = ceil($nbProducts / (int) $n);
$start = (int) ($p - $range);
if ($start < 1) {
$start = 1;
}
$stop = (int) ($p + $range);
if ($stop > $pages_nb) {
$stop = (int) $pages_nb;
}
$smarty->assign('nb_products', $nbProducts);
$pagination_infos = array('pages_nb' => (int) $pages_nb, 'p' => (int) $p, 'n' => (int) $n, 'range' => (int) $range, 'start' => (int) $start, 'stop' => (int) $stop, 'nArray' => $nArray = (int) Configuration::get('PS_PRODUCTS_PER_PAGE') != 10 ? array((int) Configuration::get('PS_PRODUCTS_PER_PAGE'), 10, 20, 50) : array(10, 20, 50));
$smarty->assign($pagination_infos);
$smarty->assign('static_token', Tools::getToken(false));
$smarty->assign('products', $products);
$category = new Category((int) $id_parent);
$selectedCategory = $category->getName(1);
$productsTitle = $this->search_query ? $this->search_query : ($id_manufacturer ? Manufacturer::getNameById($id_manufacturer, 1) : $selectedCategory);
$smarty->assign('lazy', 0);
$nextPage = $p + 1;
if ($p == $stop) {
$nextPage = 0;
}
$smarty->assign('nextPage', $nextPage);
$autoLoad = Tools::getValue('al', false);
header('Content-type: application/json');
if ($cookie->image_size == IMAGE_SIZE_LARGE) {
$productListContent = $smarty->fetch(_PS_THEME_DIR_ . 'product-list-page.tpl');
} else {
$productListContent = $smarty->fetch(_PS_THEME_DIR_ . 'product-list-page-small.tpl');
}
if ($autoLoad) {
$smarty->assign('autoload', 1);
return Tools::jsonEncode(array('productList' => $productListContent, 'nextPage' => $nextPage));
} else {
$smarty->assign('autoload', 0);
return Tools::jsonEncode(array('filtersBlock' => $this->generateFiltersBlock($selectedFilters), 'productList' => $productListContent, 'pagination' => $smarty->fetch(_PS_THEME_DIR_ . 'pagination.tpl'), 'totalItems' => $nbProducts, 'sortInfo' => $sortInfo, 'productsTitle' => $productsTitle, 'nextPage' => $nextPage));
}
// return '<div id="layered_ajax_column">'.$this->generateFiltersBlock($selectedFilters).'</div><div id="layered_ajax_products">'.$smarty->fetch(_PS_THEME_DIR_.'product-list.tpl').'</div>';
}
function test_update()
{
//arrange
$name = "Business";
$id = null;
$test_category = new Category($name, $id);
$test_category->save();
$new_name = "Personal";
//act
$test_category->update($new_name);
//assert
$this->assertEquals("Personal", $test_category->getName());
}
<?php
/* @var $this CategoryController */
/* @var $model Category */
$this->breadcrumbs = array('Categories' => array('index'), $model->name);
?>
<h3 class="title">查看 分类 <?php
echo $model->name;
?>
</h3>
<?php
$this->widget('zii.widgets.CDetailView', array('data' => $model, 'attributes' => array('id', 'name', array('name' => 'pid', 'value' => Category::getName($model->pid)), 'orderid', 'level', 'path', array('name' => 'create_uid', 'value' => User::getName($model->create_uid)), 'create_time', array('name' => 'update_uid', 'value' => User::getName($model->update_uid)), 'update_time')));
<?php
/* @var $this BlogController */
/* @var $model Blog */
$this->breadcrumbs = array('Blogs' => array('index'), $model->title);
?>
<div class='col-lg-12 page-title'>
<h1 class="title pull-left">查看 博客 <?php
echo $model->title;
?>
</h1>
<div class="pull-right">
<a class="btn btn-primary" href="<?php
echo Yii::app()->controller->createUrl('admin');
?>
">返回</a>
<a class="btn btn-primary" href="<?php
echo Yii::app()->controller->createUrl('update', array('id' => $model->id));
?>
">编辑</a>
</div>
</div>
<div class="col-lg-12">
<?php
$this->widget('zii.widgets.CDetailView', array('data' => $model, 'attributes' => array('id', array('name' => 'pid', 'value' => Category::getName($model->pid)), 'title', 'img', 'brief', array('name' => 'content', 'type' => 'raw'), 'source', array('name' => 'is_show', 'value' => $model->is_show == 1 ? "是" : "否"), 'orderid', 'views', array('name' => 'create_uid', 'value' => User::getName($model->create_uid)), array('name' => 'create_time', 'value' => date('Y-m-d H:i:s', $model->create_time)), 'update_time')));
?>
</div>
$result = $mongo->categories->find();
foreach ($result as $r) {
$c = new Category();
$c->setName($r['name']);
$c->setDescription($r['description']);
$c->setDisplayPermissionLevel($r['displayPermissionLevel']);
$c->setPostingPermissionLevel($r['postingPermissionLevel']);
$g = new CategoryGroup($r['group']['name']);
$c->setCategoryGroup($g);
$d = new Department($r['department']['name']);
$c->setDepartment($d);
if (!empty($r['customFields'])) {
$c->setCustomFields(json_encode($r['customFields']));
}
$c->save();
echo "Category: {$c->getName()}\n";
}
// Now that we've got People and Categories in the database,
// Link the Departments with their Categories and Default Person
$result = $mongo->departments->find();
foreach ($result as $r) {
$d = new Department($r['name']);
if (!empty($r['defaultPerson']['_id'])) {
$id = getPersonIdFromCrosswalk($r['defaultPerson']['_id']);
$d->setDefaultPerson_id($id);
}
if (!empty($r['categories'])) {
$ids = array();
foreach ($r['categories'] as $c) {
try {
$category = new Category($c['name']);
/**
* (non-PHPdoc)
* @see PartKeepr\Util.Serializable::serialize()
*/
public function serialize()
{
return array("id" => $this->getId(), "name" => $this->getName(), "description" => $this->getDescription(), "comment" => $this->getComment(), "stockLevel" => $this->getStockLevel(), "footprint" => is_object($this->footprint) ? $this->footprint->getId() : null, "minStockLevel" => $this->minStockLevel, "status" => $this->getStatus(), "storageLocation" => is_object($this->storageLocation) ? $this->storageLocation->getId() : null, "category" => is_object($this->category) ? $this->category->getId() : null, "partUnit" => is_object($this->partUnit) ? $this->getPartUnit()->getId() : null, "manufacturers" => $this->serializeChildren($this->getManufacturers()), "distributors" => $this->serializeChildren($this->getDistributors()), "images" => $this->serializeChildren($this->getImages()), "attachments" => $this->serializeChildren($this->getAttachments()), "parameters" => $this->serializeChildren($this->getParameters()), "createDate" => $this->getCreateDate()->format("Y-m-d H:i:s"), "needsReview" => $this->getReviewFlag(), "partCondition" => $this->getCondition(), "internalPartNumber" => $this->getInternalPartNumber(), "categoryName" => is_object($this->category) ? $this->category->getName() : null, "footprintName" => is_object($this->footprint) ? $this->footprint->getName() : null, "storageLocationName" => is_object($this->storageLocation) ? $this->storageLocation->getName() : null);
}
* @copyright 2011 City of Bloomington, Indiana
* @license http://www.gnu.org/licenses/agpl.txt GNU/AGPL, see LICENSE.txt
* @author Cliff Ingham <*****@*****.**>
*/
include '../../../configuration.inc';
include './migrationConfig.inc';
include './categoryTranslation.inc';
$pdo = new PDO(MIGRATION_DSN, MIGRATION_USER, MIGRATION_PASS);
$sql = "select comp_desc from c_types where c_type1!=0";
$result = $pdo->query($sql);
foreach ($result->fetchAll(PDO::FETCH_COLUMN) as $name) {
$name = trim($name);
$newName = isset($CATEGORIES[$name]) ? $CATEGORIES[$name] : $name;
try {
$category = new Category($newName);
} catch (Exception $e) {
$category = new Category();
$category->setName($newName);
if (preg_match('/NOTICE/', $name)) {
list($type, $notice) = explode(' ', $name);
$type = $type == 'RECYCLING' ? 'RECYCLE' : $type;
$query = $pdo->prepare('select notice from sanitation_notices where type=?');
$query->execute(array($type));
foreach ($query->fetchAll(PDO::FETCH_COLUMN) as $notice) {
$category->updateProblems($notice);
}
}
$category->save();
echo $category->getName() . "\n";
}
}
