/**
* Remove the specified resource from storage.
*
* @param int $request
* @return Response
*/
public function destroy(Request $request)
{
$rule_secret = $request->route('rule_secret', '');
$hash = Input::get('hash', '');
$calculated_hash = md5($rule_secret . env('HASH_SALT'));
if ($hash != $calculated_hash) {
$data['error'] = 'true';
$data['message'] = Config::get('constant.api_error.012');
return $data;
}
$deletedRows = App\RuleMaster::where('rule_secret', $rule_secret)->delete();
$data['message'] = Config::get('constant.general.004');
return $data;
}
public function getValidRules($input_rule_array = '', $client_id = '', $user_profile = '')
{
if ($input_rule_array == '' || $client_id == '' || $user_profile == '') {
return '';
}
if ($user_profile == 1) {
$objRules = App\RuleMaster::where('rule_master.status', 1)->join('rule_engine_database_master', 'rule_master.database_id', '=', 'rule_engine_database_master.database_id')->whereIn('rule_master.rule_secret', $input_rule_array)->select('rule_master.rule_name', 'rule_master.rule_secret', 'rule_master.aggregate_rule', 'rule_engine_database_master.database_name')->get();
} else {
if ($user_profile == 3) {
$objRules = App\RuleMaster::where('rule_master.status', 1)->join('rule_engine_database_master', 'rule_master.database_id', '=', 'rule_engine_database_master.database_id')->where(function ($query) use($client_id) {
$query->where('rule_master.globally_enabled', 1)->orWhere('rule_master.all_employee', 1)->orWhere('rule_master.client_id', $client_id);
})->whereIn('rule_master.rule_secret', $input_rule_array)->select('rule_master.rule_name', 'rule_master.rule_secret', 'rule_master.aggregate_rule', 'rule_engine_database_master.database_name')->get();
} else {
if ($user_profile == 4) {
$objRules = App\RuleMaster::where('rule_master.status', 1)->join('rule_engine_database_master', 'rule_master.database_id', '=', 'rule_engine_database_master.database_id')->where(function ($query) use($client_id) {
$query->where('rule_master.globally_enabled', 1)->orWhere('rule_master.all_merchant', 1)->orWhere('rule_master.client_id', $client_id);
})->whereIn('rule_master.rule_secret', $input_rule_array)->select('rule_master.rule_name', 'rule_master.rule_secret', 'rule_master.aggregate_rule', 'rule_engine_database_master.database_name')->get();
}
}
}
$data = $objRules->toArray();
return $data;
}
