// +------------------+--------------+------+-----+------------+----------------+ // | Field | Type | Null | Key | Default | Extra | // +------------------+--------------+------+-----+------------+----------------+ // | idexpense_import | int(10) | | PRI | NULL | auto_increment | // | category | varchar(60) | | | | | // | debit_date | date | | | 0000-00-00 | | // | description | varchar(250) | | | | | // | payment_method | varchar(60) | | | | | // | amount | float(10,2) | | | 0.00 | | // +------------------+--------------+------+-----+------------+----------------+ $do_import_expense = new DataObject($GLOBALS['conx']); $do_import_expense->setTable("expense_import"); $do_import_expense->query("select * from expense_import order by debit_date desc limit 1"); if ($do_import_expense->getNumRows() > 0) { $do_expense = new DataObject($GLOBALS['conx']); $do_expense->setTable("expense"); $do_expense->num = $do_import_expense->idexpense_import; $do_expense->description = $do_import_expense->description; $do_expense->datepayed = $do_import_expense->debit_date; $do_expense->daterecieve = $do_import_expense->debit_date; $do_expense->amount = $do_import_expense->amount; $do_expense->prepareForm(); $do_expense->form->event->addEvent("accounting.import_expense_manualy", 1010); $do_expense->form->event->addParam("idexpense_import", $do_import_expense->idexpense_import); //$do_expense->form->setSubmit(""); $e_skip = new Event("accounting.import_expense_manualy"); $e_skip->addParam("idexpense_import", $do_import_expense->idexpense_import); $e_skip->addParam("doSave", "yes"); $e_skip->addParam("insertid", 1); echo $e_skip->getLink("Do not import this expense"); $do_expense->form();
/** * calculateTagSize * modified the script so only one table is now used to calculate the tag size. * Add a time parameter so more recently clicked tag have more weigth than older clicks. * */ function calculateTagSize($do_User = NULL) { $max_font = 40; $min_font = 12; $tag_weight = 20; $reference_type = $this->default_reference; $this->setLog("\n Calculating tag sizes at " . date("Y/m/d H:i:s") . " last_calculate:" . $_SESSION['last_tag_refresh']); if ($do_User == NULL) { $do_User = $_SESSION['do_User']; } $q_clicks = new DataObject(); $q_clicks->setTable("tag_click"); $q_clicks->query("SELECT tag_name, clicked FROM tag_click WHERE tag_click.iduser="******" ORDER BY clicked DESC"); $this->setLog("\n Tag click list:" . $q_clicks->getSqlQuery()); $num_tag_clicked = 0; $max_weight = 0; while ($q_clicks->next()) { $ar_tags_weight[$q_clicks->tag_name] += $tag_weight; if ($ar_tags_weight[$q_clicks->tag_name] > $max_weight) { $max_weight = $ar_tags_weight[$q_clicks->tag_name]; } $this->setLog("\n " . $q_clicks->tag_name . " at " . $q_clicks->clicked . " weight:" . $tag_weight . " tag weight:" . $ar_tags_weight[$q_clicks->tag_name]); } if ($q_clicks->getNumRows() == 0) { $q_size = new sqlQuery($this->getDbCon()); $q_size->query("DELETE FROM tag_size WHERE iduser="******"SELECT tag_name FROM tag WHERE reference_type='" . $reference_type . "' AND iduser="******" GROUP BY tag_name"); while ($this->next()) { $q_size->query("INSERT INTO tag_size (tag_name, clicks, iduser) VALUES ('" . $this->tag_name . "', 16, " . $do_User->iduser . ")"); } $q_size->free(); } if ($max_weight > 0) { $q_size = new sqlQuery($this->getDbCon()); $q_size->query("DELETE FROM tag_size WHERE iduser="******"\n Tag " . $tag_name . " size: " . $ar_tag_size[$tag_name] . " = " . $final_weight . "*(" . $max_font . "/" . $max_weight . ") = " . $max_font / ($max_weight + 1) . " -"); } $q_tags = new sqlQuery($this->getDbCon()); $this->query("SELECT tag_name FROM tag WHERE reference_type='" . $reference_type . "' AND iduser="******" GROUP BY tag_name"); while ($this->next()) { if (isset($ar_tag_size[$this->tag_name])) { $tag_size = $ar_tag_size[$this->tag_name]; } else { $tag_size = $min_font; } $q_size->query("INSERT INTO tag_size (tag_name, clicks, iduser) VALUES ('" . $this->tag_name . "', " . $tag_size . ", " . $do_User->iduser . ")"); } $q_size->free(); } $q_clicks->query("DELETE FROM tag_click WHERE iduser="******" AND clicked < date_sub(now(), interval 1 month)"); $q_clicks->free(); }
<?php /** * import expense manualy * Check if the expense is inserted * and delete the entry in the import_export */ $insertid = $this->getParam("insertid"); $doSave = $this->getParam("doSave"); $idexpense_import = $this->getParam("idexpense_import"); $this->setLogRun(true); $this->setLog("\n Delete expense from expense_import, doSave:" . $doSave . " - " . $insertid); if ($doSave == "yes" && $insertid > 0) { $do_import_expense = new DataObject($this->getDbCon()); $do_import_expense->setLogRun(true); $do_import_expense->setTable("expense_import"); $do_import_expense->getId($idexpense_import); $do_import_expense->delete(); } $this->setLogRun(false);
<?php /** * Accounting import expenses from wellsfargo * */ $this->setLog(true); $this->setLog("\n Importing: expenses 2008"); $goto = $this->getParam("goto"); $import_file = $this->getParam("import_file"); if (empty($import_file)) { $import_file = "import/expenses_2009.csv"; } $do_expense_import = new DataObject($this->getDbCon()); $do_expense_import->setTable("expense_import"); // amount Float Number (Float) // category One Line text // debit_date Date (SQL) // description One Line text // idexpense_import Simple Number (Integer) // payment_method One Line text function format_sql_date($sheet_date) { list($month, $day, $year) = explode("/", $sheet_date); return "20" . $year . "-" . $month . "-" . $day; } function money2float($money_string) { $money_float = str_replace("\$", "", $money_string); $money_float = str_replace(",", "", $money_float); return $money_float;