/* ---- C2C : trace de consultation du devis en ligne ---- */ if (!empty($object->id) && isset($object->element) && $object->element == 'propal') { $c2c_now = $db->idate(dol_now()); $c2c_sql = "INSERT INTO ".MAIN_DB_PREFIX."propal_extrafields (fk_object, c2c_vue_premiere, c2c_vue_derniere, c2c_vue_nb)"; $c2c_sql .= " VALUES (".((int) $object->id).", '".$c2c_now."', '".$c2c_now."', 1)"; $c2c_sql .= " ON DUPLICATE KEY UPDATE"; $c2c_sql .= " c2c_vue_premiere = COALESCE(c2c_vue_premiere, '".$c2c_now."'),"; $c2c_sql .= " c2c_vue_derniere = '".$c2c_now."',"; $c2c_sql .= " c2c_vue_nb = COALESCE(c2c_vue_nb, 0) + 1"; $db->query($c2c_sql); dol_syslog('C2C consultation devis en ligne : propal '.$object->id.' depuis '.getUserRemoteIP(), LOG_WARNING); } /* ---- fin C2C ---- */