public function verify_column_synchro($ctx = "")
{
unset($ctx['table_list']);
if (isset($ctx) && $ctx != '' && $ctx != ' ') {
if (is_array($ctx)) {
$ctx_object = new stdClass();
foreach ($ctx as $key => $values) {
$ctx_object->{$key} = $values;
}
}
$compteur = 0;
foreach ($ctx_object as $row) {
$req_list_champs = 'SELECT COLUMN_NAME FROM information_schema.COLUMNS WHERE TABLE_NAME="' . $row . '"';
$res_list_champs = $this->other_query($req_list_champs);
$created_on_create = false;
$modified_on_create = false;
foreach ($res_list_champs as $row_champs) {
if (isset($row_champs->COLUMN_NAME)) {
if ($row_champs->COLUMN_NAME == "created_on") {
$created_on_create = true;
}
if ($row_champs->COLUMN_NAME == "modified_on") {
$modified_on_create = true;
}
}
}
$date_now = date('Y-m-d H:i:s');
if ($created_on_create == false) {
$this->add_new_column($row, 'created_on', $type = "DATETIME NOT NULL");
$req_sql = 'UPDATE ' . $row . ' SET created_on = "' . $date_now . '"';
parent::query($req_sql);
$compteur++;
}
if ($modified_on_create == false) {
$this->add_new_column($row, 'modified_on', $type = "DATETIME NOT NULL");
$req_sql = 'UPDATE ' . $row . ' SET modified_on = "' . $date_now . '"';
parent::query($req_sql);
$compteur++;
}
if ($created_on_create == "0000-00-00 00:00:00") {
$req_sql = 'UPDATE ' . $row . ' SET created_on = "' . $date_now . '"';
parent::query($req_sql);
$compteur++;
}
if ($modified_on_create == "0000-00-00 00:00:00") {
$req_sql = 'UPDATE ' . $row . ' SET created_on = "' . $date_now . '"';
parent::query($req_sql);
$compteur++;
}
}
} else {
return 'erreur survenue dans la fonction verify_column_synchro par rapport aux données reçues';
}
return 'Votre insertion et synchronisation + add des colonne pour la synchro se sont bien déroulée : Nobmre de modification : ' . $compteur;
}
public function delete_row($table, $where)
{
$req_sql = "DELETE FROM " . $table . " WHERE " . $where;
parent::query($req_sql);
}
