public function insertPoolingSchedule($contact_id, $member_id, $template_id)
{
$contactTarget = Contact::find($contact_id);
$memberTarget = User::find($member_id);
$templateTarget = EmailTemplate::where('sequence', $template_id)->first();
// return $templateTarget->id;
if (!$contactTarget || !$memberTarget || !$templateTarget) {
return null;
}
$stag = new EmailSchedullerPool();
$stag->contact_id = $contact_id;
$stag->member_id = $member_id;
$stag->template_id = $template_id;
// $configurationMember = MemberConfiguration::where('member_id',$member_id)->where('param_code',MemberConfiguration::FOLLOW_UP_SEQUENCE)->first();
// if(!$configurationMember){
// return null ;
// }
// $followUpSequence = $configurationMember->param_value;
$followUpSequence = Sysparam::getValue('conf_follow_up_date');
$stag->execution_date = date('Y-m-d H:i:s', strtotime("+" . $followUpSequence . " day"));
$emailSchedullerPool = EmailSchedullerPool::where('member_id', $member_id)->where('contact_id', $contact_id)->where('template_id', $template_id)->first();
if ($emailSchedullerPool) {
//save history
$this->saveHistory("canceled", $emailSchedullerPool->member_id, $emailSchedullerPool->template_id);
//delete pool
$emailSchedullerPool->delete();
}
//add entry
if ($contactTarget->active && $memberTarget->active) {
$stag->save();
return $stag->toJson();
} else {
return null;
}
}
public function getTargetEmails()
{
$polls = EmailSchedullerPool::where(DB::raw('DAY(execution_date)'), '=', date('d'))->get();
return $polls;
}
