public function __construct(UserService $userService)
{
$this->columnModel = array(array('label' => 'ID', 'width' => 100, 'table' => 'platform', 'id' => 'id', 'queryParamField' => true), array('label' => 'Name', 'width' => 250, 'table' => 'platform', 'id' => 'platform_name', 'edittype' => 'text', 'editable' => true, 'queryParamField' => true), array('label' => 'Api URL', 'width' => 250, 'table' => 'platform', 'id' => 'api_url', 'edittype' => 'text', 'editable' => true, 'queryParamField' => true), array('label' => 'Api Username', 'width' => 250, 'table' => "platform", 'id' => 'api_username', 'edittype' => 'text', 'editable' => true, 'queryParamField' => true), array('label' => 'Api Password', 'width' => 250, 'table' => 'platform', 'id' => 'api_password', 'edittype' => 'text', 'editable' => true, 'queryParamField' => true));
$this->url = route('platform-api');
$this->connectionName = 'ott';
$this->customNavButtons = array('deleteRow', 'exportCsv', 'changePassword');
parent::__construct($userService);
$this->grid->setSortName('id')->setMultiselect(true)->setSortOrder('DESC')->setInlineNavOptions(['addParams' => ['position' => "last", 'restoreAfterError' => false, 'addRowParams' => ['successfunc' => new Expr('
function(response){
if(response.responseJSON.success){
toastr.success("Platform updated");
jQuery("' . $this->grid->getGridIdentifier() . '").trigger("reloadGrid");
} else {
jQuery.each(jQuery.parseJSON(response.responseJSON.message), function( index, value ) {
toastr.error(value);
});
return false;
}
}
')]], 'editParams' => ['restoreAfterError' => false, 'successfunc' => new Expr('
function(response){
if(response.responseJSON.success){
toastr.success("Platform updated");
jQuery("' . $this->grid->getGridIdentifier() . '").trigger("reloadGrid");
} else {
jQuery.each(jQuery.parseJSON(response.responseJSON.message), function( index, value ) {
toastr.error(value);
});
return false;
}
}
')]])->setEditUrl($this->url);
}
public function __construct(UserService $userService)
{
$this->columnModel = array(array('label' => 'ID', 'width' => 100, 'table' => 'user', 'id' => 'id', 'queryParamField' => true), array('label' => 'First Name', 'width' => 100, 'table' => 'user', 'id' => 'first_name', 'edittype' => 'text', 'editable' => true, 'queryParamField' => true), array('label' => 'Last Name', 'width' => 100, 'table' => 'user', 'id' => 'last_name', 'edittype' => 'text', 'editable' => true, 'queryParamField' => true), array('label' => 'Email', 'width' => 100, 'table' => 'user', 'id' => 'email', 'edittype' => 'text', 'editable' => true, 'queryParamField' => true), array('label' => 'Company Name', 'width' => 100, 'table' => 'user', 'id' => 'company_name', 'edittype' => 'text', 'editable' => true, 'queryParamField' => true), array('label' => 'Is Admin', 'width' => 100, 'table' => 'user', 'id' => 'is_admin', 'editable' => true, 'edittype' => 'checkbox', 'editvalues' => '1:0'), array('label' => 'Campaigns', 'width' => 400, 'table' => 'campaign', 'id' => 'campaigns', 'alias' => 'campaigns', 'editable' => true, 'edittype' => 'multiselect', 'editvalues' => $userService->getSpotCampaignIdsForSelectFilter()), array('label' => 'Reports', 'width' => 400, 'table' => 'section', 'id' => 'sections', 'alias' => 'sections', 'editable' => true, 'edittype' => 'multiselect', 'editvalues' => $userService->getSections()), array('label' => 'Fields', 'width' => 400, 'table' => 'scolumn', 'id' => 'scolumns', 'alias' => 'scolumns', 'editable' => true, 'edittype' => 'multiselect', 'editvalues' => $userService->getSColumns()), array('label' => 'Api Key', 'width' => 300, 'table' => 'api_keys', 'id' => 'key', 'edittype' => 'text', 'editable' => true, 'queryParamField' => true), array('label' => 'Allowed IP Range', 'width' => 300, 'table' => 'user', 'id' => 'allowed_ip_range', 'edittype' => 'text', 'editable' => true));
$this->url = route('user-api');
$this->connectionName = 'ott';
$this->customNavButtons = array('deleteRow', 'exportCsv', 'changePassword', 'createApiKey');
parent::__construct($userService);
$this->grid->setSortName('id')->setMultiselect(true)->setSortOrder('DESC')->setInlineNavOptions(['addParams' => ['position' => "last", 'restoreAfterError' => false, 'addRowParams' => ['successfunc' => new Expr('
function(response){
if(response.responseJSON.success){
toastr.success("User updated");
jQuery("' . $this->grid->getGridIdentifier() . '").trigger("reloadGrid");
} else {
jQuery.each(jQuery.parseJSON(response.responseJSON.message), function( index, value ) {
toastr.error(value);
});
return false;
}
}
')]], 'editParams' => ['restoreAfterError' => false, 'successfunc' => new Expr('
function(response){
if(response.responseJSON.success){
toastr.success("User updated");
jQuery("' . $this->grid->getGridIdentifier() . '").trigger("reloadGrid");
} else {
jQuery.each(jQuery.parseJSON(response.responseJSON.message), function( index, value ) {
toastr.error(value);
});
return false;
}
}
')]])->setEditUrl($this->url);
}
public function __construct(UserService $userService)
{
$this->columnModel = array(array('label' => 'Country', 'width' => 200, 'table' => 'country', 'alias' => 'country', 'id' => 'name', 'defaultValue' => null, 'searchType' => 'select', 'svalues' => $userService->getCountryListForSelectFilter()), array('label' => 'Leads', 'width' => 200, 'table' => 'clients', 'type' => 'raw', 'alias' => 'leads', 'rawValue' => 'COUNT(clients.id)', 'id' => 'lead'), array('label' => 'Customers', 'width' => 200, 'table' => 'clients', 'type' => 'raw', 'alias' => 'customers', 'rawValue' => 'COUNT(clients.id) - SUM(clients.islead)', 'id' => 'customers'), array('label' => 'Deposits Count', 'width' => 200, 'table' => 'deposits', 'type' => 'raw', 'alias' => 'dcount', 'rawValue' => 'COALESCE(deposits.dcount, 0)', 'id' => 'dcount'), array('label' => 'Deposits Amount', 'width' => 200, 'table' => 'deposits', 'type' => 'raw', 'alias' => 'damount', 'rawValue' => 'COALESCE(deposits.damount, 0)', 'id' => 'damount'), array('label' => 'FTD', 'width' => 200, 'table' => 'deposits', 'type' => 'raw', 'alias' => 'FTD', 'rawValue' => 'COALESCE(deposits.FTD, 0)', 'id' => 'FTD'));
$this->rawQueryParamFields = array(array('field' => 'campaigns', 'type' => 'multiselect', 'sort' => false, 'queryOp' => 'inclusive', 'dbField' => 'customers.campaignId'), array('field' => 'country', 'type' => 'multiselect', 'sort' => true, 'queryOp' => 'inclusive', 'dbField' => 'customers.Country'), array('field' => 'dateRange', 'type' => 'dateRange', 'defaultValue' => Json::encode(array('start' => date(Config::get('app.dateformat')), 'end' => date(Config::get('app.dateformat')))), 'sort' => false));
$this->url = route('country-api');
$this->connectionName = 'so_rep';
$this->sortname = 'damount';
$this->postDataFields = array('campaigns' => new Expr("jQuery('#'+'%field%').val();"), 'dateRange' => new Expr("JSON.stringify(\$('#'+'%field%').daterangepicker('getRange'));"));
$this->customNavButtons = array('exportCsv');
parent::__construct($userService);
}
public function __construct(UserService $userService, CampaignService $campaignService)
{
$this->columnModel = array(array('label' => 'Campaigns', 'width' => 300, 'table' => 'campaign', 'id' => 'name', 'alias' => 'campaigns', 'searchType' => 'select', 'svalues' => $userService->getCampaignListForSelectFilter()), array('label' => 'Country', 'width' => 300, 'table' => 'campaign_country', 'id' => 'id', 'alias' => 'country', 'searchType' => 'select', 'svalues' => $userService->getCountryListForMultiSelectFilter(), 'editable' => true, 'edittype' => 'multiselect', 'editvalues' => $userService->getCountryIdsForSelectFilter()), array('label' => 'Platform', 'width' => 300, 'table' => 'campaign_platform', 'alias' => 'platforms', 'id' => 'platform_id', 'searchType' => 'select', 'svalues' => $userService->getPlatformListForSelectFilter(), 'editable' => true, 'edittype' => 'multifind', 'editvalues' => $userService->getPlatformIdsForSelectFilter(), 'multiple' => false, 'type' => 'select'));
$this->rawQueryParamFields = array(array('field' => 'campaigns', 'type' => 'multiselect', 'sort' => false, 'queryOp' => 'inclusive', 'dbField' => 'campaign.id'), array('field' => 'country', 'type' => 'multiselect', 'sort' => false, 'queryOp' => 'inclusive', 'dbField' => 'campaign_country.country_id'), array('field' => 'platforms', 'type' => 'multiselect', 'sort' => false, 'queryOp' => 'inclusive', 'dbField' => 'campaign_platform.platform_id'));
$this->url = route('campaign-api');
$this->connectionName = 'ott';
$this->customNavButtons = array('exportCsv');
parent::__construct($userService);
$this->grid->setSortName('id')->setMultiselect(true)->setSortOrder('ASC')->setInlineNavOptions(['editParams' => ['restoreAfterError' => false, 'successfunc' => new Expr('
function(response){
if(response.responseJSON.success){
toastr.success("Campaign updated");
jQuery("' . $this->grid->getGridIdentifier() . '").trigger("reloadGrid");
} else {
jQuery.each(jQuery.parseJSON(response.responseJSON.message), function( index, value ) {
toastr.error(value);
});
return false;
}
}
')]])->setEditUrl($this->url);
}