--- 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;
+}
+?>
+