How can i render formatted field directly in server script

Aryan1703

I have added a formatter for a field which is working perfectly fine(OL.dos). But when i am trying to format all my rows together the field "Ol.dos" return raw value i..e 1or 2. Is there a way to get the formatted value.

Thanks in advance.

 Field::inst('OL.dos')
            ->getFormatter(function ($val, $data, $opts) {
                if ($val === 1) {
                    return "Manual";
                } else if ($val === 2) {
                    return "Auto";
                }
            }),
        Field::inst('OL.comment', 'comment')
            ->getFormatter(function ($val, $data, $field) {
                $details = [
                    ['key' => 'U1.username', 'label' => 'Operator'],
                    ['key' => 'OM.Mode', 'label' => 'Mode'],
                    ['key' => 'OL.dos', 'label' => 'Door Operations Switch'],
                    ['key' => 'Y4.yesNo', 'label' => 'Are you Properly Berthed?'],
                    ['key' => 'OL.qfmID', 'label' => 'QFM #'],
                    ['key' => 'U4.username', 'label' => 'Other Operators']
                ];
                $comment = $val; // Starting with the original comment value
                $commentReturn = '';

                foreach ($details as $detail) {
                    if (isset ($data[$detail['key']]) && !empty ($data[$detail['key']])) {
                        $value = $data[$detail['key']];
                        $label = $detail['label'];
                        $commentReturn .= '<br><div class="data-detail col">[' . $label . ': ' . $value . ']</div>';
                    }
                }

                $commentReturn = $comment . '<br><div class="row">' . $commentReturn . '</div>';
                return '<div class="comment-details">' . $commentReturn . '</div>';
            }),

allan

But when i am trying to format all my rows together the field "Ol.dos" return raw value i..e 1or 2.

I'm not sure what you mean by formatting all of the rows together? What you have looks like OL.dos should be Manual or Auto when it hits the client-side. Is that not happening?

Allan

Aryan1703

Yes, in my cllient side it is giving me 1 or 2 instead of manual or auto .Below is a picture attached.

allan

Can you give me a link to the page so I can take a bit more of a look please? The full PHP being used for that controller would be useful to.

Thanks,
Allan

Aryan1703

