ONE PIECE HACKING

Ngiler SH3LL 360
: / home / tbf / quiz_tbf_accelerator / app / Exports /

Information Server
MySQL : OFF Perl : OFF CURL : ON WGET : OFF PKEXEC : OFF

Directive	Local Value
IP Address	89.40.16.97
System	Linux server.atelieruldeit.ro 3.10.0-1160.el7.x86_64 #1 SMP Mon Oct 19 16:18:59 UTC 2020 x86_64
User	tbf
PHP Version	7.3.33
Software	Apache
Doc root	Writable

Edit File : ApplicantExport.php \| Size : 3.38 KB
<?php namespace App\Exports; use App\QuizResult; use Illuminate\Contracts\View\View; use Maatwebsite\Excel\Concerns\FromView; use Carbon\Carbon; use App\ExportSetting; class ApplicantExport implements FromView { private $filters; public function __construct($filters) { $this->filters = $filters; } public function view(): View { $results = QuizResult::where('contact_data', 1)->with('activity_logs')->get(); if($this->filters != '' && sizeof($this->filters['referrals']) > 0){ $results = $results->whereIn('referral_id',$this->filters['referrals']); } if($this->filters != '' && $this->filters['dateRange']['startDate'] != '' && $this->filters['dateRange']['endDate'] != ''){ $results = $results->whereBetween('created_at', [Carbon::parse($this->filters['dateRange']['startDate'])->startOfDay(), Carbon::parse($this->filters['dateRange']['endDate'])->endOfDay()]); } $settings_questions = ExportSetting::all(); $result_array = []; $status = config('status_options.dropdown_options'); $settings_questions_headers = []; foreach($settings_questions as $q){ $settings_questions_headers[] = $q->header_name; } foreach($results as $result){ $entity_json = json_decode($result->entity_json, 1); $settings_questions_array = []; foreach($settings_questions as $q){ if(isset($entity_json[$q->question_key])){ if(isset($entity_json[$q->question_key]['answers'][0]['fields']) && sizeof($entity_json[$q->question_key]['answers'][0]['fields']) > 0){ $settings_questions_array[] = implode(', ',array_map(function($field){ if(isset($field['value'])){ if(isset($field['value']['value'])){ return $field['value']['value']; }else{ return $field['value']; } }else{ return ''; } },$entity_json[$q->question_key]['answers'][0]['fields'])); }else{ $settings_questions_array[] = $entity_json[$q->question_key]['answers'][0]['title']; } }else{ $settings_questions_array[] = ''; } } $result_array[] = [ 'first_name' => $entity_json[29]['answers'][0]['fields'][1]['value'], 'last_name' => $entity_json[29]['answers'][0]['fields'][0]['value'], 'email' => $entity_json[29]['answers'][0]['fields'][2]['value'], 'telefon' => $entity_json[29]['answers'][0]['fields'][3]['value'], 'atribuit_pentru' => $result->assigned_to, 'status' => $status[$result->status], 'feedback' => $result->feedback, 'timp' => ceil($result->activity_logs->sum('time')), 'created_at' => $result->created_at, 'extra' => $settings_questions_array ]; } return view('exports.results', [ 'results' => $result_array, 'settings_questions_headers' => $settings_questions_headers ]); } } Back

Edit File : ApplicantExport.php | Size : 3.38 KB

<?php

namespace App\Exports;

use App\QuizResult;
use Illuminate\Contracts\View\View;
use Maatwebsite\Excel\Concerns\FromView;
use Carbon\Carbon;
use App\ExportSetting;

class ApplicantExport implements FromView
{
    private $filters;
    public function __construct($filters)
    {
        $this->filters = $filters;
    }
    public function view(): View
    {
        $results = QuizResult::where('contact_data', 1)->with('activity_logs')->get();
        if($this->filters != '' && sizeof($this->filters['referrals']) > 0){
            $results = $results->whereIn('referral_id',$this->filters['referrals']);
        }
        if($this->filters != '' && $this->filters['dateRange']['startDate'] != '' && $this->filters['dateRange']['endDate'] != ''){
            $results = $results->whereBetween('created_at', [Carbon::parse($this->filters['dateRange']['startDate'])->startOfDay(), Carbon::parse($this->filters['dateRange']['endDate'])->endOfDay()]);
        }
        $settings_questions = ExportSetting::all();

$result_array = [];
        $status = config('status_options.dropdown_options');
        $settings_questions_headers = [];
        foreach($settings_questions as $q){
            $settings_questions_headers[] = $q->header_name;
        }
        foreach($results as $result){
            $entity_json = json_decode($result->entity_json, 1);
            $settings_questions_array = [];
            foreach($settings_questions as $q){
                if(isset($entity_json[$q->question_key])){
                    if(isset($entity_json[$q->question_key]['answers'][0]['fields']) && sizeof($entity_json[$q->question_key]['answers'][0]['fields']) > 0){
                        $settings_questions_array[] = implode(', ',array_map(function($field){
                            if(isset($field['value'])){
                                if(isset($field['value']['value'])){
                                    return $field['value']['value'];
                                }else{
                                    return $field['value'];
                                }
                            }else{
                                return '';
                            }
                        },$entity_json[$q->question_key]['answers'][0]['fields']));
                    }else{
                        $settings_questions_array[] = $entity_json[$q->question_key]['answers'][0]['title'];
                    }
                }else{
                    $settings_questions_array[] = '';
                }
            }
            $result_array[] = [
                'first_name' => $entity_json[29]['answers'][0]['fields'][1]['value'],
                'last_name' => $entity_json[29]['answers'][0]['fields'][0]['value'],
                'email' => $entity_json[29]['answers'][0]['fields'][2]['value'],
                'telefon' => $entity_json[29]['answers'][0]['fields'][3]['value'],
                'atribuit_pentru' => $result->assigned_to,
                'status' => $status[$result->status],
                'feedback' => $result->feedback,
                'timp' => ceil($result->activity_logs->sum('time')),
                'created_at' => $result->created_at,
                'extra' => $settings_questions_array
            ];
        }
        return view('exports.results', [
            'results' => $result_array,
            'settings_questions_headers' => $settings_questions_headers
        ]);
    }
}

Back