/**
  * Load latest with former marks
  * 
  * @param int $max Max rows
  *
  * @return array
  */
 function loadListWithFormerMark($max)
 {
     $query = "SELECT * FROM {$this->base}.{$this->table}\r\n      WHERE {$this->mark_field} NOT IN ('', 'OKOKOKOK')";
     $query .= $this->getFilterClause();
     $query .= "\n ORDER BY {$this->trigger_key_field} DESC";
     $mouvs = CRecordSante400::loadMultiple($query, array(), $max, get_class($this));
     foreach ($mouvs as &$mouv) {
         $mouv->initialize();
     }
     return $mouvs;
 }
示例#2
0
$type = CValue::get("type");
$offset = CValue::get("offset");
$step = CValue::get("step");
CRecordSante400::$verbose = CValue::get("verbose");
if (!$type) {
    CAppUI::stepAjax("CMouvement400-error-no_type", UI_MSG_ERROR);
}
CAppUI::stepAjax("CMouvement400-alert-import", UI_MSG_ALERT, $type, $offset, $step);
$mouv = CMouvFactory::create($type);
if (!$mouv->origin || !$mouv->origin_key_field) {
    CAppUI::stepAjax("CMouvement400-error-trigger_no_origin", UI_MSG_WARNING, $mouv->class);
    return;
}
$query = "SELECT * FROM {$mouv->base}.{$mouv->origin} \r\n  WHERE {$mouv->origin_key_field} >= ?\r\n  AND {$mouv->origin_key_field} < ?";
$values = array($offset, $offset + $step);
$mouvs = CRecordSante400::loadMultiple($query, $values, $step, $mouv->class);
$totals = array("success" => 0, "failure" => 0);
$failures = array();
foreach ($mouvs as $_mouv) {
    $_mouv->value_prefix = $_mouv->origin_prefix;
    $origin_key = $_mouv->data[$mouv->origin_key_field];
    // Initialize trigger field
    $data = array();
    $data[$_mouv->trigger_key_field] = null;
    $data[$_mouv->type_field] = null;
    $data[$_mouv->when_field] = null;
    // Rebuild triggers fields
    foreach ($_mouv->data as $_field => $_value) {
        $data[$_mouv->old_prefix . $_field] = null;
        $data[$_mouv->new_prefix . $_field] = $_value;
    }