Sure, here is the link and the code(I have removed extra piece of code: "https://stagingc.assettrack.cx/operations/DailyLog.php"

Editor::inst($db, 'ops_dailyLog OL', 'OL.id')
    ->field(
        //Table Fields
        Field::inst('OL.id', 'id'),
        Field::inst('OL.date', 'date')
            ->getFormatter(function ($val, $data) {
                $date = new DateTime($val);
                return $date->format('d M y');
            }),
        Field::inst('OL.endTime', 'endTime')
            ->setFormatter(Format::ifEmpty(null)),
        Field::inst('OL.entryType', 'editentryType'),
        Field::inst('OL.category', 'editCat'),
        Field::inst('U3.username', 'updatedBy'),
        Field::inst('U.username', 'controller')
            ->getFormatter(function ($val, $data, $field) {
                $controllerReturn = $val;
                if (isset ($data['U3.username'])) {
                    if ($data['U3.username'] != $val) {
                        $controllerReturn .= '<br><div class="data-detail">[updated:<br>' . $data['U3.username'] . '<br>' . $data['OL.updatedOn'] . ']</div>';
                    }
                }
                return $controllerReturn;
            }),
        Field::inst('OC.category', 'category'),
        Field::inst('OS.subCategory', 'subCategory'),
        Field::inst('OTY.type', 'type'),
        Field::inst('OL.YccBocc', 'YccBocc'),
        Field::inst('L1.location2LA', 'locationTo'),
        Field::inst('OTR.track', 'specificLoc'),
        Field::inst('OD.direction', 'direction'),
        Field::inst('L.location2LA', 'location')
            ->getFormatter(function ($val, $data, $field) {
                $locationReturn = $val;
                if (isset ($data['L1.location2LA'])) {
                    $locationReturn .= ' to ' . $data['L1.location2LA'];
                }
                if (isset ($data['OTR.track'])) {
                    $locationReturn .= '<br>' . $data['OTR.track'];
                }
                if (isset ($data['OD.direction'])) {
                    $locationReturn .= ' ' . $data['OD.direction'];
                }
                return $locationReturn;
            }),
        Field::inst('U1.username', 'operator'),
        Field::inst('OM.Mode', 'mode'),
        Field::inst('EB.EB', 'EBtype'),
        Field::inst('OL.speed', 'speed')
            ->setFormatter(Format::ifEmpty(null)),
        Field::inst('Y2.yesNo', 'wheelFlats'),
        Field::inst('OL.oscRating', 'rating')
            ->setFormatter(Format::ifEmpty(null)),
        Field::inst('OL.vatc', 'vatcReboot')
            ->options(function () {
                return array (
                    array ('label' => 'No', 'value' => '0'),
                    array ('label' => 'Lead', 'value' => '1'),
                    array ('label' => 'Trail', 'value' => '2'),
                );
            })
            ->setFormatter(Format::ifEmpty(null)),
        Field::inst('OL.vatcActive', 'vatcActive')
            ->options(function () {
                return array (
                    array ('label' => 'None', 'value' => '0'),
                    array ('label' => 'A', 'value' => '1'),
                    array ('label' => 'B', 'value' => '2'),
                );
            })
            ->setFormatter(Format::ifEmpty(null)),
        Field::inst('Y3.yesNo', 'BP'),
        Field::inst('Y4.yesNo'),
        Field::inst('Y1.yesNo', 'outOfService'),
        Field::inst('OL.qfmID', 'qfm')
            ->setFormatter(Format::ifEmpty(null)),
        Field::inst('OL.dos')
            ->getFormatter(function ($val, $data, $opts) {
                if ($val === 1) {
                    return "Manual";
                } else if ($val === 2) {
                    return "Auto";
                }
            }),
        Field::inst('U4.username', 'otherOperators'),
        Field::inst('OL.comment', 'comment')
            ->getFormatter(function ($val, $data, $field) {
                $details = [
                    ['key' => 'U1.username', 'label' => 'Operator'],
                    ['key' => 'OM.Mode', 'label' => 'Mode'],
                    ['key' => 'EB.EB', 'label' => 'EB Type'],
                    ['key' => 'OL.speed', 'label' => 'Speed'],
                    ['key' => 'Y2.yesNo', 'label' => 'Flats'],
                    ['key' => 'OL.oscRating', 'label' => 'Rating'],
                    ['key' => 'OL.vatc', 'label' => 'VATC Reboot'],
                    ['key' => 'Y3.yesNo', 'label' => 'Braking/Propulsion'],
                    ['key' => 'Y1.yesNo', 'label' => 'Out of Service'],
                    ['key' => 'OL.dos', 'label' => 'Door Operations Switch'],
                    ['key' => 'Y4.yesNo', 'label' => 'Are you Properly Berthed?'],
                    ['key' => 'OL.qfmID', 'label' => 'QFM #'],
                    ['key' => 'U4.username', 'label' => 'Other Operators']
                ];
                $comment = $val; // Starting with the original comment value
                $commentReturn = '';

                foreach ($details as $detail) {
                    if (isset ($data[$detail['key']]) && !empty ($data[$detail['key']])) {
                        $value = $data[$detail['key']];
                        $label = $detail['label'];
                        $commentReturn .= '<br><div class="data-detail col">[' . $label . ': ' . $value . ']</div>';
                    }
                }

                $commentReturn = $comment . '<br><div class="row">' . $commentReturn . '</div>';
                return '<div class="comment-details">' . $commentReturn . '</div>';
            }),
        Field::inst('OL.comment', 'commentEdit'),

        Field::inst('A2.lrv_no', 'midLRV'),
        Field::inst('A3.lrv_no', 'trailLRV'),
        Field::inst('AI.lrv_no', 'issueLRV'),
        Field::inst('A1.lrv_no', 'leadLRV')
            ->getFormatter(function ($val, $data, $field) {
                $leadLRV = $val;
                $midLRV = $data['A2.lrv_no'] ?? null;
                $trailLRV = $data['A3.lrv_no'] ?? null;
                $issueLRV = $data['AI.lrv_no'] ?? null;
                $lrvReturn = null;
                if (isset ($leadLRV)) {
                    $issueClass = ($leadLRV == $issueLRV) ? ' class="text-danger"' : '';
                    $lrvReturn .= "<br><div{$issueClass}>" . $leadLRV . '</div>';
                }
                if (isset ($midLRV)) {
                    $issueClass = ($midLRV == $issueLRV) ? ' class="text-danger"' : '';
                    $lrvReturn .= "<br><div{$issueClass}>" . $midLRV . '</div>';
                }
                if (isset ($trailLRV)) {
                    $issueClass = ($trailLRV == $issueLRV) ? ' class="text-danger"' : '';
                    $lrvReturn .= "<br><div{$issueClass}>" . $trailLRV . '</div>';
                }
                return $lrvReturn;
            }),

        Field::inst('OL.followOn', 'followOn')
            ->getFormatter(function ($val, $data, $field) {
                $follow = $val;
                $followvalue = '';
                $options = [];
                $checkbox = $data['OL.checkbox'] ?? null;
                if ($checkbox) {
                    $query = "SELECT C.label FROM ops_analysisCheckbox C WHERE FIND_IN_SET(C.id, '$checkbox')";
                    $result = query($query);
                    while ($row = mysqli_fetch_assoc($result)) {
                        $options[] = $row['label'];
                    }
                }
                if (!empty ($options)) {
                    $followvalue = '<br><div class="data-detail col">[Additional Actions: ' . implode(',', $options) . ']</div>';
                }
                $followvalue = $follow . '<br><div class="row">' . $followvalue . '</div>';
                return $followvalue;
            }),
    )

    ->where(function ($q) use ($CC, $Launches, $OCS, $Day, $today1, $yesterday1, $Type, $Oscillation, $Emergency, $date) {

        if (isset ($CC)) {
            if ($CC == 2) {
                $q->where('OL.YccBocc', 1, '=')
                    ->or_where('OL.YccBocc', 2, '=');
            } else if ($CC == 3) {
                $q->where('OL.YccBocc', 1, '=')
                    ->or_where('OL.YccBocc', 3, '=');
            }
            unset ($CC);
        }


   
    })
    ->leftJoin('users_enc U', 'U.id', '=', 'OL.controllerID')
    ->leftJoin('users_enc U1', 'U1.id', '=', 'OL.operator')
    ->leftJoin('users_enc U3', 'U3.id', '=', 'OL.updatedBy')
    ->leftJoin('users_enc U4', 'U4.id', '=', 'OL.operator1')
    ->leftJoin('ops_subcategory OS', 'OS.id', '=', 'OL.subcategory')
    ->leftJoin('ops_category OC', 'OC.id', '=', 'OS.category')
    ->leftJoin('ops_type OTY', 'OTY.id', '=', 'OC.type')
    ->leftJoin('loc L', 'L.id', '=', 'OL.locationFrom')
    ->leftJoin('loc L1', 'L1.id', '=', 'OL.locationTo')
    ->leftJoin('ops_track OTR', 'OTR.id', '=', 'OL.specificLoc')
    ->leftJoin('ops_direction OD', 'OD.id', '=', 'OL.direction')
    ->leftJoin('lrv_list A1', 'A1.id', '=', 'OL.leadLRV')
    ->leftJoin('lrv_list A2', 'A2.id', '=', 'OL.midLRV')
    ->leftJoin('lrv_list A3', 'A3.id', '=', 'OL.trailLRV')
    ->leftJoin('lrv_list AI', 'AI.id', '=', 'OL.issueLRV')
    ->leftJoin('yesno Y', 'Y.id', '=', 'OL.ocs')
    ->leftJoin('yesno Y1', 'Y1.id', '=', 'OL.trainService')
    ->leftJoin('yesno Y2', 'Y2.id', '=', 'OL.EBwheels')
    ->leftJoin('yesno Y3', 'Y3.id', '=', 'OL.BP')
    ->leftJoin('yesno Y4', 'Y4.id', '=', 'OL.berth')
    ->leftJoin('EB_types EB', 'EB.id', '=', 'OL.EBtype')
    ->leftJoin('ops_operationMode OM', 'OM.id', '=', 'OL.operationMode')

    ->debug(true)
    ->process($_POST)
    ->json();

allan

Looks like it needs a login. You can PM it to me by clicking my forum user name and then "Send message".

Allan