Answers

• allan Posts: 63,532Questions: 1Answers: 10,475 Site admin

  May 15

  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 Posts: 77Questions: 20Answers: 1

  May 15 edited May 15

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

  
• allan Posts: 63,532Questions: 1Answers: 10,475 Site admin

  May 16

  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 Posts: 77Questions: 20Answers: 1

  May 16

  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 Posts: 63,532Questions: 1Answers: 10,475 Site admin

  May 16

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

  Allan