function timeFormat($time, $format = 'full')
{
if ($time === '') {
return '';
}
if ($format == 'ago') {
$unit = 60;
$p = time() - $time;
if ($p / $unit < 1) {
return $p / 1 . '秒前';
}
$unit *= 60;
if ($p / $unit < 1) {
return intval($p / 60) . '分钟前';
}
$unit *= 24;
if ($p / $unit < 1) {
return intval($p / 60 / 60) . '小时前';
}
$unit *= 30;
if ($p / $unit < 1) {
return intval($p / 60 / 60 / 24) . '天前';
}
return tm($time, 'full');
}
if ($format == 'full') {
return date('Y-m-d H:i:s', $time);
}
if ($format == 'date') {
return date('Y-m-d', $time);
}
if ($format == 'month') {
return date('m-d', $time);
}
}
function main($imp, $cmd)
{
global $SIDU;
if (!$SIDU[1]) {
$err = @lang(2201);
} elseif ($SIDU['eng'] == 'pg' && !$SIDU[2]) {
$err = @lang(2202);
}
echo "<form action='imp.php?id={$SIDU['0']},{$SIDU['1']},{$SIDU['2']}' method='post' enctype='multipart/form-data'>\n\t<div class='web'><p class='dot'><b>", @lang(2203), ": <i class='red'>DB = {$SIDU['1']}", $SIDU[2] ? ".{$SIDU['2']}" : "", "</i></b></p>";
if ($err) {
echo "<p class='err'>{$err}</p></div></form>";
return;
}
if ($cmd) {
$SIDU[4] = $imp['tab'];
}
if ($SIDU[4]) {
$res = @tm("SQL", "SELECT * FROM " . @goodname($SIDU[4]) . " LIMIT 1");
$col = @get_sql_col($res, $SIDU['eng']);
foreach ($col as $v) {
$imp['cols'][] = $v[0];
}
}
if (!$imp['col']) {
$imp['col'] = @implode("\n", $imp['cols']);
}
if ($cmd) {
$err = @valid_data($SIDU, $imp);
if ($err) {
echo "<p class='err'>{$err}</p>";
} else {
return @save_data($SIDU, $imp);
}
}
if ($SIDU['eng'] == 'my') {
$sql = "SHOW TABLES from `{$SIDU['1']}`";
} elseif ($SIDU['eng'] == 'sl') {
$sql = "SELECT name FROM sqlite_master WHERE type='table' ORDER BY 1";
} else {
$sql = "SELECT relname FROM pg_class a,pg_namespace b\nWHERE a.relnamespace=b.oid AND b.nspname='public' AND a.relkind='r' ORDER BY 1";
}
$arr = @sql2arr($sql, 1);
$tabs[0] = @lang(2204);
foreach ($arr as $v) {
$tabs[$v] = $v;
}
echo "<table><tr><td>", @lang(2205), ":</td><td>", @html_form("select", "imp[tab]", $SIDU[4], "", "", "onchange=\"location='imp.php?id={$SIDU['0']},{$SIDU['1']},{$SIDU['2']},r,'+this.options[this.selectedIndex].value\"", $tabs), "</td></tr>";
if ($SIDU[4]) {
echo "<tr><td valign='top'>", @lang(2206), ":</td><td>", @html_form("textarea", "imp[col]", $imp['col'], 350, 90), "</td></tr>";
}
echo "<tr><td valign='top'>", @lang(2207), ":</td><td><input type='file' name='f'/> ", @lang(2208, '2MB'), "</td></tr></table>\n\t<p class='dot'><br/><b>", @lang(2209), ":</b></p>\n\t<p class='dot'>", @lang(2210), ": ", @html_form("text", "imp[sepC]", $imp['sepC'] ? $imp['sepC'] : ',', 50), " eg \\t , ; « | »\n\t<br/>", @lang(2211), " ", @html_form("text", "imp[cut1]", $imp['cut1'], 50), " ", @lang(2212), " ", @html_form("text", "imp[cut2]", $imp['cut2'], 50), " ", @lang(2213), "\n\t<br/>", @lang(2214), ": ", @html_form("text", "imp[pk]", $imp['pk'], 150), " eg. c1;c2\n\t<br/>", @html_form("checkbox", "imp[del]", $imp['del'], "", "", "", array(1 => '')), @lang(2215), "\n\t<br/>", @html_form("checkbox", "imp[merge]", $imp['merge'], "", "", "", array(1 => '')), @lang(2216), "\n\t<br/>", @html_form("checkbox", "imp[stop]", $imp['stop'], "", "", "", array(1 => '')), @lang(2217), "</p>\n\t<p>", @html_form("submit", "cmd", @lang(2218)), "</p></div></form>";
}
function save_data($SIDU, $txt, $eng)
{
$txt = @trim($txt);
if (@substr($txt, -1) == ')') {
$txt = @trim(@substr($txt, 0, -1));
if (@substr($txt, -1) == ',') {
$txt = @substr($txt, 0, -1);
}
$txt .= ')';
}
$res = @tm("SQL", $txt);
$err = @sidu_err(1);
if ($err) {
return $err;
}
echo @html_js("Goto('menu','menu.php?id={$SIDU['0']}',1);Goto('main','db.php?id={$SIDU['0']},{$SIDU['1']},{$SIDU['2']},{$SIDU['3']},{$SIDU['4']},{$SIDU['5']},{$SIDU['6']}',1);self.close()");
exit;
}
function utm($lon, $lat)
{
/* Convert lon/lat to UTM x/y */
global $NORTH;
global $workingUTMzone;
// compute UTMzone
list($UTMzone, $UTMlatZone) = getUTMzone($lon, $lat);
//echo "$".$UTMzone."$";
if ($UTMzone != $workingUTMzone) {
initUTM($UTMzone);
}
if ($lon < 0.0) {
$lon += 360.0;
}
list($x, $y) = tm($lon, $lat);
$x += 500000.0;
if ($lat < 0) {
$y += 10000000.0;
}
/* For S hemisphere, add 10^6 m */
return array($x, $y, $UTMzone, $UTMlatZone);
}
function save_data($SIDU, $eng, $cmd)
{
foreach ($_POST as $k => $v) {
if (@substr($k, 0, 5) == 'data_' || @substr($k, 0, 10) == 'cbox_data_') {
$arr = @explode('_', $k, 3);
$data[$arr[0]][$arr[1]][$arr[2]] = $v;
}
}
foreach ($SIDU['col'] as $i => $v) {
$col[] = $eng == 'pg' ? '"' . $v[0] . '"' : $v[0];
}
$tab = $eng == 'pg' ? '"' . $SIDU[2] . '"."' . $SIDU[4] . '"' : ($eng == 'my' ? "`{$SIDU['1']}`.`{$SIDU['4']}`" : $SIDU[4]);
foreach ($data['cbox']['data'] as $i => $v) {
//only need i
unset($COL);
unset($VAL);
$where = '';
$is_new = @substr($i, 0, 3) === 'new';
if (!$is_new || $cmd == 'data_del') {
foreach ($_POST['pkV'][$i] as $j => $v) {
$where .= " and " . $col[$j] . (@strtoupper($v) === 'NULL' ? " IS NULL" : "='{$v}'");
}
$where = "WHERE " . @substr($where, 5);
}
if ($cmd == 'data_save') {
foreach ($data['data'][$i] as $j => $v) {
$v = @strip($v, 1, 0, 1);
if (!$is_new || $eng != 'pg' || $v != '' || @substr($SIDU['col'][$j][3], 0, 8) != 'nextval(') {
if ($eng == 'pg' && $SIDU['page']['dataEasy']) {
if ($SIDU['col'][$j][1] == "smallint" || $SIDU['col'][$j][1] == "int") {
$v = @ceil($v);
} elseif ((@substr($SIDU['col'][$j][1], 0, 8) == "varchar(" || @substr($SIDU['col'][$j][1], 0, 5) == "char(") && @strtoupper($v) != 'NULL') {
$v = @trim(@substr($v, 0, $SIDU['col'][$j][4] - 4));
}
}
$COL[] = $col[$j];
$VAL[] = $v;
}
//above logic too complex - even myself forgot :D
}
if ($is_new && isset($COL)) {
$res = @tm("insert", $tab, $COL, $VAL);
} elseif (!$is_new) {
$res = @tm("update", $tab, $COL, $VAL, $where);
}
} elseif ($cmd == 'data_del') {
$res = @tm("delete", $tab, null, null, $where);
}
$errno = @sidu_err(1);
if ($errno) {
$err .= ($eng == 'pg' ? $errno : "Err {$errno}") . "\\n";
} elseif ($cmd == "data_save") {
echo @html_js("parent.document.dataTab.cbox_data_{$i}.checked=''");
} elseif ($cmd == "data_del") {
echo @html_js("parent.document.getElementById('tr_{$i}').style.display='none'");
}
}
if ($err) {
echo @html_js("alert('" . @strtr($err, @array("'" => "\\'", "\"" => "\\\"", "\n" => "\\n")) . "')");
}
}
<td id="tbl-msg">Message</td>
</tr>
</thead>
<tbody>
<?php
foreach ($log as $l) {
?>
<tr class="<?php
echo $l->mtype;
?>
">
<td title="<?php
echo strip_tags(dt($l->timestamp));
?>
"><?php
echo tm($l->timestamp);
?>
</td>
<?php
if ($l->mtype == 'user_message') {
?>
<td>
<?php
if ($l->type == 'message') {
?>
<?php
echo ph($l->nickname);
?>
: <?php
echo add_irc_colors(_irc_link_links(ph($l->text)));
?>
/**
* Returns correctly formated date-time
* @param mixed $date STRING(datestring) | INT(unix-time-format)
* @param boolean $disable_wrapper disables the wrapper for moment.js
* @return string
*/
function dt_tm($time, $disable_wrapper = false)
{
return ($disable_wrapper ? '' : '<span data-moment="' . $time . '">') . dt($time, true) . ' ' . tm($time, true) . ($disable_wrapper ? '' : '</span>');
}
private function montos_punto_memo($monto)
{
// se convierte el monto a valor en letra
$V = new EnLetras();
$valor = explode(".", $monto);
if (count($valor) > 1) {
$con = strtoupper($V->ValorEnLetras($valor[0], " Bs. F Con "));
return $con . strtoupper($V->ValorEnLetras($valor[1], " Centimos")) . " (Bs. F " . tm($monto) . ")";
} else {
return strtoupper($V->ValorEnLetras($valor[0], " Bs. F")) . " (Bs. F " . tm($monto) . ")";
}
}
function valid_data($SIDU, &$exp, $cmd)
{
if (!$exp['db'] && !$exp['drop'] && !$exp['desc'] && !$exp['data']) {
$exp['desc'] = $exp['data'] = 1;
}
if ($exp['drop']) {
$exp['desc'] = 1;
}
if ($exp['ext'] != 'html' && $exp['ext'] != 'sql') {
$exp['ext'] = 'csv';
}
// if (!$cmd) $exp['zip'] = 1;//default save as zip
$exp['where'] = @trim(@stripslashes($exp['where']));
if (!$_GET['sql']) {
if ($SIDU[4]) {
$exp['tabs'][0] = $SIDU[4];
} else {
$exp['tabs'] = @explode(",", $_GET['tab']);
}
if ($SIDU['eng'] == 'my') {
foreach ($exp['tabs'] as $tab) {
$exp['sql'][] = "SELECT * FROM `{$SIDU['1']}`.`{$tab}`";
}
} elseif ($SIDU['eng'] == 'pg') {
foreach ($exp['tabs'] as $tab) {
$exp['sql'][] = "SELECT * FROM \"{$SIDU['2']}\".\"{$tab}\"";
}
} else {
foreach ($exp['tabs'] as $tab) {
$exp['sql'][] = "SELECT * FROM {$tab}";
}
}
if (!$exp['sql'][1]) {
$res = @tm("SQL", $exp['sql'][0] . " LIMIT 1");
$col = @get_sql_col($res, $SIDU['eng']);
foreach ($col as $v) {
$exp['tab_col'][] = $v[0];
}
if ($exp['tab_col'] != $exp['col']) {
foreach ($exp['col'] as $k => $v) {
$exp['col'][$k] = @goodname($v);
}
$exp['sql'][0] = "SELECT " . @implode(",", $exp['col']) . @substr($exp['sql'][0], 8);
}
if ($exp['where']) {
$exp['sql'][0] .= " WHERE {$exp['where']}";
}
}
} else {
$exp['sql'][0] = $_GET['sql'];
}
}
private function migrarInformeSocioEconomico()
{
$tipos = ['Q' => 1, 'A' => 2, 'H' => 3, 'C' => 4, 'R' => 5, 'O' => 6];
$tenencias = ['P' => 1, 'A' => 2, 'D' => 3, 'L' => 4, 'O' => 5, 'C' => 6, 'I' => 7];
$this->info("Migrando informes socio economicos");
$this->getTable('inf_social')->chunk(1000, function ($informes) use($tipos, $tenencias) {
foreach ($informes as $informe) {
$this->info("Migrando informe de la solicitud: " . $informe->idsolicitud);
$solicitud = Solicitud::findOrFail($informe->idsolicitud);
$solicitud->desabilitarConcurrencia();
$solicitud->desabilitarValidaciones();
$solicitud->tipo_vivienda_id = $tipos[$informe->tipocasa];
$solicitud->tenencia_id = $tenencias[$informe->tipotenencia];
$solicitud->informe_social = $informe->observaciones;
$solicitud->total_ingresos = tm($informe->totalingresos);
$solicitud->save();
}
});
}
</head>
<body>
<p align="center">
<img src="<?php
tm('site_logo');
?>
" alt="*" height="150">
<br/>
Seja bem-vindo ao <b><?php
tm('site_name');
?>
</b>, onde os caminhos se encontram.
</p>
<p align="center"><?php
tm('content');
?>
</p>
<p align="center"><?php
tm("menu");
?>
</p>
<div style="background-color: #00ff33" align="center"><b><br/>
<?php
tm('power');
tm('footer');
?>
</b>
</div>
</body>
</html>
function main_func($SIDU, $link, $conn)
{
$col = @array('OID' => 'oid', 'Func' => 'proname', 'Owner' => 'towner', 'return' => 'prorettype', 'lang' => 'prolang', 'Definition' => 'prosrc', 'Comment' => 'comm');
@db_conn($conn, $link[1]);
$lang = @sql2arr("SELECT oid,lanname FROM pg_language", 2);
$typ = @sql2arr("SELECT oid,typname FROM pg_type", 2);
$res = @tm("SQL", "SELECT b.proname,b.oid,pg_get_userbyid(b.proowner) AS towner,b.pronamespace,\nobj_description(b.oid,'pg_proc') AS comm,b.proargtypes,b.prorettype,b.prolang,b.prosrc\nFROM pg_namespace a,pg_proc b\nWHERE a.oid=b.pronamespace AND a.nspname='{$link['2']}'" . ($link[4] != '' ? " AND b.proname LIKE '{$link['4']}%'" : "") . " ORDER BY 1");
while ($row = @pg_fetch_array($res)) {
$row['prorettype'] = $typ[$row['prorettype']];
$row['prolang'] = $lang[$row['prolang']];
$para = @explode(" ", @trim($row['proargtypes']));
unset($parr);
foreach ($para as $v) {
$parr[] = $typ[$v];
}
$para = @implode(",", $parr);
if ($para) {
$row['proname'] .= "({$para})";
}
foreach ($col as $k => $v) {
$data[$k] = $row[$v];
}
$arr[] = $data;
}
@cout_obj($SIDU, $link, $arr, $col);
}
public function getTotalIngresosForAttribute()
{
return tm($this->total_ingresos);
}
<?php
// $Id$
//
// Authors:
// Jeff Buchbinder <*****@*****.**>
//
// FreeMED Electronic Medical Record and Practice Management System
// Copyright (C) 1999-2012 FreeMED Software Foundation
//
// This program is free software; you can redistribute it and/or modify
// it under the terms of the GNU General Public License as published by
// the Free Software Foundation; either version 2 of the License, or
// (at your option) any later version.
//
// This program is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
// GNU General Public License for more details.
//
// You should have received a copy of the GNU General Public License
// along with this program; if not, write to the Free Software
// Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
include_once dirname(__FILE__) . '/bootstrap.test.php';
tm("org.freemedsoftware.api.Scheduler.GetDailyAppointments", array('2006-11-30'));
tm("org.freemedsoftware.api.Scheduler.FindDateAppointments", array('2006-11-30'));
// org.freemedsoftware.api.Scheduler.FindGroupAppointments ( group_id )
tm("org.freemedsoftware.api.Scheduler.GetAppointment", array(1));
// org.freemedsoftware.api.Scheduler.CopyAppointment ( group_id, date )
// org.freemedsoftware.api.Scheduler.CopyGroupAppointment ( group_id, date )
// org.freemedsoftware.api.Scheduler.SetAppointment ( hash of data )
function menu_sl($conn, $tree)
{
global $SIDU;
foreach ($conn[6] as $db) {
$SIDU['dbL'] = @db_conn($conn, $db);
$arr[$db][0]['r'] = array();
$res = @tm("SQL", "SELECT type,name FROM sqlite_master ORDER BY 2");
while ($row = @sqlite_fetch_array($res, SQLITE_NUM)) {
if ($row[0] == 'table') {
@menu_tree_init($arr[$db][0]['r'], $row[1], $tree);
} elseif ($row[0] == 'view') {
@menu_tree_init($arr[$db][0]['v'], $row[1], $tree);
}
}
@menu_tree_init($arr[$db][0]['r'], "sqlite_master", $tree);
}
return $arr;
}
public function getMontoaprForAttribute()
{
return tm($this->montoapr);
}
public function getCoberturaAttribute($value)
{
return tm($value);
}
public function atualizarEstatus($data, $autorizador_id = null)
{
list($cont_aprobados, $cont_devueltos, $cont_procesados, $cont_total) = array(0, 0, 0, 0);
$presupuestos_model = Presupuesto::where('solicitud_id', '=', $data['solicitud']['id'])->get();
$cont_total = count($presupuestos_model);
if (!empty($presupuestos_model)) {
foreach ($presupuestos_model as $presupuesto_model) {
if ($presupuesto_model->estatus_doc == "APR") {
$cont_aprobados++;
}
if ($presupuesto_model->estatus_doc == "PPA") {
$cont_procesados++;
}
if ($presupuesto_model->estatus_doc == "DEV") {
$cont_devueltos++;
}
}
}
$solicitud_model = Solicitud::where('id', '=', $data['solicitud']['id'])->first();
if ($cont_aprobados == $cont_total) {
if (!empty($solicitud_model)) {
$solicitud_model->estatus = "APR";
$solicitud_model->save();
}
} elseif ($cont_devueltos > 0) {
if (!empty($solicitud_model)) {
$solicitud_model->estatus = "DEV";
$solicitud_model->save();
}
} elseif ($cont_procesados > 0) {
if (!empty($solicitud_model)) {
$solicitud_model->estatus = "PPA";
$solicitud_model->usuario_autorizacion_id = $autorizador_id;
$solicitud_model->beneficiario_json = json_encode($solicitud_model->personaBeneficiario->toArray());
if (is_object($solicitud_model->personaSolicitante)) {
$solicitud_model->solicitante_json = json_encode($solicitud_model->personaSolicitante->toArray());
}
$solicitud_model->total_ingresos = tm($solicitud_model->total_ingresos);
$solicitud_model->save();
}
}
return;
}
public function getMontoMensualForAttribute()
{
return tm($this->monto_mensual);
}
function sidu_sl_pk($tab)
{
$res = @tm("SQL", "pragma table_info({$tab})");
while ($row = @sqlite_fetch_array($res)) {
if ($row['pk']) {
$pk[] = $row['name'];
}
}
return @implode(',', $pk);
}
tm('site_logo');
?>
" align="right" width="130">
<?php
tm('site_name');
?>
<br/>
</div>
<div class="menubar"><?php
tm('menu');
?>
</div>
<div id="content" class="content">
<?php
tm('content');
?>
</div> <!-- content -->
</div> <!-- page -->
<div id="footer" class="footer">
<?php
tm('footer');
?>
<br/>
<!-- Não remova a atribuição! -->
<font size="1"><?php
tm('power');
?>
</font>
</div> <!-- footer -->
</body>
</html>
">Edit post</a></li>
</ul><?php
}
?>
<div class="spotlight">
<a href="<?php
echo site_url('user/' . $creator->id);
?>
"><div class="avatar" style="background-image:url(<?php
echo avatar_image($creator->id);
?>
);"></div><?php
echo showname($creator);
?>
<br /><span class="date" title="<?php
echo tm($entry->timestamp, true);
?>
"><?php
echo dt($entry->timestamp);
?>
</span></a>
<em><?php
echo d($creator->about);
?>
</em>
</div>
<center>
<?php
echo $rating->display_large();
?>
</center>
