/**
* eventApplyFilter
* This event check process all the imported expenses and based on their description
* categorize them and set the proper suplier.
* Then it insert it into Expense table and delete it from the ExpenseImport.
*/
public function eventApplyFilters(EventControler $evctl)
{
$this->getUserAll();
$do_expense = new Expense();
while ($this->next()) {
$account = 0;
$suplier = 0;
if ($this->category == "Airlines / Transportation") {
$account = 16;
}
if ($this->category == "ATM Withdrawals") {
$account = 44;
}
if ($this->category == "Auto / Gas") {
$account = 5;
}
if ($this->category == "Building Supply / Wholesale") {
$account = 13;
}
if ($this->category == "Entertainment") {
$account = 21;
}
if ($this->category == "Groceries") {
$account = 47;
}
if ($this->category == "Insurance / Financial Services") {
$account = 23;
}
if ($this->category == "Office Supply / Stationery") {
$account = 15;
}
if ($this->category == "Postage / Delivery") {
$account = 33;
}
if ($this->category == "Restaurants") {
$account = 4;
}
if ($this->category == "Utilities / Telecom") {
$account = 14;
}
if (preg_match("/DIRECTNIC COM/", $this->description)) {
$account = 49;
$suplier = 32;
}
if (preg_match("/GANDI/i", $this->description)) {
$account = 49;
$suplier = 48;
}
if (preg_match("/THAWTE INC/i", $this->description)) {
$account = 49;
$suplier = 47;
}
if (preg_match("/GEOTRUST/i", $this->description)) {
$account = 49;
$suplier = 27;
}
if (preg_match("/BANKCARD/i", $this->description)) {
$account = 17;
$suplier = 39;
}
if (preg_match("/FXOL FGN/i", $this->description)) {
$account = 17;
$suplier = 39;
}
if (preg_match("/MEMBERSHIP FEE/i", $this->description)) {
$account = 17;
$suplier = 39;
}
if (preg_match("/ADP TX/i", $this->description)) {
$account = 26;
$suplier = 30;
}
if (preg_match("/Arctern/i", $this->description)) {
$account = 42;
$suplier = 8;
}
if (preg_match("/INR AT/i", $this->description)) {
$account = 42;
$suplier = 71;
}
if (preg_match("/WORD LIONS/i", $this->description)) {
$account = 9;
$suplier = 73;
}
if (preg_match("/NETFLIX/i", $this->description)) {
$account = 23;
$suplier = 18;
}
if (preg_match("/BLUE SHIELD/i", $this->description)) {
$account = 43;
$suplier = 4;
}
if (preg_match("/KAIZER/i", $this->description)) {
$account = 43;
$suplier = 51;
}
if (preg_match("/NET2EZ/i", $this->description)) {
$account = 3;
$suplier = 19;
}
if (preg_match("/FRY\\'S/i", $this->description)) {
$account = 13;
$suplier = 28;
}
if (preg_match("/YAHOO SEARCH/i", $this->description)) {
$account = 10;
$suplier = 37;
}
if (preg_match("/CISLO/i", $this->description)) {
$account = 11;
$suplier = 2;
}
if (preg_match("/VERIZON/i", $this->description)) {
$account = 14;
$suplier = 38;
}
if (preg_match("/CINGULAR/i", $this->description) || preg_match("/at\\&t/i", $this->description) || preg_match("/IPHONE/i", $this->description)) {
$account = 14;
$suplier = 7;
}
if (preg_match("/CALLCENTRIC/i", $this->description)) {
$account = 3;
$suplier = 107;
}
if (preg_match("/SIPPHONE/i", $this->description) || preg_match("/GIZMO/i", $this->description)) {
$account = 14;
$suplier = 26;
}
if (preg_match("/ADWS/i", $this->description)) {
$account = 10;
$suplier = 26;
}
if (preg_match("/AMZN PMTS/i", $this->description) || preg_match("/Amazon Payments/i", $this->description)) {
$account = 3;
$suplier = 11;
}
if (preg_match("/OFFICE DEPOT/i", $this->description)) {
$account = 15;
$suplier = 52;
}
if (preg_match("/OFFICE MAX/i", $this->description)) {
$account = 15;
$suplier = 72;
}
if (preg_match("/STAPLES/i", $this->description)) {
$account = 15;
$suplier = 13;
}
if (preg_match("/WEBEX/i", $this->description)) {
$account = 50;
$suplier = 40;
}
if (preg_match("/PAYCYCLE/i", $this->description)) {
$account = 11;
$suplier = 16;
}
if (preg_match("/INTUIT/i", $this->description)) {
$account = 50;
$suplier = 16;
}
if (preg_match("/EXPERTPAY/i", $this->description)) {
$account = 46;
}
if (preg_match("/PAYROLL/i", $this->description)) {
$account = 46;
}
if (preg_match("/USATAXPYMT/i", $this->description)) {
$account = 26;
$suplier = 30;
}
if (preg_match("/Tax/i", $this->description)) {
$account = 8;
$suplier = 30;
}
if (preg_match("/GRAND CASINO/i", $this->description)) {
$account = 4;
$suplier = 113;
}
if (preg_match("/IN-N-OUT/i", $this->description)) {
$account = 4;
$suplier = 14;
}
if (preg_match("/STARBUCKS/i", $this->description)) {
$account = 4;
$suplier = 14;
}
if (preg_match("/SAFARIBOOKSONL/i", $this->description)) {
$account = 21;
$suplier = 67;
}
if (preg_match("/BEST BUY/i", $this->description)) {
$account = 13;
$suplier = 5;
}
if (preg_match("/LAW OFFICES/i", $this->description)) {
$account = 11;
$suplier = 68;
}
if (preg_match("/CA BOE/i", $this->description)) {
$account = 8;
$suplier = 53;
}
if (preg_match("/TRAFFICSWARM/i", $this->description)) {
$account = 50;
$suplier = 69;
}
if (preg_match("/DELL/i", $this->description)) {
$account = 13;
$suplier = 34;
}
if (preg_match("/T\\-MOBILE/i", $this->description)) {
$account = 14;
$suplier = 45;
}
if (preg_match("/Amazon Prime/i", $this->description)) {
$account = 23;
$suplier = 10;
}
if (preg_match("/FRONTIER/i", $this->description)) {
$account = 16;
$suplier = 49;
}
if (preg_match("/YOGAGLO/i", $this->description)) {
$account = 50;
$suplier = 50;
}
if (preg_match("/SNCF/i", $this->description)) {
$account = 47;
$suplier = 70;
}
if (preg_match("/ITUNES/i", $this->description)) {
$account = 12;
$suplier = 9;
}
if ($account != 0) {
$do_expense->newRecord();
$do_expense->num = $this->idexpense_import;
$do_expense->description = $this->description;
$do_expense->date_paid = $this->debit_date;
$do_expense->date_receive = $this->debit_date;
$do_expense->amount = $this->amount;
$do_expense->iduser = $_SESSION['do_User']->iduser;
$do_expense->idledger_account = $account;
if ($suplier != 0) {
$do_expense->idsuplier = $suplier;
}
$do_expense->add();
$this->delete();
}
}
$disp = new Display($evctl->goto);
$disp->addParam("message", "Import completed");
$evctl->setDisplayNext($disp);
}
