dev-chiefworks
73 lines
2.1 KiB
PHP
73 lines
2.1 KiB
PHP
<?php
|
|
namespace App\Models;
|
|
|
|
use CodeIgniter\Model;
|
|
|
|
class userTrips extends Model{
|
|
protected $db;
|
|
public $con_name = 'dbFloat';
|
|
|
|
public function __construct()
|
|
{
|
|
parent::__construct();
|
|
$this->db = \Config\Database::connect($this->con_name);
|
|
}
|
|
|
|
private function logArray3($in){
|
|
if (!is_array($in)){
|
|
log_message('critical', "NOT ARRAY => $in \n");
|
|
return;
|
|
}
|
|
foreach($in as $key => $value){
|
|
$vl='';
|
|
if (is_array($value)){
|
|
foreach($value as $kk => $vv){
|
|
$vl .= "$kk => $vv \n";
|
|
}
|
|
}
|
|
else{
|
|
$vl=$value;
|
|
}
|
|
|
|
log_message('critical', "$key=>".$vl);
|
|
}
|
|
|
|
|
|
}
|
|
|
|
|
|
public function savvyLoadSavedTrips($in, &$out) {
|
|
|
|
$ret = 0;
|
|
$member_id = $in['member_id'];
|
|
$out["total_record"] = 0;
|
|
$out['session_valid'] = '';
|
|
$out['internal_return'] = PHP_API_OK;
|
|
|
|
$saveTrips = $this->db->query("SELECT * FROM members_trips WHERE member_id = $member_id AND status = 1 ORDER BY trip_date DESC");
|
|
|
|
if ($saveTrips != null) {
|
|
$out["total_record"] = $saveTrips->getNumRows();
|
|
$ic = 0;
|
|
$this->logArray3("card lines total_record => ".$saveTrips->getNumRows());
|
|
|
|
foreach ($saveTrips->getResultArray() as $f) {
|
|
// $this->logArray3("Saved Trips total => ".$ic);
|
|
$suffix = str_pad($ic, 5, '0', STR_PAD_LEFT);
|
|
$out['trip_name_' . $suffix] = $f['trip_name'];
|
|
$out['trip_id_' . $suffix] = $f['id'];
|
|
$out['from_' . $suffix] = $f['trip_from'];
|
|
$out['to_' . $suffix] = $f['trip_to'];
|
|
$out['date_' . $suffix] = $f['trip_date'];
|
|
$out['country_' . $suffix] = $f['country'];
|
|
$out['color_' . $suffix] = $f['color'];
|
|
$ic++;
|
|
}
|
|
|
|
}
|
|
return $ret;
|
|
}
|
|
|
|
|
|
|
|
} |