--- a/admin/exportAusbudget.php +++ b/admin/exportAusbudget.php @@ -1,1 +1,68 @@ +"; + $html = phpQuery::newDocumentHTML(file_get_contents($dir . $fname)); + phpQuery::selectDocument($html); + foreach (pq('table')->elements as $table) { + $data = Array(); + ////echo "loltable"; + //echo $table->ownerDocument->saveXML($table); + foreach (pq('tr',$table)->elements as $row) { + //echo "lolrow"; + $rowText = pq($row)->text(); + if (strpos($rowText, "Twitter") === false) { + + $key = trim(pq("td:first", $row)->text()); + //echo "$key
"; + $value = trim(str_replace(pq("td:first", $row)->text(), "", pq("td", $row)->text())); + if ($key == "2011-2012" || $key == "2012-2013") { + $eValue = explode("-", $value); + $value = trim(str_replace(Array("$", ",", "\n"), "", $eValue[0])); + } + //echo "$value
"; + $data[$key] = trim(str_replace(Array("\n"), "", $value)); + if ($key == "Source") { + + foreach ($headers as $fieldName) { + if (isset($data[$fieldName])) { + + $csvrow[] = $data[$fieldName]; + } else { + $csvrow[] = ""; + } + } + + fputcsv($fp, array_values($csvrow)); + $data = Array(); + $csvrow = Array(); + } + } + } + } + } + } + } + die; +} +?> +