crocodic-studio / crudbooster

src/views/statistic_builder/components/chartbar.blade.php

@if($command=='layout')
    <div id='{{$componentID}}' class='border-box'>

        <div class="panel panel-default">
            <div class="panel-heading">
                [name]
            </div>
            <div class="panel-body">
                [sql]
            </div>
        </div>

        <div class='action pull-right'>
            <a href='javascript:void(0)' data-componentid='{{$componentID}}' data-name='Panel Area' class='btn-edit-component'><i class='fa fa-pencil'></i></a>
            &nbsp;
            <a href='javascript:void(0)' data-componentid='{{$componentID}}' class='btn-delete-component'><i class='fa fa-trash'></i></a>
        </div>
    </div>
@elseif($command=='configuration')
    <form method='post'>
        <input type='hidden' name='_token' value='{{csrf_token()}}'/>
        <input type='hidden' name='componentid' value='{{$componentID}}'/>
        <div class="form-group">
            <label>Name</label>
            <input class="form-control" required name='config[name]' type='text' value='{{@$config->name}}'/>
        </div>

        <div class="form-group">
            <label>SQL Query Line</label>
            <textarea name='config[sql]' required rows="4" class='form-control'>{{@$config->sql}}</textarea>
            <div class="block-help">
                Use column name 'label' as line chart label. Use name 'value' as value of line chart. Sparate with ; each sql line. Use [SESSION_NAME] to use
                alias session.
            </div>
        </div>

        <div class="form-group">
            <label>Bar Area Name</label>
            <input class="form-control" required name='config[area_name]' type='text' value='{{@$config->area_name}}'/>
            <div class="block-help">You can naming each line area. Write name sparate with ;</div>
        </div>

        <div class="form-group">
            <label>Goals Value</label>
            <input class="form-control" name='config[goals]' type='number' value='{{@$config->goals}}'/>
        </div>
    </form>
@elseif($command=='showFunction')

    @if($key == 'sql')
        <?php
        $sqls = explode(';', $value);
        $dataPoints = array();
        $datax = array();

        foreach ($sqls as $i => $sql) {

            $datamerger = array();

            $sessions = Session::all();
            foreach ($sessions as $key => $val) {
                $sql = str_replace("[".$key."]", $val, $sql);
            }

            try {
                $query = DB::select(DB::raw($sql));
                foreach ($query as $r) {
                    $datax[] = $r->label;
                    $datamerger[] = $r->value;
                }
            } catch (\Exception $e) {

Consider adding a comment why this CATCH block is empty.

            }

            $dataPoints[$i] = $datamerger;
        }

        $datax = array_unique($datax);

        $area_name = explode(';', $config->area_name);
        $area_name_safe = $area_name;
        foreach ($area_name_safe as &$a) {
            $a = str_slug($a, '_');

The function str_slug() has been deprecated: Str::slug() should be used directly instead. Will be removed in Laravel 6.0.

        }

        $data_result = array();
        foreach ($datax as $i => $d) {
            $dr = array();
            $dr['y'] = $d;
            foreach ($area_name as $e => $name) {
                $name = str_slug($name, '_');

The function str_slug() has been deprecated: Str::slug() should be used directly instead. Will be removed in Laravel 6.0.

                $dr[$name] = $dataPoints[$e][$i];
            }
            $data_result[] = $dr;
        }

        $data_result = json_encode($data_result);
        // $data_result = preg_replace('/"([a-zA-Z_]+[a-zA-Z0-9_]*)":/','$1:',$data_result);

        ?>
        <div id="chartContainer-{{$componentID}}" style="height: 250px;"></div>


        <script type="text/javascript">

            $(function () {
                new Morris.Bar({
                    element: 'chartContainer-{{$componentID}}',
                    data: $.parseJSON("{!! addslashes($data_result) !!}"),
                    xkey: 'y',
                    ykeys: {!! json_encode($area_name_safe) !!},
                    labels: {!! json_encode($area_name) !!},
                    resize: true,
                    parseTime: false,
                    @if($config->goals)
                    goals: [{{$config->goals}}],
                    @endif
                    behaveLikeLine: true,
                    hideHover: 'auto'
                });
            })
        </script>

    @else

        {!! $value !!}
    @endif
@endif