=date('[from-y]-[from-m]-[from-d]') and value<=adddate(date('[to-y]-[to-m]-[to-d]'),1) and length(value)>0"; $code_to_migrate[4]["replacement"] = "select distinct resource.ref 'Resource ID',resource.field8 'Resource Title',node.name 'Expires' from resource join resource_node on resource.ref=resource_node.resource join node on node.ref=resource_node.node join resource_type_field on node.resource_type_field=resource_type_field.ref where resource_type_field.type=6 and node.name>=date('[from-y]-[from-m]-[from-d]') and node.name<=adddate(date('[to-y]-[to-m]-[to-d]'),1) and length(node.name)>0"; $reports = ps_query("select ref,name,query from report"); foreach ($reports as $report) { t022_perform_migration($report, $code_to_migrate); } function t022_perform_migration($rep, $code_to_migrate) { foreach ($code_to_migrate as $code) { $position = strpos((string) $rep["query"], (string) $code["fingerprint"]); if ($position > 0 || $position === 0) { echo "Migrating report {$rep['ref']}

"; $new_query = str_replace($code["fingerprint"], $code["replacement"], $rep["query"]); ps_query("UPDATE report SET query=? WHERE ref=?", array("s",$new_query, "i",$rep['ref'])); } } }