public static function loadLatestDebtRecovery($user_id, $year, $month) { foreach (Model_Debit_Date::all() as $debit_date) { if (!is_numeric($month) || !in_array(intval($month), range(1, 12))) { $month = intval(date('m')); } if (!is_numeric($year) || intval($year) < 2015) { $year = intval(date('Y')); } $debt_recovery = Model_Debt_Recovery::find_by_debit_date_id_and_year_and_month($debit_date->id, $year, $month); if (is_null($debt_recovery)) { $debt_recovery = Model_Debt_Recovery::create(array('debit_date_id' => $debit_date->id, 'year' => intval($year), 'month' => intval($month), 'user_id' => $user_id)); if (is_null($debt_recovery)) { continue; } } // sms template try { $debt_recovery->sms_template_id = Model_Message_Template::find_by_key('debt_manager.recovery.sms')->id; $debt_recovery->save(); } catch (Exception $ex) { echo $ex->getMessage(); } // email template try { $debt_recovery->email_template_id = Model_Message_Template::find_by_key('debt_manager.recovery.email')->id; $debt_recovery->save(); } catch (Exception $ex) { echo $ex->getMessage(); } } }
</td> <td><?php echo $debt->get_customer()->custcellno; ?> </td> <td><?php echo $debt->get_customer()->custemail; ?> </td> <td><?php echo $date_picker->get_date(); ?> </td> <td> <?php $debit_date = Model_Debit_Date::find_by_id($debt->debt_recovery_id); echo $debit_date != null ? $debit_date->debit_date_description : ''; ?> </td> <td>R <?php echo number_format($debt->amount_due, 2); ?> </td> <td align="center"> <?php $onclick = 'window.open("admin-debt-recovery-messages.php?debt_id=' . $debt->id . '", "_blank", "toolbar=no, scrollbars=yes, resizable=yes, top=200, left=200, width=800, height=600");'; ?> <a href="#" onclick='<?php echo $onclick; ?> '>View Messages</a>