PHP Category::findWithTransactionDescription Examples

Example #1

File: Transaction.php Project: rishadomar/ta

 public static function reCategorise()
 {
     $q = "SELECT * FROM trans WHERE category = 0";
     global $db;
     $result = $db->query($q);
     if (!$result) {
         throw new Exception('Failed fetching the data from database. Query: ' . $q);
     }
     $rows = $result->fetchAll();
     foreach ($rows as &$row) {
         $transaction = new Transaction($row[0], $row[1], $row[2], $row[3], $row[4], $row[5], $row[6]);
         echo "Considering: " . $transaction->description . "\n";
         $category = Category::findWithTransactionDescription($transaction->description);
         if ($category->getId() == 0) {
             unset($transaction);
             continue;
         }
         echo "Setting category to: " . $category->getName() . " for transaction " . $transaction->toString() . "\n";
         $transaction->setCategory($category);
         unset($transaction);
     }
 }