protected function initSQL($stmt, $values, $create = false)
{
$stmt->addColumnValue("id_target", intval($values["id_target"]));
$stmt->addColumnValue("enabled", $values["source_enabled"]);
$stmt->addColumnValue("name", $values["source_name"]);
$stmt->addColumnValue("name_sort", strtolower(remove_leading_empty_words(remove_accents($values["source_name"]))));
$stmt->addColumnValue("country", $values["source_country"]);
$stmt->addColumnValue("language", $values["source_language"]);
$stmt->addColumnValueDate("updatetime");
$stmt->addColumnValue("collection", $this->normalizeTagsCollections($values["source_collection"]));
$stmt->addColumnValue("tag", $this->normalizeTagsCollections($values["source_tag"]));
$stmt->addColumnValue("crawl_minimal_period", $values["crawl_minimal_period"]);
if ($create) {
$stmt->addColumnValue("crawl_priority", "2");
}
// Remove Param element
$stmt->addColumnValue('language_detection_list', $values["source_language_detection_list"]);
$stmt->addColumnValue('crawl_maxdepth', $values["source_crawl_max_depth"]);
$stmt->addColumnValue('crawl_url_concurrency', $values["source_crawl_url_concurrency"]);
$stmt->addColumnValue('crawl_url_per_minute', $values["source_crawl_url_per_minute"]);
$stmt->addColumnValue('automatic_cleaning', $values["source_automatic_cleaning"]);
// crawl_schedule
$schedules = new SimpleXMLElement($values["source_schedule_xml"]);
$stmt->addColumnValue('crawl_schedule', $schedules->asXML());
// crawl_filtering_rules
$rules = new SimpleXMLElement($values["source_crawl_filtering_rules_xml"]);
$stmt->addColumnValue('crawl_filtering_rules', $rules->asXML());
$stmt->addColumnValue('metadata', $values["source_metadata"]);
$stmt->addColumnValue('contact', $values["source_contact"]);
$stmt->addColumnValue('comment', $values["source_comment"]);
return $stmt;
}
if (!update_field($name, $import_update_fields)) {
continue;
}
if (!in_array($name, $ignore)) {
$d = (string) $data;
if (empty(trim($d)) && in_array($name, $xml_items)) {
$x = $data->children();
$d = $x[0]->asXML();
$stmt->addColumnValue($name, $d);
} else {
$d = (string) $data;
if ($name == 'params') {
$stmt->addColumnValue($name, base64_decode($d));
} else {
if ($name == 'name') {
$stmt->addColumnValue('name_sort', strtolower(remove_leading_empty_words(remove_accents($d))));
}
$stmt->addColumnValue($name, $d);
}
}
}
}
if ($mode == 'insert' && !$stmt->checkNotNull($mg_source_not_null)) {
$arr = array('status' => 'error');
//echo json_encode($arr);
//exit();
} else {
$rs = $stmt->execute();
}
}
}
