function deletecampaign_post() {
      $campaign_id = $this->post('campaign_id');
      if ($campaign_id) {
        $this->asteriskDB->select('campaign_id');
        $this->asteriskDB->where('campaign_id', $campaign_id);
        $query = $this->asteriskDB->get('vicidial_campaigns');
        if($query->num_rows() > 0) {
          $campaigns = $campaign_id;

          // From godial - begin

          // Deleting Remote Agents/Users by [email protected]
          $query = $this->asteriskDB->query("SELECT user_start,number_of_lines FROM vicidial_remote_agents WHERE campaign_id='$campaign_id'");
          $row=$query->row();
          $user_start=$row->user_start;
          $number_of_lines=$row->number_of_lines;

          $query = $this->asteriskDB->query("DELETE FROM vicidial_users WHERE user_level='4' AND user='$user_start';");


          $query = $this->asteriskDB->query("DELETE FROM vicidial_campaigns WHERE campaign_id IN ('$campaigns')");
          $query = $this->asteriskDB->query("DELETE FROM vicidial_campaign_agents WHERE campaign_id IN ('$campaigns')");
          $query = $this->asteriskDB->query("DELETE FROM vicidial_campaign_stats WHERE campaign_id IN ('$campaigns')");
          $query = $this->asteriskDB->query("DELETE FROM vicidial_remote_agents WHERE campaign_id IN ('$campaigns')");
          $query = $this->asteriskDB->query("DELETE FROM vicidial_live_agents WHERE campaign_id IN ('$campaigns')");
          $query = $this->asteriskDB->query("DELETE FROM vicidial_campaign_statuses WHERE campaign_id IN ('$campaigns')");
          $query = $this->asteriskDB->query("DELETE FROM vicidial_campaign_hotkeys WHERE campaign_id IN ('$campaigns')");
          $query = $this->asteriskDB->query("DELETE FROM vicidial_callbacks WHERE campaign_id IN ('$campaigns')");
          $query = $this->asteriskDB->query("DELETE FROM vicidial_lead_recycle WHERE campaign_id IN ('$campaigns')");
          $query = $this->asteriskDB->query("DELETE FROM vicidial_campaign_server_stats WHERE campaign_id IN ('$campaigns')");
          $query = $this->asteriskDB->query("DELETE FROM vicidial_server_trunks WHERE campaign_id IN ('$campaigns')");
          $query = $this->asteriskDB->query("DELETE FROM vicidial_pause_codes WHERE campaign_id IN ('$campaigns')");
          $query = $this->asteriskDB->query("DELETE FROM vicidial_campaigns_list_mix WHERE campaign_id IN ('$campaigns')");
          $query = $this->asteriskDB->query("DELETE FROM vicidial_xfer_presets WHERE campaign_id IN ('$campaigns')");
$query = $this->asteriskDB->query("DELETE FROM vicidial_hopper WHERE campaign_id IN ('$campaigns')");
          $query = $this->asteriskDB->query("SELECT menu_id,did_pattern FROM vicidial_inbound_dids WHERE campaign_id='$campaign_id'");
          $menu_id = $query->row()->menu_id;
          $did_pattern = $query->row()->did_pattern;
          if ($menu_id != '')
          {
            $query = $this->asteriskDB->query("DELETE FROM vicidial_call_menu WHERE menu_id = '$menu_id'");
          }
          $query = $this->asteriskDB->query("DELETE FROM vicidial_inbound_dids WHERE campaign_id='$campaign_id'");
          $query = $this->asteriskDB->query("DELETE FROM vicidial_inbound_groups WHERE group_id='ING".$did_pattern."'");

          $query = $this->asteriskDB->query("SELECT list_id FROM vicidial_lists WHERE campaign_id IN ('$campaigns')");
          foreach ($query->result() AS $list_id)
          {
            $lquery = $this->asteriskDB->query("SELECT count(*) AS leads FROM vicidial_list WHERE list_id='".$list_id->list_id."'");
            $lead_cnt = $lquery->row()->leads;
            $dquerylist = $this->asteriskDB->query("DELETE FROM vicidial_list WHERE list_id='".$list_id->list_id."'");

          }
          $dquery = $this->asteriskDB->query("DELETE FROM vicidial_lists WHERE list_id='".$list_id->list_id."'");
          // From godial - end


          $this->response(array('status' => SUCCESS_MSG), 200);
        } else {
          $this->response(array('status' => RECORD_NOT_FOUND, 'error' => 'Record not found'), 400);
        }
      } else {
        $this->response(array('status' => INVALID_PARAMETERS, 'error' => 'Invalid parameters'), 400);
      }
    }


