alxarafe /
alixar
| 1 | <?php |
||
| 479 | $this->country =$tmparray['label']; |
||
| 480 | } |
||
| 481 | |||
| 482 | if ($withregion && $this->state_id && (empty($this->state_code) || empty($this->state) || empty($this->region) || empty($this->region_cpde))) |
||
|
Bug
introduced
by
|
|||
| 483 | {
|
||
| 484 | require_once DOL_DOCUMENT_ROOT .'/core/lib/company.lib.php'; |
||
| 485 | $tmparray=getState($this->state_id,'all',0,1); |
||
| 562 | $out.=dol_print_phone($this->phone_mobile,$this->country_code,$contactid,$thirdpartyid,'AC_TEL',' ','mobile',$langs->trans("PhoneMobile")); $outdone++;
|
||
| 563 | } |
||
| 564 | if (! empty($this->phone_perso)) {
|
||
| 565 | $out.=dol_print_phone($this->phone_perso,$this->country_code,$contactid,$thirdpartyid,'AC_TEL',' ','phone',$langs->trans("PhonePerso")); $outdone++;
|
||
| 566 | } |
||
| 567 | if (! empty($this->office_phone)) {
|
||
| 568 | $out.=dol_print_phone($this->office_phone,$this->country_code,$contactid,$thirdpartyid,'AC_TEL',' ','phone',$langs->trans("PhonePro")); $outdone++;
|
||
| 586 | } |
||
| 587 | if (! empty($this->url)) |
||
| 588 | {
|
||
| 589 | $out.=dol_print_url($this->url,'_goout',0,1); |
||
| 590 | $outdone++; |
||
| 591 | } |
||
| 592 | $out.='<div style="clear: both;">'; |
||
| 593 | if (!empty(Globals::$conf->socialnetworks->enabled)) {
|
||
| 594 | if ($this->skype) $out.=dol_print_socialnetworks($this->skype,$this->id,$object->id,'skype'); |
||
| 595 | $outdone++; |
||
| 596 | if ($this->jabberid) $out.=dol_print_socialnetworks($this->jabberid,$this->id,$object->id,'jabber'); |
||
| 597 | $outdone++; |
||
| 598 | if ($this->twitter) $out.=dol_print_socialnetworks($this->twitter,$this->id,$object->id,'twitter'); |
||
| 599 | $outdone++; |
||
| 625 | } |
||
| 626 | |||
| 627 | include_once DOL_DOCUMENT_ROOT.'/ecm/class/ecmfiles.class.php'; |
||
| 628 | $ecmfile=new EcmFiles($this->db); |
||
| 629 | $result = $ecmfile->fetch(0, '', $this->last_main_doc); |
||
| 630 | if ($result < 0) |
||
| 631 | {
|
||
| 632 | $this->error = $ecmfile->error; |
||
| 779 | |||
| 780 | if(!$already_added) {
|
||
| 781 | |||
| 782 | $this->db->begin(); |
||
| 783 | |||
| 784 | // Insert into database |
||
| 785 | $sql = "INSERT INTO ".MAIN_DB_PREFIX."element_contact"; |
||
| 828 | /** |
||
| 829 | * Copy contact from one element to current |
||
| 830 | * |
||
| 831 | * @param CommonObject $objFrom Source element |
||
| 832 | * @param string $source Nature of contact ('internal' or 'external')
|
||
| 833 | * @return int >0 if OK, <0 if KO |
||
| 834 | */ |
||
| 840 | {
|
||
| 841 | if ($this->add_contact($contact['id'], $contact['fk_c_type_contact'], $contact['source']) < 0) |
||
| 842 | {
|
||
| 843 | $this->error=$this->db->lasterror(); |
||
| 844 | return -1; |
||
| 845 | } |
||
| 846 | } |
||
| 866 | if ($type_contact_id) $sql.= ", fk_c_type_contact = '".$type_contact_id ."'"; |
||
| 867 | if ($fk_socpeople) $sql.= ", fk_socpeople = '".$fk_socpeople ."'"; |
||
| 868 | $sql.= " where rowid = ".$rowid; |
||
| 869 | $resql=$this->db->query($sql); |
||
| 870 | if ($resql) |
||
| 871 | {
|
||
| 872 | return 0; |
||
| 892 | global $user; |
||
| 893 | |||
| 894 | |||
| 895 | $this->db->begin(); |
||
| 896 | |||
| 897 | $sql = "DELETE FROM ".MAIN_DB_PREFIX."element_contact"; |
||
| 898 | $sql.= " WHERE rowid =".$rowid; |
||
| 943 | $sql.= " AND fk_c_type_contact IN (".$listId.")";
|
||
| 944 | |||
| 945 | dol_syslog(get_class($this)."::delete_linked_contact", LOG_DEBUG); |
||
| 946 | if ($this->db->query($sql)) |
||
| 947 | {
|
||
| 948 | return 1; |
||
| 949 | } |
||
| 982 | if ($source == 'external'|| $source == 'thirdparty') $sql.=" LEFT JOIN ".MAIN_DB_PREFIX."socpeople t on ec.fk_socpeople = t.rowid"; |
||
| 983 | $sql.= " WHERE ec.element_id =".$this->id; |
||
| 984 | $sql.= " AND ec.fk_c_type_contact=tc.rowid"; |
||
| 985 | $sql.= " AND tc.element='".$this->db->escape($this->element)."'"; |
||
| 986 | if ($code) $sql.= " AND tc.code = '".$this->db->escape($code)."'"; |
||
| 987 | if ($source == 'internal') $sql.= " AND tc.source = 'internal'"; |
||
| 988 | if ($source == 'external' || $source == 'thirdparty') $sql.= " AND tc.source = 'external'"; |
||
| 1043 | //$sql.= " LEFT JOIN ".MAIN_DB_PREFIX."socpeople as s ON ec.fk_socpeople=s.rowid"; // Si contact de type external, alors il est lie a une societe |
||
| 1044 | $sql.= " WHERE ec.rowid =".$rowid; |
||
| 1045 | $sql.= " AND ec.fk_c_type_contact=tc.rowid"; |
||
| 1046 | $sql.= " AND tc.element = '".$this->db->escape($this->element)."'"; |
||
| 1047 | |||
| 1048 | dol_syslog(get_class($this)."::swapContactStatus", LOG_DEBUG); |
||
| 1049 | $resql=$this->db->query($sql); |
||
| 1085 | $tab = array(); |
||
| 1086 | $sql = "SELECT DISTINCT tc.rowid, tc.code, tc.libelle, tc.position"; |
||
| 1087 | $sql.= " FROM ".MAIN_DB_PREFIX."c_type_contact as tc"; |
||
| 1088 | $sql.= " WHERE tc.element='".$this->db->escape($this->element)."'"; |
||
| 1089 | if ($activeonly == 1) $sql.= " AND tc.active=1"; // only the active types |
||
| 1090 | if (! empty($source) && $source != 'all') $sql.= " AND tc.source='".$this->db->escape($source)."'"; |
||
| 1091 | if (! empty($code)) $sql.= " AND tc.code='".$this->db->escape($code)."'"; |
||
| 1163 | if ($status) $sql.= " AND ec.statut = ".$status; |
||
| 1164 | |||
| 1165 | dol_syslog(get_class($this)."::getIdContact", LOG_DEBUG); |
||
| 1166 | $resql=$this->db->query($sql); |
||
| 1167 | if ($resql) |
||
| 1168 | {
|
||
| 1169 | while ($obj = $this->db->fetch_object($resql)) |
||
| 1196 | if (empty($contactid)) return 0; |
||
| 1197 | |||
| 1198 | require_once DOL_DOCUMENT_ROOT.'/contact/class/contact.class.php'; |
||
| 1199 | $contact = new Contact($this->db); |
||
| 1200 | $result=$contact->fetch($contactid); |
||
| 1201 | $this->contact = $contact; |
||
| 1202 | return $result; |
||
| 1214 | // phpcs:enable |
||
| 1215 | global $conf; |
||
| 1216 | |||
| 1217 | if (empty($this->socid) && empty($this->fk_soc) && empty($this->fk_thirdparty) && empty($force_thirdparty_id)) |
||
| 1218 | return 0; |
||
| 1219 | |||
| 1220 | require_once DOL_DOCUMENT_ROOT . '/societe/class/societe.class.php'; |
||
| 1224 | $idtofetch = $force_thirdparty_id; |
||
| 1225 | |||
| 1226 | if ($idtofetch) {
|
||
| 1227 | $thirdparty = new Societe($this->db); |
||
| 1228 | $result = $thirdparty->fetch($idtofetch); |
||
| 1229 | $this->thirdparty = $thirdparty; |
||
| 1230 | |||
| 1252 | return 0; |
||
| 1253 | } |
||
| 1254 | |||
| 1255 | $sql = 'SELECT rowid FROM '.MAIN_DB_PREFIX.$this->table_element.' WHERE '.$this->table_ref_field.' LIKE "'.$this->db->escape($ref).'" LIMIT 1'; |
||
| 1256 | |||
| 1257 | $query = $this->db->query($sql); |
||
| 1258 | |||
| 1262 | |||
| 1263 | $result = $this->db->fetch_object($query); |
||
| 1264 | |||
| 1265 | return $this->fetch($result->rowid); |
||
| 1266 | } |
||
| 1267 | |||
| 1268 | // phpcs:disable PEAR.NamingConventions.ValidFunctionName.NotCamelCaps |
||
| 1298 | $sql.= " FROM ".MAIN_DB_PREFIX."c_barcode_type"; |
||
| 1299 | $sql.= " WHERE rowid = ".$idtype; |
||
| 1300 | dol_syslog(get_class($this).'::fetch_barcode', LOG_DEBUG); |
||
| 1301 | $resql = $this->db->query($sql); |
||
| 1302 | if ($resql) |
||
| 1303 | {
|
||
| 1304 | $obj = $this->db->fetch_object($resql); |
||
| 1329 | // phpcs:enable |
||
| 1330 | include_once DOL_DOCUMENT_ROOT.'/projet/class/project.class.php'; |
||
| 1331 | |||
| 1332 | if (empty($this->fk_project) && ! empty($this->fk_projet)) $this->fk_project = $this->fk_projet; // For backward compatibility |
||
| 1333 | if (empty($this->fk_project)) return 0; |
||
| 1334 | |||
| 1335 | $project = new Project($this->db); |
||
| 1336 | $result = $project->fetch($this->fk_project); |
||
| 1337 | |||
| 1338 | $this->projet = $project; // deprecated |
||
| 1351 | // phpcs:enable |
||
| 1352 | include_once DOL_DOCUMENT_ROOT.'/product/class/product.class.php'; |
||
| 1353 | |||
| 1354 | if (empty($this->fk_product)) return 0; |
||
| 1355 | |||
| 1356 | $product = new Product($this->db); |
||
| 1357 | $result = $product->fetch($this->fk_product); |
||
| 1358 | |||
| 1359 | $this->product = $product; |
||
| 1370 | function fetch_user($userid) |
||
| 1371 | {
|
||
| 1372 | // phpcs:enable |
||
| 1373 | $user = new User($this->db); |
||
| 1374 | $result=$user->fetch($userid); |
||
| 1375 | $this->user = $user; |
||
| 1376 | return $result; |
||
| 1392 | $origin = $this->origin; |
||
| 1393 | |||
| 1394 | $classname = ucfirst($origin); |
||
| 1395 | $this->$origin = new $classname($this->db); |
||
| 1396 | $this->$origin->fetch($this->origin_id); |
||
| 1397 | } |
||
| 1398 | |||
| 1420 | } |
||
| 1421 | |||
| 1422 | dol_syslog(get_class($this).'::fetchObjectFrom', LOG_DEBUG); |
||
| 1423 | $resql = $this->db->query($sql); |
||
| 1424 | if ($resql) |
||
| 1425 | {
|
||
| 1426 | $row = $this->db->fetch_row($resql); |
||
| 1449 | $sql.= " WHERE rowid = ".$id; |
||
| 1450 | |||
| 1451 | dol_syslog(get_class($this).'::getValueFrom', LOG_DEBUG); |
||
| 1452 | $resql = $this->db->query($sql); |
||
| 1453 | if ($resql) |
||
| 1454 | {
|
||
| 1455 | $row = $this->db->fetch_row($resql); |
||
| 1486 | |||
| 1487 | $error=0; |
||
| 1488 | |||
| 1489 | $this->db->begin(); |
||
| 1490 | |||
| 1491 | // Special case |
||
| 1492 | if ($table == 'product' && $field == 'note_private') $field='note'; |
||
| 1581 | $sql.= ",".MAIN_DB_PREFIX."usergroup_user as ug"; |
||
| 1582 | } |
||
| 1583 | if (isset($this->ismultientitymanaged) && $this->ismultientitymanaged == 2) $sql.= ", ".MAIN_DB_PREFIX."societe as s"; // If we need to link to societe to limit select to entity |
||
| 1584 | else if ($this->restrictiononfksoc == 1 && $this->element != 'societe' && !$user->rights->societe->client->voir && !$socid) $sql.= ", ".MAIN_DB_PREFIX."societe as s"; // If we need to link to societe to limit select to socid |
||
| 1585 | else if ($this->restrictiononfksoc == 2 && $this->element != 'societe' && !$user->rights->societe->client->voir && !$socid) $sql.= " LEFT JOIN ".MAIN_DB_PREFIX."societe as s ON te.fk_soc = s.rowid"; // If we need to link to societe to limit select to socid |
||
| 1586 | if ($this->restrictiononfksoc && !$user->rights->societe->client->voir && !$socid) $sql.= " LEFT JOIN ".MAIN_DB_PREFIX."societe_commerciaux as sc ON ".$alias.".rowid = sc.fk_soc"; |
||
| 1587 | $sql.= " WHERE te.".$fieldid." < '".$this->db->escape($this->ref)."'"; // ->ref must always be defined (set to id if field does not exists) |
||
| 1588 | if ($this->restrictiononfksoc == 1 && !$user->rights->societe->client->voir && !$socid) $sql.= " AND sc.fk_user = " .$user->id; |
||
| 1589 | if ($this->restrictiononfksoc == 2 && !$user->rights->societe->client->voir && !$socid) $sql.= " AND (sc.fk_user = " .$user->id.' OR te.fk_soc IS NULL)'; |
||
| 1590 | if (! empty($filter)) |
||
| 1723 | } |
||
| 1724 | |||
| 1725 | dol_syslog(get_class($this)."::setProject", LOG_DEBUG); |
||
| 1726 | if ($this->db->query($sql)) |
||
| 1727 | {
|
||
| 1728 | $this->fk_project = $projectid; |
||
| 1729 | return 1; |
||
| 1755 | $sql .= ' SET '.$fieldname.' = '.$id; |
||
| 1756 | $sql .= ' WHERE rowid='.$this->id; |
||
| 1757 | |||
| 1758 | if ($this->db->query($sql)) |
||
| 1759 | {
|
||
| 1760 | $this->mode_reglement_id = $id; |
||
| 1761 | // for supplier |
||
| 1791 | $fieldname = 'multicurrency_code'; |
||
| 1792 | |||
| 1793 | $sql = 'UPDATE '.MAIN_DB_PREFIX.$this->table_element; |
||
| 1794 | $sql .= ' SET '.$fieldname." = '".$this->db->escape($code)."'"; |
||
| 1795 | $sql .= ' WHERE rowid='.$this->id; |
||
| 1796 | |||
| 1797 | if ($this->db->query($sql)) |
||
| 1836 | $sql .= ' SET '.$fieldname.' = '.$rate; |
||
| 1837 | $sql .= ' WHERE rowid='.$this->id; |
||
| 1838 | |||
| 1839 | if ($this->db->query($sql)) |
||
| 1840 | {
|
||
| 1841 | $this->multicurrency_tx = $rate; |
||
| 1842 | |||
| 1851 | |||
| 1852 | switch ($this->element) {
|
||
| 1853 | case 'propal': |
||
| 1854 | $this->updateline( |
||
| 1855 | $line->id, $line->subprice, $line->qty, $line->remise_percent, $line->tva_tx, $line->localtax1_tx, $line->localtax2_tx, |
||
| 1856 | ($line->description?$line->description:$line->desc), 'HT', $line->info_bits, $line->special_code, $line->fk_parent_line, |
||
| 1857 | $line->skip_update_total, $line->fk_fournprice, $line->pa_ht, $line->label, $line->product_type, $line->date_start, |
||
| 1940 | $sql .= ' SET '.$fieldname.' = '.$id; |
||
| 1941 | $sql .= ' WHERE rowid='.$this->id; |
||
| 1942 | |||
| 1943 | if ($this->db->query($sql)) |
||
| 1944 | {
|
||
| 1945 | $this->cond_reglement_id = $id; |
||
| 1946 | // for supplier |
||
| 1947 | if (get_class($this) == 'Fournisseur') $this->cond_reglement_supplier_id = $id; |
||
| 1948 | $this->cond_reglement = $id; // for compatibility |
||
| 1949 | return 1; |
||
| 1950 | } |
||
| 1951 | else |
||
| 1978 | $sql = "UPDATE ".MAIN_DB_PREFIX.$this->table_element." SET ".$fieldname." = ".$id; |
||
| 1979 | $sql.= " WHERE rowid = ".$this->id." AND fk_statut = 0"; |
||
| 1980 | |||
| 1981 | if ($this->db->query($sql)) |
||
| 1982 | {
|
||
| 1983 | $this->fk_delivery_address = $id; |
||
| 1984 | return 1; |
||
| 2014 | return -1; |
||
| 2015 | } |
||
| 2016 | |||
| 2017 | $this->db->begin(); |
||
| 2018 | |||
| 2019 | if ($shipping_method_id<0) $shipping_method_id='NULL'; |
||
| 2020 | dol_syslog(get_class($this).'::setShippingMethod('.$shipping_method_id.')');
|
||
| 2068 | $sql.= " SET fk_warehouse = ".$warehouse_id; |
||
| 2069 | $sql.= " WHERE rowid=".$this->id; |
||
| 2070 | |||
| 2071 | if ($this->db->query($sql)) {
|
||
| 2072 | $this->warehouse_id = ($warehouse_id=='NULL')?null:$warehouse_id; |
||
| 2073 | return 1; |
||
| 2074 | } else {
|
||
| 2097 | $newmodelpdf=dol_trunc($modelpdf,255); |
||
| 2098 | |||
| 2099 | $sql = "UPDATE ".MAIN_DB_PREFIX.$this->table_element; |
||
| 2100 | $sql.= " SET model_pdf = '".$this->db->escape($newmodelpdf)."'"; |
||
| 2101 | $sql.= " WHERE rowid = ".$this->id; |
||
| 2102 | // if ($this->element == 'facture') $sql.= " AND fk_statut < 2"; |
||
| 2103 | // if ($this->element == 'propal') $sql.= " AND fk_statut = 0"; |
||
| 2137 | dol_syslog(get_class($this)."::setBankAccount was called on objet with property table_element not defined",LOG_ERR); |
||
| 2138 | return -1; |
||
| 2139 | } |
||
| 2140 | $this->db->begin(); |
||
| 2141 | |||
| 2142 | if ($fk_account<0) $fk_account='NULL'; |
||
| 2143 | dol_syslog(get_class($this).'::setBankAccount('.$fk_account.')');
|
||
| 2212 | if ($renum) $sql.= ' AND rang <> 0'; |
||
| 2213 | |||
| 2214 | dol_syslog(get_class($this)."::line_order", LOG_DEBUG); |
||
| 2215 | $resql = $this->db->query($sql); |
||
| 2216 | if ($resql) |
||
| 2217 | {
|
||
| 2218 | $row = $this->db->fetch_row($resql); |
||
| 2285 | $sql.= ' ORDER BY rang ASC'; |
||
| 2286 | |||
| 2287 | dol_syslog(get_class($this)."::getChildrenOfLine search children lines for line ".$id."", LOG_DEBUG); |
||
| 2288 | $resql = $this->db->query($sql); |
||
| 2289 | if ($resql) |
||
| 2290 | {
|
||
| 2291 | $i=0; |
||
| 2360 | $sql.= ' WHERE rowid = '.$rowid; |
||
| 2361 | |||
| 2362 | dol_syslog(get_class($this)."::updateRangOfLine", LOG_DEBUG); |
||
| 2363 | if (! $this->db->query($sql)) |
||
| 2364 | {
|
||
| 2365 | dol_print_error($this->db); |
||
| 2366 | } |
||
| 2400 | $sql = 'UPDATE '.MAIN_DB_PREFIX.$this->table_element_line.' SET '.$fieldposition.' = '.$rang ; |
||
| 2401 | $sql.= ' WHERE '.$this->fk_element.' = '.$this->id; |
||
| 2402 | $sql.= ' AND rang = '.($rang - 1); |
||
| 2403 | if ($this->db->query($sql) ) |
||
| 2404 | {
|
||
| 2405 | $sql = 'UPDATE '.MAIN_DB_PREFIX.$this->table_element_line.' SET '.$fieldposition.' = '.($rang - 1); |
||
| 2406 | $sql.= ' WHERE rowid = '.$rowid; |
||
| 2434 | $sql = 'UPDATE '.MAIN_DB_PREFIX.$this->table_element_line.' SET '.$fieldposition.' = '.$rang; |
||
| 2435 | $sql.= ' WHERE '.$this->fk_element.' = '.$this->id; |
||
| 2436 | $sql.= ' AND rang = '.($rang+1); |
||
| 2437 | if ($this->db->query($sql) ) |
||
| 2438 | {
|
||
| 2439 | $sql = 'UPDATE '.MAIN_DB_PREFIX.$this->table_element_line.' SET '.$fieldposition.' = '.($rang+1); |
||
| 2440 | $sql.= ' WHERE rowid = '.$rowid; |
||
| 2462 | $sql.= ' WHERE rowid ='.$rowid; |
||
| 2463 | |||
| 2464 | dol_syslog(get_class($this)."::getRangOfLine", LOG_DEBUG); |
||
| 2465 | $resql = $this->db->query($sql); |
||
| 2466 | if ($resql) |
||
| 2467 | {
|
||
| 2468 | $row = $this->db->fetch_row($resql); |
||
| 2481 | $sql = 'SELECT rowid FROM '.MAIN_DB_PREFIX.$this->table_element_line; |
||
| 2482 | $sql.= ' WHERE '.$this->fk_element.' = '.$this->id; |
||
| 2483 | $sql.= ' AND rang = '.$rang; |
||
| 2484 | $resql = $this->db->query($sql); |
||
| 2485 | if ($resql) |
||
| 2486 | {
|
||
| 2487 | $row = $this->db->fetch_row($resql); |
||
| 2507 | $sql.= ' AND fk_parent_line = '.$fk_parent_line; |
||
| 2508 | |||
| 2509 | dol_syslog(get_class($this)."::line_max", LOG_DEBUG); |
||
| 2510 | $resql = $this->db->query($sql); |
||
| 2511 | if ($resql) |
||
| 2512 | {
|
||
| 2513 | $row = $this->db->fetch_row($resql); |
||
| 2554 | } |
||
| 2555 | |||
| 2556 | $sql = 'UPDATE '.MAIN_DB_PREFIX.$this->table_element; |
||
| 2557 | $sql.= " SET ref_ext = '".$this->db->escape($ref_ext)."'"; |
||
| 2558 | $sql.= " WHERE ".(isset($this->table_rowid)?$this->table_rowid:'rowid')." = ". $this->id; |
||
| 2559 | |||
| 2560 | dol_syslog(get_class($this)."::update_ref_ext", LOG_DEBUG); |
||
| 2600 | if ($this->table_element == 'product') $suffix=''; |
||
| 2601 | |||
| 2602 | $sql = 'UPDATE '.MAIN_DB_PREFIX.$this->table_element; |
||
| 2603 | $sql.= " SET note".$suffix." = ".(!empty($note)?("'".$this->db->escape($note)."'"):"NULL");
|
||
| 2604 | $sql.= " ,".(in_array($this->table_element, array('actioncomm', 'adherent', 'advtargetemailing', 'cronjob', 'establishment'))?"fk_user_mod":"fk_user_modif")." = ".$user->id;
|
||
| 2605 | $sql.= " WHERE rowid =". $this->id; |
||
| 2606 | |||
| 2722 | $sql.= ' ORDER by rowid'; // We want to be sure to always use same order of line to not change lines differently when option MAIN_ROUNDOFTOTAL_NOT_TOTALOFROUND is used |
||
| 2723 | |||
| 2724 | dol_syslog(get_class($this)."::update_price", LOG_DEBUG); |
||
| 2725 | $resql = $this->db->query($sql); |
||
| 2726 | if ($resql) |
||
| 2727 | {
|
||
| 2728 | $this->total_ht = 0; |
||
| 2807 | $this->multicurrency_total_ttc += isset($this->revenuestamp)?($this->revenuestamp * $multicurrency_tx):0; |
||
| 2808 | |||
| 2809 | // Situations totals |
||
| 2810 | if ($this->situation_cycle_ref && $this->situation_counter > 1 && method_exists($this, 'get_prev_sits') && $this->type != $this::TYPE_CREDIT_NOTE ) |
||
| 2811 | {
|
||
| 2812 | $prev_sits = $this->get_prev_sits(); |
||
| 2813 | |||
| 2898 | if ($origin == 'invoice') $origin='facture'; |
||
| 2899 | if ($origin == 'invoice_template') $origin='facturerec'; |
||
| 2900 | if ($origin == 'supplierorder') $origin='order_supplier'; |
||
| 2901 | $this->db->begin(); |
||
| 2902 | |||
| 2903 | $sql = "INSERT INTO ".MAIN_DB_PREFIX."element_element (";
|
||
| 2904 | $sql.= "fk_source"; |
||
| 3007 | $sql .= ' ORDER BY '.$orderby; |
||
| 3008 | |||
| 3009 | dol_syslog(get_class($this)."::fetchObjectLink", LOG_DEBUG); |
||
| 3010 | $resql = $this->db->query($sql); |
||
| 3011 | if ($resql) |
||
| 3012 | {
|
||
| 3013 | $num = $this->db->num_rows($resql); |
||
| 3163 | if ($updatesource) |
||
| 3164 | {
|
||
| 3165 | $sql.= "fk_source = ".$sourceid; |
||
| 3166 | $sql.= ", sourcetype = '".$this->db->escape($sourcetype)."'"; |
||
| 3167 | $sql.= " WHERE fk_target = ".$this->id; |
||
| 3168 | $sql.= " AND targettype = '".$this->db->escape($this->element)."'"; |
||
| 3169 | } |
||
| 3221 | {
|
||
| 3222 | if ($deletesource) |
||
| 3223 | {
|
||
| 3224 | $sql.= " fk_source = ".$sourceid." AND sourcetype = '".$this->db->escape($sourcetype)."'"; |
||
| 3225 | $sql.= " AND fk_target = ".$this->id." AND targettype = '".$this->db->escape($this->element)."'"; |
||
| 3226 | } |
||
| 3227 | else if ($deletetarget) |
||
| 3268 | $elementId = (!empty($elementId)?$elementId:$this->id); |
||
| 3269 | $elementTable = (!empty($elementType)?$elementType:$this->table_element); |
||
| 3270 | |||
| 3271 | $this->db->begin(); |
||
| 3272 | |||
| 3273 | $fieldstatus="fk_statut"; |
||
| 3274 | if ($elementTable == 'facture_rec') $fieldstatus="suspended"; |
||
| 3304 | {
|
||
| 3305 | // Appel des triggers |
||
| 3306 | include_once DOL_DOCUMENT_ROOT . '/core/class/interfaces.class.php'; |
||
| 3307 | $interface=new Interfaces($this->db); |
||
| 3308 | $result=$interface->run_triggers($trigkey,$this,$user,$langs,$conf); |
||
| 3309 | if ($result < 0) {
|
||
| 3310 | $error++; $this->errors=$interface->errors; |
||
| 3362 | $sql.= " FROM ".MAIN_DB_PREFIX.$this->table_element; |
||
| 3363 | $sql.= " WHERE entity IN (".getEntity($this->element).")";
|
||
| 3364 | if (! empty($id)) $sql.= " AND rowid = ".$id; |
||
| 3365 | if (! empty($ref)) $sql.= " AND ref = '".$this->db->escape($ref)."'"; |
||
| 3366 | |||
| 3367 | $resql = $this->db->query($sql); |
||
| 3368 | if ($resql) |
||
| 3393 | {
|
||
| 3394 | $sql = 'SELECT special_code FROM '.MAIN_DB_PREFIX.$this->table_element_line; |
||
| 3395 | $sql.= ' WHERE rowid = '.$lineid; |
||
| 3396 | $resql = $this->db->query($sql); |
||
| 3397 | if ($resql) |
||
| 3398 | {
|
||
| 3399 | $row = $this->db->fetch_row($resql); |
||
| 3437 | // Check if third party can be deleted |
||
| 3438 | $sql = "SELECT COUNT(*) as nb from ".MAIN_DB_PREFIX.$table; |
||
| 3439 | $sql.= " WHERE ".$this->fk_element." = ".$id; |
||
| 3440 | $resql=$this->db->query($sql); |
||
| 3441 | if ($resql) |
||
| 3442 | {
|
||
| 3443 | $obj=$this->db->fetch_object($resql); |
||
| 3509 | $sql.= " WHERE ".$this->fk_element." = ".$this->id; |
||
| 3510 | |||
| 3511 | dol_syslog(get_class($this).'::getTotalDiscount', LOG_DEBUG); |
||
| 3512 | $resql = $this->db->query($sql); |
||
| 3513 | if ($resql) |
||
| 3514 | {
|
||
| 3515 | $num=$this->db->num_rows($resql); |
||
| 3636 | */ |
||
| 3637 | function setExtraParameters() |
||
| 3638 | {
|
||
| 3639 | $this->db->begin(); |
||
| 3640 | |||
| 3641 | $extraparams = (! empty($this->extraparams) ? json_encode($this->extraparams) : null); |
||
| 3642 | |||
| 3643 | $sql = "UPDATE ".MAIN_DB_PREFIX.$this->table_element; |
||
| 3644 | $sql.= " SET extraparams = ".(! empty($extraparams) ? "'".$this->db->escape($extraparams)."'" : "null"); |
||
| 3675 | if (!empty($this->fk_incoterms)) |
||
| 3676 | {
|
||
| 3677 | $sql = 'SELECT code FROM '.MAIN_DB_PREFIX.'c_incoterms WHERE rowid = '.(int) $this->fk_incoterms; |
||
| 3678 | $result = $this->db->query($sql); |
||
| 3679 | if ($result) |
||
| 3680 | {
|
||
| 3681 | $res = $this->db->fetch_object($result); |
||
| 3696 | function getIncotermsForPDF() |
||
| 3697 | {
|
||
| 3698 | $sql = 'SELECT code FROM '.MAIN_DB_PREFIX.'c_incoterms WHERE rowid = '.(int) $this->fk_incoterms; |
||
| 3699 | $resql = $this->db->query($sql); |
||
| 3700 | if ($resql) |
||
| 3701 | {
|
||
| 3702 | $num = $this->db->num_rows($resql); |
||
| 3730 | {
|
||
| 3731 | $sql = "UPDATE ".MAIN_DB_PREFIX.$this->table_element; |
||
| 3732 | $sql.= " SET fk_incoterms = ".($id_incoterm > 0 ? $id_incoterm : "null"); |
||
| 3733 | $sql.= ", location_incoterms = ".($id_incoterm > 0 ? "'".$this->db->escape($location)."'" : "null"); |
||
| 3734 | $sql.= " WHERE rowid = " . $this->id; |
||
| 3735 | dol_syslog(get_class($this).'::setIncoterms', LOG_DEBUG); |
||
| 3736 | $resql=$this->db->query($sql); |
||
| 3779 | |||
| 3780 | // Line extrafield |
||
| 3781 | require_once DOL_DOCUMENT_ROOT.'/core/class/extrafields.class.php'; |
||
| 3782 | $extrafieldsline = new AlExtraFields($this->db); |
||
| 3783 | $extralabelslines=$extrafieldsline->fetch_name_optionals_label($this->table_element_line); |
||
| 3784 | |||
| 3785 | // Output template part (modules that overwrite templates must declare this into descriptor) |
||
| 3830 | |||
| 3831 | // Line extrafield |
||
| 3832 | require_once DOL_DOCUMENT_ROOT.'/core/class/extrafields.class.php'; |
||
| 3833 | $extrafieldsline = new AlExtraFields($this->db); |
||
| 3834 | $extralabelslines=$extrafieldsline->fetch_name_optionals_label($this->table_element_line); |
||
| 3835 | |||
| 3836 | $parameters = array('num'=>$num,'i'=>$i,'dateSelector'=>$dateSelector,'seller'=>$seller,'buyer'=>$buyer,'selected'=>$selected, 'extrafieldsline'=>$extrafieldsline);
|
||
| 3876 | // Reduction short |
||
| 3877 | print '<td class="linecoldiscount" align="right">'.$langs->trans('ReductionShort').'</td>';
|
||
| 3878 | |||
| 3879 | if ($this->situation_cycle_ref) {
|
||
| 3880 | print '<td class="linecolcycleref" align="right">' . $langs->trans('Progress') . '</td>';
|
||
| 3881 | } |
||
| 3882 | |||
| 3995 | // Product |
||
| 3996 | if ($line->fk_product > 0) |
||
| 3997 | {
|
||
| 3998 | $product_static = new Product($this->db); |
||
| 3999 | $product_static->fetch($line->fk_product); |
||
| 4000 | |||
| 4001 | $product_static->ref = $line->ref; //can change ref in hook |
||
| 4172 | |||
| 4173 | if (($line->info_bits & 2) == 2) // TODO Not sure this is used for source object |
||
| 4174 | {
|
||
| 4175 | $discount=new DiscountAbsolute($this->db); |
||
| 4176 | $discount->fk_soc = $this->socid; |
||
| 4177 | $this->tpl['label'].= $discount->getNomUrl(0,'discount'); |
||
| 4178 | } |
||
| 4293 | function add_element_resource($resource_id, $resource_type, $busy=0, $mandatory=0) |
||
| 4294 | {
|
||
| 4295 | // phpcs:enable |
||
| 4296 | $this->db->begin(); |
||
| 4297 | |||
| 4298 | $sql = "INSERT INTO ".MAIN_DB_PREFIX."element_resources (";
|
||
| 4299 | $sql.= "resource_id"; |
||
| 4339 | // phpcs:enable |
||
| 4340 | global $user; |
||
| 4341 | |||
| 4342 | $this->db->begin(); |
||
| 4343 | |||
| 4344 | $sql = "DELETE FROM ".MAIN_DB_PREFIX."element_resources"; |
||
| 4345 | $sql.= " WHERE rowid=".$rowid; |
||
| 4448 | |||
| 4449 | require_once $file; |
||
| 4450 | |||
| 4451 | $obj = new $classname($this->db); |
||
| 4452 | |||
| 4453 | // If generator is ODT, we must have srctemplatepath defined, if not we set it. |
||
| 4454 | if ($obj->type == 'odt' && empty($srctemplatepath)) |
||
| 4730 | global $langs,$conf; |
||
| 4731 | |||
| 4732 | include_once DOL_DOCUMENT_ROOT . '/core/class/interfaces.class.php'; |
||
| 4733 | $interface=new Interfaces($this->db); |
||
| 4734 | $result=$interface->run_triggers($trigger_name,$this,$user,$langs,$conf); |
||
| 4735 | |||
| 4736 | if ($result < 0) |
||
| 4816 | $sql.= " WHERE fk_object = ".$rowid; |
||
| 4817 | |||
| 4818 | //dol_syslog(get_class($this)."::fetch_optionals get extrafields data for ".$this->table_element, LOG_DEBUG); // Too verbose |
||
| 4819 | $resql=$this->db->query($sql); |
||
| 4820 | if ($resql) |
||
| 4821 | {
|
||
| 4822 | $this->array_options = array(); |
||
| 4867 | */ |
||
| 4868 | function deleteExtraFields() |
||
| 4869 | {
|
||
| 4870 | $this->db->begin(); |
||
| 4871 | |||
| 4872 | $table_element = $this->table_element; |
||
| 4873 | if ($table_element == 'categorie') $table_element = 'categories'; // For compatibility |
||
| 4914 | // Check parameters |
||
| 4915 | $langs->load('admin');
|
||
| 4916 | require_once DOL_DOCUMENT_ROOT.'/core/class/extrafields.class.php'; |
||
| 4917 | $extrafields = new AlExtraFields($this->db); |
||
| 4918 | $target_extrafields=$extrafields->fetch_name_optionals_label($this->table_element); |
||
| 4919 | |||
| 4920 | //Eliminate copied source object extra_fields that do not exist in target object |
||
| 5163 | // Check parameters |
||
| 5164 | $langs->load('admin');
|
||
| 5165 | require_once DOL_DOCUMENT_ROOT.'/core/class/extrafields.class.php'; |
||
| 5166 | $extrafields = new AlExtraFields($this->db); |
||
| 5167 | $target_extrafields=$extrafields->fetch_name_optionals_label($this->table_element); |
||
| 5168 | |||
| 5169 | $value=$this->array_options["options_".$key]; |
||
| 5289 | if (! is_object($form)) |
||
| 5290 | {
|
||
| 5291 | require_once DOL_DOCUMENT_ROOT.'/core/class/html.form.class.php'; |
||
| 5292 | $form=new Form($this->db); |
||
| 5293 | } |
||
| 5294 | |||
| 5295 | $val=$this->fields[$key]; |
||
| 5897 | if (! is_object($form)) |
||
| 5898 | {
|
||
| 5899 | require_once DOL_DOCUMENT_ROOT.'/core/class/html.form.class.php'; |
||
| 5900 | $form=new Form($this->db); |
||
| 5901 | } |
||
| 5902 | |||
| 5903 | $objectid = $this->id; |
||
| 6253 | /** |
||
| 6254 | * Function to show lines of extrafields with output datas |
||
| 6255 | * |
||
| 6256 | * @param Extrafields $extrafields Extrafield Object |
||
| 6257 | * @param string $mode Show output (view) or input (edit) for extrafield |
||
| 6258 | * @param array $params Optional parameters. Example: array('style'=>'class="oddeven"', 'colspan'=>$colspan)
|
||
| 6259 | * @param string $keysuffix Suffix string to add after name and id of field (can be used to avoid duplicate names) |
||
| 6365 | $datenotinstring = $this->array_options['options_' . $key]; |
||
| 6366 | if (! is_numeric($this->array_options['options_' . $key])) // For backward compatibility |
||
| 6367 | {
|
||
| 6368 | $datenotinstring = $this->db->jdate($datenotinstring); |
||
| 6369 | } |
||
| 6370 | $value = GETPOSTISSET($keyprefix.'options_'.$key.$keysuffix)?dol_mktime(GETPOST($keyprefix.'options_'.$key.$keysuffix."hour", 'int', 3), GETPOST($keyprefix.'options_'.$key.$keysuffix."min",'int',3), 0, GETPOST($keyprefix.'options_'.$key.$keysuffix."month",'int',3), GETPOST($keyprefix.'options_'.$key.$keysuffix."day",'int',3), GETPOST($keyprefix.'options_'.$key.$keysuffix."year",'int',3)):$datenotinstring; |
||
| 6371 | } |
||
| 6515 | {
|
||
| 6516 | if (isset(Globals::$conf->global->MARGIN_TYPE) && Globals::$conf->global->MARGIN_TYPE == 'costprice') {
|
||
| 6517 | require_once DOL_DOCUMENT_ROOT.'/product/class/product.class.php'; |
||
| 6518 | $product = new Product($this->db); |
||
| 6519 | $result = $product->fetch($fk_product); |
||
| 6520 | if ($result <= 0) |
||
| 6521 | {
|
||
| 6597 | $pdir = '/'; |
||
| 6598 | if ($modulepart == 'ticket') |
||
| 6599 | {
|
||
| 6600 | $dir .= get_exdir(0, 0, 0, 0, $this, $modulepart).$this->track_id.'/'; |
||
| 6601 | $pdir .= get_exdir(0, 0, 0, 0, $this, $modulepart).$this->track_id.'/'; |
||
| 6602 | } |
||
| 6603 | else |
||
| 6934 | } |
||
| 6935 | else |
||
| 6936 | {
|
||
| 6937 | $queryarray[$field] = $this->db->idate($this->{$field});
|
||
| 6938 | } |
||
| 6939 | } |
||
| 6940 | else if($this->isArray($info)) |
||
| 7046 | protected function quote($value, $fieldsentry) |
||
| 7047 | {
|
||
| 7048 | if (is_null($value)) return 'NULL'; |
||
| 7049 | else if (preg_match('/^(int|double|real)/i', $fieldsentry['type'])) return $this->db->escape("$value");
|
||
| 7050 | else return "'".$this->db->escape($value)."'"; |
||
| 7051 | } |
||
| 7052 | |||
| 7067 | $now=dol_now(); |
||
| 7068 | |||
| 7069 | $fieldvalues = $this->setSaveQuery(); |
||
| 7070 | if (array_key_exists('date_creation', $fieldvalues) && empty($fieldvalues['date_creation'])) $fieldvalues['date_creation']=$this->db->idate($now);
|
||
| 7071 | if (array_key_exists('fk_user_creat', $fieldvalues) && ! ($fieldvalues['fk_user_creat'] > 0)) $fieldvalues['fk_user_creat']=$user->id;
|
||
| 7072 | unset($fieldvalues['rowid']); // The field 'rowid' is reserved field name for autoincrement field so we don't need it into insert. |
||
| 7073 | |||
| 7168 | if ($morewhere) $sql.= $morewhere; |
||
| 7169 | $sql.=' LIMIT 1'; // This is a fetch, to be sure to get only one record |
||
| 7170 | |||
| 7171 | $res = $this->db->query($sql); |
||
| 7172 | if ($res) |
||
| 7173 | {
|
||
| 7174 | $obj = $this->db->fetch_object($res); |
||
| 7206 | $now=dol_now(); |
||
| 7207 | |||
| 7208 | $fieldvalues = $this->setSaveQuery(); |
||
| 7209 | if (array_key_exists('date_modification', $fieldvalues) && empty($fieldvalues['date_modification'])) $fieldvalues['date_modification']=$this->db->idate($now);
|
||
| 7210 | if (array_key_exists('fk_user_modif', $fieldvalues) && ! ($fieldvalues['fk_user_modif'] > 0)) $fieldvalues['fk_user_modif']=$user->id;
|
||
| 7211 | unset($fieldvalues['rowid']); // The field 'rowid' is reserved field name for autoincrement field so we don't need it into update. |
||
| 7212 | |||
| 7287 | {
|
||
| 7288 | $error=0; |
||
| 7289 | |||
| 7290 | $this->db->begin(); |
||
| 7291 | |||
| 7292 | if ($forcechilddeletion) |
||
| 7293 | {
|
||
| 7294 | foreach($this->childtables as $table) |
||
| 7295 | {
|
||
| 7296 | $sql = 'DELETE FROM '.MAIN_DB_PREFIX.$table.' WHERE '.$this->fk_element.' = '.$this->id; |
||
| 7297 | $resql = $this->db->query($sql); |
||
| 7384 | {
|
||
| 7385 | require_once DOL_DOCUMENT_ROOT.'/core/class/comment.class.php'; |
||
| 7386 | |||
| 7387 | $comment = new Comment($this->db); |
||
| 7388 | $result=$comment->fetchAllFor($this->element, $this->id); |
||
| 7389 | if ($result<0) {
|
||
| 7390 | $this->errors=array_merge($this->errors, $comment->errors); |
||
| 7424 |
Loading history...