@@ -1438,7 +1438,7 @@ discard block |
||
| 1438 | 1438 | return $this->LibStatut($this->status, $mode); |
| 1439 | 1439 | } |
| 1440 | 1440 | |
| 1441 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 1441 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 1442 | 1442 | /** |
| 1443 | 1443 | * Return the status |
| 1444 | 1444 | * |
@@ -1448,7 +1448,7 @@ discard block |
||
| 1448 | 1448 | */ |
| 1449 | 1449 | public function LibStatut($status, $mode = 0) |
| 1450 | 1450 | { |
| 1451 | - // phpcs:enable |
|
| 1451 | + // phpcs:enable |
|
| 1452 | 1452 | if (empty($this->labelStatus) || empty($this->labelStatusShort)) { |
| 1453 | 1453 | global $langs; |
| 1454 | 1454 | //$langs->load("assets"); |
@@ -1438,7 +1438,7 @@ discard block |
||
| 1438 | 1438 | return $this->LibStatut($this->status, $mode); |
| 1439 | 1439 | } |
| 1440 | 1440 | |
| 1441 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 1441 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 1442 | 1442 | /** |
| 1443 | 1443 | * Return the status |
| 1444 | 1444 | * |
@@ -1448,7 +1448,7 @@ discard block |
||
| 1448 | 1448 | */ |
| 1449 | 1449 | public function LibStatut($status, $mode = 0) |
| 1450 | 1450 | { |
| 1451 | - // phpcs:enable |
|
| 1451 | + // phpcs:enable |
|
| 1452 | 1452 | if (empty($this->labelStatus) || empty($this->labelStatusShort)) { |
| 1453 | 1453 | global $langs; |
| 1454 | 1454 | //$langs->load("assets"); |
@@ -19,11 +19,11 @@ |
||
| 19 | 19 | * or see https://www.gnu.org/ |
| 20 | 20 | */ |
| 21 | 21 | |
| 22 | - /** |
|
| 23 | - * \file htdocs/ai/class/ai.class.php |
|
| 24 | - * \ingroup ai |
|
| 25 | - * \brief Class files with common methods for Ai |
|
| 26 | - */ |
|
| 22 | + /** |
|
| 23 | + * \file htdocs/ai/class/ai.class.php |
|
| 24 | + * \ingroup ai |
|
| 25 | + * \brief Class files with common methods for Ai |
|
| 26 | + */ |
|
| 27 | 27 | |
| 28 | 28 | require_once DOL_DOCUMENT_ROOT . "/core/lib/admin.lib.php"; |
| 29 | 29 | require_once constant('DOL_DOCUMENT_ROOT') . '/core/lib/geturl.lib.php'; |
@@ -688,7 +688,7 @@ discard block |
||
| 688 | 688 | } |
| 689 | 689 | |
| 690 | 690 | |
| 691 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 691 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 692 | 692 | /** |
| 693 | 693 | * Mise a jour du lien entre le paiement de salaire et la ligne dans llx_bank generee |
| 694 | 694 | * |
@@ -697,7 +697,7 @@ discard block |
||
| 697 | 697 | */ |
| 698 | 698 | public function update_fk_bank($id_bank) |
| 699 | 699 | { |
| 700 | - // phpcs:enable |
|
| 700 | + // phpcs:enable |
|
| 701 | 701 | $sql = "UPDATE " . MAIN_DB_PREFIX . "payment_salary SET fk_bank = " . ((int) $id_bank) . " WHERE rowid = " . ((int) $this->id); |
| 702 | 702 | |
| 703 | 703 | dol_syslog(get_class($this) . "::update_fk_bank", LOG_DEBUG); |
@@ -776,7 +776,7 @@ discard block |
||
| 776 | 776 | return $this->LibStatut($this->statut, $mode); |
| 777 | 777 | } |
| 778 | 778 | |
| 779 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 779 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 780 | 780 | /** |
| 781 | 781 | * Return the status |
| 782 | 782 | * |
@@ -786,7 +786,7 @@ discard block |
||
| 786 | 786 | */ |
| 787 | 787 | public function LibStatut($status, $mode = 0) |
| 788 | 788 | { |
| 789 | - // phpcs:enable |
|
| 789 | + // phpcs:enable |
|
| 790 | 790 | global $langs; // TODO Renvoyer le libelle anglais et faire traduction a affichage |
| 791 | 791 | |
| 792 | 792 | $langs->load('compta'); |
@@ -455,7 +455,7 @@ discard block |
||
| 455 | 455 | return $paymentsalary; |
| 456 | 456 | } |
| 457 | 457 | |
| 458 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.PublicUnderscore |
|
| 458 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.PublicUnderscore |
|
| 459 | 459 | /** |
| 460 | 460 | * Clean sensible object datas |
| 461 | 461 | * |
@@ -464,7 +464,7 @@ discard block |
||
| 464 | 464 | */ |
| 465 | 465 | protected function _cleanObjectDatas($object) |
| 466 | 466 | { |
| 467 | - // phpcs:enable |
|
| 467 | + // phpcs:enable |
|
| 468 | 468 | $object = parent::_cleanObjectDatas($object); |
| 469 | 469 | |
| 470 | 470 | unset($object->rowid); |
@@ -448,7 +448,7 @@ discard block |
||
| 448 | 448 | } |
| 449 | 449 | } |
| 450 | 450 | |
| 451 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 451 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 452 | 452 | /** |
| 453 | 453 | * Update link between payment salary and line generate into llx_bank |
| 454 | 454 | * |
@@ -457,7 +457,7 @@ discard block |
||
| 457 | 457 | */ |
| 458 | 458 | public function update_fk_bank($id_bank) |
| 459 | 459 | { |
| 460 | - // phpcs:enable |
|
| 460 | + // phpcs:enable |
|
| 461 | 461 | $sql = 'UPDATE ' . MAIN_DB_PREFIX . 'salary SET fk_bank = ' . ((int) $id_bank); |
| 462 | 462 | $sql .= " WHERE rowid = " . ((int) $this->id); |
| 463 | 463 | $result = $this->db->query($sql); |
@@ -665,7 +665,7 @@ discard block |
||
| 665 | 665 | } |
| 666 | 666 | } |
| 667 | 667 | |
| 668 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 668 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 669 | 669 | /** |
| 670 | 670 | * Tag social contribution as paid completely |
| 671 | 671 | * |
@@ -676,7 +676,7 @@ discard block |
||
| 676 | 676 | */ |
| 677 | 677 | public function set_paid($user) |
| 678 | 678 | { |
| 679 | - // phpcs:enable |
|
| 679 | + // phpcs:enable |
|
| 680 | 680 | dol_syslog(get_class($this) . "::set_paid is deprecated, use setPaid instead", LOG_NOTICE); |
| 681 | 681 | return $this->setPaid($user); |
| 682 | 682 | } |
@@ -703,7 +703,7 @@ discard block |
||
| 703 | 703 | } |
| 704 | 704 | } |
| 705 | 705 | |
| 706 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 706 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 707 | 707 | /** |
| 708 | 708 | * Remove tag paid on social contribution |
| 709 | 709 | * |
@@ -712,7 +712,7 @@ discard block |
||
| 712 | 712 | */ |
| 713 | 713 | public function set_unpaid($user) |
| 714 | 714 | { |
| 715 | - // phpcs:enable |
|
| 715 | + // phpcs:enable |
|
| 716 | 716 | $sql = "UPDATE " . MAIN_DB_PREFIX . "salary SET"; |
| 717 | 717 | $sql .= " paye = 0"; |
| 718 | 718 | $sql .= " WHERE rowid = " . ((int) $this->id); |
@@ -740,7 +740,7 @@ discard block |
||
| 740 | 740 | return $this->LibStatut($this->paye, $mode, $alreadypaid); |
| 741 | 741 | } |
| 742 | 742 | |
| 743 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 743 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 744 | 744 | /** |
| 745 | 745 | * Return label of a given status |
| 746 | 746 | * |
@@ -751,7 +751,7 @@ discard block |
||
| 751 | 751 | */ |
| 752 | 752 | public function LibStatut($status, $mode = 0, $alreadypaid = -1) |
| 753 | 753 | { |
| 754 | - // phpcs:enable |
|
| 754 | + // phpcs:enable |
|
| 755 | 755 | global $langs; |
| 756 | 756 | |
| 757 | 757 | // Load translation files required by the page |
@@ -834,7 +834,7 @@ discard block |
||
| 834 | 834 | return $return; |
| 835 | 835 | } |
| 836 | 836 | |
| 837 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 837 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 838 | 838 | /** |
| 839 | 839 | * Create a withdrawal request for a direct debit order or a credit transfer order. |
| 840 | 840 | * Use the remain to pay excluding all existing open direct debit requests. |
@@ -848,7 +848,7 @@ discard block |
||
| 848 | 848 | */ |
| 849 | 849 | public function demande_prelevement($fuser, $amount = 0, $type = 'direct-debit', $sourcetype = 'salaire', $checkduplicateamongall = 0) |
| 850 | 850 | { |
| 851 | - // phpcs:enable |
|
| 851 | + // phpcs:enable |
|
| 852 | 852 | global $conf, $mysoc; |
| 853 | 853 | |
| 854 | 854 | $error = 0; |
@@ -956,7 +956,7 @@ discard block |
||
| 956 | 956 | } |
| 957 | 957 | } |
| 958 | 958 | |
| 959 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 959 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 960 | 960 | /** |
| 961 | 961 | * Remove a direct debit request or a credit transfer request |
| 962 | 962 | * |
@@ -966,7 +966,7 @@ discard block |
||
| 966 | 966 | */ |
| 967 | 967 | public function demande_prelevement_delete($fuser, $did) |
| 968 | 968 | { |
| 969 | - // phpcs:enable |
|
| 969 | + // phpcs:enable |
|
| 970 | 970 | $sql = 'DELETE FROM ' . $this->db->prefix() . 'prelevement_demande'; |
| 971 | 971 | $sql .= ' WHERE rowid = ' . ((int) $did); |
| 972 | 972 | $sql .= ' AND traite = 0'; |
@@ -271,7 +271,7 @@ discard block |
||
| 271 | 271 | } |
| 272 | 272 | } |
| 273 | 273 | |
| 274 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 274 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 275 | 275 | /** |
| 276 | 276 | * Create a line |
| 277 | 277 | * |
@@ -284,7 +284,7 @@ discard block |
||
| 284 | 284 | */ |
| 285 | 285 | public function create_line($origin_id, $qty, $fk_product, $description, $array_options = []) |
| 286 | 286 | { |
| 287 | - // phpcs:enable |
|
| 287 | + // phpcs:enable |
|
| 288 | 288 | $error = 0; |
| 289 | 289 | $idprod = $fk_product; |
| 290 | 290 | |
@@ -546,7 +546,7 @@ discard block |
||
| 546 | 546 | } |
| 547 | 547 | } |
| 548 | 548 | |
| 549 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 549 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 550 | 550 | /** |
| 551 | 551 | * Creating the delivery slip from an existing shipment |
| 552 | 552 | * |
@@ -556,7 +556,7 @@ discard block |
||
| 556 | 556 | */ |
| 557 | 557 | public function create_from_sending($user, $sending_id) |
| 558 | 558 | { |
| 559 | - // phpcs:enable |
|
| 559 | + // phpcs:enable |
|
| 560 | 560 | global $conf; |
| 561 | 561 | |
| 562 | 562 | $expedition = new Expedition($this->db); |
@@ -598,7 +598,7 @@ discard block |
||
| 598 | 598 | return $this->create($user); |
| 599 | 599 | } |
| 600 | 600 | |
| 601 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 601 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 602 | 602 | /** |
| 603 | 603 | * Update a livraison line (only extrafields) |
| 604 | 604 | * |
@@ -608,7 +608,7 @@ discard block |
||
| 608 | 608 | */ |
| 609 | 609 | public function update_line($id, $array_options = []) |
| 610 | 610 | { |
| 611 | - // phpcs:enable |
|
| 611 | + // phpcs:enable |
|
| 612 | 612 | global $conf; |
| 613 | 613 | $error = 0; |
| 614 | 614 | |
@@ -840,7 +840,7 @@ discard block |
||
| 840 | 840 | return $result; |
| 841 | 841 | } |
| 842 | 842 | |
| 843 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 843 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 844 | 844 | /** |
| 845 | 845 | * Load lines insto $this->lines. |
| 846 | 846 | * |
@@ -848,7 +848,7 @@ discard block |
||
| 848 | 848 | */ |
| 849 | 849 | public function fetch_lines() |
| 850 | 850 | { |
| 851 | - // phpcs:enable |
|
| 851 | + // phpcs:enable |
|
| 852 | 852 | $this->lines = array(); |
| 853 | 853 | |
| 854 | 854 | $sql = "SELECT ld.rowid, ld.fk_product, ld.description, ld.subprice, ld.total_ht, ld.qty as qty_shipped, ld.fk_origin_line, "; |
@@ -928,7 +928,7 @@ discard block |
||
| 928 | 928 | return $this->LibStatut($this->statut, $mode); |
| 929 | 929 | } |
| 930 | 930 | |
| 931 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 931 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 932 | 932 | /** |
| 933 | 933 | * Return the label of a given status |
| 934 | 934 | * |
@@ -938,7 +938,7 @@ discard block |
||
| 938 | 938 | */ |
| 939 | 939 | public function LibStatut($status, $mode) |
| 940 | 940 | { |
| 941 | - // phpcs:enable |
|
| 941 | + // phpcs:enable |
|
| 942 | 942 | global $langs; |
| 943 | 943 | |
| 944 | 944 | if (empty($this->labelStatus) || empty($this->labelStatusShort)) { |
@@ -378,7 +378,7 @@ discard block |
||
| 378 | 378 | return $line; |
| 379 | 379 | } |
| 380 | 380 | |
| 381 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 381 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 382 | 382 | /** |
| 383 | 383 | * Select a database |
| 384 | 384 | * PostgreSQL does not have an equivalent for `mysql_select_db` |
@@ -389,7 +389,7 @@ discard block |
||
| 389 | 389 | */ |
| 390 | 390 | public function select_db($database) |
| 391 | 391 | { |
| 392 | - // phpcs:enable |
|
| 392 | + // phpcs:enable |
|
| 393 | 393 | if ($database == $this->database_name) { |
| 394 | 394 | return true; |
| 395 | 395 | } else { |
@@ -586,7 +586,7 @@ discard block |
||
| 586 | 586 | return $ret; |
| 587 | 587 | } |
| 588 | 588 | |
| 589 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 589 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 590 | 590 | /** |
| 591 | 591 | * Returns the current line (as an object) for the resultset cursor |
| 592 | 592 | * |
@@ -595,7 +595,7 @@ discard block |
||
| 595 | 595 | */ |
| 596 | 596 | public function fetch_object($resultset) |
| 597 | 597 | { |
| 598 | - // phpcs:enable |
|
| 598 | + // phpcs:enable |
|
| 599 | 599 | // If resultset not provided, we take the last used by connection |
| 600 | 600 | if (!is_resource($resultset) && !is_object($resultset)) { |
| 601 | 601 | $resultset = $this->_results; |
@@ -603,7 +603,7 @@ discard block |
||
| 603 | 603 | return pg_fetch_object($resultset); |
| 604 | 604 | } |
| 605 | 605 | |
| 606 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 606 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 607 | 607 | /** |
| 608 | 608 | * Return datas as an array |
| 609 | 609 | * |
@@ -612,7 +612,7 @@ discard block |
||
| 612 | 612 | */ |
| 613 | 613 | public function fetch_array($resultset) |
| 614 | 614 | { |
| 615 | - // phpcs:enable |
|
| 615 | + // phpcs:enable |
|
| 616 | 616 | // If resultset not provided, we take the last used by connection |
| 617 | 617 | if (!is_resource($resultset) && !is_object($resultset)) { |
| 618 | 618 | $resultset = $this->_results; |
@@ -620,7 +620,7 @@ discard block |
||
| 620 | 620 | return pg_fetch_array($resultset); |
| 621 | 621 | } |
| 622 | 622 | |
| 623 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 623 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 624 | 624 | /** |
| 625 | 625 | * Return datas as an array |
| 626 | 626 | * |
@@ -629,7 +629,7 @@ discard block |
||
| 629 | 629 | */ |
| 630 | 630 | public function fetch_row($resultset) |
| 631 | 631 | { |
| 632 | - // phpcs:enable |
|
| 632 | + // phpcs:enable |
|
| 633 | 633 | // Si le resultset n'est pas fourni, on prend le dernier utilise sur cette connection |
| 634 | 634 | if (!is_resource($resultset) && !is_object($resultset)) { |
| 635 | 635 | $resultset = $this->_results; |
@@ -637,7 +637,7 @@ discard block |
||
| 637 | 637 | return pg_fetch_row($resultset); |
| 638 | 638 | } |
| 639 | 639 | |
| 640 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 640 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 641 | 641 | /** |
| 642 | 642 | * Return number of lines for result of a SELECT |
| 643 | 643 | * |
@@ -647,7 +647,7 @@ discard block |
||
| 647 | 647 | */ |
| 648 | 648 | public function num_rows($resultset) |
| 649 | 649 | { |
| 650 | - // phpcs:enable |
|
| 650 | + // phpcs:enable |
|
| 651 | 651 | // If resultset not provided, we take the last used by connection |
| 652 | 652 | if (!is_resource($resultset) && !is_object($resultset)) { |
| 653 | 653 | $resultset = $this->_results; |
@@ -655,7 +655,7 @@ discard block |
||
| 655 | 655 | return pg_num_rows($resultset); |
| 656 | 656 | } |
| 657 | 657 | |
| 658 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 658 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 659 | 659 | /** |
| 660 | 660 | * Return the number of lines in the result of a request INSERT, DELETE or UPDATE |
| 661 | 661 | * |
@@ -665,7 +665,7 @@ discard block |
||
| 665 | 665 | */ |
| 666 | 666 | public function affected_rows($resultset) |
| 667 | 667 | { |
| 668 | - // phpcs:enable |
|
| 668 | + // phpcs:enable |
|
| 669 | 669 | // If resultset not provided, we take the last used by connection |
| 670 | 670 | if (!is_resource($resultset) && !is_object($resultset)) { |
| 671 | 671 | $resultset = $this->_results; |
@@ -846,7 +846,7 @@ discard block |
||
| 846 | 846 | return pg_last_error($this->db); |
| 847 | 847 | } |
| 848 | 848 | |
| 849 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 849 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 850 | 850 | /** |
| 851 | 851 | * Get last ID after an insert INSERT |
| 852 | 852 | * |
@@ -856,7 +856,7 @@ discard block |
||
| 856 | 856 | */ |
| 857 | 857 | public function last_insert_id($tab, $fieldid = 'rowid') |
| 858 | 858 | { |
| 859 | - // phpcs:enable |
|
| 859 | + // phpcs:enable |
|
| 860 | 860 | //$result = pg_query($this->db,"SELECT MAX(".$fieldid.") FROM ".$tab); |
| 861 | 861 | $result = pg_query($this->db, "SELECT currval('" . $tab . "_" . $fieldid . "_seq')"); |
| 862 | 862 | if (!$result) { |
@@ -912,7 +912,7 @@ discard block |
||
| 912 | 912 | } |
| 913 | 913 | |
| 914 | 914 | |
| 915 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 915 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 916 | 916 | /** |
| 917 | 917 | * Return connection ID |
| 918 | 918 | * |
@@ -920,13 +920,13 @@ discard block |
||
| 920 | 920 | */ |
| 921 | 921 | public function DDLGetConnectId() |
| 922 | 922 | { |
| 923 | - // phpcs:enable |
|
| 923 | + // phpcs:enable |
|
| 924 | 924 | return '?'; |
| 925 | 925 | } |
| 926 | 926 | |
| 927 | 927 | |
| 928 | 928 | |
| 929 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 929 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 930 | 930 | /** |
| 931 | 931 | * Create a new database |
| 932 | 932 | * Do not use function xxx_create_db (xxx=mysql, ...) as they are deprecated |
@@ -940,7 +940,7 @@ discard block |
||
| 940 | 940 | */ |
| 941 | 941 | public function DDLCreateDb($database, $charset = '', $collation = '', $owner = '') |
| 942 | 942 | { |
| 943 | - // phpcs:enable |
|
| 943 | + // phpcs:enable |
|
| 944 | 944 | if (empty($charset)) { |
| 945 | 945 | $charset = $this->forcecharset; |
| 946 | 946 | } |
@@ -960,7 +960,7 @@ discard block |
||
| 960 | 960 | return $ret; |
| 961 | 961 | } |
| 962 | 962 | |
| 963 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 963 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 964 | 964 | /** |
| 965 | 965 | * List tables into a database |
| 966 | 966 | * |
@@ -970,7 +970,7 @@ discard block |
||
| 970 | 970 | */ |
| 971 | 971 | public function DDLListTables($database, $table = '') |
| 972 | 972 | { |
| 973 | - // phpcs:enable |
|
| 973 | + // phpcs:enable |
|
| 974 | 974 | $listtables = array(); |
| 975 | 975 | |
| 976 | 976 | $escapedlike = ''; |
@@ -988,7 +988,7 @@ discard block |
||
| 988 | 988 | return $listtables; |
| 989 | 989 | } |
| 990 | 990 | |
| 991 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 991 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 992 | 992 | /** |
| 993 | 993 | * List tables into a database |
| 994 | 994 | * |
@@ -998,7 +998,7 @@ discard block |
||
| 998 | 998 | */ |
| 999 | 999 | public function DDLListTablesFull($database, $table = '') |
| 1000 | 1000 | { |
| 1001 | - // phpcs:enable |
|
| 1001 | + // phpcs:enable |
|
| 1002 | 1002 | $listtables = array(); |
| 1003 | 1003 | |
| 1004 | 1004 | $escapedlike = ''; |
@@ -1016,7 +1016,7 @@ discard block |
||
| 1016 | 1016 | return $listtables; |
| 1017 | 1017 | } |
| 1018 | 1018 | |
| 1019 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 1019 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 1020 | 1020 | /** |
| 1021 | 1021 | * List information of columns into a table. |
| 1022 | 1022 | * |
@@ -1025,7 +1025,7 @@ discard block |
||
| 1025 | 1025 | */ |
| 1026 | 1026 | public function DDLInfoTable($table) |
| 1027 | 1027 | { |
| 1028 | - // phpcs:enable |
|
| 1028 | + // phpcs:enable |
|
| 1029 | 1029 | $infotables = array(); |
| 1030 | 1030 | |
| 1031 | 1031 | $sql = "SELECT "; |
@@ -1054,7 +1054,7 @@ discard block |
||
| 1054 | 1054 | } |
| 1055 | 1055 | |
| 1056 | 1056 | |
| 1057 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 1057 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 1058 | 1058 | /** |
| 1059 | 1059 | * Create a table into database |
| 1060 | 1060 | * |
@@ -1069,7 +1069,7 @@ discard block |
||
| 1069 | 1069 | */ |
| 1070 | 1070 | public function DDLCreateTable($table, $fields, $primary_key, $type, $unique_keys = null, $fulltext_keys = null, $keys = null) |
| 1071 | 1071 | { |
| 1072 | - // phpcs:enable |
|
| 1072 | + // phpcs:enable |
|
| 1073 | 1073 | // @TODO: $fulltext_keys parameter is unused |
| 1074 | 1074 | |
| 1075 | 1075 | $sqlk = array(); |
@@ -1146,7 +1146,7 @@ discard block |
||
| 1146 | 1146 | } |
| 1147 | 1147 | } |
| 1148 | 1148 | |
| 1149 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 1149 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 1150 | 1150 | /** |
| 1151 | 1151 | * Drop a table into database |
| 1152 | 1152 | * |
@@ -1155,7 +1155,7 @@ discard block |
||
| 1155 | 1155 | */ |
| 1156 | 1156 | public function DDLDropTable($table) |
| 1157 | 1157 | { |
| 1158 | - // phpcs:enable |
|
| 1158 | + // phpcs:enable |
|
| 1159 | 1159 | $tmptable = preg_replace('/[^a-z0-9\.\-\_]/i', '', $table); |
| 1160 | 1160 | |
| 1161 | 1161 | $sql = "DROP TABLE " . $this->sanitize($tmptable); |
@@ -1167,7 +1167,7 @@ discard block |
||
| 1167 | 1167 | } |
| 1168 | 1168 | } |
| 1169 | 1169 | |
| 1170 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 1170 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 1171 | 1171 | /** |
| 1172 | 1172 | * Return a pointer of line with description of a table or field |
| 1173 | 1173 | * |
@@ -1177,7 +1177,7 @@ discard block |
||
| 1177 | 1177 | */ |
| 1178 | 1178 | public function DDLDescTable($table, $field = "") |
| 1179 | 1179 | { |
| 1180 | - // phpcs:enable |
|
| 1180 | + // phpcs:enable |
|
| 1181 | 1181 | $sql = "SELECT attname FROM pg_attribute, pg_type WHERE typname = '" . $this->escape($table) . "' AND attrelid = typrelid"; |
| 1182 | 1182 | $sql .= " AND attname NOT IN ('cmin', 'cmax', 'ctid', 'oid', 'tableoid', 'xmin', 'xmax')"; |
| 1183 | 1183 | if ($field) { |
@@ -1189,7 +1189,7 @@ discard block |
||
| 1189 | 1189 | return $this->_results; |
| 1190 | 1190 | } |
| 1191 | 1191 | |
| 1192 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 1192 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 1193 | 1193 | /** |
| 1194 | 1194 | * Create a new field into table |
| 1195 | 1195 | * |
@@ -1201,7 +1201,7 @@ discard block |
||
| 1201 | 1201 | */ |
| 1202 | 1202 | public function DDLAddField($table, $field_name, $field_desc, $field_position = "") |
| 1203 | 1203 | { |
| 1204 | - // phpcs:enable |
|
| 1204 | + // phpcs:enable |
|
| 1205 | 1205 | // cles recherchees dans le tableau des descriptions (field_desc) : type,value,attribute,null,default,extra |
| 1206 | 1206 | // ex. : $field_desc = array('type'=>'int','value'=>'11','null'=>'not null','extra'=> 'auto_increment'); |
| 1207 | 1207 | $sql = "ALTER TABLE " . $this->sanitize($table) . " ADD " . $this->sanitize($field_name) . " "; |
@@ -1238,7 +1238,7 @@ discard block |
||
| 1238 | 1238 | return 1; |
| 1239 | 1239 | } |
| 1240 | 1240 | |
| 1241 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 1241 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 1242 | 1242 | /** |
| 1243 | 1243 | * Update format of a field into a table |
| 1244 | 1244 | * |
@@ -1249,7 +1249,7 @@ discard block |
||
| 1249 | 1249 | */ |
| 1250 | 1250 | public function DDLUpdateField($table, $field_name, $field_desc) |
| 1251 | 1251 | { |
| 1252 | - // phpcs:enable |
|
| 1252 | + // phpcs:enable |
|
| 1253 | 1253 | $sql = "ALTER TABLE " . $this->sanitize($table); |
| 1254 | 1254 | $sql .= " ALTER COLUMN " . $this->sanitize($field_name) . " TYPE " . $this->sanitize($field_desc['type']); |
| 1255 | 1255 | if (isset($field_desc['value']) && preg_match("/^[^\s]/i", $field_desc['value'])) { |
@@ -1284,7 +1284,7 @@ discard block |
||
| 1284 | 1284 | return 1; |
| 1285 | 1285 | } |
| 1286 | 1286 | |
| 1287 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 1287 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 1288 | 1288 | /** |
| 1289 | 1289 | * Drop a field from table |
| 1290 | 1290 | * |
@@ -1294,7 +1294,7 @@ discard block |
||
| 1294 | 1294 | */ |
| 1295 | 1295 | public function DDLDropField($table, $field_name) |
| 1296 | 1296 | { |
| 1297 | - // phpcs:enable |
|
| 1297 | + // phpcs:enable |
|
| 1298 | 1298 | $tmp_field_name = preg_replace('/[^a-z0-9\.\-\_]/i', '', $field_name); |
| 1299 | 1299 | |
| 1300 | 1300 | $sql = "ALTER TABLE " . $this->sanitize($table) . " DROP COLUMN " . $this->sanitize($tmp_field_name); |
@@ -1305,7 +1305,7 @@ discard block |
||
| 1305 | 1305 | return 1; |
| 1306 | 1306 | } |
| 1307 | 1307 | |
| 1308 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 1308 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 1309 | 1309 | /** |
| 1310 | 1310 | * Create a user to connect to database |
| 1311 | 1311 | * |
@@ -1317,7 +1317,7 @@ discard block |
||
| 1317 | 1317 | */ |
| 1318 | 1318 | public function DDLCreateUser($dolibarr_main_db_host, $dolibarr_main_db_user, $dolibarr_main_db_pass, $dolibarr_main_db_name) |
| 1319 | 1319 | { |
| 1320 | - // phpcs:enable |
|
| 1320 | + // phpcs:enable |
|
| 1321 | 1321 | // Note: using ' on user does not works with pgsql |
| 1322 | 1322 | $sql = "CREATE USER " . $this->sanitize($dolibarr_main_db_user) . " with password '" . $this->escape($dolibarr_main_db_pass) . "'"; |
| 1323 | 1323 | |
@@ -215,7 +215,7 @@ discard block |
||
| 215 | 215 | } |
| 216 | 216 | |
| 217 | 217 | |
| 218 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 218 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 219 | 219 | /** |
| 220 | 220 | * Select a database |
| 221 | 221 | * |
@@ -224,7 +224,7 @@ discard block |
||
| 224 | 224 | */ |
| 225 | 225 | public function select_db($database) |
| 226 | 226 | { |
| 227 | - // phpcs:enable |
|
| 227 | + // phpcs:enable |
|
| 228 | 228 | dol_syslog(get_class($this) . "::select_db database=" . $database, LOG_DEBUG); |
| 229 | 229 | $result = false; |
| 230 | 230 | try { |
@@ -388,7 +388,7 @@ discard block |
||
| 388 | 388 | return $msg; |
| 389 | 389 | } |
| 390 | 390 | |
| 391 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 391 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 392 | 392 | /** |
| 393 | 393 | * Returns the current line (as an object) for the resultset cursor |
| 394 | 394 | * |
@@ -397,7 +397,7 @@ discard block |
||
| 397 | 397 | */ |
| 398 | 398 | public function fetch_object($resultset) |
| 399 | 399 | { |
| 400 | - // phpcs:enable |
|
| 400 | + // phpcs:enable |
|
| 401 | 401 | // If the resultset was not provided, we get the last one for this connection |
| 402 | 402 | if (!is_object($resultset)) { |
| 403 | 403 | $resultset = $this->_results; |
@@ -406,7 +406,7 @@ discard block |
||
| 406 | 406 | } |
| 407 | 407 | |
| 408 | 408 | |
| 409 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 409 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 410 | 410 | /** |
| 411 | 411 | * Return datas as an array |
| 412 | 412 | * |
@@ -415,7 +415,7 @@ discard block |
||
| 415 | 415 | */ |
| 416 | 416 | public function fetch_array($resultset) |
| 417 | 417 | { |
| 418 | - // phpcs:enable |
|
| 418 | + // phpcs:enable |
|
| 419 | 419 | // If resultset not provided, we take the last used by connection |
| 420 | 420 | if (!is_object($resultset)) { |
| 421 | 421 | $resultset = $this->_results; |
@@ -423,7 +423,7 @@ discard block |
||
| 423 | 423 | return $resultset->fetch_array(); |
| 424 | 424 | } |
| 425 | 425 | |
| 426 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 426 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 427 | 427 | /** |
| 428 | 428 | * Return datas as an array |
| 429 | 429 | * |
@@ -432,7 +432,7 @@ discard block |
||
| 432 | 432 | */ |
| 433 | 433 | public function fetch_row($resultset) |
| 434 | 434 | { |
| 435 | - // phpcs:enable |
|
| 435 | + // phpcs:enable |
|
| 436 | 436 | // If resultset not provided, we take the last used by connection |
| 437 | 437 | if (!is_bool($resultset)) { |
| 438 | 438 | if (!is_object($resultset)) { |
@@ -445,7 +445,7 @@ discard block |
||
| 445 | 445 | } |
| 446 | 446 | } |
| 447 | 447 | |
| 448 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 448 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 449 | 449 | /** |
| 450 | 450 | * Return number of lines for result of a SELECT |
| 451 | 451 | * |
@@ -455,7 +455,7 @@ discard block |
||
| 455 | 455 | */ |
| 456 | 456 | public function num_rows($resultset) |
| 457 | 457 | { |
| 458 | - // phpcs:enable |
|
| 458 | + // phpcs:enable |
|
| 459 | 459 | // If resultset not provided, we take the last used by connection |
| 460 | 460 | if (!is_object($resultset)) { |
| 461 | 461 | $resultset = $this->_results; |
@@ -463,7 +463,7 @@ discard block |
||
| 463 | 463 | return isset($resultset->num_rows) ? $resultset->num_rows : 0; |
| 464 | 464 | } |
| 465 | 465 | |
| 466 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 466 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 467 | 467 | /** |
| 468 | 468 | * Return the number of lines in the result of a request INSERT, DELETE or UPDATE |
| 469 | 469 | * |
@@ -473,7 +473,7 @@ discard block |
||
| 473 | 473 | */ |
| 474 | 474 | public function affected_rows($resultset) |
| 475 | 475 | { |
| 476 | - // phpcs:enable |
|
| 476 | + // phpcs:enable |
|
| 477 | 477 | // If resultset not provided, we take the last used by connection |
| 478 | 478 | if (!is_object($resultset)) { |
| 479 | 479 | $resultset = $this->_results; |
@@ -591,7 +591,7 @@ discard block |
||
| 591 | 591 | } |
| 592 | 592 | } |
| 593 | 593 | |
| 594 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 594 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 595 | 595 | /** |
| 596 | 596 | * Get last ID after an insert INSERT |
| 597 | 597 | * |
@@ -601,7 +601,7 @@ discard block |
||
| 601 | 601 | */ |
| 602 | 602 | public function last_insert_id($tab, $fieldid = 'rowid') |
| 603 | 603 | { |
| 604 | - // phpcs:enable |
|
| 604 | + // phpcs:enable |
|
| 605 | 605 | return $this->db->insert_id; |
| 606 | 606 | } |
| 607 | 607 | |
@@ -666,7 +666,7 @@ discard block |
||
| 666 | 666 | } |
| 667 | 667 | |
| 668 | 668 | |
| 669 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 669 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 670 | 670 | /** |
| 671 | 671 | * Return connection ID |
| 672 | 672 | * |
@@ -674,7 +674,7 @@ discard block |
||
| 674 | 674 | */ |
| 675 | 675 | public function DDLGetConnectId() |
| 676 | 676 | { |
| 677 | - // phpcs:enable |
|
| 677 | + // phpcs:enable |
|
| 678 | 678 | $resql = $this->query('SELECT CONNECTION_ID()'); |
| 679 | 679 | if ($resql) { |
| 680 | 680 | $row = $this->fetch_row($resql); |
@@ -684,7 +684,7 @@ discard block |
||
| 684 | 684 | } |
| 685 | 685 | } |
| 686 | 686 | |
| 687 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 687 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 688 | 688 | /** |
| 689 | 689 | * Create a new database |
| 690 | 690 | * Do not use function xxx_create_db (xxx=mysql, ...) as they are deprecated |
@@ -698,7 +698,7 @@ discard block |
||
| 698 | 698 | */ |
| 699 | 699 | public function DDLCreateDb($database, $charset = '', $collation = '', $owner = '') |
| 700 | 700 | { |
| 701 | - // phpcs:enable |
|
| 701 | + // phpcs:enable |
|
| 702 | 702 | if (empty($charset)) { |
| 703 | 703 | $charset = $this->forcecharset; |
| 704 | 704 | } |
@@ -722,7 +722,7 @@ discard block |
||
| 722 | 722 | return $ret; |
| 723 | 723 | } |
| 724 | 724 | |
| 725 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 725 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 726 | 726 | /** |
| 727 | 727 | * List tables into a database |
| 728 | 728 | * |
@@ -732,7 +732,7 @@ discard block |
||
| 732 | 732 | */ |
| 733 | 733 | public function DDLListTables($database, $table = '') |
| 734 | 734 | { |
| 735 | - // phpcs:enable |
|
| 735 | + // phpcs:enable |
|
| 736 | 736 | $listtables = array(); |
| 737 | 737 | |
| 738 | 738 | $like = ''; |
@@ -754,7 +754,7 @@ discard block |
||
| 754 | 754 | return $listtables; |
| 755 | 755 | } |
| 756 | 756 | |
| 757 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 757 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 758 | 758 | /** |
| 759 | 759 | * List tables into a database |
| 760 | 760 | * |
@@ -764,7 +764,7 @@ discard block |
||
| 764 | 764 | */ |
| 765 | 765 | public function DDLListTablesFull($database, $table = '') |
| 766 | 766 | { |
| 767 | - // phpcs:enable |
|
| 767 | + // phpcs:enable |
|
| 768 | 768 | $listtables = array(); |
| 769 | 769 | |
| 770 | 770 | $like = ''; |
@@ -786,7 +786,7 @@ discard block |
||
| 786 | 786 | return $listtables; |
| 787 | 787 | } |
| 788 | 788 | |
| 789 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 789 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 790 | 790 | /** |
| 791 | 791 | * List information of columns into a table. |
| 792 | 792 | * |
@@ -795,7 +795,7 @@ discard block |
||
| 795 | 795 | */ |
| 796 | 796 | public function DDLInfoTable($table) |
| 797 | 797 | { |
| 798 | - // phpcs:enable |
|
| 798 | + // phpcs:enable |
|
| 799 | 799 | $infotables = array(); |
| 800 | 800 | |
| 801 | 801 | $tmptable = preg_replace('/[^a-z0-9\.\-\_]/i', '', $table); |
@@ -812,7 +812,7 @@ discard block |
||
| 812 | 812 | return $infotables; |
| 813 | 813 | } |
| 814 | 814 | |
| 815 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 815 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 816 | 816 | /** |
| 817 | 817 | * Create a table into database |
| 818 | 818 | * |
@@ -827,7 +827,7 @@ discard block |
||
| 827 | 827 | */ |
| 828 | 828 | public function DDLCreateTable($table, $fields, $primary_key, $type, $unique_keys = null, $fulltext_keys = null, $keys = null) |
| 829 | 829 | { |
| 830 | - // phpcs:enable |
|
| 830 | + // phpcs:enable |
|
| 831 | 831 | // @TODO: $fulltext_keys parameter is unused |
| 832 | 832 | |
| 833 | 833 | if (empty($type)) { |
@@ -909,7 +909,7 @@ discard block |
||
| 909 | 909 | } |
| 910 | 910 | } |
| 911 | 911 | |
| 912 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 912 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 913 | 913 | /** |
| 914 | 914 | * Drop a table into database |
| 915 | 915 | * |
@@ -918,7 +918,7 @@ discard block |
||
| 918 | 918 | */ |
| 919 | 919 | public function DDLDropTable($table) |
| 920 | 920 | { |
| 921 | - // phpcs:enable |
|
| 921 | + // phpcs:enable |
|
| 922 | 922 | $tmptable = preg_replace('/[^a-z0-9\.\-\_]/i', '', $table); |
| 923 | 923 | |
| 924 | 924 | $sql = "DROP TABLE " . $this->sanitize($tmptable); |
@@ -930,7 +930,7 @@ discard block |
||
| 930 | 930 | } |
| 931 | 931 | } |
| 932 | 932 | |
| 933 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 933 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 934 | 934 | /** |
| 935 | 935 | * Return a pointer of line with description of a table or field |
| 936 | 936 | * |
@@ -940,7 +940,7 @@ discard block |
||
| 940 | 940 | */ |
| 941 | 941 | public function DDLDescTable($table, $field = "") |
| 942 | 942 | { |
| 943 | - // phpcs:enable |
|
| 943 | + // phpcs:enable |
|
| 944 | 944 | $sql = "DESC " . $this->sanitize($table) . " " . $this->sanitize($field); |
| 945 | 945 | |
| 946 | 946 | dol_syslog(get_class($this) . "::DDLDescTable " . $sql, LOG_DEBUG); |
@@ -948,7 +948,7 @@ discard block |
||
| 948 | 948 | return $this->_results; |
| 949 | 949 | } |
| 950 | 950 | |
| 951 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 951 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 952 | 952 | /** |
| 953 | 953 | * Create a new field into table |
| 954 | 954 | * |
@@ -960,7 +960,7 @@ discard block |
||
| 960 | 960 | */ |
| 961 | 961 | public function DDLAddField($table, $field_name, $field_desc, $field_position = "") |
| 962 | 962 | { |
| 963 | - // phpcs:enable |
|
| 963 | + // phpcs:enable |
|
| 964 | 964 | // cles recherchees dans le tableau des descriptions (field_desc) : type,value,attribute,null,default,extra |
| 965 | 965 | // ex. : $field_desc = array('type'=>'int','value'=>'11','null'=>'not null','extra'=> 'auto_increment'); |
| 966 | 966 | $sql = "ALTER TABLE " . $this->sanitize($table) . " ADD " . $this->sanitize($field_name) . " "; |
@@ -997,7 +997,7 @@ discard block |
||
| 997 | 997 | return -1; |
| 998 | 998 | } |
| 999 | 999 | |
| 1000 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 1000 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 1001 | 1001 | /** |
| 1002 | 1002 | * Update format of a field into a table |
| 1003 | 1003 | * |
@@ -1008,7 +1008,7 @@ discard block |
||
| 1008 | 1008 | */ |
| 1009 | 1009 | public function DDLUpdateField($table, $field_name, $field_desc) |
| 1010 | 1010 | { |
| 1011 | - // phpcs:enable |
|
| 1011 | + // phpcs:enable |
|
| 1012 | 1012 | $sql = "ALTER TABLE " . $this->sanitize($table); |
| 1013 | 1013 | $sql .= " MODIFY COLUMN " . $this->sanitize($field_name) . " " . $this->sanitize($field_desc['type']); |
| 1014 | 1014 | if (in_array($field_desc['type'], array('double', 'tinyint', 'int', 'varchar')) && $field_desc['value']) { |
@@ -1043,7 +1043,7 @@ discard block |
||
| 1043 | 1043 | } |
| 1044 | 1044 | } |
| 1045 | 1045 | |
| 1046 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 1046 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 1047 | 1047 | /** |
| 1048 | 1048 | * Drop a field from table |
| 1049 | 1049 | * |
@@ -1053,7 +1053,7 @@ discard block |
||
| 1053 | 1053 | */ |
| 1054 | 1054 | public function DDLDropField($table, $field_name) |
| 1055 | 1055 | { |
| 1056 | - // phpcs:enable |
|
| 1056 | + // phpcs:enable |
|
| 1057 | 1057 | $tmp_field_name = preg_replace('/[^a-z0-9\.\-\_]/i', '', $field_name); |
| 1058 | 1058 | |
| 1059 | 1059 | $sql = "ALTER TABLE " . $this->sanitize($table) . " DROP COLUMN `" . $this->sanitize($tmp_field_name) . "`"; |
@@ -1065,7 +1065,7 @@ discard block |
||
| 1065 | 1065 | } |
| 1066 | 1066 | |
| 1067 | 1067 | |
| 1068 | - // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 1068 | + // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps |
|
| 1069 | 1069 | /** |
| 1070 | 1070 | * Create a user and privileges to connect to database (even if database does not exists yet) |
| 1071 | 1071 | * |
@@ -1077,7 +1077,7 @@ discard block |
||
| 1077 | 1077 | */ |
| 1078 | 1078 | public function DDLCreateUser($dolibarr_main_db_host, $dolibarr_main_db_user, $dolibarr_main_db_pass, $dolibarr_main_db_name) |
| 1079 | 1079 | { |
| 1080 | - // phpcs:enable |
|
| 1080 | + // phpcs:enable |
|
| 1081 | 1081 | $sql = "CREATE USER '" . $this->escape($dolibarr_main_db_user) . "' IDENTIFIED BY '" . $this->escape($dolibarr_main_db_pass) . "'"; |
| 1082 | 1082 | dol_syslog(get_class($this) . "::DDLCreateUser", LOG_DEBUG); // No sql to avoid password in log |
| 1083 | 1083 | $resql = $this->query($sql); |