function deletecampaigns_post() {
      $campaign_ids = $this->post('campaign_ids');

      if (!$campaign_ids) {
        $this->response(array('status' => INVALID_PARAMETERS, 'error' => 'Invalid parameters'), 400);
        return;
      }
      $campaings_list = explode(',', $campaign_ids);
      $campaigns_list_size = count($campaings_list);
      $campaigns = $campaign_ids;
      $campaign_id = $campaings_list[0];

      if ($campaigns_list_size > 0) {

        $query = $this->asteriskDB->query("DELETE FROM vicidial_campaigns WHERE campaign_id IN (" . $campaigns . ")");
        $query = $this->asteriskDB->query("DELETE FROM vicidial_campaign_agents WHERE campaign_id IN (" . $campaigns . ")");
        $query = $this->asteriskDB->query("DELETE FROM vicidial_campaign_stats WHERE campaign_id IN (" . $campaigns . ")");
        $query = $this->asteriskDB->query("DELETE FROM vicidial_remote_agents WHERE campaign_id IN (" . $campaigns . ")");
        $query = $this->asteriskDB->query("DELETE FROM vicidial_live_agents WHERE campaign_id IN (" . $campaigns . ")");
        $query = $this->asteriskDB->query("DELETE FROM vicidial_campaign_statuses WHERE campaign_id IN (" . $campaigns . ")");
        $query = $this->asteriskDB->query("DELETE FROM vicidial_campaign_hotkeys WHERE campaign_id IN (" . $campaigns . ")");
        $query = $this->asteriskDB->query("DELETE FROM vicidial_callbacks WHERE campaign_id IN (" . $campaigns . ")");
        $query = $this->asteriskDB->query("DELETE FROM vicidial_lead_recycle WHERE campaign_id IN (" . $campaigns . ")");
        $query = $this->asteriskDB->query("DELETE FROM vicidial_campaign_server_stats WHERE campaign_id IN (" . $campaigns . ")");
        $query = $this->asteriskDB->query("DELETE FROM vicidial_server_trunks WHERE campaign_id IN (" . $campaigns . ")");
        $query = $this->asteriskDB->query("DELETE FROM vicidial_pause_codes WHERE campaign_id IN (" . $campaigns . ")");
        $query = $this->asteriskDB->query("DELETE FROM vicidial_campaigns_list_mix WHERE campaign_id IN (" . $campaigns . ")");
        $query = $this->asteriskDB->query("DELETE FROM vicidial_xfer_presets WHERE campaign_id IN (" . $campaigns . ")");
        $query = $this->asteriskDB->query("DELETE FROM vicidial_xfer_stats WHERE campaign_id IN (" . $campaigns . ")");
        $query = $this->asteriskDB->query("DELETE FROM vicidial_hopper WHERE campaign_id IN (" . $campaigns . ")");
        $query = $this->asteriskDB->query("SELECT menu_id,did_pattern FROM vicidial_inbound_dids WHERE campaign_id='$campaign_id'");
        $menu_id = $query->row()->menu_id;
        $did_pattern = $query->row()->did_pattern;
        if ($menu_id != '')
        {
          $query = $this->asteriskDB->query("DELETE FROM vicidial_call_menu WHERE menu_id = '$menu_id'");
        }
$query = $this->asteriskDB->query("DELETE FROM vicidial_inbound_dids WHERE campaign_id='$campaign_id'");
        $query = $this->asteriskDB->query("DELETE FROM vicidial_inbound_groups WHERE group_id='ING".$did_pattern."'");

        $query = $this->asteriskDB->query("SELECT list_id FROM vicidial_lists WHERE campaign_id IN (" . $campaigns . ")");
        foreach ($query->result() AS $list_id)
        {
          $lquery = $this->asteriskDB->query("SELECT count(*) AS leads FROM vicidial_list WHERE list_id='".$list_id->list_id."'");
          $lead_cnt = $lquery->row()->leads;
          $dquerylist = $this->asteriskDB->query("DELETE FROM vicidial_list WHERE list_id='".$list_id->list_id."'");

        }
        $dquery = $this->asteriskDB->query("DELETE FROM vicidial_lists WHERE list_id='".$list_id->list_id."'");
          // From godial - end


          $this->response(array('status' => SUCCESS_MSG, 'camapigns' => $campaigns), 200);
        } else {
          $this->response(array('status' => RECORD_NOT_FOUND, 'error' => 'Record not found'), 400);
        }

    }