/**
* Format a given date or the current date to MySQL DATETIME type
*
* @return The formated date
*/
function mysqlDateTime($date)
{
if (empty($date) || strtolower($date) == 'now') {
return date('Y-m-d H:i:s');
} else {
return nice_date($date, 'Y-m-d H:i:s');
}
}
public function import_index()
{
if ($this->modules->users->is("dev_mode")) {
$data_dwoo = new Dwoo_Data();
$import_dir = ROOT_PATH . "test.interline.ua/storage/import";
//xprintr($import_dir);
$files = array();
$allowed = array("xml", "zip", "csv", "DBF", "dbf");
$dir = $this->dir_tree($import_dir);
if ($dir) {
foreach ($dir as $one) {
if (in_array(substr($one, -3), $allowed)) {
$tmpKeyDate = nice_date(filemtime($one));
$files[$tmpKeyDate["UNIX"]] = array("file" => $one, "date" => nice_date(filemtime($one)), "size" => $this->format_bytes(filesize($one)));
}
}
} else {
$files = array();
}
ksort($files);
$data_dwoo->assign("data", $files);
jsonout(array("ok" => $this->dwoo->get("cms/import-index.php", $data_dwoo)));
} else {
jsonout(array("error" => "У вас недостаточно прав для доступа к импорту"));
}
}
echo forum_count($row['id']);
?>
Posts</span>
<span class="item"><?php
echo lang('topic_by');
?>
<strong><?php
echo $topic_author['styled_name'];
?>
</strong></span>
<span class="item">
<?php
if ($last_post) {
?>
Last post was <?php
echo nice_date($last_post['time']);
?>
<?php
echo lang('by');
?>
<strong><?php
echo $last_post_udata['styled_name'];
?>
</strong>
<?php
} else {
?>
<?php
echo lang('none');
}
?>
echo '<div class="col-md-12">';
echo '<div class="alert alert-danger" role="alert">';
echo validation_errors();
echo '</div>';
echo '</div>';
echo '</div>';
}
?>
<div class="row">
<div class="col-md-2">
<div class="form-group">
<label for="data_prazo">Data (dd/mm/aaaa)</label>
<input type="text" class="form-control" id="data_prazo" name="data_prazo"
value="<?php
echo nice_date($prazo[0]->data_prazo, 'd/m/Y');
?>
">
</div>
</div>
<div class="col-md-10">
<div class="form-group">
<label for="descricao">Descrição</label>
<textarea class="form-control" id="descricao" name="descricao"><?php
echo $prazo[0]->descricao;
?>
</textarea>
</div>
</div>
</div>
echo '<div class="col-md-12">';
echo '<div class="alert alert-danger" role="alert">';
echo validation_errors();
echo '</div>';
echo '</div>';
echo '</div>';
}
?>
<div class="row">
<div class="col-md-2">
<div class="form-group">
<label for="data_andamento">Data (dd/mm/aaaa)</label>
<input type="text" class="form-control" id="data_andamento" name="data_andamento"
value="<?php
echo nice_date($andamento[0]->data_andamento, 'd/m/Y');
?>
">
</div>
</div>
<div class="col-md-9">
<div class="form-group">
<label for="descricao">Descrição</label>
<textarea class="form-control" id="descricao" name="descricao"><?php
echo $andamento[0]->descricao;
?>
</textarea>
</div>
</div>
<div class="col-md-1">
<div class="form-group">
/<?php
echo $number;
?>
/<?php
if ($folder == 'my_folder') {
echo $this->uri->segment(4);
}
?>
'">
<span <?php
if ($type == 'inbox' && $tmp->readed == 'false') {
echo "style=\"font-weight: bold\"";
}
?>
><?php
echo nice_date($message_date);
?>
<img src="<?php
echo $this->config->item('img_path') . $arrow;
?>
.gif" />
<?php
echo $senderName;
?>
<?php
if ($folder == 'folder') {
echo "(" . $this->Message_model->get_messages(array('type' => $type, 'number' => $number, 'uid' => $this->session->userdata('id_user')))->num_rows() . ")";
} else {
echo "(" . $this->Message_model->get_messages(array('type' => $type, 'number' => $number, 'id_folder' => $this->uri->segment(4), 'uid' => $this->session->userdata('id_user')))->num_rows() . ")";
}
?>
<div class="row">
<div class="col-md-12">
<div class="panel panel-default">
<div class="panel-heading">
<h3 class="panel-title">Dados do Processo</h3>
</div>
<div class="panel-body">
<a href="<?php
echo base_url('processos/consulta/' . $processo[0]->id_processos);
?>
"><?php
echo $processo[0]->numero_processo;
?>
</a> |
<?php
echo $processo[0]->numero_interno;
?>
|
<?php
echo nice_date($processo[0]->data_abertura, 'd/m/Y');
?>
|
<?php
echo $processo[0]->localizacao;
?>
</div>
</div>
</div>
</div>
$error_qry = "{$query}";
include "error.php";
} else {
echo "<p>" . pg_NumRows($result) . " sessions found</p>";
echo "<table border=\"0\" align=center><tr>\n";
echo "<th class=cols>Session #</th><th class=cols>Name</th>";
echo "<th class=cols align=left>Start</th>";
echo "<th class=cols align=left>Duration</th>";
echo "</tr>";
// Build table of sessions found
for ($i = 0; $i < pg_NumRows($result); $i++) {
$thissession = pg_Fetch_Object($result, $i);
if ($i % 2 == 0) {
echo "<tr bgcolor={$colors['6']}>";
} else {
echo "<tr bgcolor={$colors['7']}>";
}
echo "<td align=center> {$thissession->session_id} </td>\n";
echo "<td> <a href=\"user.php?user_no={$thissession->user_no}\">{$thissession->fullname}";
if ("{$thissession->fullname}" == "") {
echo "{$thissession->username}";
}
echo "</a> </td>\n";
echo "<td>" . nice_date($thissession->session_start) . "</td>\n";
echo "<td>{$thissession->duration}</td>\n";
echo "</tr>\n";
}
echo "</table>\n";
}
}
echo "</table>\n</form>\n";
<label for="email"><span>Email address:</span>
<input type="email" name="email" id="email" value="<?php
echo set_value('email', $result['email']);
?>
" placeholder="Please enter patient's email" required>
<?php
echo form_error('email', "<div class='error'>", '</div>');
?>
</label>
<!--passcode is auto-generated in controller -->
<label for="passcode"><span>Passcode:</span>
<input type="text" name="passcode" id="passcode" value="<?php
echo set_value('passcode', $result['passcode']);
?>
" required>
</label>
<label for="birthday"><span>Birthday:</span>
<input type="date" name="birthday" id="birthday" value="<?php
echo set_value('birthday', nice_date($result['birthday'], 'Y-m-d'));
?>
" placeholder="Please enter patient's birth date" required>
<?php
echo form_error('birthday', "<div class='error'>", '</div>');
?>
</label>
<input type="submit" value="" id="submit">
</form>
</div>
</div>
<?php
include APPPATH . 'views\\templates\\lab_footer.php';
<td><?php
echo $row->rekening;
?>
</td>
</tr>
<tr>
<td class="bold">Transfer</td>
<td><?php
echo harga($row->transfer);
?>
</td>
</tr>
<tr>
<td class="bold">Daftar</td>
<td><?php
echo nice_date(unix_to_human($row->daftar), 'd F Y');
?>
</td>
</tr>
<tr>
<td class="bold">Status</td>
<td>
<?php
if ($row->stat === '1') {
echo '<span class="label label-success">Aktif</span> ';
} else {
echo '<span class="label label-warning">Belum Aktif</span> ';
}
?>
</td>
</tr>
<tr>
<th>Date</th>
<th>Name</th>
<th>Payment</th>
</tr>
</thead>
<tbody>
<?php
foreach ($rows as $row) {
?>
<tr>
<td><?php
echo nice_date($row->timestamp_checkout, 'd M Y');
?>
</td>
<td><?php
echo $row->name;
?>
</td>
<td>$<?php
echo $row->payment_checkout;
?>
</td>
</tr>
<?php
}
<th>Data</th>
<th>Descrição</th>
<th></th>
</tr>
</thead>
<tbody>
<?php
foreach ($prazos as $row) {
?>
<tr>
<td><a href="<?php
echo base_url('prazos/consulta/' . $row->id_processos . '/' . $row->id_prazos);
?>
">
<?php
echo nice_date($row->data_prazo, 'd/m/Y');
?>
</a></td>
<td><?php
echo $row->descricao;
?>
</td>
<td style="white-space:nowrap">
<a class="btn btn-default btn-xs"
href="<?php
echo base_url('prazos/edita/' . $row->id_processos . '/' . $row->id_prazos);
?>
">
<span class="glyphicon glyphicon-edit" aria-hidden="true" title="Editar"></span></a>
<a class="btn btn-default btn-xs"
public function extension()
{
$input_date = $this->extension_date;
$better_date = nice_date($input_date, 'Y-m-d');
$data = ['chawri_extension_sellers_id' => $this->session->userdata['user_data'][0]['users_id'], 'chawri_products_orders_id' => $this->products_id, 'chawri_extension_date' => $better_date, 'chawri_extension_reasons' => $this->extension, 'chawri_extension_current_date' => $date = date('Y-m-d H:i:s')];
if ($this->db->insert('chawri_extension', $data)) {
return true;
} else {
return false;
}
}
$xtable->set_attribute("style", "empty-cells: show; border-collapse: collapse; border: 1px solid {$colors['row1']} ;");
$xtable->set_attribute("border", "1");
// Create column headers for selected fields.
$xthead = $xtable->new_child("thead", "");
$xthr = $xthead->new_child("tr", "");
$clone_tr = $doc->create_element("tr");
foreach ($columns as $column) {
$xth = $xthr->new_child("th", $column);
$xth->set_attribute("class", "cols");
$clone_td = $doc->create_element("td");
$clone_td = $clone_tr->append_child($clone_td);
$clone_td->set_attribute("class", "sml");
}
list($day, $month, $year) = explode('/', nice_date($from_date));
$from_timestamp = mktime(0, 0, 0, $month, $day, $year);
list($day, $month, $year) = explode('/', nice_date($to_date));
$to_timestamp = mktime(0, 0, 0, $month, $day, $year);
$j_from_date = GregorianToJD(date("n", $from_timestamp), date("j", $from_timestamp), date("Y", $from_timestamp));
$j_to_date = GregorianToJD(date("n", $to_timestamp), date("j", $to_timestamp), date("Y", $to_timestamp));
$temp_timestamp = $from_timestamp;
$temp_date = getdate($from_timestamp);
for ($day = 0; $day <= $j_to_date - $j_from_date; $day++) {
$temp_timestamp = mktime($temp_date["hour"], $temp_date["minutes"], $temp_date["seconds"], $temp_date["mon"], $temp_date["mday"] + $day, $temp_date["year"]);
$day_array[date("Y-m-d", $temp_timestamp)] = $day;
$xth = $xthr->new_child("th", date("D d m y", $temp_timestamp));
$xth->set_attribute("class", "cols");
$clone_td = $doc->create_element("td");
$clone_td = $clone_tr->append_child($clone_td);
if (date("D", $temp_timestamp) == "Sat" || date("D", $temp_timestamp) == "Sun") {
$clone_td->set_attribute("class", "sml row1");
} else {
/** Overridden method from Request, just so we display the subset of
* request data we are interested in for QAMS.
*/
function RenderDetails($ef)
{
global $session, $bigboxcols, $bigboxrows;
$html = "";
$html .= $ef->BreakLine("Project Details");
if (!$this->new_record) {
$html .= $ef->DataEntryLine("W/R #", "{$this->request_id}" . " <b>Requested:</b> " . nice_date($this->request_on) . " <b>Status:</b> " . $this->status_desc);
$html .= $ef->BreakLine("Quality Assurance Details");
} else {
// QA Model
// This determines which default approvals are set up initially..
$html .= $ef->DataEntryLine("QA Model", "", "lookup", "qa_model_id", array("_sql" => "SELECT * FROM qa_model", "_null" => "--- choose a model ---", "title" => "The QA model most appropriate to this project"));
// PROJECT ROLES
// These are specific important roles to be assigned to the project for QA
// purposes. Note, we also consider that anyone who has been ALLOCATED to
// this project is a valid QA Reviewer (client or internal).
// Project Manager
$html .= $ef->DataEntryLine("Project Mgr", "{$this->fullname}", "lookup", "project_manager", array("_sql" => SqlSelectRequesters($session->org_code), "_null" => "--- select a person ---", "title" => "The project manager in charge of this project."));
// QA Mentor
$html .= $ef->DataEntryLine("QA Mentor", "{$this->fullname}", "lookup", "qa_mentor", array("_sql" => SqlSelectRequesters($session->org_code), "_null" => "--- select a person ---", "title" => "The QA mentor helping with quality assurance on this project."));
}
$html .= $ef->DataEntryLine("Brief", "%s", "text", "brief", array("size" => 70, "title" => "A brief description of the project."));
// Organisation drop-down
if ($session->AllowedTo("Admin") || $session->AllowedTo("Support") || $session->AllowedTo("Contractor")) {
$html .= $ef->DataEntryLine("Organisation", "{$this->org_name}", "lookup", "org_code", array("_sql" => SqlSelectOrganisations($this->org_code), "_null" => "--- select an organisation ---", "onchange" => "OrganisationChanged();", "title" => "The organisation that this work will be done for."));
} else {
if ($this->new_record) {
$this->org_name = $session->org_name;
}
$html .= $ef->DataEntryLine("Organisation", "{$this->org_name}", "", "");
}
// Person within Organisation drop-down
$html .= $ef->DataEntryLine("Person", "{$this->fullname}", "lookup", "requester_id", array("_sql" => SqlSelectRequesters($this->org_code), "_null" => "--- select a person ---", "onchange" => "PersonChanged();", "title" => "The client who is requesting this, or who is in charge of ensuring it happens."));
// System (within Organisation) drop-down
$html .= $ef->DataEntryLine("System", "{$this->system_desc}", "lookup", "system_id", array("_sql" => SqlSelectSystems($this->org_code), "_null" => "--- select a system ---", "onchange" => "SystemChanged();", "title" => "The business system that this project applies to."));
// Urgency of Request
$html .= $ef->DataEntryLine("Urgency", $this->urgency_desc, "lookup", "urgency", array("_type" => "request|urgency", "title" => "The urgency of the project, separate from the long-term importance"));
// Importance of Request
$html .= $ef->DataEntryLine("Importance", $this->importance_desc, "lookup", "importance", array("_type" => "request|importance", "title" => "The relative long-term importance of the project, separate from the urgency"));
// Requested By Date
$html .= $ef->DataEntryLine("Requested By", $this->requested_by_date, "date", "requested_by_date", array("title" => "The date that you would like this project completed by", "onblur" => "this.value=CheckDate(this)"));
// Agreed Due Date
$html .= $ef->DataEntryLine("Agreed Due", $this->agreed_due_date, "date", "agreed_due_date", array("title" => "The date that has been agreed that the project will be completed by / on", "onblur" => "this.value=CheckDate(this)"));
// Detailed description
$html .= $ef->DataEntryLine("Details", str_replace('%', '%%', html_format($this->detailed)), "textarea", "detailed", array("title" => "Full details of the project", "rows" => $bigboxrows, "cols" => $bigboxcols));
return $html;
}
<div class="row">
<div class="col-xs-10 col-xs-offset-1">
<div class="box box-danger">
<div class="box-body">
<?php
if (isset($start_date)) {
?>
<h2>Summary from: <?php
echo nice_date($start_date, 'd M Y');
?>
to <?php
echo nice_date($end_date, 'd M Y');
?>
</h2>
<?php
} else {
?>
<h2>Summary from all time</h2>
<?php
}
?>
<div class="row">
<div class="col-xs-3">
<!-- Date and time range -->
<div class="form-group">
<div class="input-group">
<button class="btn btn-default pull-right" id="daterange-btnearning">
<i class="fa fa-calendar"></i><span>Select Date Range</span>
<i class="fa fa-caret-down"></i>
}, 500); } startTime(); })(); </script> </span> </div> </div> </div> <div class="datedisplay"> <p> <?php echo nice_date(unix_to_human(time()), 'l m-d-y'); ?> </p> </div> <footer> <a href='#timein' data-toggle='modal'> <input class="round-button" type="submit" value="IN"/> </a> </footer> <div class="datedisplay"> <p> <?php echo $this->session->fullname; ?> </p>
<tr>
<th>Date</th>
<th>Premium Visits</th>
<th>Non Premium Visits</th>
<th>Link</th>
<th>Revenue Generated</th>
</tr>
</thead>
<tbody>
<?php
foreach ($rows as $row) {
?>
<tr>
<td><?php
echo nice_date($row->time, 'd M Y, H:i');
?>
</td>
<td><?php
echo $row->premium_visit;
?>
</td>
<td><?php
echo $row->normal_visit;
?>
</td>
<td><?php
echo $row->link;
?>
</td>
<td>$<?php
printf("<tr class=row%1d>\n", $i % 2);
echo "<td class=sml nowrap>{$timesheet->requester_name}</td>\n";
if (isset($GLOBALS[org_code]) && $GLOBALS[org_code] > 0) {
echo "<td class=sml nowrap>{$timesheet->abbreviation}</td>\n";
}
echo "<td class=sml align=center nowrap><a href=\"{$base_url}/wr.php?request_id={$timesheet->request_id}\">{$timesheet->request_id}</a></td>\n";
echo "<td class=sml>" . substr(nice_date($timesheet->work_on), 7) . "</td>\n";
echo "<td class=sml>{$timesheet->work_quantity} {$timesheet->work_units}</td>\n";
echo "<td class=sml align=right>{$timesheet->work_rate} </td>\n";
echo "<td class=sml>{$timesheet->worker_name}</td>\n";
if ("{$timesheet->work_charged}" == "") {
if ("{$uncharged}" == "") {
echo "<td class=sml>uncharged</td>";
}
} else {
echo "<td class=sml>" . substr(nice_date($timesheet->work_charged), 7) . "</td>";
}
echo "<td class=sml>" . html_format($timesheet->work_description) . "</td>";
if ("{$uncharged}" != "") {
echo "<td class=\"sml\"><a href=\"{$base_url}/wr.php?request_id={$timesheet->request_id}\">{$timesheet->brief}</a></td>\n";
printf("<td class=\"sml\">%s</td>\n", $timesheet->review_needed == 't' ? '<span style="color:red;">Review</span>' : ' ');
echo "<td class=sml align=right>";
printf("<input type=\"checkbox\" value=\"1\" id=\"{$timesheet->timesheet_id}\" name=\"chg_ok[{$timesheet->timesheet_id}]\"%s>", "{$timesheet->ok_to_charge}" == "t" ? " checked" : "");
printf("<input type=hidden name=\"chg_worker[{$timesheet->timesheet_id}]\" value=\"%s\">", htmlspecialchars($timesheet->worker_name));
printf("<input type=hidden name=\"chg_desc[{$timesheet->timesheet_id}]\" value=\"%s\">", htmlspecialchars($timesheet->work_description));
printf("<input type=hidden name=\"chg_request[{$timesheet->timesheet_id}]\" value=\"%s\">", htmlspecialchars($timesheet->request_id));
printf("<input type=hidden name=\"chg_requester[{$timesheet->timesheet_id}]\" value=\"%s\">", htmlspecialchars($timesheet->requester_name));
echo "</td>\n";
echo "<td class=sml><font size=2><input type=text size=6 name=\"chg_inv[{$timesheet->timesheet_id}]\" value=\"\"></font> </td>\n";
echo "<td class=sml><font size=2><input type=text size=8 name=\"chg_amt[{$timesheet->timesheet_id}]\" value=\"\"></font> </td>\n";
echo "<td class=sml><font size=2><input type=text size=10 name=\"chg_on[{$timesheet->timesheet_id}]\" value=\"" . date("d/m/Y") . "\"></font> </td>\n";
public function date_helper()
{
$this->load->helper('date');
echo now('Australia/Victoria');
echo "<br>";
echo now('+8');
echo "<br>";
$datestring = 'Year: %Y Month: %m Day: %d - %h:%i %a';
$time = time();
echo mdate($datestring, $time);
//at UTC
echo "<br>";
$format = 'DATE_RFC822';
$time = time();
echo standard_date($format, $time);
//Deprecated
echo "<br>";
echo date(DATE_RFC822, time());
echo "<br>";
echo local_to_gmt(time());
echo "<br>";
$timestamp = 1140153693;
$timezone = 'UM8';
$daylight_saving = TRUE;
echo gmt_to_local($timestamp, $timezone, $daylight_saving);
echo "<br>";
echo "<br>";
$unix = mysql_to_unix('20061124092345');
echo $unix;
echo "<br>";
echo "<br>";
$now = time();
echo unix_to_human($now);
// U.S. time, no seconds
echo "<br>";
echo unix_to_human($now, TRUE, 'us');
// U.S. time with seconds
echo "<br>";
echo unix_to_human($now, TRUE, 'eu');
// Euro time with seconds
echo "<br>";
echo "<br>";
$now = time();
$human = unix_to_human($now);
$unix = human_to_unix($human);
echo $human;
echo "<br>";
echo $unix;
echo "<br>";
echo "<br>";
echo "<br>";
$bad_date = '199605';
// Should Produce: 1996-05-01
$better_date = nice_date($bad_date, 'Y-m-d');
echo $bad_date;
echo "<br>";
echo $better_date;
echo "<br>";
echo "<br>";
$bad_date = '9-11-2001';
// Should Produce: 2001-09-11
$better_date = nice_date($bad_date, 'Y-m-d');
echo $bad_date;
echo "<br>";
echo $better_date;
echo "<br>";
echo "<br>";
$post_date = '1079621429';
$now = time();
$units = 2;
echo timespan($post_date, $now, $units);
echo "<br>";
echo "<br>";
echo days_in_month(06, 2005);
echo "<br>";
echo "<br>";
$range = date_range('2012-01-01', '2012-01-15');
echo "First 15 days of 2012:";
foreach ($range as $date) {
echo $date . "\n";
}
echo "<br>";
echo "<br>";
echo timezones('UM5');
echo "<br>";
echo "<br>";
echo timezone_menu('UM8');
echo "<br>";
echo "<br>";
}
<div class="col-md-12" id="workstream_thread" style="">
<?php
if (!empty($workstream)) {
foreach ($workstream as $key => $value) {
?>
<div class="row">
<div class="col-md-1">
<img class="browse_job_user_img" style="margin-top: 33px;" src="<?php
echo assets_path('uploads/profile/' . $value->profile_image);
?>
">
</div>
<div class="col-md-11">
<h6><?php
echo nice_date($value->time, 'd M Y');
?>
</h6>
<p class="alert alert-success" id="othermsg" ><?php
echo $value->message;
?>
</p>
</div>
</div>
<?php
}
}
?>
</div>
<div class="col-md-12" style="padding:0px">
<input type="hidden" name="sender" value="<?php
foreach ($parados as $row) {
?>
<tr>
<td><a href="<?php
echo base_url('processos/consulta/' . $row->id_processos);
?>
"><?php
echo $row->numero_processo;
?>
</a></td>
<td><?php
echo $row->numero_interno;
?>
</td>
<td><?php
echo nice_date($row->data_abertura, 'd/m/Y');
?>
</td>
<td><?php
echo $row->descricao;
?>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
</div>
<div class="row">
<div class="col-md-12">
<div class="panel panel-default">
<div class="panel-heading">
<h3 class="panel-title">Dados do Apenso</h3>
</div>
<div class="panel-body">
<?php
echo $apenso[0]->numero_apenso;
?>
|
<?php
echo nice_date($apenso[0]->data_apenso, 'd/m/Y');
?>
|
<?php
echo $apenso[0]->localizacao;
?>
|
<?php
echo $apenso[0]->descricao;
?>
</div>
</div>
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label for="numero_apenso">Número do Apenso</label>
<input type="text" class="form-control" id="numero_apenso" name="numero_apenso" autofocus
value="<?php
echo $vdc['numero_apenso'];
?>
">
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label for="data_apenso">Data (dd/mm/aaaa)</label>
<input type="text" class="form-control" id="data_apenso" name="data_apenso"
value="<?php
echo nice_date($vdc['data_apenso'], 'd/m/Y');
?>
">
</div>
</div>
</div>
<div class="row">
<div class="col-md-4">
<div class="form-group">
<label for="localizacao">Localização</label>
<select class="form-control" id='localizacao' name='localizacao'>
<?php
foreach ($localizacoes as $row) {
echo "<option value='{$row->id_localizacoes}'";
echo $vdc['localizacao'] == $row->id_localizacoes ? 'selected' : '';
function get_project_export($position, $username, $project, $status, $from, $to)
{
if ($project == "0") {
$project = " IS NOT NULL";
} else {
$project = "=" . $project . "";
}
if ($position == "0") {
$position = " IS NOT NULL";
} else {
$position = "=" . $position . "";
}
if ($username == "0") {
$username = "******";
} else {
$username = "******" . $username . "";
}
if ($status == "0") {
$status = " IS NOT NULL";
} else {
$status = "=" . $status . "";
}
if ($from == "") {
$from = " IS NOT NULL";
} else {
$bad_date = $from;
$better_date = nice_date($bad_date, 'Y-m-d');
$from = ">='" . $better_date . "'";
}
if ($to == "") {
$to = " IS NOT NULL";
} else {
$bad_date_1 = $to;
$better_date_1 = nice_date($bad_date_1, 'Y-m-d');
$to = "<='" . $better_date_1 . "'";
}
$query = $this->db->query('SELECT e_reg.e_username as Name,
e_work.w_date as Date,
e_position.p_name as Position,
e_work.w_working as Working,
e_proj.e_proj_name as ProjectName,
e_work.w_module as Module,
status.s_name as Status,
e_work.w_details as Description,
e_work.w_date_created as Created,
e_work.w_date_modified as Modified
FROM e_work
LEFT JOIN e_proj ON e_work.w_proj=e_proj.e_id
INNER JOIN status ON e_work.w_status=status.s_id
INNER JOIN e_reg ON e_work.u_id=e_reg.e_id
INNER JOIN e_position ON e_work.u_position=e_position.p_id
where e_work.w_proj' . $project . ' AND
e_work.w_status' . $status . ' AND
e_work.u_position' . $position . ' AND
e_work.u_id' . $username . ' AND
e_work.w_date_created' . $from . ' AND
e_work.w_date_created' . $to . '
ORDER BY e_work.w_id DESC');
$write_w = $this->dbutil->csv_from_result($query);
return $write_w;
}
<th>Nama</th>
<th>Email</th>
<th>Kota</th>
<th>HP</th>
<th>Transfer</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
if ($data->num_rows() > 0) {
foreach ($data->result() as $row) {
?>
<tr>
<td><?php
echo '<abbr title="' . unix_to_human($row->daftar, TRUE) . '">' . nice_date(unix_to_human($row->daftar), 'd M y') . '</abbr>';
?>
</td>
<td><?php
echo $row->userid;
?>
</td>
<td><?php
echo anchor('admin/member/detail/' . $row->userid . '?ref=aktif', strtoupper($row->nama), array('title' => 'Lihat detail: ' . $row->nama, 'class' => 'tooltipkan'));
?>
</td>
<td><?php
echo $row->email;
?>
</td>
<td><?php
<?php
echo $orderDetail->prix;
?>
<i class="fa fa-eur"></i>
</p>
<p style="text-align: left;">
<span>Quantité : </span>
<?php
echo $orderDetail->quantite;
?>
</p>
<p style="text-align: left;">
<span>Ce produit a été commander le</span>
<?php
$bad_date = $orderDetail->date_commande;
$better_date = nice_date($bad_date, 'd-m-Y');
echo $better_date;
?>
</p>
<a href="<?php
echo base_url('single/index/' . strtolower(url_title(convert_accented_characters($orderDetail->nom_produit))) . '/' . $orderDetail->id_produit);
?>
" class="btn btn-success" title="Afficher plus">Plus... »</a>
</div>
</div>
<?php
}
<label><?php
echo $this->lang->line('field_buying_price');
?>
: </label>
<?php
echo $item->buying_price;
?>
<br />
<label><?php
echo $this->lang->line('field_buying_date');
?>
: </label>
<?php
if (!empty($item->buying_date)) {
echo nice_date($item->buying_date, $this->lang->line('date_format_short'));
}
?>
</div>
<div class="col-md-4">
<label><?php
echo $this->lang->line('field_warranty_duration');
?>
: </label>
<?php
if (!empty($item->warranty_duration)) {
echo $item->warranty_duration . ' ' . $this->lang->line('text_months');
}
?>
<br />
<?php
foreach ($apensos as $row) {
?>
<tr>
<td>
<a href="<?php
echo base_url('apensos/consultaap/' . $row->id_processos . '/' . $row->id_apensos);
?>
">
<?php
echo $row->numero_apenso;
?>
</a>
</td>
<td><?php
echo nice_date($row->data_apenso, 'd/m/Y');
?>
</td>
<td><?php
echo $row->localizacao;
?>
</td>
<td><?php
echo $posicoes[$row->posicao];
?>
</td>
<td>
<a class="btn btn-default btn-xs"
href="<?php
echo base_url('apensos/edita/' . $row->id_processos . '/' . $row->id_apensos);
<table class="table table-striped">
<thead>
<tr>
<th>Data</th>
<th>Descrição</th>
<th>Interesse</th>
<th></th>
</tr>
</thead>
<tbody>
<?php
foreach ($andamentos as $row) {
?>
<tr>
<td><?php
echo nice_date($row->data_andamento, 'd/m/Y');
?>
</td>
<td><?php
echo $row->descricao;
?>
</td>
<td><?php
echo $interesse[$row->interesse];
?>
</td>
<td style="white-space:nowrap">
<a class="btn btn-default btn-xs"
href="<?php
echo base_url('andamentos/edita/' . $row->id_processos . '/' . $row->id_andamentos);
