/** * Creates an Category object based on a DB row. * * @param array $row The DB row containing Category data. * @return \MyMovies\Domain\Category */ protected function buildDomainObject($row) { $cat = new Categorie(); $cat->setCat_id($row['cat_id']); $cat->setCat_name($row['cat_name']); return $cat; }
public function update(Categorie $categorie) { $query = $this->_db->prepare('UPDATE categorie SET nom=:nom, detail=:detail WHERE id=:id'); $query->bindValue(':nom', $categorie->nom()); $query->bindValue(':detail', $categorie->detail()); $query->bindValue(':id', $categorie->id()); $query->execute(); $query->closeCursor(); }
private function setQuestions() { $categories = new Categorie(); $questions = new Question(); $questions->readQuestions($categories->getCategories()); $tabUn = $questions->getUn(); $tabAutre = $questions->getAutre(); $this->_questions = array('lun1' => $tabUn[0], 'lautre1' => $tabAutre[0], 'lun2' => $tabUn[1], 'lautre2' => $tabAutre[1]); }
function getCategorie($id) { $result = $this->connector->query("SELECT * FROM categorie WHERE `cat_id` = '{$id}'"); while ($row = $this->connector->fetchArray($result)) { $categorie = new Categorie(); $categorie->setCat_id($row['cat_id']); $categorie->setCat_title($row['cat_title']); $categorie->setCat_despription($row['cat_despription']); return $categorie; } }
public function create($nom) { $category = new Categorie($this->link); $category->setTitre($nom); $nom = mysqli_real_escape_string($this->link, $category->getCategory()); $request = "INSERT INTO categories VALUES(NULL, '" . $nom . "')"; $res = mysqli_query($this->link, $request); if ($res) { return $this->select(mysqli_insert_id($this->link)); } else { throw new Exception("Internal server error"); } }
public function procede() { if (!$this->oRequest->existParam('key')) { throw new Error('Vous devez renseigner la clé.', 3003); } if ($this->oRequest->getParam('key', 'string') != Config::get('ingestkey')) { throw new Error('La clé est invalide.', 3003); } //Ajoute du titre $this->oView->addData('titre', 'Analyse des releases'); //On récupère les 30 dernières releases $oMysqli = Database::getInstance(); //Traitement de la requête $sSqlRequest = "SELECT r.*, \r\n (SELECT GROUP_CONCAT(t.id_regex ORDER BY t.id_regex SEPARATOR ';') FROM tks_tags t WHERE t.id_release = r.id) AS tags,\r\n (SELECT GROUP_CONCAT(f.date ORDER BY f.date SEPARATOR ';') FROM tks_torrents f WHERE f.id_release = r.id) AS dates\t\r\n FROM tks_releases r \r\n WHERE r.id_categorie = '0' \r\n ORDER BY r.id DESC \r\n LIMIT 10"; $oResults = $oMysqli->query($sSqlRequest); $oTable = new TableGenerator(); $oTable->setId(md5('Scrapper')); $oTable->addColumn('Release'); $oTable->addColumn('Catégorie'); $oTable->addColumn('ID Fiche'); $aCategories = Categorie::getCategoriesSelect(); while ($aResult = $oResults->fetch_assoc()) { $oScrapper = new Scrapper($aResult['name'], $aResult['id']); $oScrapper->procede(); $oTable->addLine(array($aResult['name'], $aCategories[$oScrapper->getCategorie()], $oScrapper->getFiche())); } $oTable->setBottom(''); $oTable->create(); $this->oView->addData('content', $oTable->getCode()); $this->oView->Create(); }
function __construct() { if (!isset(self::$database)) { //Connection à la BDD si pas déjà connecté self::$database = BaseDeDonnees::getInstance(); } }
function recupereCategorie() { $categories = Categorie::fetchAll(); //Change l'ordre selon la fonction de comparaison cmp. usort($categories, "cmp"); return $categories; }
public static function getAllCategories() { $results = Categorie::select('name', 'id')->orderBy('name', 'asc')->get(); $allCategories = array(); foreach ($results as $result) { $allCategories = array_add($allCategories, $result->id, $result->name); } return $allCategories; }
public function beheerMateriaal() { if (Auth::check()) { $categories = Categorie::with('materials')->get(); return View::make('users.admin.beheerMateriaal', ['categories' => $categories]); } else { return Redirect::to('/'); } }
/** * Make changes to the database. * * @return void */ public function up() { // Schema::create('categories', function ($table) { $table->increments('id'); $table->string('title'); }); $cat = new Categorie(); $cat->title = "Wood"; $cat->save(); $cat = new Categorie(); $cat->title = "Metal"; $cat->save(); $cat = new Categorie(); $cat->title = "Ceramic"; $cat->save(); $cat = new Categorie(); $cat->title = "Glass"; $cat->save(); $cat = new Categorie(); $cat->title = "Fabric"; $cat->save(); $cat = new Categorie(); $cat->title = "Plastic"; $cat->save(); $cat = new Categorie(); $cat->title = "Concrete"; $cat->save(); $cat = new Categorie(); $cat->title = "Appliances"; $cat->save(); $cat = new Categorie(); $cat->title = "Electical"; $cat->save(); $cat = new Categorie(); $cat->title = "Plumbing"; $cat->save(); $cat = new Categorie(); $cat->title = "Insulation"; $cat->save(); $cat = new Categorie(); $cat->title = "Other"; $cat->save(); }
/** * Initialise les variables en tableaux, et crée l'ensemble des catégories question de la partie */ function __construct() { $bddConnect = new Connector(); $this->tabCategorie = array(); $this->tabTheme1 = array(); $this->tabTheme2 = array(); $this->tabQuestion = array(); $this->tabReponse = array(); $this->tabExplication = array(); // étape actuelle de la partie (1 étape = 1 question) $this->position = 0; // création et récupération des catégories de la partie $Categorie = new Categorie($bddConnect->getBdd()); $nomCategorie = $Categorie->getNomCategorie(); for ($i = 0; $i < sizeof($nomCategorie); $i++) { // création et récupération des thèmes de la partie associés aux catégories choisies $Theme = new Theme($bddConnect->getBdd(), $nomCategorie[$i]); $idTheme = $Theme->getIdTheme(); $theme1 = $Theme->getTheme1(); $theme2 = $Theme->getTheme2(); for ($j = 0; $j < sizeof($theme1); $j++) { // cration et récupération des questions de la partie associées aux thémes $Question = new Question($bddConnect->getBdd(), $idTheme[$j]); $intituleQuestion = $Question->getIntituleQuestion(); $reponse = $Question->getReponse(); $explication = $Question->getExplication(); for ($h = 0; $h < sizeof($intituleQuestion); $h++) { // 1 indice de chauqe tableau équivaut au catégorie / theme question / ... de la question actuelle array_push($this->tabCategorie, $nomCategorie[$i]); array_push($this->tabTheme1, $theme1[$j]); array_push($this->tabTheme2, $theme2[$j]); array_push($this->tabQuestion, $intituleQuestion[$h]); array_push($this->tabReponse, $reponse[$h]); // s'il existe ou non une explication de la réponse if (isset($explication[$h])) { array_push($this->tabExplication, $explication[$h]); } else { array_push($this->tabExplication, null); } } } } }
/** * * @return array A list of all Links. */ public function findAll() { $sql = "select * from rit_link"; $result = $this->getDb()->fetchAll($sql); // Convert query result to an array of domain objects $links = array(); foreach ($result as $row) { $linkId = $row['lnk_id']; $links[$linkId] = $this->buildDomainObject($row); if (null !== $row['cat_id']) { $sql2 = "select * from rit_categories"; $r2 = $this->getDb()->fetchAll($sql2); $cat = new Categorie(); $cat->setId($r2[0]['cat_id']); $cat->setName($r2[0]['cat_name']); $links[$linkId]->setArticle($cat); } } return $links; }
public function run() { Eloquent::unguard(); DB::statement('SET FOREIGN_KEY_CHECKS=0;'); DB::table('categories')->delete(); Categorie::create(array('user_id' => 2, 'nom' => 'Men Cat 1', 'nomcourt' => 'M1', 'sexe_id' => 1, 'hcpmin' => -5, 'hcpmax' => 18.4, 'agemin' => 30, 'agemax' => 99, 'agelimityear' => 0, 'tee_id' => 3)); Categorie::create(array('user_id' => 2, 'nom' => 'Men Cat 2', 'nomcourt' => 'M2', 'sexe_id' => 1, 'hcpmin' => 18.5, 'hcpmax' => 36, 'agemin' => 30, 'agemax' => 99, 'agelimityear' => 0, 'tee_id' => 4)); Categorie::create(array('user_id' => 2, 'nom' => 'Ladies Cat 1', 'nomcourt' => 'L1', 'sexe_id' => 2, 'hcpmin' => -5, 'hcpmax' => 20.4, 'agemin' => 30, 'agemax' => 99, 'agelimityear' => 0, 'tee_id' => 6)); Categorie::create(array('user_id' => 2, 'nom' => 'Ladies Cat 2', 'nomcourt' => 'L2', 'sexe_id' => 2, 'hcpmin' => 20.5, 'hcpmax' => 36, 'agemin' => 30, 'agemax' => 99, 'agelimityear' => 0, 'tee_id' => 7)); DB::statement('SET FOREIGN_KEY_CHECKS=1;'); }
public static function supprimerCategorie($nom) { $nomCat = Categorie::getDefaultCategorie(); require_once "../Modele/Film.class.php"; $films = Film::getListeFilms(); foreach ($films as $film) { if ($film['categorie'] == $nom) { Film::setDefaultCategorie($nomCat['nom'], $film['id']); } } SingletonRequete::getBase()->requeteParam("DELETE FROM Category WHERE category_name=?", array($nom)); }
function ajax_categoria() { $macro = $_REQUEST["macro"]; $suffisso = $_REQUEST["suffisso"]; //query sulle categorie $objCat = new Categorie(); $arrCat = $objCat->getAll(" and cat_fkclasse=" . $macro . " order by cat_sorting"); $num = count($arrCat); if ($num == 0) { print "- - <input type='hidden' name='categoria" . $suffisso . "' value=''>"; } else { print "<select name='categoria" . $suffisso . "' id='categoria" . $suffisso . "' class='select' onChange=\"ajaxSottocat('','" . $suffisso . "'); ajaxProdotto('','" . $suffisso . "'); \"><option value=''></option>"; foreach ($arrCat as $arr) { print "<option value='" . $arr["cat_id"] . "'"; if (isset($_REQUEST["evidenza"]) && $_REQUEST["evidenza"] == $arr["cat_id"]) { print " selected"; } print ">" . $arr["cat_categoria"] . "</option>"; } print "</select>"; } }
/** * @param string $backUrl * @param int $categorie_id * @return \Illuminate\Http\RedirectResponse */ public function add($backUrl = 'compet', $categorie_id = 0) { if ($categorie_id == 0) { return Redirect::route($backUrl); } $categorie = Categorie::find($categorie_id); $userclub = new Competcategorie(); $userclub->categorie_id = $categorie->id; $userclub->compet_id = MySession::getModel('compet')->id; $userclub->tee_id = $categorie->tee_id; $userclub->save(); return Redirect::route($backUrl); }
public static function getSamePost($id = "", $cate = "", $limit) { if ($cate != "" && $id != "") { if (Post::where('categorieID', $cate)->count() > 4) { $data = DB::select(" SELECT * FROM posts WHERE categorieID = {$cate} AND id != {$id} ORDER BY id ASC LIMIT 0, {$limit} "); } else { $parent = Categorie::find($cate)->parent; $data = DB::select(" SELECT * FROM posts WHERE parent = {$parent} AND id != {$id} ORDER BY id ASC LIMIT 0, {$limit} "); } } else { $data = DB::select("SELECT * FROM posts WHERE parent = 1 ORDER BY id DESC LIMIT 0, {$limit} "); } return $data; }
function _categories($fk_parent = 0, $keyword = '') { global $db, $conf; $TFille = array(); if (!empty($keyword)) { $resultset = $db->query("SELECT rowid FROM " . MAIN_DB_PREFIX . "categorie WHERE label LIKE '%" . addslashes($keyword) . "%' ORDER BY label"); while ($obj = $db->fetch_object($resultset)) { $cat = new Categorie($db); $cat->fetch($obj->rowid); $TFille[] = $cat; } } else { $parent = new Categorie($db); if (empty($fk_parent)) { if (empty($conf->global->SPC_DO_NOT_LOAD_PARENT_CAT)) { $TFille = $parent->get_all_categories(0, true); } } else { $parent->fetch($fk_parent); $TFille = $parent->get_filles(); } } return $TFille; }
/** * Delete category * * @param int $id Category ID * @return array * * @url DELETE category/{id} */ function delete($id) { if (!DolibarrApiAccess::$user->rights->categorie->supprimer) { throw new RestException(401); } $result = $this->category->fetch($id); if (!$result) { throw new RestException(404, 'category not found'); } if (!DolibarrApi::_checkAccessToResource('category', $this->category->id)) { throw new RestException(401, 'Access not allowed for login ' . DolibarrApiAccess::$user->login); } if (!$this->category->delete(DolibarrApiAccess::$user)) { throw new RestException(401, 'error when delete category'); } return array('success' => array('code' => 200, 'message' => 'Category deleted')); }
public static function callSelectOption($parent) { $result = array('--- Root ---'); $data = DB::select("SELECT * FROM categories"); foreach ($data as $k => $value) { if ($value->parent == $parent) { $result[$value->id] = $value->name; $data1 = Categorie::where('parent', '=', $value->id)->get(); foreach ($data1 as $value1) { $id1 = $value1['id']; $result[$id1] = "--" . $value1->name; $data2 = Categorie::where('parent', '=', $value1->id)->get(); foreach ($data2 as $value2) { $id2 = $value2['id']; $result[$id2] = "-----" . $value2->name; } } } } return $result; }
require '../main.inc.php'; require_once DOL_DOCUMENT_ROOT . '/categories/class/categorie.class.php'; require_once DOL_DOCUMENT_ROOT . '/core/lib/treeview.lib.php'; require_once DOL_DOCUMENT_ROOT . '/core/lib/functions2.lib.php'; $langs->load("categories"); if (!$user->rights->categorie->lire) { accessforbidden(); } $id = GETPOST('id', 'int'); $type = GETPOST('type') ? GETPOST('type') : Categorie::TYPE_PRODUCT; $catname = GETPOST('catname', 'alpha'); $section = GETPOST('section') ? GETPOST('section') : 0; /* * View */ $categstatic = new Categorie($db); $form = new Form($db); if ($type == Categorie::TYPE_PRODUCT) { $title = $langs->trans("ProductsCategoriesArea"); } elseif ($type == Categorie::TYPE_SUPPLIER) { $title = $langs->trans("SuppliersCategoriesArea"); } elseif ($type == Categorie::TYPE_CUSTOMER) { $title = $langs->trans("CustomersCategoriesArea"); } elseif ($type == Categorie::TYPE_MEMBER) { $title = $langs->trans("MembersCategoriesArea"); } elseif ($type == Categorie::TYPE_CONTACT) { $title = $langs->trans("ContactsCategoriesArea"); } else { $title = $langs->trans("CategoriesArea"); } $arrayofjs = array('/includes/jquery/plugins/jquerytreeview/jquery.treeview.js', '/includes/jquery/plugins/jquerytreeview/lib/jquery.cookie.js');
} if ($search_accountancy_code_buy) { $param = "&search_accountancy_code_buy=" . $search_accountancy_code_buy; } // Add $param from extra fields foreach ($search_array_options as $key => $val) { $crit = $val; $tmpkey = preg_replace('/search_options_/', '', $key); if ($val != '') { $param .= '&search_options_' . $tmpkey . '=' . urlencode($val); } } print_barre_liste($texte, $page, $_SERVER["PHP_SELF"], $param, $sortfield, $sortorder, '', $num, $nbtotalofrecords, 'title_products.png'); if (!empty($catid)) { print "<div id='ways'>"; $c = new Categorie($db); $ways = $c->print_all_ways(' > ', 'product/list.php'); print " > " . $ways[0] . "<br>\n"; print "</div><br>"; } if (!empty($canvas) && file_exists(DOL_DOCUMENT_ROOT . '/product/canvas/' . $canvas . '/actions_card_' . $canvas . '.class.php')) { $fieldlist = $object->field_list; $datas = $object->list_datas; $picto = 'title.png'; $title_picto = img_picto('', $picto); $title_text = $title; // Default templates directory $template_dir = DOL_DOCUMENT_ROOT . '/product/canvas/' . $canvas . '/tpl/'; // Check if a custom template is present if (file_exists(DOL_DOCUMENT_ROOT . '/theme/' . $conf->theme . '/tpl/product/' . $canvas . '/list.tpl.php')) { $template_dir = DOL_DOCUMENT_ROOT . '/theme/' . $conf->theme . '/tpl/product/' . $canvas . '/';
/** * Get list of products for a category * * @param array $authentication Array of authentication information * @param array $id Category id * @param $lang $lang Force lang * @return array Array result */ function getProductsForCategory($authentication, $id, $lang = '') { global $db, $conf, $langs; $langcode = $lang ? $lang : (empty($conf->global->MAIN_LANG_DEFAULT) ? 'auto' : $conf->global->MAIN_LANG_DEFAULT); $langs->setDefaultLang($langcode); dol_syslog("Function: getProductsForCategory login="******" id=" . $id); if ($authentication['entity']) { $conf->entity = $authentication['entity']; } $objectresp = array(); $errorcode = ''; $errorlabel = ''; $error = 0; $fuser = check_authentication($authentication, $error, $errorcode, $errorlabel); if (!$error && !$id) { $error++; $errorcode = 'BAD_PARAMETERS'; $errorlabel = "Parameter id must be provided."; } if (!$error) { $langcode = $lang ? $lang : (empty($conf->global->MAIN_LANG_DEFAULT) ? 'auto' : $conf->global->MAIN_LANG_DEFAULT); $langs->setDefaultLang($langcode); $fuser->getrights(); if ($fuser->rights->produit->lire) { $categorie = new Categorie($db); $result = $categorie->fetch($id); if ($result > 0) { $table = "product"; $field = "product"; $sql = "SELECT fk_" . $field . " FROM " . MAIN_DB_PREFIX . "categorie_" . $table; $sql .= " WHERE fk_categorie = " . $id; $sql .= " ORDER BY fk_" . $field . " ASC"; dol_syslog("getProductsForCategory get id of product into category", LOG_DEBUG); $res = $db->query($sql); if ($res) { while ($rec = $db->fetch_array($res)) { $obj = new Product($db); $obj->fetch($rec['fk_' . $field]); $iProduct = 0; if ($obj->status > 0) { $dir = !empty($conf->product->dir_output) ? $conf->product->dir_output : $conf->service->dir_output; $pdir = get_exdir($obj->id, 2) . $obj->id . "/photos/"; $dir = $dir . '/' . $pdir; $products[] = array('id' => $obj->id, 'ref' => $obj->ref, 'ref_ext' => $obj->ref_ext, 'label' => !empty($obj->multilangs[$langs->defaultlang]["label"]) ? $obj->multilangs[$langs->defaultlang]["label"] : $obj->label, 'description' => !empty($obj->multilangs[$langs->defaultlang]["description"]) ? $obj->multilangs[$langs->defaultlang]["description"] : $obj->description, 'date_creation' => dol_print_date($obj->date_creation, 'dayhourrfc'), 'date_modification' => dol_print_date($obj->date_modification, 'dayhourrfc'), 'note' => !empty($obj->multilangs[$langs->defaultlang]["note"]) ? $obj->multilangs[$langs->defaultlang]["note"] : $obj->note, 'status_tosell' => $obj->status, 'status_tobuy' => $obj->status_buy, 'type' => $obj->type, 'barcode' => $obj->barcode, 'barcode_type' => $obj->barcode_type, 'country_id' => $obj->country_id > 0 ? $obj->country_id : '', 'country_code' => $obj->country_code, 'custom_code' => $obj->customcode, 'price_net' => $obj->price, 'price' => $obj->price_ttc, 'vat_rate' => $obj->tva_tx, 'price_base_type' => $obj->price_base_type, 'stock_real' => $obj->stock_reel, 'stock_alert' => $obj->seuil_stock_alerte, 'pmp' => $obj->pmp, 'import_key' => $obj->import_key, 'dir' => $pdir, 'images' => $obj->liste_photos($dir, $nbmax = 10)); //Retreive all extrafield for thirdsparty // fetch optionals attributes and labels $extrafields = new ExtraFields($db); $extralabels = $extrafields->fetch_name_optionals_label('product', true); //Get extrafield values $product->fetch_optionals($obj->id, $extralabels); foreach ($extrafields->attribute_label as $key => $label) { $products[$iProduct] = array_merge($products[$iProduct], array('options_' . $key => $product->array_options['options_' . $key])); } $iProduct++; } } // Retour $objectresp = array('result' => array('result_code' => 'OK', 'result_label' => ''), 'products' => $products); } else { $errorcode = 'NORECORDS_FOR_ASSOCIATION'; $errorlabel = 'No products associated' . $sql; $objectresp = array('result' => array('result_code' => $errorcode, 'result_label' => $errorlabel)); dol_syslog("getProductsForCategory:: " . $c->error, LOG_DEBUG); } } else { $error++; $errorcode = 'NOT_FOUND'; $errorlabel = 'Object not found for id=' . $id; } } else { $error++; $errorcode = 'PERMISSION_DENIED'; $errorlabel = 'User does not have permission for this request'; } } if ($error) { $objectresp = array('result' => array('result_code' => $errorcode, 'result_label' => $errorlabel)); } return $objectresp; }
require_once DOL_DOCUMENT_ROOT . '/core/class/html.formother.class.php'; $langs->load("categories"); $id = GETPOST('id', 'int'); $ref = GETPOST('ref'); $type = GETPOST('type'); $action = GETPOST('action'); $confirm = GETPOST('confirm'); $removeelem = GETPOST('removeelem', 'int'); $elemid = GETPOST('elemid'); if ($id == "") { dol_print_error('', 'Missing parameter id'); exit; } // Security check $result = restrictedArea($user, 'categorie', $id, '&category'); $object = new Categorie($db); $result = $object->fetch($id); $object->fetch_optionals($id, $extralabels); if ($result <= 0) { dol_print_error($db, $object->error); exit; } $type = $object->type; $extrafields = new ExtraFields($db); $extralabels = $extrafields->fetch_name_optionals_label($object->table_element); // Initialize technical object to manage hooks. Note that conf->hooks_modules contains array array $hookmanager->initHooks(array('categorycard')); /* * Actions */ // Remove element from category
/** * Delete a third party from database and all its dependencies (contacts, rib...) * @param id id of third party to delete */ function delete($id) { global $user,$langs,$conf; require_once(DOL_DOCUMENT_ROOT."/lib/files.lib.php"); dol_syslog("Societe::Delete", LOG_DEBUG); $sqr = 0; // Test if child exists $listtable=array("propal","commande","facture","contrat","facture_fourn","commande_fournisseur"); $haschild=0; foreach($listtable as $table) { // Check if third party can be deleted $nb=0; $sql = "SELECT COUNT(*) as nb from ".MAIN_DB_PREFIX.$table; $sql.= " WHERE fk_soc = " . $id; $resql=$this->db->query($sql); if ($resql) { $obj=$this->db->fetch_object($resql); if ($obj->nb > 0) { $haschild+=$obj->nb; } } else { $this->error .= $this->db->lasterror(); dol_syslog("Societe::Delete erreur -1 ".$this->error, LOG_ERR); return -1; } } if ($haschild > 0) { $this->error="ErrorRecordHasChildren"; return -1; } if ($this->db->begin()) { // Added by Matelli (see http://matelli.fr/showcases/patchs-dolibarr/fix-third-party-deleting.html) // Removing every "categorie" link with this company require_once(DOL_DOCUMENT_ROOT."/categories/class/categorie.class.php"); $static_cat = new Categorie($this->db); $toute_categs = array(); // Fill $toute_categs array with an array of (type => array of ("Categorie" instance)) if ($this->client || $this->prospect) { $toute_categs ['societe'] = $static_cat->containing($this->id,2); } if ($this->fournisseur) { $toute_categs ['fournisseur'] = $static_cat->containing($this->id,1); } // Remove each "Categorie" foreach ($toute_categs as $type => $categs_type) { foreach ($categs_type as $cat) { $cat->del_type($this, $type); } } // Remove contacts $sql = "DELETE from ".MAIN_DB_PREFIX."socpeople"; $sql.= " WHERE fk_soc = " . $id; dol_syslog("Societe::Delete sql=".$sql, LOG_DEBUG); if ($this->db->query($sql)) { $sqr++; } else { $this->error .= $this->db->lasterror(); dol_syslog("Societe::Delete erreur -1 ".$this->error, LOG_ERR); } // Update link in member table $sql = "UPDATE ".MAIN_DB_PREFIX."adherent"; $sql.= " SET fk_soc = NULL WHERE fk_soc = " . $id; dol_syslog("Societe::Delete sql=".$sql, LOG_DEBUG); if ($this->db->query($sql)) { $sqr++; } else { $this->error .= $this->db->lasterror(); dol_syslog("Societe::Delete erreur -1 ".$this->error, LOG_ERR); } // Remove ban $sql = "DELETE from ".MAIN_DB_PREFIX."societe_rib"; $sql.= " WHERE fk_soc = " . $id; dol_syslog("Societe::Delete sql=".$sql, LOG_DEBUG); if ($this->db->query($sql)) { $sqr++; } else { $this->error = $this->db->lasterror(); dol_syslog("Societe::Delete erreur -2 ".$this->error, LOG_ERR); } // Remove third party $sql = "DELETE from ".MAIN_DB_PREFIX."societe"; $sql.= " WHERE rowid = " . $id; dol_syslog("Societe::Delete sql=".$sql, LOG_DEBUG); if ($this->db->query($sql)) { $sqr++; } else { $this->error = $this->db->lasterror(); dol_syslog("Societe::Delete erreur -3 ".$this->error, LOG_ERR); } if ($sqr == 4) { // Appel des triggers include_once(DOL_DOCUMENT_ROOT . "/core/class/interfaces.class.php"); $interface=new Interfaces($this->db); $result=$interface->run_triggers('COMPANY_DELETE',$this,$user,$langs,$conf); if ($result < 0) { $error++; $this->errors=$interface->errors; } // Fin appel triggers $this->db->commit(); // Suppression du repertoire document $docdir = $conf->societe->dir_output . "/" . $id; if (file_exists ($docdir)) { dol_delete_dir_recursive($docdir); } return 1; } else { $this->db->rollback(); return -1; } } }
$langs->load("categories"); $langs->load("products"); $langs->load("contacts"); $mesg = ''; $id = GETPOST('id', 'int'); $ref = GETPOST('ref'); $type = GETPOST('type'); $action = GETPOST('action'); $confirm = GETPOST('confirm'); if ($id == "") { dol_print_error('', 'Missing parameter id'); exit; } // Security check $result = restrictedArea($user, 'categorie', $id, '&category'); $object = new Categorie($db); $result = $object->fetch($id); if ($result <= 0) { dol_print_error($db, $object->error); exit; } $type = $object->type; /* * Actions */ if ($user->rights->categorie->supprimer && $action == 'confirm_delete' && $confirm == 'yes') { if ($object->delete($user) >= 0) { header("Location: " . DOL_URL_ROOT . '/categories/index.php?type=' . $type); exit; } else { $mesg = '<div class="error">' . $object->error . '</div>';
/** * Delete a third party from database and all its dependencies (contacts, rib...) * * @param int $id Id of third party to delete * @return int <0 if KO, 0 if nothing done, >0 if OK */ function delete($id) { global $user, $langs, $conf; require_once(DOL_DOCUMENT_ROOT . "/core/lib/files.lib.php"); dol_syslog(get_class($this) . "::delete", LOG_DEBUG); $error = 0; // Test if child exists //$objectisused = $this->isObjectUsed($this->rowid); // TODO A reactivier if (empty($objectisused)) { require_once(DOL_DOCUMENT_ROOT . "/categories/class/categorie.class.php"); $static_cat = new Categorie($this->db); $toute_categs = array(); // Fill $toute_categs array with an array of (type => array of ("Categorie" instance)) if ($this->client || $this->prospect) { $toute_categs ['societe'] = $static_cat->containing($this->id, 2); } if ($this->fournisseur) { $toute_categs ['fournisseur'] = $static_cat->containing($this->id, 1); } // Remove each "Categorie" foreach ($toute_categs as $type => $categs_type) { foreach ($categs_type as $cat) { $cat->del_type($this, $type); } } return parent::delete(); // TODO Supprimer les contacts // Remove contacts if (!$error) { $sql = "DELETE FROM " . MAIN_DB_PREFIX . "socpeople"; $sql.= " WHERE fk_soc = " . $id; dol_syslog(get_class($this) . "::delete sql=" . $sql, LOG_DEBUG); if (!$this->db->query($sql)) { $error++; $this->error .= $this->db->lasterror(); dol_syslog(get_class($this) . "::delete erreur -1 " . $this->error, LOG_ERR); } } // Update link in member table if (!$error) { $sql = "UPDATE " . MAIN_DB_PREFIX . "adherent"; $sql.= " SET fk_soc = NULL WHERE fk_soc = " . $id; dol_syslog(get_class($this) . "::delete sql=" . $sql, LOG_DEBUG); if (!$this->db->query($sql)) { $error++; $this->error .= $this->db->lasterror(); dol_syslog(get_class($this) . "::delete erreur -1 " . $this->error, LOG_ERR); } } // Remove ban if (!$error) { $sql = "DELETE FROM " . MAIN_DB_PREFIX . "societe_rib"; $sql.= " WHERE fk_soc = " . $id; dol_syslog(get_class($this) . "::Delete sql=" . $sql, LOG_DEBUG); if (!$this->db->query($sql)) { $error++; $this->error = $this->db->lasterror(); dol_syslog(get_class($this) . "::Delete erreur -2 " . $this->error, LOG_ERR); } } // Removed extrafields //$result=$this->deleteExtraFields($this); //if ($result < 0) $error++; if (!$error) { // Additionnal action by hooks include_once(DOL_DOCUMENT_ROOT . '/core/class/hookmanager.class.php'); $hookmanager = new HookManager($this->db); $hookmanager->initHooks(array('thirdparty_extrafields')); $parameters = array(); $action = 'delete'; $reshook = $hookmanager->executeHooks('deleteThirdparty', $parameters, $this, $action); // Note that $action and $object may have been modified by some hooks if (!empty($hookmanager->error)) { $error++; $this->error = $hookmanager->error; } } // Remove third party if (!$error) { $sql = "DELETE FROM " . MAIN_DB_PREFIX . "societe"; $sql.= " WHERE rowid = " . $id; dol_syslog(get_class($this) . "::delete sql=" . $sql, LOG_DEBUG); if (!$this->db->query($sql)) { $error++; $this->error = $this->db->lasterror(); dol_syslog(get_class($this) . "::delete erreur -3 " . $this->error, LOG_ERR); } } if (!$error) { // Appel des triggers include_once(DOL_DOCUMENT_ROOT . "/core/class/interfaces.class.php"); $interface = new Interfaces($this->db); $result = $interface->run_triggers('COMPANY_DELETE', $this, $user, $langs, $conf); if ($result < 0) { $error++; $this->errors = $interface->errors; } // Fin appel triggers } if (!$error) { $this->db->commit(); // Delete directory $docdir = $conf->societe->multidir_output[$this->entity] . "/" . $id; if (file_exists($docdir)) { dol_delete_dir_recursive($docdir); } return 1; } else { $this->db->rollback(); return -1; } } }
<?php include_once $_SERVER["DOCUMENT_ROOT"] . "/admin/classes/utils.php"; require $_SERVER["DOCUMENT_ROOT"] . "/inc/inc.config.php"; require $_SERVER["DOCUMENT_ROOT"] . "/admin/classes/Categorie.php"; require $_SERVER["DOCUMENT_ROOT"] . "/admin/classes/Produit.php"; require $_SERVER["DOCUMENT_ROOT"] . "/admin/classes/Produit_image.php"; $debug = false; $categorie = new Categorie(); $produit = new Produit(); $produit_image = new Produit_image(); // ---- Liste des catégories de niveau 0 ------ // if (1 == 1) { unset($recherche); $recherche["id_parent"] = 0; $liste_categorie = $categorie->getListe($recherche, $debug); } // -------------------------------------------- // ?> <!doctype html> <html class="no-js" lang="fr"> <head> <title>Les différents aménagements de Modul-Ouest</title> <?php include $_SERVER["DOCUMENT_ROOT"] . "/inc/header.php"; ?> </head> <body class="page">
<?php $manager = new UserManager($link); $user = $manager->selectById($_SESSION['id']); $manager = new Categorie($link); $topic = $manager->selectById($_GET['id']); if (isset($topic)) { require './views/modify-topic.phtml'; }