alxarafe /
alixar
| 1 | <?php |
||
| 738 | //$sql.= " ORDER BY code ASC"; |
||
| 739 | |||
| 740 | dol_syslog(get_class($this) . "::select_country", LOG_DEBUG); |
||
| 741 | $resql = $this->db->query($sql); |
||
|
Bug
Best Practice
introduced
by
|
|||
| 742 | if ($resql) {
|
||
| 743 | $out .= '<select id="select' . $htmlname . '" class="flat maxwidth200onsmartphone selectcountry' . ($morecss ? ' ' . $morecss : '') . '" name="' . $htmlname . '" ' . $htmloption . '>'; |
||
| 744 | $num = $this->db->num_rows($resql); |
||
| 846 | $sql .= " ORDER BY code ASC"; |
||
| 847 | |||
| 848 | dol_syslog(get_class($this) . "::select_incoterm", LOG_DEBUG); |
||
| 849 | $resql = $this->db->query($sql); |
||
| 850 | if ($resql) {
|
||
| 851 | if (Globals::$conf->use_javascript_ajax && !$forcecombo) {
|
||
| 852 | include_once DOL_DOCUMENT_ROOT . '/core/lib/ajax.lib.php'; |
||
| 978 | $sql .= " FROM " . MAIN_DB_PREFIX . "c_type_fees as c"; |
||
| 979 | $sql .= " WHERE active > 0"; |
||
| 980 | |||
| 981 | $resql = $this->db->query($sql); |
||
| 982 | if ($resql) {
|
||
| 983 | $num = $this->db->num_rows($resql); |
||
| 984 | $i = 0; |
||
| 1092 | $placeholder = ''; |
||
| 1093 | if ($selected && empty($selected_input_value)) {
|
||
| 1094 | require_once DOL_DOCUMENT_ROOT . '/societe/class/societe.class.php'; |
||
| 1095 | $societetmp = new Societe($this->db); |
||
| 1096 | $societetmp->fetch($selected); |
||
| 1097 | $selected_input_value = $societetmp->name; |
||
| 1098 | unset($societetmp); |
||
| 1198 | foreach ($scrit as $crit) {
|
||
| 1199 | if ($i > 0) |
||
| 1200 | $sql .= " AND "; |
||
| 1201 | $sql .= "(s.nom LIKE '" . $this->db->escape($prefix . $crit) . "%')"; |
||
| 1202 | $i++; |
||
| 1203 | } |
||
| 1204 | if (count($scrit) > 1) |
||
| 1333 | $sql .= " ORDER BY re.description ASC"; |
||
| 1334 | |||
| 1335 | dol_syslog(get_class($this) . "::select_remises", LOG_DEBUG); |
||
| 1336 | $resql = $this->db->query($sql); |
||
| 1337 | if ($resql) {
|
||
| 1338 | print '<select id="select_' . $htmlname . '" class="flat maxwidthonsmartphone" name="' . $htmlname . '">'; |
||
| 1339 | $num = $this->db->num_rows($resql); |
||
| 1452 | |||
| 1453 | if (!is_object($hookmanager)) {
|
||
| 1454 | include_once DOL_DOCUMENT_ROOT . '/core/class/hookmanager.class.php'; |
||
| 1455 | $hookmanager = new HookManager($this->db); |
||
| 1456 | } |
||
| 1457 | |||
| 1458 | // We search third parties |
||
| 1691 | } |
||
| 1692 | |||
| 1693 | dol_syslog(get_class($this) . "::select_dolusers", LOG_DEBUG); |
||
| 1694 | $resql = $this->db->query($sql); |
||
| 1695 | if ($resql) {
|
||
| 1696 | $num = $this->db->num_rows($resql); |
||
| 1697 | $i = 0; |
||
| 1816 | // phpcs:enable |
||
| 1817 | global $conf, $user, $langs; |
||
| 1818 | |||
| 1819 | $userstatic = new User($this->db); |
||
| 1820 | $out = ''; |
||
| 1821 | |||
| 1822 | // Method with no ajax |
||
| 1915 | |||
| 1916 | if ($selected && empty($selected_input_value)) {
|
||
| 1917 | require_once DOL_DOCUMENT_ROOT . '/product/class/product.class.php'; |
||
| 1918 | $producttmpselect = new Product($this->db); |
||
| 1919 | $producttmpselect->fetch($selected); |
||
| 1920 | $selected_input_value = $producttmpselect->ref; |
||
| 1921 | unset($producttmpselect); |
||
| 2132 | |||
| 2133 | $sql .= ' WHERE p.entity IN (' . getEntity('product') . ')';
|
||
| 2134 | if (count($warehouseStatusArray)) {
|
||
| 2135 | $sql .= ' AND (p.fk_product_type = 1 OR e.statut IN (' . $this->db->escape(implode(',', $warehouseStatusArray)) . '))';
|
||
| 2136 | } |
||
| 2137 | |||
| 2138 | if (!empty(Globals::$conf->global->PRODUIT_ATTRIBUTES_HIDECHILD)) {
|
||
| 2393 | $sql .= " LIMIT 1"; |
||
| 2394 | |||
| 2395 | dol_syslog(get_class($this) . '::constructProductListOption search price for level ' . $price_level . '', LOG_DEBUG); |
||
| 2396 | $result2 = $this->db->query($sql); |
||
| 2397 | if ($result2) {
|
||
| 2398 | $objp2 = $this->db->fetch_object($result2); |
||
| 2399 | if ($objp2) {
|
||
| 2528 | if (!empty(Globals::$conf->use_javascript_ajax) && !empty(Globals::$conf->global->PRODUIT_USE_SEARCH_TO_SELECT)) {
|
||
| 2529 | if ($selected > 0) {
|
||
| 2530 | require_once DOL_DOCUMENT_ROOT . '/product/class/product.class.php'; |
||
| 2531 | $producttmpselect = new Product($this->db); |
||
| 2532 | $producttmpselect->fetch($selected); |
||
| 2533 | $selected_input_value = $producttmpselect->ref; |
||
| 2534 | unset($producttmpselect); |
||
| 2581 | $sql .= " WHERE p.entity IN (" . getEntity('product') . ")";
|
||
| 2582 | $sql .= " AND p.tobuy = 1"; |
||
| 2583 | if (strval($filtertype) != '') |
||
| 2584 | $sql .= " AND p.fk_product_type=" . $this->db->escape($filtertype); |
||
| 2585 | if (!empty($filtre)) |
||
| 2586 | $sql .= " " . $filtre; |
||
| 2587 | // Add criteria on ref/label |
||
| 2798 | $sql .= " ORDER BY s.nom, pfp.ref_fourn DESC"; |
||
| 2799 | |||
| 2800 | dol_syslog(get_class($this) . "::select_product_fourn_price", LOG_DEBUG); |
||
| 2801 | $result = $this->db->query($sql); |
||
| 2802 | |||
| 2803 | if ($result) {
|
||
| 2804 | $num = $this->db->num_rows($result); |
||
| 2891 | $sql .= " ORDER BY a.label ASC"; |
||
| 2892 | |||
| 2893 | dol_syslog(get_class($this) . "::select_address", LOG_DEBUG); |
||
| 2894 | $resql = $this->db->query($sql); |
||
| 2895 | if ($resql) {
|
||
| 2896 | print '<select class="flat" id="select_' . $htmlname . '" name="' . $htmlname . '">'; |
||
| 2897 | if ($showempty) |
||
| 2940 | $sql .= " AND active > 0"; |
||
| 2941 | $sql .= " ORDER BY sortorder"; |
||
| 2942 | |||
| 2943 | $resql = $this->db->query($sql); |
||
| 2944 | if ($resql) {
|
||
| 2945 | $num = $this->db->num_rows($resql); |
||
| 2946 | $i = 0; |
||
| 2986 | $sql .= " FROM " . MAIN_DB_PREFIX . 'c_availability'; |
||
| 2987 | $sql .= " WHERE active > 0"; |
||
| 2988 | |||
| 2989 | $resql = $this->db->query($sql); |
||
| 2990 | if ($resql) {
|
||
| 2991 | $num = $this->db->num_rows($resql); |
||
| 2992 | $i = 0; |
||
| 3060 | $sql .= " FROM " . MAIN_DB_PREFIX . 'c_input_reason'; |
||
| 3061 | $sql .= " WHERE active > 0"; |
||
| 3062 | |||
| 3063 | $resql = $this->db->query($sql); |
||
| 3064 | if ($resql) {
|
||
| 3065 | $num = $this->db->num_rows($resql); |
||
| 3066 | $i = 0; |
||
| 3153 | $sql .= " WHERE entity IN (" . getEntity('c_paiement') . ")";
|
||
| 3154 | //if ($active >= 0) $sql.= " AND active = ".$active; |
||
| 3155 | |||
| 3156 | $resql = $this->db->query($sql); |
||
| 3157 | if ($resql) {
|
||
| 3158 | $num = $this->db->num_rows($resql); |
||
| 3159 | $i = 0; |
||
| 3357 | $sql .= " ORDER BY libelle ASC"; |
||
| 3358 | |||
| 3359 | dol_syslog(get_class($this) . "::selectShippingMode", LOG_DEBUG); |
||
| 3360 | $result = $this->db->query($sql); |
||
| 3361 | if ($result) {
|
||
| 3362 | $num = $this->db->num_rows($result); |
||
| 3363 | $i = 0; |
||
| 3437 | $opt = '<option value ="" selected></option>'; |
||
| 3438 | $sql = 'SELECT rowid, ref, situation_cycle_ref, situation_counter, situation_final, fk_soc FROM ' . MAIN_DB_PREFIX . 'facture WHERE situation_counter>=1'; |
||
| 3439 | $sql .= ' ORDER by situation_cycle_ref, situation_counter desc'; |
||
| 3440 | $resql = $this->db->query($sql); |
||
| 3441 | if ($resql && $this->db->num_rows($resql) > 0) {
|
||
| 3442 | // Last seen cycle |
||
| 3443 | $ref = 0; |
||
| 3490 | $sql = 'SELECT rowid, label, code from ' . MAIN_DB_PREFIX . 'c_units'; |
||
| 3491 | $sql .= ' WHERE active > 0'; |
||
| 3492 | |||
| 3493 | $resql = $this->db->query($sql); |
||
| 3494 | if ($resql && $this->db->num_rows($resql) > 0) {
|
||
| 3495 | if ($showempty) |
||
| 3496 | $return .= '<option value="none"></option>'; |
||
| 3543 | $sql .= " ORDER BY label"; |
||
| 3544 | |||
| 3545 | dol_syslog(get_class($this) . "::select_comptes", LOG_DEBUG); |
||
| 3546 | $result = $this->db->query($sql); |
||
| 3547 | if ($result) {
|
||
| 3548 | $num = $this->db->num_rows($result); |
||
| 3549 | $i = 0; |
||
| 3610 | |||
| 3611 | if ($selected) {
|
||
| 3612 | require_once DOL_DOCUMENT_ROOT . '/compta/bank/class/account.class.php'; |
||
| 3613 | $bankstatic = new Account($this->db); |
||
| 3614 | $result = $bankstatic->fetch($selected); |
||
| 3615 | if ($result) |
||
| 3616 | print $bankstatic->getNomUrl(1); |
||
| 3653 | $sql .= " FROM " . MAIN_DB_PREFIX . "bank_categ as c"; |
||
| 3654 | $sql .= " WHERE entity = " . Globals::$conf->entity; |
||
| 3655 | $sql .= " ORDER BY c.label"; |
||
| 3656 | $result = $this->db->query($sql); |
||
| 3657 | if ($result) {
|
||
| 3658 | $num = $this->db->num_rows($result); |
||
| 3659 | $i = 0; |
||
| 4027 | |||
| 4028 | $out = ''; |
||
| 4029 | |||
| 4030 | $formproject = new FormProjets($this->db); |
||
| 4031 | |||
| 4032 | $langs->load("project");
|
||
| 4033 | if ($htmlname != "none") {
|
||
| 4221 | } else {
|
||
| 4222 | if ($selected) {
|
||
| 4223 | require_once DOL_DOCUMENT_ROOT . '/user/class/user.class.php'; |
||
| 4224 | $theuser = new User($this->db); |
||
| 4225 | $theuser->fetch($selected); |
||
| 4226 | print $theuser->getNomUrl(1); |
||
| 4227 | } else {
|
||
| 4451 | } else {
|
||
| 4452 | if ($selected) {
|
||
| 4453 | require_once DOL_DOCUMENT_ROOT . '/contact/class/contact.class.php'; |
||
| 4454 | $contact = new Contact($this->db); |
||
| 4455 | $contact->fetch($selected); |
||
| 4456 | print $contact->getFullName($langs); |
||
| 4457 | } else {
|
||
| 4491 | } else {
|
||
| 4492 | if ($selected) {
|
||
| 4493 | require_once DOL_DOCUMENT_ROOT . '/societe/class/societe.class.php'; |
||
| 4494 | $soc = new Societe($this->db); |
||
| 4495 | $soc->fetch($selected); |
||
| 4496 | $out .= $soc->getNomUrl($langs); |
||
| 4497 | } else {
|
||
| 4640 | $sql .= " AND c.code IN (" . $country_code . ")";
|
||
| 4641 | $sql .= " ORDER BY t.code ASC, t.taux ASC, t.recuperableonly ASC"; |
||
| 4642 | |||
| 4643 | $resql = $this->db->query($sql); |
||
| 4644 | if ($resql) {
|
||
| 4645 | $num = $this->db->num_rows($resql); |
||
| 4646 | if ($num) {
|
||
| 4753 | } else if (!$idprod) { // We don't know type of product
|
||
| 4754 | $code_country .= ",'" . $societe_acheteuse->country_code . "'"; |
||
| 4755 | } else {
|
||
| 4756 | $prodstatic = new Product($this->db); |
||
| 4757 | $prodstatic->fetch($idprod); |
||
| 4758 | if ($prodstatic->type == Product::TYPE_SERVICE) { // We know product is a service
|
||
| 4759 | $code_country .= ",'" . $societe_acheteuse->country_code . "'"; |
||
| 5360 | if (!empty($classpath)) {
|
||
| 5361 | dol_include_once($classpath); |
||
| 5362 | if ($classname && class_exists($classname)) {
|
||
| 5363 | $objecttmp = new $classname($this->db); |
||
| 5364 | } |
||
| 5365 | } |
||
| 5366 | if (!is_object($objecttmp)) {
|
||
| 5458 | if ($objecttmp->ismultientitymanaged == 2) |
||
| 5459 | if (!$user->rights->societe->client->voir && !$user->societe_id) |
||
| 5460 | $sql .= " AND t.rowid = sc.fk_soc AND sc.fk_user = " . $user->id; |
||
| 5461 | $sql .= $this->db->order($fieldstoshow, "ASC"); |
||
| 5462 | //$sql.=$this->db->plimit($limit, 0); |
||
| 5463 | // Build output string |
||
| 5464 | $resql = $this->db->query($sql); |
||
| 6257 | $listofidcompanytoscan .= ',' . $object->thirdparty->parent; |
||
| 6258 | if (($object->fk_project > 0) && !empty(Globals::$conf->global->THIRDPARTY_INCLUDE_PROJECT_THIRDPARY_IN_LINKTO)) {
|
||
| 6259 | include_once DOL_DOCUMENT_ROOT . '/projet/class/project.class.php'; |
||
| 6260 | $tmpproject = new Project($this->db); |
||
| 6261 | $tmpproject->fetch($object->fk_project); |
||
| 6262 | if ($tmpproject->socid > 0 && ($tmpproject->socid != $object->thirdparty->id)) |
||
| 6263 | $listofidcompanytoscan .= ',' . $tmpproject->socid; |
||
| 6441 | $sql .= " FROM " . MAIN_DB_PREFIX . "export_model"; |
||
| 6442 | $sql .= " WHERE type = '" . $type . "'"; |
||
| 6443 | $sql .= " ORDER BY rowid"; |
||
| 6444 | $result = $this->db->query($sql); |
||
| 6445 | if ($result) {
|
||
| 6446 | print '<select class="flat" id="select_' . $htmlname . '" name="' . $htmlname . '">'; |
||
| 6447 | if ($useempty) {
|
||
| 6876 | $sql .= " ORDER BY ug.nom ASC"; |
||
| 6877 | |||
| 6878 | dol_syslog(get_class($this) . "::select_dolgroups", LOG_DEBUG); |
||
| 6879 | $resql = $this->db->query($sql); |
||
| 6880 | if ($resql) {
|
||
| 6881 | // Enhance with select2 |
||
| 6882 | include_once DOL_DOCUMENT_ROOT . '/core/lib/ajax.lib.php'; |
||
| 7167 |
Loading history...