public function searchAction() { $numberPage = 1; if ($this->request->isPost()) { $query = Criteria::fromInput($this->di, "Categories", $_POST); $this->session->conditions = $query->getConditions(); } else { $numberPage = $this->request->getQuery("page", "int"); if ($numberPage <= 0) { $numberPage = 1; } } $parameters = array(); if ($this->session->conditions) { $parameters["conditions"] = $this->session->conditions; } $parameters["order"] = "id"; $categories = Categories::find($parameters); if (count($categories) == 0) { $this->flash->notice("The search did not find any categories"); return $this->dispatcher->forward(array("controller" => "categories", "action" => "index")); } $paginator = new \Phalcon\Paginator\Adapter\Model(array("data" => $categories, "limit" => 10, "page" => $numberPage)); $page = $paginator->getPaginate(); $this->view->setVar("page", $page); }
public function indexAction() { if ($this->request->hasPost('od') && $this->request->getPost('od') == 'y') { $this->view->setRenderLevel(View::LEVEL_ACTION_VIEW); } $zap = ''; if ($this->request->hasPost('cat_id') && $this->request->isAjax()) { $this->view->setRenderLevel(View::LEVEL_ACTION_VIEW); $cat_id = $this->request->getPost('cat_id'); if (isset($cat_id) && is_numeric($cat_id)) { if ($this->request->hasPost('sub-cat')) { $zap = "id = {$cat_id}"; $c_cat = 1; } else { $zap = "id = {$cat_id} or id_sub = {$cat_id}"; $c_cat = 1; } foreach (Categories::find(array("{$zap}")) as $csv) { $c_cat = $c_cat + $csv->proposal->count(); } if ($c_cat == 1) { $this->view->disable(); echo 1; die; } } } ///////////////// Пагинация if (!empty($_POST['page'])) { $currentPage = $_POST["page"]; } else { $currentPage = 1; } // Chat::find(array('order' => 'creation_date DESC')) if (empty($zap)) { $zaps = ''; } else { $query = $this->modelsManager->createQuery("SELECT id FROM Categories WHERE " . $zap)->execute()->toArray(); foreach ($query as $f) { $cats_id[] = $f['id']; } // $this->elements->var_print($cats_id); $sre = implode(" ,", $cats_id); $zaps = " category_id IN ({$sre})"; // echo $zaps; } $bield = $this->modelsManager->createBuilder()->from('Proposal')->where($zaps)->orderBy('creation_date DESC'); $paginator = new Phalcon\Paginator\Adapter\QueryBuilder(array("builder" => $bield, "limit" => 10, "page" => $currentPage)); $page = $paginator->getPaginate(); foreach ($page->items as $prop) { foreach ($prop->dannproposal as $dann) { $props[$prop->id][$dann->fieldtype->id] = $dann->dann; $props[$prop->id]['cat'] = $prop->categories->name; } } $this->view->setVars(array('cl' => count($page->items), 'prop' => $props = isset($props) ? $props : false, 'page_num' => $page->current, 'page_total' => $page->total_pages)); }
public function getsubmenu() { $text = ''; $tyc = Categories::find(array("id_sub > 0")); foreach ($tyc->toArray() as $category) { $text .= '<li ><a data-cat="' . $category['id'] . '" sub-cat="' . $category['id_sub'] . '">' . $category['name'] . ' </a> </li>'; } return $text; }
public function postDestory() { $category = Categories::find(Input::get('id')); if ($category) { $category->delete(); return Redirect::to('admin/categories/index')->with('message', '刪除成功'); } return Redirect::to('admin/categories/index')->with('message', '刪除失敗,請再試一次'); }
public static function getCatPath($cid) { $catPath = ''; $category = Categories::findFirst(array('conditions' => 'id=?1', 'bind' => array(1 => $cid))); if ($category->level >= 2) { $cats = Categories::find(array('conditions' => 'lpoint<=?1 and rpoint>=?2 and level>=?3 and level<=?4', 'bind' => array(1 => $category->lpoint, 2 => $category->rpoint, 3 => 2, 4 => 3), 'order' => 'level'))->toArray(); foreach ($cats as $cat) { $catPath .= $catPath ? '/' . $cat['title_en'] : $cat['title_en']; } } return $catPath; }
/** * Sets the category we are operating on * * @param Categories|integer $cat A category table or a numeric category ID * * @return void */ protected function setCategory($cat) { // Initialise $this->category = null; $this->category_id = null; $this->folder = null; if ($cat instanceof Categories) { $this->category = $cat; $this->category_id = $cat->id; } elseif (is_numeric($cat)) { $this->category_id = (int) $cat; $container = Container::getInstance('com_ars'); $this->category = $container->factory->model('Categories')->tmpInstance(); $this->category->find($this->category_id); } // Store folder $folder = $this->category->directory; // Check for categories stored in Amazon S3 $potentialPrefix = substr($folder, 0, 5); $potentialPrefix = strtolower($potentialPrefix); if ($potentialPrefix == 's3://') { // If it is stored on S3 make sure there are files stored with the given directory prefix $check = substr($folder, 5); $s3 = AmazonS3::getInstance(); $items = $s3->getBucket('', $check . '/'); if (empty($items)) { return; } } else { // If it is stored locally, make sure the folder exists \JLoader::import('joomla.filesystem.folder'); if (!\JFolder::exists($folder)) { $folder = JPATH_ROOT . '/' . $folder; if (!\JFolder::exists($folder)) { return; } } } $this->folder = $folder; }
public function indexAction() { $orderBy = array("1" => "price asc", "2" => "price desc", "3" => "discount asc", "4" => "discount desc"); $numberPage = 1; $query = Products::query(); // -> where("is_available=1"); if ($this->request->isPost()) { // SEARCH $name = $this->request->getPost("name"); $status = $this->request->getPost("status"); $category = $this->request->getPost("category"); $subcat = $this->request->getPost("subcat"); $order = $this->request->getPost("order"); if ($name != "") { $query->andWhere("name like '%{$name}%'"); } if ($category != "") { $query->andWhere("category_id={$category}"); } if ($subcat != "") { $query->andWhere("sub_category_id={$subcat}"); } if ($order != "") { $query->order($orderBy[$order]); } } if (!$status || $status == "") { $status = 'New'; } if ($status != "All") { $query->andWhere("status='{$status}'"); } $numberPage = $this->request->getQuery("page", "int"); $productList = $query->execute(); $products = new Paginator(array("data" => $productList, "limit" => 10, "page" => $numberPage)); $categories = Categories::find(); $statusTypies = ["New", "Confirmed", "Enabled", "Disabled", "Approved"]; $postData = $this->request->getPost(); $subcats = SubCategories::find(); $this->view->page = $products->getPaginate(); $this->view->categories = $categories; $this->view->subcats = $subcats; $this->view->statusTypies = $statusTypies; $this->view->postData = $postData; $this->view->orderBy = $orderBy; $this->view->status = $status; $this->view->categoriesJson = json_encode(Categories::find()->toArray()); $this->view->subCatsJson = json_encode($subcats->toArray()); }
public static function findByName($name) { $response = new Categories(); if (!$name) { $response->status = $response::STATUS_BAD_REQUEST; $response->addError('NAME_IS_REQUIRED'); return $response->toArray(); } try { $response->data = Categories::find(['conditions' => 'name LIKE :name:', 'bind' => ['name' => '%' . $name . '%'], 'order' => 'name ASC'])->toArray(); } catch (Exception $e) { $response->setException($e); } finally { return $response->toArray(); } }
public function indexAction() { $this->tag->prependTitle('Разделы'); $this->view->setVar('h1', 'Разделы'); $categories = Categories::find(); $paginator = new Paginator(array( "data" => $categories, "limit" => 10, "page" => $this->request->getQuery("page", "int") ?: 1 )); $this->view->page = $paginator->getPaginate(); $this->view->elements = $categories; }
public function update($id) { $rules = array('title' => 'sometimes|required|min:2|max:30'); $messages = array('title.required' => 'Title is required.'); $validator = Validator::make(Input::all(), $rules, $messages); if ($validator->fails()) { return $this->response(array('statusCode' => 400, 'statusDescription' => 'Bad Request', 'errors' => $validator->messages()->toJson())); } else { $title = Input::get('title'); $parent_id = Input::get('parent_id'); $status = Input::get('status'); $is_featured = Input::get('is_featured'); Categories::find($id)->update(array('title' => $title, 'parent_id' => $parent_id, 'is_featured' => $is_featured, 'status' => $status, 'updated_at' => date("Y-m-d H:i:s"))); return $this->response(array('statusCode' => 100, 'statusDescription' => 'Success', 'message' => "Category Added Successfully")); } }
/** * Edits a categorie * * @param string $id */ public function editAction($id) { if (!$this->request->isPost()) { $subcat = SubCategories::findFirstByid($id); if (!$subcat) { $this->flash->error("SubCategory was not found"); return $this->dispatcher->forward(array("controller" => "subcat", "action" => "index")); } $this->view->id = $subcat->id; $this->tag->setDefault("id", $subcat->id); $this->tag->setDefault("name", $subcat->name); $this->tag->setDefault("title", $subcat->title); $this->tag->setDefault("subtitle", $subcat->subtitle); $this->view->subcat = $subcat; $this->view->categories = Categories::find(); } }
public function authentificateAction() { if (!$this->getRequest()->isPost()) { return $this->_forward('index'); } $form = $this->getForm(); if (!$form->isValid($_POST)) { $this->view->form = $form; return $this->render('index'); } else { $values = $form->getValues(); $authAdapter = new Zend_Auth_Adapter_DbTable(Zend_Registry::get('database')); $authAdapter->setTableName('users'); $authAdapter->setIdentityColumn('Login'); $authAdapter->setCredentialColumn('Password'); $authAdapter->setIdentity($values['Login']); $authAdapter->setCredential($values['Password']); $select = $authAdapter->getDbSelect(); $select->where('Active = 1'); if ($authAdapter->authenticate()->getCode() == Zend_Auth_Result::SUCCESS) { $databaseTable = $authAdapter->getResultRowObject(); Zend_Registry::get('database')->query('UPDATE users SET LastConnection = NOW() WHERE Id = "' . $databaseTable->Id . '"'); $session = $this->session; if (isset($_COOKIE['PreviousCategory'])) { $table = new Categories(); $row = $table->find($_COOKIE['PreviousCategory'])->current(); if (isset($row->Id)) { $session->category = $row->Id; $session->categoryName = $row->Name; } } $session->access = true; $session->id = $databaseTable->Id; $session->lastName = $databaseTable->LastName; $session->firstName = $databaseTable->FirstName; $session->rights = new UsersRights($databaseTable->Status); $this->view->access = true; $this->_forward('home'); } else { $this->view->message = '<div class="error">Identification incorrect : mauvais nom d\'utilisateur et/ou mot de passe.</div>'; $this->view->form = $form; return $this->render('index'); } } }
public function fillFullTitle() { $categories = array(); foreach(Categories::find() as $category) { $categories[$category->parentID][$category->id] = $category->title; } $helpers = new Helpers; $titles = $helpers->titleRecursive($categories); foreach ($titles as $id => $title) { $category = Categories::findFirst($id); $category->titleFull = $title; $category->save(); } }
public function setplaceAction() { $this->view->setRenderLevel(View::LEVEL_ACTION_VIEW); if (is_numeric($this->request->getPost('cat_id')) && $this->request->hasPost('cat_id') && $this->request->isAjax()) { $cat_id = $this->request->getPost('cat_id'); foreach (FieldType::find() as $fl) { if ($fl->id == 4) { $field[$fl->id] = array($fl->name, $fl->dtype, $fl->pref); } } if (!$this->request->hasPost('sub')) { foreach (Categories::find(array("id ={$cat_id} or id_sub ={$cat_id}")) as $categ) { foreach ($categ->fieldtype as $fil) { if (strpos($fil->dtype, "a:") !== false) { $field[$fil->id] = array($fil->name, unserialize($fil->dtype), $fil->pref); } else { $field[$fil->id] = array($fil->name, $fil->dtype, $fil->pref); } } } } else { $ct = Categories::findFirst($cat_id)->id_sub; foreach (Categories::find(array("id ={$ct} or id ={$cat_id}")) as $categ) { foreach ($categ->fieldtype as $fil) { if (strpos($fil->dtype, "a:") !== false) { $field[$fil->id] = array($fil->name, unserialize($fil->dtype), $fil->pref); } else { $field[$fil->id] = array($fil->name, $fil->dtype, $fil->pref); } } } } $this->view->setVars(array('field' => $field = isset($field) ? $field : false)); } else { $this->view->setVars(array('field' => $field = isset($field) ? $field : false)); } }
public function getCategory($cat_id) { return View::make('store.category')->with('product', Product::where('category_id', "=", "{$cat_id}")->paginate(6))->with('category', Categories::find($cat_id)); }
/** * testFindAllThreaded method * * @return void */ public function testFindAllThreaded() { $this->loadFixtures('Category'); $TestModel = new Categories(); $result = $TestModel->find('threaded'); $expected = array(array('Category' => array('id' => '1', 'parent_id' => '0', 'name' => 'Category 1', 'created' => '2007-03-18 15:30:23', 'updated' => '2007-03-18 15:32:31'), 'children' => array(array('Category' => array('id' => '2', 'parent_id' => '1', 'name' => 'Category 1.1', 'created' => '2007-03-18 15:30:23', 'updated' => '2007-03-18 15:32:31'), 'children' => array(array('Category' => array('id' => '7', 'parent_id' => '2', 'name' => 'Category 1.1.1', 'created' => '2007-03-18 15:30:23', 'updated' => '2007-03-18 15:32:31'), 'children' => array()), array('Category' => array('id' => '8', 'parent_id' => '2', 'name' => 'Category 1.1.2', 'created' => '2007-03-18 15:30:23', 'updated' => '2007-03-18 15:32:31'), 'children' => array()))), array('Category' => array('id' => '3', 'parent_id' => '1', 'name' => 'Category 1.2', 'created' => '2007-03-18 15:30:23', 'updated' => '2007-03-18 15:32:31'), 'children' => array()))), array('Category' => array('id' => '4', 'parent_id' => '0', 'name' => 'Category 2', 'created' => '2007-03-18 15:30:23', 'updated' => '2007-03-18 15:32:31'), 'children' => array()), array('Category' => array('id' => '5', 'parent_id' => '0', 'name' => 'Category 3', 'created' => '2007-03-18 15:30:23', 'updated' => '2007-03-18 15:32:31'), 'children' => array(array('Category' => array('id' => '6', 'parent_id' => '5', 'name' => 'Category 3.1', 'created' => '2007-03-18 15:30:23', 'updated' => '2007-03-18 15:32:31'), 'children' => array())))); $this->assertEquals($expected, $result); $result = $TestModel->find('threaded', array('conditions' => array('Category.name LIKE' => 'Category 1%'))); $expected = array(array('Category' => array('id' => '1', 'parent_id' => '0', 'name' => 'Category 1', 'created' => '2007-03-18 15:30:23', 'updated' => '2007-03-18 15:32:31'), 'children' => array(array('Category' => array('id' => '2', 'parent_id' => '1', 'name' => 'Category 1.1', 'created' => '2007-03-18 15:30:23', 'updated' => '2007-03-18 15:32:31'), 'children' => array(array('Category' => array('id' => '7', 'parent_id' => '2', 'name' => 'Category 1.1.1', 'created' => '2007-03-18 15:30:23', 'updated' => '2007-03-18 15:32:31'), 'children' => array()), array('Category' => array('id' => '8', 'parent_id' => '2', 'name' => 'Category 1.1.2', 'created' => '2007-03-18 15:30:23', 'updated' => '2007-03-18 15:32:31'), 'children' => array()))), array('Category' => array('id' => '3', 'parent_id' => '1', 'name' => 'Category 1.2', 'created' => '2007-03-18 15:30:23', 'updated' => '2007-03-18 15:32:31'), 'children' => array())))); $this->assertEquals($expected, $result); $result = $TestModel->find('threaded', array('fields' => 'id, parent_id, name')); $expected = array(array('Category' => array('id' => '1', 'parent_id' => '0', 'name' => 'Category 1'), 'children' => array(array('Category' => array('id' => '2', 'parent_id' => '1', 'name' => 'Category 1.1'), 'children' => array(array('Category' => array('id' => '7', 'parent_id' => '2', 'name' => 'Category 1.1.1'), 'children' => array()), array('Category' => array('id' => '8', 'parent_id' => '2', 'name' => 'Category 1.1.2'), 'children' => array()))), array('Category' => array('id' => '3', 'parent_id' => '1', 'name' => 'Category 1.2'), 'children' => array()))), array('Category' => array('id' => '4', 'parent_id' => '0', 'name' => 'Category 2'), 'children' => array()), array('Category' => array('id' => '5', 'parent_id' => '0', 'name' => 'Category 3'), 'children' => array(array('Category' => array('id' => '6', 'parent_id' => '5', 'name' => 'Category 3.1'), 'children' => array())))); $this->assertEquals($expected, $result); $result = $TestModel->find('threaded', array('order' => 'id DESC')); $expected = array(array('Category' => array('id' => 5, 'parent_id' => 0, 'name' => 'Category 3', 'created' => '2007-03-18 15:30:23', 'updated' => '2007-03-18 15:32:31'), 'children' => array(array('Category' => array('id' => 6, 'parent_id' => 5, 'name' => 'Category 3.1', 'created' => '2007-03-18 15:30:23', 'updated' => '2007-03-18 15:32:31'), 'children' => array()))), array('Category' => array('id' => 4, 'parent_id' => 0, 'name' => 'Category 2', 'created' => '2007-03-18 15:30:23', 'updated' => '2007-03-18 15:32:31'), 'children' => array()), array('Category' => array('id' => 1, 'parent_id' => 0, 'name' => 'Category 1', 'created' => '2007-03-18 15:30:23', 'updated' => '2007-03-18 15:32:31'), 'children' => array(array('Category' => array('id' => 3, 'parent_id' => 1, 'name' => 'Category 1.2', 'created' => '2007-03-18 15:30:23', 'updated' => '2007-03-18 15:32:31'), 'children' => array()), array('Category' => array('id' => 2, 'parent_id' => 1, 'name' => 'Category 1.1', 'created' => '2007-03-18 15:30:23', 'updated' => '2007-03-18 15:32:31'), 'children' => array(array('Category' => array('id' => '8', 'parent_id' => '2', 'name' => 'Category 1.1.2', 'created' => '2007-03-18 15:30:23', 'updated' => '2007-03-18 15:32:31'), 'children' => array()), array('Category' => array('id' => '7', 'parent_id' => '2', 'name' => 'Category 1.1.1', 'created' => '2007-03-18 15:30:23', 'updated' => '2007-03-18 15:32:31'), 'children' => array())))))); $this->assertEquals($expected, $result); $result = $TestModel->find('threaded', array('conditions' => array('Category.name LIKE' => 'Category 3%'))); $expected = array(array('Category' => array('id' => '5', 'parent_id' => '0', 'name' => 'Category 3', 'created' => '2007-03-18 15:30:23', 'updated' => '2007-03-18 15:32:31'), 'children' => array(array('Category' => array('id' => '6', 'parent_id' => '5', 'name' => 'Category 3.1', 'created' => '2007-03-18 15:30:23', 'updated' => '2007-03-18 15:32:31'), 'children' => array())))); $this->assertEquals($expected, $result); $result = $TestModel->find('threaded', array('conditions' => array('Category.name LIKE' => 'Category 1.1%'))); $expected = array(array('Category' => array('id' => '2', 'parent_id' => '1', 'name' => 'Category 1.1', 'created' => '2007-03-18 15:30:23', 'updated' => '2007-03-18 15:32:31'), 'children' => array(array('Category' => array('id' => '7', 'parent_id' => '2', 'name' => 'Category 1.1.1', 'created' => '2007-03-18 15:30:23', 'updated' => '2007-03-18 15:32:31'), 'children' => array()), array('Category' => array('id' => '8', 'parent_id' => '2', 'name' => 'Category 1.1.2', 'created' => '2007-03-18 15:30:23', 'updated' => '2007-03-18 15:32:31'), 'children' => array())))); $this->assertEquals($expected, $result); $result = $TestModel->find('threaded', array('fields' => 'id, parent_id, name', 'conditions' => array('Category.id !=' => 2))); $expected = array(array('Category' => array('id' => '1', 'parent_id' => '0', 'name' => 'Category 1'), 'children' => array(array('Category' => array('id' => '3', 'parent_id' => '1', 'name' => 'Category 1.2'), 'children' => array()))), array('Category' => array('id' => '4', 'parent_id' => '0', 'name' => 'Category 2'), 'children' => array()), array('Category' => array('id' => '5', 'parent_id' => '0', 'name' => 'Category 3'), 'children' => array(array('Category' => array('id' => '6', 'parent_id' => '5', 'name' => 'Category 3.1'), 'children' => array())))); $this->assertEquals($expected, $result); $result = $TestModel->find('all', array('fields' => 'id, name, parent_id', 'conditions' => array('Category.id !=' => 1))); $expected = array(array('Category' => array('id' => '2', 'name' => 'Category 1.1', 'parent_id' => '1')), array('Category' => array('id' => '3', 'name' => 'Category 1.2', 'parent_id' => '1')), array('Category' => array('id' => '4', 'name' => 'Category 2', 'parent_id' => '0')), array('Category' => array('id' => '5', 'name' => 'Category 3', 'parent_id' => '0')), array('Category' => array('id' => '6', 'name' => 'Category 3.1', 'parent_id' => '5')), array('Category' => array('id' => '7', 'name' => 'Category 1.1.1', 'parent_id' => '2')), array('Category' => array('id' => '8', 'name' => 'Category 1.1.2', 'parent_id' => '2'))); $this->assertEquals($expected, $result); $result = $TestModel->find('threaded', array('fields' => 'id, parent_id, name', 'conditions' => array('Category.id !=' => 1))); $expected = array(array('Category' => array('id' => '2', 'parent_id' => '1', 'name' => 'Category 1.1'), 'children' => array(array('Category' => array('id' => '7', 'parent_id' => '2', 'name' => 'Category 1.1.1'), 'children' => array()), array('Category' => array('id' => '8', 'parent_id' => '2', 'name' => 'Category 1.1.2'), 'children' => array()))), array('Category' => array('id' => '3', 'parent_id' => '1', 'name' => 'Category 1.2'), 'children' => array())); $this->assertEquals($expected, $result); }
/** * Update the specified resource in storage. * * @param int $id * @return Response */ public function update($id) { $rules = array('category' => 'required|Integer', 'condition' => 'required|Integer', 'name' => 'required', 'description' => 'required', 'donor' => 'required|Integer', 'orignal_price' => 'required|Numeric', 'price' => 'required|Numeric', 'image' => 'required', 'attributes' => 'required'); $validator = Validator::make(Input::all(), $rules); if ($validator->fails()) { return $this->response(array('statusCode' => 400, 'statusDescription' => 'Bad Request', 'errors' => $validator->messages()->toJson())); } else { $iGetInstitute = Donor::where('user_id', Input::get('donor'))->first(); $product = Product::find($id)->update(array('products_price' => Input::get('price'), 'products_orginal_price' => Input::get('orignal_price'), 'brand' => Input::get('brand', NULL), 'products_status' => Input::get('products_status', 1), 'products_donar' => Input::get('donor'), 'condition' => Input::get('condition'), 'products_image' => Input::get('image'), 'gender' => Input::get('gender'), 'age_range' => Input::get('age_range'), 'collections_id' => Input::get('collections_id'), 'seasons_id' => Input::get('seasons_id'), 'types_id' => Input::get('types_id'), 'freshly_faved' => Input::get('freshly_faved'), 'institution_id' => $iGetInstitute->institution_id)); // $product->save(); $category = Categories::find(Input::get('category')); $product = Product::find($id); //$product->productCategory()->save($category); Product::find($id)->productCategory()->detach(); //updateExistingPivot($category->categories_id, array("categories_id"=>$category->categories_id),false); $product->productCategory()->save($category); if (Input::has('tags')) { Product::find($id)->productTags()->detach(); $product = Product::find($id); $inptags = Input::get("tags"); $tags = explode(",", $inptags); foreach ($tags as $key => $value) { $ctag = Tags::find($value); if ($ctag) { $product->productTags()->save($ctag); } } } $attributes = json_decode(Input::get("attributes"), TRUE); //$attribs = array(); ProductsAttributes::where("products_id", $id)->delete(); foreach ($attributes as $key => $value) { $opt_values = explode(",", $value); foreach ($opt_values as $optval) { //echo $key." ".$optval."<br/>"; $attribute = new ProductsAttributes(array('options_id' => $key, 'options_values_id' => $optval)); $product->productsAttributes()->save($attribute); } } $description = ProductsDescription::find($id)->update(array("products_name" => Input::get("name"), "products_description" => Input::get("description"))); //$product->productsDescription()->save($description); return $this->response(array('statusCode' => 100, 'statusDescription' => 'Success')); } }
/** * Show the form for editing the specified resource. * * @param int $id * @return Response */ public function edit($id) { $issue = Issue::find($id); if ($issue == NULL) { throw new Exception('Invalid Book ID'); } $issue->added_at_timestamp = date('d-M-y h:i A', strtotime($issue->added_at_timestamp)); $book = Books::find($issue->book_id); $issue->book_name = $book->title; $issue->author = $book->author; $issue->category = Categories::find($book->category_id)->category; $issue->available_status = (bool) $issue->available_status; if ($issue->available_status == 1) { return $issue; } $conditions = array('return_time' => 0, 'book_issue_id' => $id); $book_issue_log = Logs::where($conditions)->take(1)->get(); foreach ($book_issue_log as $log) { $student_id = $log->student_id; } $student_data = Student::find($student_id); unset($student_data->email_id); unset($student_data->books_issued); unset($student_data->approved); unset($student_data->rejected); $student_branch = Branch::find($student_data->branch)->branch; $roll_num = $student_data->roll_num . '/' . $student_branch . '/' . substr($student_data->year, 2, 4); unset($student_data->roll_num); unset($student_data->branch); unset($student_data->year); $student_data->roll_num = $roll_num; $student_data->category = StudentCategories::find($student_data->category)->category; $issue->student = $student_data; return $issue; }
public function testBehaviorsNestedSet() { require 'unit-tests/config.db.php'; if (empty($configMysql)) { $this->markTestSkipped("Test skipped"); return; } $this->_prepareDI(); $cars = new Categories(); $cars->title = 'Cars'; $this->assertTrue($cars->saveNode()); $phones = new Categories(); $phones->title = 'Mobile phones'; $this->assertTrue($phones->saveNode()); $ford = new Categories(); $ford->title = 'Ford'; $this->assertTrue($ford->appendTo($cars)); $mercedes = new Categories(); $mercedes->title = 'Mercedes'; $this->assertTrue($mercedes->insertBefore($ford)); $audi = new Categories(); $audi->title = 'Audi'; $this->assertTrue($audi->prependTo($cars)); $samsung = new Categories(); $samsung->title = 'Samsung'; $this->assertTrue($samsung->appendTo($phones)); $motorola = new Categories(); $motorola->title = 'Motorola'; $this->assertTrue($motorola->insertAfter($samsung)); $iphone = new Categories(); $iphone->title = 'iPhone'; $this->assertTrue($iphone->insertBefore($samsung)); $data = array(array("id" => 1, "root" => 1, "lft" => 1, "rgt" => 8, "lvl" => 1, "title" => "Cars"), array("id" => 5, "root" => 1, "lft" => 2, "rgt" => 3, "lvl" => 2, "title" => "Audi"), array("id" => 4, "root" => 1, "lft" => 4, "rgt" => 5, "lvl" => 2, "title" => "Mercedes"), array("id" => 3, "root" => 1, "lft" => 6, "rgt" => 7, "lvl" => 2, "title" => "Ford"), array("id" => 2, "root" => 2, "lft" => 1, "rgt" => 8, "lvl" => 1, "title" => "Mobile phones"), array("id" => 8, "root" => 2, "lft" => 2, "rgt" => 3, "lvl" => 2, "title" => "iPhone"), array("id" => 6, "root" => 2, "lft" => 4, "rgt" => 5, "lvl" => 2, "title" => "Samsung"), array("id" => 7, "root" => 2, "lft" => 6, "rgt" => 7, "lvl" => 2, "title" => "Motorola")); $categories = Categories::find(array('order' => 'root, lft')); $this->assertEquals($data, $categories->toArray()); }
<section class="padd-tb-60 bg-dark image-v2 bg-fixed"> <div class="container"> <div class="row"> <div class="col-md-4 col-md-offset-4"> <div class="panel panel-default"> <div class="panel-heading"> <h3 class="panel-title">Product Details</h3> </div> <div class="panel-body"> <?php $supplier = Suppliers::find($product->supplierId); $category = Categories::find($product->categoryId); ?> <p>Product ID: {{$product->supplierProductId}}</p> <p>Name: {{$product->name}}</p> <p>Supplier: {{$supplier->name}}</p> <p>Category: {{$category->name}}</p> <p>Cost: {{$product->unitPrice}}</p> <p>Quantity: {{$product->quantity}}<br></p> <p>Color is: {{$product->color}}</p> <p>Description is: {{$product->details}}</p> <div class="padd-t-20"> <a class="btn btn-small btn-green" href="{{ URL::to('suppliers/' . $product->id . '/edit') }}">Edit</a> {{ Form::open(array('url' => 'products/' . $product->id, 'class' => 'pull-right')) }} {{ Form::hidden('_method', 'DELETE') }} {{ Form::submit('Delete', array('class' => 'btn btn-danger', 'onclick' => 'return confirm("Are you sure you want to delete this product?")')) }}
<tr> <th><h4>Name</h4></th> <th><h4>Cost</h4></th> <th><h4>Supplier</h4></th> <th><h4>Category</h4></th> <th><h4>Quantity</h4></th> <th><h4>Colour</h4></th> <th><h4>Status</h4></th> </tr> </thead> <tbody> @foreach($products as $key => $value) <tr> <?php $supplier = Suppliers::find($value->supplierId); $category = Categories::find($value->categoryId); ?> <td style="width:15%"><strong>{{ $value->name }}</strong></td> <td style="width:15%">{{ $value->unitPrice}}</td> <td style="width:15%">{{ $supplier->name}}</td> <td style="width:15%">{{ $category->name}}</td> <td style="width:15%">{{ $value->quantity}}</td> <td style="width:10%">{{ $value->color}}</td> <td style="width:5%"><a class="btn btn-small btn-blue" href="{{ URL::to('products/' . $value->id . '/details') }}">Details</a></td> <td style="width:5%"><a class="btn btn-small btn-green" href="{{ URL::to('products/' . $value->id . '/edit') }}">Edit</a></td> <td style="width:5%"> {{ Form::open(array('url' => 'products/' . $value->id, 'class' => 'pull-right')) }} {{ Form::hidden('_method', 'DELETE') }} {{ Form::submit('Delete', array('class' => 'btn btn-danger', 'onclick' => 'return confirm("Are you sure you want to delete this product?")')) }} {{ Form::close() }} </td>
public function redofferAction() { $this->view->setRenderLevel(View::LEVEL_ACTION_VIEW); if ($this->request->hasPost('offer_id')) { foreach (FieldType::find() as $field) { $fil[$field->id] = $field->name; } $offer = Offers::findFirst($this->request->getPost('offer_id')); foreach ($offer->dannoffers as $dan) { $dan_fil[$dan->fieldtype->id] = $dan->dann; } $cat = $offer->categories; $cat_id = $cat->id; foreach (Categories::find(array("id_sub =0")) as $categ) { $category[$categ->id] = $categ->name; } // Получение родительской категории if (count(Categories::find(array("id_sub = {$cat->id}"))) > 0) { foreach (Categories::find(array("id_sub = {$cat->id}")) as $categ) { $sub_cat[$categ->id] = $categ->name; } } else { foreach (Categories::find(array("id = {$cat->id_sub}")) as $categ) { $par_cat = $categ->id; foreach (Categories::find(array("id_sub = {$categ->id}")) as $cate) { $sub_cat[$cate->id] = $cate->name; } } } if (count(Categories::find(array("id = {$cat->id_sub}"))) > 0) { foreach (Categories::findFirst(array("id = {$cat->id_sub}"))->fieldtype as $cat_field) { $cat_fd[$cat_field->id] = array($cat_field->name, $cat_field->pref, $cat_field->dtype); } } foreach ($cat->fieldtype as $cat_field) { $cat_f[$cat_field->id] = array($cat_field->name, $cat_field->pref, $cat_field->dtype); } // $this->elements->var_print($dan_fil); if (!isset($sub_cat)) { $par_cat = $cat_id; } $this->view->setVars(array('field' => $fil, 'cat_field' => $cat_f = isset($cat_f) ? $cat_f : false, 'cat_fieldf' => $cat_fd = isset($cat_fd) ? $cat_fd : false, 'offer_name' => $offer_name = isset($offer->name) ? $offer->name : false, 'offer_text' => $off = isset($offer->text) ? $offer->text : false, 'offer_id' => $off = isset($offer->id) ? $offer->id : false, 'dan_fil' => $dan_fil = isset($dan_fil) ? $dan_fil : false, 'par_cat' => $par_cat = isset($par_cat) ? $par_cat : false, 'cat_id' => $cat_id = isset($cat_id) ? $cat_id : false, 'cat' => $category = isset($category) ? $category : false, 'sub_cat' => $sub_cat = isset($sub_cat) ? $sub_cat : false)); } }
public function indexAction() { $this->view->categories = Categories::find(); }
function providerSignupAction() { if ($this->request->isPost()) { $name = $this->request->getPost('name'); $email = $this->request->getPost('email'); $password = $this->request->getPost('password'); $cpassword = $this->request->getPost('cpassword'); $timezone = $this->request->getPost('timezone'); $phone = $this->request->getPost('phone'); $address = $this->request->getPost('address'); $categories = $this->request->getPost('categories'); $membership = $this->request->getPost('membership'); $card_token = $this->request->getPost('card_token'); $errors = array(); $fields = array('name', 'email', 'password', 'cpassword', 'phone', 'address', 'membership', 'card_token'); $fieldsEntered = 0; foreach ($fields as $field) { if (trim(${$field}) != '') { $fieldsEntered++; } } if ($fieldsEntered < count($fields)) { array_push($errors, "Some fields were not entered."); } if (!filter_var($email, FILTER_VALIDATE_EMAIL)) { array_push($errors, "Email is invalid."); } if (strlen($password) < 6) { array_push($errors, "Password must be at least 6 characters long."); } if ($password != $cpassword) { array_push($errors, "Passwords don't match."); } if (!preg_match('/^\\(?[0-9]{3}\\)?|[0-9]{3}[-. ]? [0-9]{3}[-. ]?[0-9]{4}$/', $phone)) { array_push($errors, "Invalid phone number format."); } $apiLink = $this->config->maps->api_link; $geoData = file_get_contents($apiLink . urlencode($address)); if ($geoData === FALSE) { array_push($errors, "Invalid address."); } $provider = Providers::findFirst("email = '{$email}'"); if ($provider) { array_push($errors, "Email is already taken."); } if (!count($errors)) { $salt = bin2hex(openssl_random_pseudo_bytes(16, $cstrong)); $provider = new Providers(); $provider->name = $name; $provider->email = $email; $provider->salt = $salt; $provider->password = md5($salt . $password); $provider->timezone = $timezone; $provider->membership = $membership; require_once "../vendor/stripe-php-master/init.php"; \Stripe\Stripe::setApiKey($this->config->stripe->secret_key); $plan = Memberships::findFirst("id = '{$membership}'"); $amount = (int) $plan->total * 100; $duration = $plan->duration; $date = new DateTime(date()); $date->add(new DateInterval('P' . $duration . 'M')); $provider->expiry_date = $date->format('Y-m-d H:i:s'); $account = \Stripe\Account::create(array("managed" => true, "country" => "US")); $provider->stripe_account_token = $account->id; $customer = \Stripe\Customer::create(array("description" => $name, "email" => $email, "source" => $card_token)); $provider->stripe_customer_token = $customer->id; $provider->stripe_card_token = $customer->default_source; $providerPhone = new ProviderPhones(); $providerPhone->telephone = $phone; $provider->providerPhones = $providerPhone; $providerAddress = new ProviderAddresses(); $geoJSON = json_decode($geoData); if ($geoJSON->status == "OK") { $geometry = $geoJSON->results[0]->geometry->location; $lat = $geometry->lat; $lng = $geometry->lng; } else { $lat = 0; $lng = 0; } $providerAddress->latitude = $lat; $providerAddress->longitude = $lng; $providerAddress->address = $address; $provider->providerAddresses = $providerAddress; $providerCategories = array(); foreach ($categories as $category) { $providerCategory = new ProviderCategories(); $providerCategory->cid = $category; array_push($providerCategories, $providerCategory); } $provider->providerCategories = $providerCategories; if ($provider->create()) { \Stripe\Charge::create(array("amount" => $amount, "currency" => "usd", "customer" => $provider->stripe_customer_token, "source" => $provider->stripe_card_token, "description" => "{$plan->name} plan subscription")); $this->response->redirect('/login?success'); $this->view->disable(); } else { array_push($errors, "An error occurred during the signup process."); } } $this->view->errors = $errors; } $timezones = (require "../app/config/timezones.php"); $this->view->timezones = $timezones; $memberships = Memberships::find("id > 1"); $this->view->memberships = $memberships; $categories = Categories::find(); $this->view->categories = $categories; echo $this->view->render('auth', 'providerSignup'); }
public function offerAction() { $this->view->setRenderLevel(View::LEVEL_ACTION_VIEW); if (isset($_POST['offer'])) { $offer_id = $this->request->getPost('offer'); $offer = Offers::findFirst($offer_id); $date = new DateTime($offer->creation_date); $date = $date->format('Y-m-d H:i'); if (isset($offer->image)) { $image = unserialize($offer->image); } else { $image = ''; } foreach ($offer->dannoffers as $dann) { if ($dann->field_type_id == 14) { $operator = $dann->dann; } elseif ($dann->field_type_id == 7) { $gsm = $dann->dann; } elseif ($dann->field_type_id == 6) { $dost = $dann->dann; } elseif ($dann->field_type_id == 15) { $rad_dost = $dann->dann . " " . $dann->fieldtype->pref; } elseif ($dann->field_type_id == 16) { $stat = $dann->dann; } elseif ($dann->field_type_id == 5) { $price = $dann->dann; } elseif ($dann->field_type_id == 17) { $spec = $dann->dann; } foreach ($offer->categories->fieldtype as $field) { if ($field->id == $dann->field_type_id) { $cat_dann[$field->name] = $dann->dann . " " . $field->pref; } } if (count(Categories::find(array("id = {$offer->categories->id_sub}"))) > 0) { foreach (Categories::findFirst(array("id = {$offer->categories->id_sub}"))->fieldtype as $fiel) { if ($fiel->id == $dann->field_type_id) { $cat_dann[$fiel->name] = $dann->dann . " " . $fiel->pref; } } } } foreach ($offer->comments as $comment) { $comm[$comment->id] = array('reciever' => $comment->user->first_name, 'text' => $comment->text, 'date' => $comment->creation_date); } $this->view->setVars(array('name' => $nm = isset($offer->user->first_name) ? $offer->user->first_name : false, 'user_id' => $id_u = isset($offer->user->id) ? $offer->user->id : false, 'offer_id' => $id = isset($offer->id) ? $offer->id : false, 'offer_name' => $of_name = isset($offer->name) ? $offer->name : false, 'offer_date' => $dat = isset($date) ? $date : false, 'offer_text' => $text = isset($offer->text) ? $offer->text : false, 'offer_image' => $image, 'oper' => $oper = isset($operator) ? $operator : false, 'gsm' => $gsm = isset($gsm) ? $gsm : false, 'dost' => $dost = isset($dost) ? $dost : false, 'radius_d' => $rad_dost = isset($rad_dost) ? $rad_dost : false, 'status' => $stat = isset($stat) ? $stat : false, 'price' => $price = isset($price) ? $price : false, 'cat_dann' => $cat_dann = isset($cat_dann) ? $cat_dann : false, 'spec' => $spec = isset($spec) ? $spec : false, 'comments' => $comm = isset($comm) ? $comm : false)); } }
public function getDelete($id = '') { if ($id == '') { return Redirect::to($this->route)->with('msg_error', Lang::get('messages.categories_display_err')); } else { $category = Categories::find($id); $delete = Categories::destroy($id); if (!$delete) { return Redirect::to($this->route . '/trash')->with('msg_error', Lang::get('messages.categories_delete_err', array('title' => $category->title))); } else { return Redirect::to($this->route . '/trash')->with('msg_success', Lang::get('messages.categories_delete', array('title' => $category->title))); } } }
<div class="categories"> <?php foreach (Categories::find("status = 1") as $category) { echo "<span class='category'>", $category->name, "</span>"; } ?> </div>
public function setcategoryAction() { $form = new Zend_Form(); $form->setAction(PUBLIC_PATH . $this->getRequest()->getControllerName() . '/setcategory/'); $form->setMethod('post'); $form->setAttrib('id', 'CategoryForm'); $type = new Zend_Form_Element_Select('Categorie'); //$type->setLabel('Choisissez la catégorie de vos saisies'); $type->setRequired(true); $table = new Categories(); $select = $table->select(); $objects = $table->fetchAll($select); foreach ($objects as $object) { $type->addMultiOption($object->Id, $object->Name); } if (!empty($this->session->category)) { $type->setValue($this->session->category); } else { $type->setValue($objects[0]->Id); } $type->setDecorators(array('ViewHelper', 'Description', 'Errors', array('HtmlTag', array('tag' => 'dd', 'class' => 'PositionCenter')))); $submit = new Zend_Form_Element_Submit('Enregistrer'); $form->addElement($type); $form->addElement($submit); if ($this->getRequest()->isPost() && $form->isValid($_POST)) { $values = $form->getValues(); $row = $table->find($values['Categorie'])->current(); unset($_COOKIE['PreviousCategory']); setcookie('PreviousCategory', $row->Id, time() + 365 * 24 * 60 * 60, '/'); $this->session->category = $row->Id; $this->session->categoryName = $row->Name; $this->session->message = '<div class = "success">Vos saisies seront désormais pris en compte et rentrés dans la catégorie <strong>' . $row->Name . '</strong></div>'; return $this->_forward('index'); } else { $this->rememberCategory(); $this->view->message .= '<div class = "notice">Choisissez le métier sur lequel vous souhaitez travailler</div>'; $this->view->form = $form; return $this->render('form'); } }
<?php error_reporting(E_ALL); require 'app/config/config.php'; $modelManager = new Phalcon\Model\Manager(); $modelManager->setModelsDir(__DIR__ . '/' . $config->phalcon->modelsDir); Phalcon\Db\Pool::setDefaultDescriptor($config->database); $categoriesCode = array(); foreach (Categories::find() as $category) { $categoriesCode[$category->name] = $category->id; } foreach (News::find() as $new) { foreach ($new->getNewsCategories() as $newCategory) { $newCategory->delete(); } $categories = array(); if (stripos($new->title, 'conf') !== false) { $categories['conf'] = true; } if (stripos($new->title, 'world') !== false) { $categories['conf'] = true; } if (stripos($new->title, 'Rio') !== false) { $categories['conf'] = true; } if (stripos($new->title, 'phpDay') !== false) { $categories['conf'] = true; } if (stripos($new->title, 'NW') !== false) { $categories['conf'] = true; }
public function show($id) { $category = Categories::find($id); return View::make('categories.show')->with('category', $category); }