Revize c478920d
Přidáno uživatelem Ondřej Fibich před asi 9 roky(ů)
application/models/email_queue.php | ||
---|---|---|
* @property string $body
|
||
* @property integer $state
|
||
* @property timestamp $access_time
|
||
* @property string $hash
|
||
*/
|
||
class Email_queue_Model extends ORM
|
||
{
|
||
... | ... | |
/**
|
||
* Unsuccessfully sent e-mail, almost same as new
|
||
*/
|
||
const STATE_FAIL = 2;
|
||
|
||
/**
|
||
* E-mail has been read by recipient
|
||
*/
|
||
const STATE_READ = 3;
|
||
const STATE_FAIL = 2;
|
||
|
||
/**
|
||
* Returns current email queue, by default 10 e-mails to send
|
||
... | ... | |
*/
|
||
public function get_current_queue($count = 10)
|
||
{
|
||
return $this
|
||
->in('state',
|
||
array(
|
||
self::STATE_NEW,
|
||
self::STATE_FAIL
|
||
)
|
||
)
|
||
return $this->where('state <> ',self::STATE_OK)
|
||
->orderby('access_time')
|
||
->limit($count,0)
|
||
->find_all();
|
||
... | ... | |
$order_by = 'id', $order_by_direction = 'ASC', $filter_sql='')
|
||
{
|
||
// args
|
||
$args = array(Contact_Model::TYPE_EMAIL, Contact_Model::TYPE_EMAIL, self::STATE_OK, self::STATE_READ);
|
||
$args = array(Contact_Model::TYPE_EMAIL, Contact_Model::TYPE_EMAIL, self::STATE_OK);
|
||
|
||
// sql body
|
||
$body = "SELECT eq.id, eq.from, eq.to, eq.subject, eq.state, eq.access_time,
|
||
... | ... | |
LEFT JOIN contacts tc ON eq.to = tc.value AND tc.type = ?
|
||
LEFT JOIN users_contacts tuc ON tc.id = tuc.contact_id
|
||
LEFT JOIN users tu ON tuc.user_id = tu.id
|
||
WHERE eq.state = ? OR eq.state = ? ";
|
||
WHERE eq.state = ?
|
||
GROUP BY eq.id";
|
||
|
||
// filter
|
||
if (empty($filter_sql))
|
||
{
|
||
return $this->db->query("
|
||
$body
|
||
GROUP BY eq.id
|
||
ORDER BY ".$this->db->escape_column($order_by)." $order_by_direction
|
||
LIMIT " . intval($limit_from) . "," . intval($limit_results) . "
|
||
", $args);
|
||
... | ... | |
return $this->db->query("
|
||
SELECT COUNT(*) AS total
|
||
FROM email_queues eq
|
||
WHERE eq.state = ? OR eq.state = ?
|
||
", self::STATE_OK, self::STATE_READ)->current()->total;
|
||
WHERE eq.state = ?
|
||
", self::STATE_OK)->current()->total;
|
||
}
|
||
|
||
// filter
|
||
... | ... | |
LEFT JOIN contacts tc ON eq.to = tc.value AND tc.type = ?
|
||
LEFT JOIN users_contacts tuc ON tc.id = tuc.contact_id
|
||
LEFT JOIN users tu ON tuc.user_id = tu.id
|
||
WHERE eq.state = ? OR eq.state = ?
|
||
WHERE eq.state = ?
|
||
GROUP BY eq.id
|
||
$having
|
||
", array
|
||
(
|
||
Contact_Model::TYPE_EMAIL, Contact_Model::TYPE_EMAIL,
|
||
self::STATE_OK, self::STATE_READ
|
||
self::STATE_OK
|
||
))->count();
|
||
}
|
||
|
||
... | ... | |
LEFT JOIN contacts tc ON eq.to = tc.value AND tc.type = ?
|
||
LEFT JOIN users_contacts tuc ON tc.id = tuc.contact_id
|
||
LEFT JOIN users tu ON tuc.user_id = tu.id
|
||
WHERE eq.state = ? OR eq.state = ?
|
||
WHERE eq.state = ?
|
||
GROUP BY eq.id
|
||
$having
|
||
) eq
|
||
", Contact_Model::TYPE_EMAIL, Contact_Model::TYPE_EMAIL, self::STATE_OK, self::STATE_READ);
|
||
", Contact_Model::TYPE_EMAIL, Contact_Model::TYPE_EMAIL, self::STATE_OK);
|
||
}
|
||
|
||
/**
|
||
... | ... | |
LEFT JOIN contacts tc ON eq.to = tc.value AND tc.type = ?
|
||
LEFT JOIN users_contacts tuc ON tc.id = tuc.contact_id
|
||
LEFT JOIN users tu ON tuc.user_id = tu.id
|
||
WHERE eq.state = ? OR eq.state = ?
|
||
WHERE eq.state = ?
|
||
GROUP BY eq.id
|
||
$having
|
||
", array
|
||
(
|
||
Contact_Model::TYPE_EMAIL, Contact_Model::TYPE_EMAIL,
|
||
self::STATE_OK, self::STATE_READ
|
||
self::STATE_OK
|
||
))->as_array();
|
||
|
||
$pids = array();
|
||
... | ... | |
LEFT JOIN contacts tc ON eq.to = tc.value AND tc.type = ?
|
||
LEFT JOIN users_contacts tuc ON tc.id = tuc.contact_id
|
||
LEFT JOIN users tu ON tuc.user_id = tu.id
|
||
WHERE eq.state <> ? AND eq.state <> ?
|
||
WHERE eq.state <> ?
|
||
GROUP BY eq.id
|
||
$having
|
||
ORDER BY ".$this->db->escape_column($order_by)." $order_by_direction
|
||
LIMIT " . intval($limit_from) . "," . intval($limit_results) . "
|
||
", Contact_Model::TYPE_EMAIL, Contact_Model::TYPE_EMAIL, self::STATE_OK, self::STATE_READ);
|
||
", Contact_Model::TYPE_EMAIL, Contact_Model::TYPE_EMAIL, self::STATE_OK);
|
||
}
|
||
|
||
/**
|
||
... | ... | |
return $this->db->query("
|
||
SELECT COUNT(*) AS total
|
||
FROM email_queues eq
|
||
WHERE eq.state <> ? AND eq.state <> ?
|
||
", self::STATE_OK, self::STATE_READ)->current()->total;
|
||
WHERE eq.state <> ?
|
||
", self::STATE_OK)->current()->total;
|
||
}
|
||
|
||
// filter
|
||
... | ... | |
LEFT JOIN contacts tc ON eq.to = tc.value AND tc.type = ?
|
||
LEFT JOIN users_contacts tuc ON tc.id = tuc.contact_id
|
||
LEFT JOIN users tu ON tuc.user_id = tu.id
|
||
WHERE eq.state <> ? AND eq.state <> ?
|
||
WHERE eq.state <> ?
|
||
GROUP BY eq.id
|
||
$having
|
||
", array
|
||
(
|
||
Contact_Model::TYPE_EMAIL, Contact_Model::TYPE_EMAIL,
|
||
self::STATE_OK, self::STATE_READ
|
||
self::STATE_OK
|
||
))->count();
|
||
}
|
||
|
Také k dispozici: Unified diff
Undo my stupid mistake (I have pushed issue-957 to master instead of develop). Do I have copied files from GitHub master and push them back..