public function store(Request $request, PercentageCalculator $percentageCalculator, LambdaCalculator $lambdaCalculator, DeltaCalculator $deltaCalculator)
{
$lambda = $lambdaCalculator->calculateFromQuestions($request->test['questions']);
$delta = $deltaCalculator->calculate($request->birthday, $request->studyHours);
// dd($request->test['id']);
return Result::create(['name' => $request->name, 'delta' => $delta, 'lambda' => $lambda, 'test_id' => $request->test['id']]);
}
public function run()
{
$faker = Faker\factory::create();
DB::table('results')->delete();
foreach (range(1, 5) as $index) {
Result::create(['question1' => $faker->word, 'question1_option' => $faker->word, 'question1_answer' => $faker->word, 'question1_points' => $faker->numberBetween($min = 1, $max = 100), 'secrecy' => $faker->numberBetween($min = 1, $max = 3)]);
}
}
public function postFSave(FSavePRequest $request, $user_email, $form_url)
{
$user = User::where('user_email', base64_decode($user_email))->where('user_active', '1')->firstOrFail();
$form = $user->Form()->where('form_url', $form_url)->where('form_active', 1)->firstOrFail();
if (!$form->canWrite()) {
return redirect()->back()->with('msgError', '表单已经超过填写人数的最大限制了');
}
$agent = new Agent();
$platform = $agent->platform();
$platform_v = $agent->version($platform);
$browser = $agent->browser();
$browser_v = $agent->version($browser);
$device = $agent->device();
$result = Result::create(['result_ruid' => Auth::check() ? Auth::id() : 0, 'result_form_id' => $form->form_id, 'result_ip' => ip2long($request->ip()), 'result_device' => $device, 'result_system' => $platform, 'result_system_v' => $platform_v, 'result_browser' => $browser, 'result_browser_v' => $browser_v]);
if ($result) {
//插入数据
$fields = $form->Field()->orderBy('field_sort', 'ASC')->get();
$splitStr = ':$split$:';
$user_id = Auth::check() ? Auth::id() : 0;
foreach ($fields as $field) {
$inputs = $request->input($field->field_attr_name);
if (is_array($inputs)) {
if ($field->field_type == 'group:shop-thumbnail') {
$rows = [];
foreach ($inputs as $input) {
$rows[] = $input['goods_name'] . '(' . $input['goods_preice'] . ')：' . $input['goods_num'];
}
$resultrow_attr_value = implode($splitStr, $rows);
} else {
$resultrow_attr_value = implode($splitStr, $inputs);
}
} else {
$resultrow_attr_value = $inputs;
}
ResultRow::create(['resultrow_ruid' => $user_id, 'resultrow_result_id' => $result->result_id, 'resultrow_sort' => $field->field_sort, 'resultrow_type' => $field->field_type, 'resultrow_title' => $field->field_title, 'resultrow_tips' => $field->field_tips, 'resultrow_attr_name' => $field->field_attr_name, 'resultrow_attr_value' => $resultrow_attr_value]);
}
// 发送邮件提示
if ($form->form_tips_email) {
$email = Email::create(['email_cuid' => 0, 'email_ruid' => $user->user_id, 'email_block' => 'form_reply_tips', 'email_target' => $user->user_email, 'email_title' => '[ ' . WEBSITE_NAME . ' ]提示您：您的表单有了新的回复', 'email_datas' => $form->form_code, 'email_is_sent' => 0]);
$this->dispatch(new SendReminderEmail($email));
}
$res = redirect('/u/' . $user_email . '/f-success')->with('msgSuccess', '您的表单已经成功提交，感谢您的参与。');
} else {
$res = redirect()->back()->with('msgError', MSG_FA);
}
return $res;
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
$test = Test::create($request->all());
$score = 0;
$quiz = Quiz::find($request->get('quiz_id'));
foreach ($quiz->questions as $question) {
if ($request->has($question->id)) {
$result = Result::create(['quiz_id' => $request->get('quiz_id'), 'user_id' => $request->get('user_id'), 'test_id' => $test->id, 'question_id' => $question->id, 'answer_id' => $request->get($question->id)]);
$answer = Answer::find($request->get($question->id));
if ($answer->correct) {
$score += 1;
}
}
}
$test->score = $score;
$test->save();
return redirect()->route('tests.result', $test);
}
public function checkPedimento($referen, $valorOrigen)
{
if ($valorOrigen['entrada'] == 1) {
$pk_referencia = $referen->pk_referencia;
$tabla = 'optr02';
$camposel1 = 'pk_factura';
$camposel2 = 'pk_cove';
$campow = 'pk_referencia';
} else {
$pk_referencia = $referen->folio_ds;
$tabla = 'ds505';
$camposel1 = 'NumeroFactura';
$camposel2 = 'NumeroFactura';
$campow = 'folio_ds';
}
//Recorrer campos del Anexo 22
$anexo = Anexo22::all();
foreach ($anexo as $anx) {
//Checar validaciones por campo
foreach ($anx->validations as $val) {
$valid = $val->id;
$camposbd = $anx->relationships->where('origin_id', $valorOrigen['entrada'])->first();
$data = ["tabla" => $camposbd->table, "campos" => $camposbd->field, "attr_id" => $val->attribute_id, "data_val" => $val->val_data, "anx_id" => $anx->id, "entrada" => $valorOrigen['entrada'], "referencia" => $pk_referencia];
$validacion = new Validation();
$valor = $validacion->isValid($data);
if ($valor == 0) {
if ($val->attribute_id == 9) {
$docum = 1;
} else {
$docum = 0;
}
$datos = ["res_referen" => $pk_referencia, "validations_id" => $valid, "res_document" => $docum, "res_company" => Session::get('empresa'), "res_user" => Session::get('usuario')];
$totalres = Result::where('res_referen', $pk_referencia)->where('validations_id', $valid)->count();
if ($totalres == 0) {
Result::create($datos);
}
}
}
}
$factura = \DB::connection('users')->table($tabla)->where($campow, $pk_referencia)->first();
$cove = $this->checkCove($factura, $camposel1, $camposel2, $pk_referencia);
echo $cove;
}
public function uploadResult(Request $request)
{
$data = $request->all();
$questionResult = $data['question'];
$result = explode(',', $questionResult);
for ($i = 0; $i < count($result); $i++) {
$saveResult = explode('-', $result[$i]);
Result::create(['user_id' => $data['user_id'], 'question_id' => $saveResult[0], 'answer' => $saveResult[1], 'second' => $saveResult[2]]);
if ($saveResult[3] == '1') {
$FavoriteRecord = Favorite::where('user_id', $data['user_id'])->where('question_id', $saveResult[0])->first();
if ($FavoriteRecord == null || $FavoriteRecord == 'null') {
Favorite::create(['user_id' => $data['user_id'], 'question_id' => $saveResult[0]]);
}
} else {
if ($saveResult[3] == '0') {
Favorite::where('user_id', $data['user_id'])->where('question_id', $saveResult[0])->delete();
}
}
}
$UserRecord = UserRecord::where('user_id', $data['user_id'])->get();
$StageRecord = $UserRecord->where('stages_id', $data['stages_id'])->first();
$CrementRecord = UserRecord::where('user_id', $data['user_id'])->where('stages_id', $data['stages_id'])->max('stage_score');
$Crement = $data['score'] - $CrementRecord;
$User = User::where('id', $data['user_id'])->first();
if (count($UserRecord) == 0 || $StageRecord == 'null' || $StageRecord == null) {
$User->increment('score', $data['score']);
} else {
if ($Crement > 0) {
$User->increment('score', $Crement);
}
}
$UserSrcoreRecord = Score::where('user_id', $data['user_id'])->where('category_id', floor($data['stages_id'] / 100));
if (count($UserSrcoreRecord->get()) == 0) {
Score::create(['user_id' => $data['user_id'], 'user_name' => $User['name'], 'category_id' => floor($data['stages_id'] / 100), 'score' => $data['score']]);
} else {
if ($Crement > 0) {
$UserSrcoreRecord->first()->increment('score', $Crement);
}
}
UserRecord::create(['user_id' => $data['user_id'], 'stages_id' => $data['stages_id'], 'accuracy' => $data['accuracy'], 'accuracy_detail' => $data['accuracy_detail'], 'status' => $data['status'], 'status_detail' => $data['status_detail'], 'stage_score' => $data['score']]);
return response()->json(['RetCode' => '1']);
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
Model::unguard();
DB::table('results')->delete();
$faker = Faker::create();
foreach (Report::all() as $report) {
$coefficients = array();
$organizationIndicators = $report->owner->organization->indicators;
foreach ($organizationIndicators as $organizationIndicator) {
$coefficients[$organizationIndicator->id] = $organizationIndicator->pivot->coefficient;
}
foreach ($report->users as $user) {
foreach ($report->indicators as $indicator) {
$value = $indicator->type == 'value' ? $faker->randomNumber(3) : $faker->randomFloat(3, 0, 1);
$points = $value * $coefficients[$indicator->id];
Result::create(['report_id' => $report->id, 'user_id' => $user->id, 'indicator_id' => $indicator->id, 'value' => $value, 'points' => $points]);
}
$report->evaluated_at = Carbon::now();
$report->save();
}
}
Model::reguard();
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
//return $request->all();
$v = $this->validator($request->all());
if ($v->fails()) {
return redirect()->back()->withErrors($v->errors())->withInput();
} else {
$resultcreate = Result::create(['period_start' => $this->changedateformat($request->period_start), 'period_end' => $this->changedateformat($request->period_end), 'users_id' => Auth()->user()->id, 'acquisitiontotal' => $request->acquisitiontotal, 'transactiontotal' => $request->transactiontotal, 'commissiontotal' => $request->commissiontotal, 'variabletotal' => $request->variabletotal, 'fixedtotal' => $request->fixedtotal]);
if ($resultcreate) {
$arrayfixed = $request->fixed_cost_id;
$arrayvariable = $request->variable_costs_id;
foreach ($request->fixedcost as $key => $value) {
ResultFixed::create(['results_id' => $resultcreate->id, 'fixed_costs_id' => $arrayfixed[$key], 'cost' => $value]);
}
foreach ($request->variablecost as $key => $value) {
ResultVariable::create(['results_id' => $resultcreate->id, 'variable_costs_id' => $arrayvariable[$key], 'cost' => $value]);
}
Session::flash('message', 'Resultado creado correctamente');
//SE REGISTRA LA ACTIVIDAD EN LA BITACORA
$this->binnacle("REGISTRÓ NUEVO RESULTADO");
}
return Redirect::to('/result/');
}
}
