147 lines
5.0 KiB
PHP
147 lines
5.0 KiB
PHP
#!/usr/bin/env php
|
|
<?php
|
|
/* Copyright (C) 2016 Laurent Destailleur <eldy@users.sourceforge.net>
|
|
*
|
|
* This program is free software; you can redistribute it and/or modify
|
|
* it under the terms of the GNU General Public License as published by
|
|
* the Free Software Foundation; either version 3 of the License, or
|
|
* (at your option) any later version.
|
|
*
|
|
* This program is distributed in the hope that it will be useful,
|
|
* but WITHOUT ANY WARRANTY; without even the implied warranty of
|
|
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
|
* GNU General Public License for more details.
|
|
*
|
|
* You should have received a copy of the GNU General Public License
|
|
* along with this program. If not, see <https://www.gnu.org/licenses/>.
|
|
* or see https://www.gnu.org/
|
|
*
|
|
* Get a distant dump file and load it into a mysql database
|
|
*/
|
|
|
|
$sapi_type = php_sapi_name();
|
|
$script_file = basename(__FILE__);
|
|
$path = dirname(__FILE__).'/';
|
|
|
|
// Test if batch mode
|
|
if (substr($sapi_type, 0, 3) == 'cgi') {
|
|
echo "Error: You are using PHP for CGI. To execute ".$script_file." from command line, you must use PHP for CLI mode.\n";
|
|
exit;
|
|
}
|
|
|
|
// Global variables
|
|
$error = 0;
|
|
|
|
$confirm = isset($argv[1]) ? $argv[1] : '';
|
|
|
|
// Include Dolibarr environment
|
|
$res = 0;
|
|
if (!$res && file_exists($path."../../master.inc.php")) {
|
|
$res = @include $path."../../master.inc.php";
|
|
}
|
|
if (!$res && file_exists($path."../../htdocs/master.inc.php")) {
|
|
$res = @include $path."../../htdocs/master.inc.php";
|
|
}
|
|
if (!$res && file_exists("../master.inc.php")) {
|
|
$res = @include "../master.inc.php";
|
|
}
|
|
if (!$res && file_exists("../../master.inc.php")) {
|
|
$res = @include "../../master.inc.php";
|
|
}
|
|
if (!$res && file_exists("../../../master.inc.php")) {
|
|
$res = @include "../../../master.inc.php";
|
|
}
|
|
if (!$res && preg_match('/\/nltechno([^\/]*)\//', $_SERVER["PHP_SELF"], $reg)) {
|
|
$res = @include $path."../../../dolibarr".$reg[1]."/htdocs/master.inc.php"; // Used on dev env only
|
|
}
|
|
if (!$res && preg_match('/\/nltechno([^\/]*)\//', $_SERVER["PHP_SELF"], $reg)) {
|
|
$res = @include "../../../dolibarr".$reg[1]."/htdocs/master.inc.php"; // Used on dev env only
|
|
}
|
|
if (!$res) {
|
|
die("Failed to include master.inc.php file\n");
|
|
}
|
|
include_once DOL_DOCUMENT_ROOT.'/core/lib/files.lib.php';
|
|
|
|
|
|
/*
|
|
* Main
|
|
*/
|
|
|
|
print "***** ".$script_file." *****\n";
|
|
print "Update dates to current year for database name = ".$db->database_name."\n";
|
|
if (empty($confirm)) {
|
|
print "Usage: $script_file confirm\n";
|
|
print "Return code: 0 if success, <>0 if error\n";
|
|
exit(-1);
|
|
}
|
|
|
|
|
|
$tmp = dol_getdate(dol_now());
|
|
|
|
|
|
$tables = array(
|
|
'propal' => array(0 => 'datep', 1 => 'fin_validite', 2 => 'date_valid', 3 => 'date_cloture'),
|
|
'commande' => array(0 => 'date_commande', 1 => 'date_valid', 2 => 'date_cloture'),
|
|
'facture' => array(0 => 'datec', 1 => 'datef', 2 => 'date_valid', 3 => 'date_lim_reglement'),
|
|
'paiement' => array(0 => 'datep'),
|
|
'bank' => array(0 => 'datev', 1 => 'dateo'),
|
|
'commande_fournisseur' => array(0 => 'date_commande', 1 => 'date_valid', 3 => 'date_creation', 4 => 'date_approve', 5 => 'date_approve2', 6 => 'date_livraison'),
|
|
'supplier_proposal' => array(0 => 'datec', 1 => 'date_valid', 2 => 'date_cloture'),
|
|
'expensereport' => array(0 => 'date_debut', 1 => 'date_fin', 2 => 'date_create', 3 => 'date_valid', 4 => 'date_approve', 5 => 'date_refuse', 6 => 'date_cancel'),
|
|
'holiday' => array(0 => 'date_debut', 1 => 'date_fin', 2 => 'date_create', 3 => 'date_valid', 5 => 'date_refuse', 6 => 'date_cancel'),
|
|
'ticket' => array(0 => 'datec', 1 => 'date_read', 2 => 'date_close')
|
|
);
|
|
|
|
$year = 2010;
|
|
$currentyear = $tmp['year'];
|
|
while ($year <= $currentyear) {
|
|
//$year=2021;
|
|
$delta1 = ($currentyear - $year);
|
|
$delta2 = ($currentyear - $year - 1);
|
|
//$delta=-1;
|
|
|
|
if ($delta1) {
|
|
foreach ($tables as $tablekey => $tableval) {
|
|
print "Correct ".$tablekey." for year ".$year." and move them to current year ".$currentyear." ";
|
|
$sql = "select rowid from ".MAIN_DB_PREFIX.$tablekey." where ".$tableval[0]." between '".$year."-01-01' and '".$year."-12-31' and ".$tableval[0]." < DATE_ADD(NOW(), INTERVAL -1 YEAR)";
|
|
//$sql="select rowid from ".MAIN_DB_PREFIX.$tablekey." where ".$tableval[0]." between '".$year."-01-01' and '".$year."-12-31' and ".$tableval[0]." > NOW()";
|
|
$resql = $db->query($sql);
|
|
if ($resql) {
|
|
$num = $db->num_rows($resql);
|
|
$i = 0;
|
|
while ($i < $num) {
|
|
$obj = $db->fetch_object($resql);
|
|
if ($obj) {
|
|
print ".";
|
|
$sql2 = "UPDATE ".MAIN_DB_PREFIX.$tablekey." set ";
|
|
$j = 0;
|
|
foreach ($tableval as $field) {
|
|
if ($j) {
|
|
$sql2 .= ", ";
|
|
}
|
|
$sql2 .= $field." = ".$db->ifsql("DATE_ADD(".$field.", INTERVAL ".$delta1." YEAR) > NOW()", "DATE_ADD(".$field.", INTERVAL ".$delta2." YEAR)", "DATE_ADD(".$field.", INTERVAL ".$delta1." YEAR)");
|
|
$j++;
|
|
}
|
|
$sql2 .= " WHERE rowid = ".$obj->rowid;
|
|
//print $sql2."\n";
|
|
$resql2 = $db->query($sql2);
|
|
if (!$resql2) {
|
|
dol_print_error($db);
|
|
}
|
|
}
|
|
$i++;
|
|
}
|
|
} else {
|
|
dol_print_error($db);
|
|
}
|
|
print "\n";
|
|
}
|
|
}
|
|
|
|
$year++;
|
|
}
|
|
|
|
print "\n";
|
|
|
|
exit(0);
|