/** * 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; }