taleeb35

public function mail() {
       $NewDate=Date('y:m:d', strtotime("+2 days"));
    
       $emails = $this->Issue->find('list',array(
           'conditions' => array('Issue.date_target' => $NewDate),
           'fields' => array('Issue.owner_id')
       ));
       
       //foreach($emails as $email):
     

taleeb35

 public function copy_daily() {
 
        $users = $this->User->find('all');
        $current_date = Date("Y-m-d H:i:s");
        $email_date = Date("Y-m-d",  strtotime($current_date));
                   
        foreach ($users as $user):
            $user_email = $user['User']['email'];
            $user_id = $user['User']['id'];

taleeb35

$email_body = "<table width='800px' cellspacing='0' cellpadding='5' border='1' style='border-collapse: collapse;'>"
                            . "<tr><th>ID</th> <th>Task Name</th> <th>Assigned Date</th> <th>Action</th> </tr>";

$task_view_link = "<a href=" . APP_URL . "/issues/view/" . $issue_id . ">" . $task_name . "</a>";
                $close_issue = "<a href=" . APP_URL  . "/issues/email_close_issue/" . $issue_id . "/" . $issue_close_string . ">Close Task</a>";
                $email_body .= "<tr><td>" . $issue_id . " </td><td>" .  $task_view_link . "</td><td>" . $target_email_date . "</td><td>" . $close_issue . "</td></tr>";

$email_body .="</table>";

taleeb35

$email_body = '<table width="800px" cellspacing="0" cellpadding="5" border="1" style="border-collapse: collapse;">'
   	                     . '<tr><th>ID</th> <th>Task Name</th> <th>Assigned Date</th> <th>Action</th> </tr>';

$task_view_link = '<a href="' . APP_URL . '/issues/view/' . $issue_id . '">' . $task_name . '</a>';
                $close_issue = '<a href="' . APP_URL  . '/issues/email_close_issue/' . $issue_id . '/' . $issue_close_string . '">Close Task</a>';
                $email_body .= '<tr><td>' . $issue_id . ' </td><td>' .  $task_view_link . '</td><td>' . $target_email_date . '</td><td>' . $close_issue . '</td></tr>';

$email_body .='</table>';

taleeb35

<table width="800px" cellspacing="0" cellpadding="5" border="1" style="border-collapse:collapse"><tbody><tr><th>ID</th> <th>Task Name</th> <th>Assigned Date</th> <th>Action</th> </tr><tr><td>1347 </td><td><a href="http://controls.localhost.com/issues/view/1347" target="_blank">Inventory of Authorized and Unauthorized Devices </a></td><td><span class="aBn" data-term="goog_281741611" tabindex="0"><span class="aQJ">2014-09-12</span></span></td><td><a href="http://controls.localhost.com/issues/email_close_issue/1347/5413256b-12a0-4f00-895d-10ad7f000001" target="_blank">Close Task</a></td></tr><tr><td>1348 </td><td><a href="http://controls.localhost.com/issues/view/1348" target="_blank">Test monthly control</a></td><td><span class="aBn" data-term="goog_281741612" tabindex="0"><span class="aQJ">2014-09-12</span></span></td><td><a href="http://controls.localhost.com/issues/email_close_issue/1348/5413256c-1c08-42ec-9cb0-10ad7f000001" target="_blank">Close Task</a></td></tr><tr><td>1349 </td><td><a href="http://contro

taleeb35

<?php
App::uses('AppController', 'Controller');
/**
 * Helps Controller
 *
 * @property Help $Help
 * @property PaginatorComponent $Paginator
 */
class StatesController extends AppController {
    var $helpers = array('Html','Js');

taleeb35

<?php
App::uses('AppModel', 'Model');
/**
 * Department Model
 *
 * @property Project $Project
 */
class Country extends AppModel {
    
    public $hasMany = array(

taleeb35

/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50173
Source Host           : localhost:3306
Source Database       : smart2

Target Server Type    : MYSQL
Target Server Version : 50173

taleeb35

/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50173
Source Host           : localhost:3306
Source Database       : smart2

Target Server Type    : MYSQL
Target Server Version : 50173

taleeb35

$(function() {
 
    $('#countries').change(function() {
        var selectedValue = $(this).val();
 
        var targeturl = $(this).attr('rel') + '?id=' + selectedValue;
        $.ajax({
            type: 'get',
            url: targeturl,
            beforeSend: function(xhr) {