ApiC

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use App\Sip_ref_activity;
use App\Sip_ref_form;
use App\Sip_ref_sub_form;
use App\Sip_ref_column;
use App\Sip_ref_row;
use App\Sip_trx_row_value;
use App\Sip_trx_form_value;
use App\Sip_trx_form_submission;

class ApiController extends Controller
{

    public function formValueApi($id,$form,$submission)
    {

        $subs = Sip_ref_form::find($form)->subs;

        foreach($subs as $sub){

            // get row
            $tmpRows = $sub->rows()->where('sip_ref_rows_type_row','row')->get();

            foreach($tmpRows as $row){

                //get row columns
                $tmpCodes = $row->codes;

                foreach($tmpCodes as $code){

                    $code['value'] = Sip_trx_form_value::where('sip_trx_form_values_code',$code->sip_trx_row_values_code)->where('sip_trx_form_values_submission_id',$submission)->first();

                }

                $row['values'] = $tmpCodes;

                unset($row['codes']);

            }

            $sub['rows'] = $tmpRows;

        }

        return $subs;
    }

    public function paramsIndexApi($id,$sub)
    {

        $subs = Sip_ref_form::find($sub)->subs;

        foreach($subs as $sub){

            //groups
            $groups = $sub->rows()->where('sip_ref_rows_type_row','group')->get();

            foreach($groups as $group){

                //get columns
                $group->groupcolumns;

                //get rows
                $grouprows = $group->grouprows()->where('sip_ref_rows_type_parent','parent')->with('codes')->get();

                // get rows children
                foreach($grouprows as $gr){

                    $gr['children'] = $gr->children()->with('codes')->get();

                }

                $group['grouprows'] = $grouprows;

            }

            $sub['tables'] = $groups;
        }

        return $subs;
    }

    public function activityListApi()
    {
        return Sip_ref_activity::all();
    }

    public function formListApi($id)
    {

        return Sip_ref_activity::find($id)->forms;
    }

    public function subformIndexApi($id,$sub)
    {

        return Sip_ref_form::find($id)->subs;

    }

    public function paramsStoreApi($id, Request $request)
    {
        // check form
        $form = Sip_ref_form::find($id);

        if(!is_object($form)){
            return array('status' => false, 'code' => 500, 'message' => 'Data not found');
        }

        // input submission
        $input = array(

            'sip_trx_form_submission_user_id' => $request->input('by'),
            'sip_trx_form_submission_form_id' => $id

            );

        $submission = Sip_trx_form_submission::create($input);

        foreach($request->all() as $key => $req){

            if($req !== 'by'){

                $input = array(
                    'sip_trx_form_values_value_string' => $req,
                    'sip_trx_form_values_code' => $key,
                    'sip_trx_form_values_submission_id' => $submission->sip_trx_form_submission_id,
                    'sip_trx_form_values_form_id' => $id
                    );

                Sip_trx_form_value::create($input);

            }

        }

        return array('message' => 'Ok');
    }

}