CampaignListController.php
2.15 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
<?php
namespace App\Http\Controllers;
use Auth;
use Response;
use Input;
use Config;
use Session;
use App\Http\Controllers;
use DB;
use App\Models\Group;
use App\Models\User;
use App\Jobs\KHRMSLib;
use Log;
use DateTime;
use Illuminate\Http\Request;
use App\Http\Requests;
class CampaignListController extends Controller
{
public function __construct()
{
}
//Function to enable to create Campaign List
public function createList()
{
$campaign_list = DB::table('hrms_masters')->select('mkey')->distinct()->get();
return view('layout.module.campaignlists.index',compact('campaign_list'));
}
public function storeCampaignListData()
{
$campaign_list = DB::table('hrms_masters')->select('mkey')->distinct()->get();
return view('layout.module.campaignlists.index',compact('campaign_list'));
}
public function store()
{
$campaign_list = DB::table('hrms_masters')->select('mkey')->distinct()->get();
$action=Input::get("action");
if ($action="save")
{
$list_id=Input::get("list_id");
$list_name=Input::get("list_name");
$campaign_name=Input::get("campaign_name");
$active_status=Input::get("active_status");
$ListCreated=DB::table('campaign_list')->insert(
['list_id' => $list_id,
'list_name' => $list_name,
'client' => $campaign_name,
'status' => $active_status,
'created_at'=>date("Y-m-d h:i:s"),
'modified_at'=>date("Y-m-d h:i:s")]);
}
}
public function campaignDependentList(Request $request,$campaign_name){
$campaignListData=DB::table("campaign_list")->select('list_name','status')->where("client",'=',$campaign_name)->get();
return $campaignListData;
}
public function liststatus(Request $request){
$list_name=Input::get("list_name");
$liststatus=Input::get("liststatus");
DB::table('campaign_list')->where('list_name', $list_name)->update(['status' => $liststatus]);
DB::table('records')->where('listname', $list_name)->update(['currentstatus' => $liststatus]);
return 'success';
}
}