每日归档： 2014年6月27日

#insert voucher_store_submission
INSERT INTO `voucher_store_submission` (`submission_id`, `submission_time`, `store_id`, `user_id`, `requisition_id`, `comment`, `export_cti`, `export_time`, `is_evoucher`) 
VALUES 
(NULL, '2014-06-26 00:00:00', 179292, 0, NULL, '\'E05000075\'', 'Y', NULL, 'Y'),
(NULL, '2014-06-26 00:00:00', 179368, 0, NULL, '\'E10000013\'', 'Y', NULL, 'Y');

#update voucher status
update voucher 
set submission_time = '2014-06-26 00:00:00', status_id = 7, submission_id = 1991
where voucher_id = 78505;

update voucher 
set submission_time = '2014-06-26 00:00:00', status_id = 7, submission_id = 1990
where voucher_id = 88443;

#insert action 
INSERT INTO `voucher_action` (`id`, `voucher_id`, `action_id`, `action_time`, `user_id`, `comment`, `ct_user`) 
VALUES 
(NULL, 78505, 8, '2014-06-26 00:00:00', 0, '', NULL),
(NULL, 88443, 8, '2014-06-26 00:00:00', 0, '', NULL);

在voucher_action 里添加notification_id

在notification里创建记录 填写trager和cc和role

在model/email_notifications.php 里创建notification对应的function，这个function和数据库里存储的function一致

这个function 的作用就是把调用这个function地方传递进来的$action_info传递到调用的view文件里，然后从这个view取回email_content，然后直接调用——notification_send即可

调用方法如下：

$action_info = array();
$action_info['voucher_number'] = $this->voucher_number_get_for_notification( $voucher_id );
$action_info['transaction_number'] = $this->voucher_lkup->submission_id_to_transaction_number( $submission_id );
$action_info['release_or_reject'] = 'release';
$this->load->model('email_notifications');
$this->email_notifications->action_trigger_notification( $action_id, $action_info );