<?php if(!defined('BASEPATH')) exit('No direct script access allowed'); class Cron_auto_pause_campaign_done extends Cron_Controller { function __construct() { // Call the Model constructor parent::__construct(); $this->load->model(MODEL_PATH . 'ex_campaign_startup_model'); $this->load->library(LIBRARY_PATH . 'obmail'); $this->load->helper('array'); } public function index() { $clients = $this->db->select('mu.user_id, CONCAT(mu.firstname, \' \', mu.lastname) AS client_name, mu.email_address, mu.last_login, cp.id AS campaign_id, cp.campaign AS campaign_name, el.lead_count AS lead_count, cp.excs_id', FALSE) ->join('client_postjob AS cp', 'cp.user_id = mu.user_id') ->join('ex_campaign_startup AS ecs', 'cp.excs_id = ecs.id') ->join('ex_leads AS el', 'cp.excs_id = el.excs_id') ->where('cp.dialer_status <>', 'R') ->get('main_users AS mu') ->result_array(); $details = $this->ex_campaign_startup_model->campaign_leads_details(46); echo "<pre>"; print_r($clients); echo "<pre>"; echo "<pre>"; print_r($details); echo "<pre>"; } }