function recordConstruct($args) { if (count($args) > 1) { $name = $args[0]; $owner_id = $args[1]; } if (!empty($name)) { $this->name = $name; $this->register_ts = time(); $this->register_date = db_date(); } if (isset($owner_id) && $owner_id > 0) { $this->save(); $owner = new DB_Channel_Access(); $owner->setChanId($this->channel_id); $owner->setUserId($owner_id); $owner->setLevel(500); $this->addAccess($owner); } }
/** * Update a token * @param integer Token ID * @param string Token value * @param integer Token expiration in seconds */ function token_update($p_token_id, $p_value, $p_expiry = TOKEN_EXPIRY) { token_ensure_exists($p_token_id); $c_token_id = db_prepare_int($p_token_id); $c_value = db_prepare_string($p_value); $c_expiry = db_timestamp(db_date(time() + $p_expiry)); $t_tokens_table = config_get('mantis_tokens_table'); $query = "UPDATE {$t_tokens_table} \n\t\t\t\t\tSET value='{$c_value}', expiry={$c_expiry}\n\t\t\t\t\tWHERE id={$c_token_id}"; db_query($query); return true; }
* * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE * ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE * LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE * POSSIBILITY OF SUCH DAMAGE. */ db_queryf("delete from stats_servers"); db_queryf("delete from stats_users"); db_queryf("delete from stats_channels"); db_queryf("delete from stats_channel_users"); foreach ($this->servers as $num => $server) { db_queryf("insert into stats_servers (server_name, `desc`, start_date, max_users, isService) " . "values ('%s', '%s', '%s', '%s', '%s')", $server->getName(), $server->getDesc(), db_date($server->getStartTs()), $server->getMaxUsers(), $server->isService()); } foreach ($this->users as $numeric => $user) { $server = $this->getServer($user->getServerNumeric()); db_queryf("insert into stats_users \n\t\t\t(nick, ident, host, name, server, modes, account, signon_date)\n\t\t\tvalues\n\t\t\t('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')", $user->getNick(), $user->getIdent(), $user->getHost(), $user->getName(), $server->getName(), $user->getModes(), $user->getAccountName(), db_date($user->getSignonTs())); } foreach ($this->channels as $chan_key => $chan) { db_queryf("insert into stats_channels (channel_name, topic, modes) values ('%s', '%s', '%s')", $chan->getName(), $chan->getTopic(), $chan->getModes()); foreach ($chan->getUserList() as $numeric) { $user = $this->getUser($numeric); db_queryf("insert into stats_channel_users (channel_name, nick, isOp, isVoice) values \n\t\t\t\t('%s', '%s', '%s', '%s')", $chan->getName(), $user->getNick(), $chan->isOp($numeric), $chan->isVoice($numeric)); } }
<?php include '../include.php'; url_query_require(); $d = db_grab('SELECT d.title, t.extension, d.content FROM docs d JOIN docs_types t ON d.type_id = t.id WHERE d.id = ' . $_GET['id']); db_query('INSERT INTO docs_views ( documentID, userID, viewedOn ) VALUES ( ' . $_GET['id'] . ', ' . user() . ', ' . db_date() . ' )'); file_download($d['content'], $d['title'], $d['extension']);
} else { $t_metrics[3][$t_ptr] += $t_data[$t][$t_status]; } } } } } else { $i = 0; foreach ($t_view_status as $t_status => $t_label) { if (isset($t_data[$t][$t_status])) { $t_metrics[++$i][$t_ptr] = $t_data[$t][$t_status]; } else { $t_metrics[++$i][$t_ptr] = 0; } } } if ($f_show_as_table) { echo '<tr class="row-' . ($t_ptr % 2 + 1) . '"><td>' . $t_ptr . ' (' . db_date($t_metrics[0][$t_ptr]) . ')' . '</td>'; for ($i = 1; $i <= $t_label_count; $i++) { echo '<td>' . $t_metrics[$i][$t_ptr] . '</td>'; } echo '</tr>'; } } if ($f_show_as_table) { echo '</table>'; html_body_end(); html_end(); } else { graph_bydate($t_metrics, $t_labels, lang_get('by_category'), $f_width, $f_width * $t_ar); }
// scale the amount of premium accordingly // but need to round it down otherwise strtotime may fail $expires = strtotime(db_date($expires) . " +" . max(0, floor($address['months'] * ($balance['balance'] / $address['balance']))) . " months +" . max(0, floor($address['years'] * ($balance['balance'] / $address['balance']))) . " years"); crypto_log("New premium expiry date: " . db_date($expires)); // apply premium data to user account $q = db()->prepare("UPDATE user_properties SET updated_at=NOW(),is_premium=1, premium_expires=?, is_reminder_sent=0 WHERE id=? LIMIT 1"); $q->execute(array(db_date($expires), $address['user_id'])); // update outstanding premium as paid $q = db()->prepare("UPDATE outstanding_premiums SET is_paid=1,paid_at=NOW(),paid_balance=? WHERE id=?"); $q->execute(array($balance['balance'], $address['id'])); // update jobs to premium priority $q = db()->prepare("UPDATE jobs SET priority=? WHERE user_id=? AND is_executed=0 AND priority > ?"); $q->execute(array(get_site_config('premium_job_priority'), $address['user_id'], get_site_config('premium_job_priority'))); crypto_log("Updated old jobs to new priority"); if ($user['email']) { send_user_email($user, "purchase_partial", array("name" => $user['name'] ? $user['name'] : $user['email'], "amount" => number_format_autoprecision($address['balance']), "received" => number_format_autoprecision($balance['balance']), "currency" => get_currency_abbr($address['currency']), "currency_name" => get_currency_name($address['currency']), "expires" => db_date($expires), "address" => $address['address'], "explorer" => get_explorer_address($address['currency'], $address['address']), "url" => absolute_url(url_for("user#user_premium")), "profile_url" => absolute_url(url_for("user#user_premium")), "reminder" => $reminder, "cancelled" => $cancelled)); crypto_log("Sent e-mail to " . htmlspecialchars($user['email']) . "."); } } else { // the user hasn't paid a thing // mark it as unpaid $q = db()->prepare("UPDATE outstanding_premiums SET is_unpaid=1,cancelled_at=NOW() WHERE id=?"); $q->execute(array($address['id'])); // release the premium address $q = db()->prepare("UPDATE premium_addresses SET is_used=0,used_at=NULL WHERE id=?"); $q->execute(array($address['premium_address_id'])); if ($user['email']) { send_user_email($user, "purchase_cancelled", array("name" => $user['name'] ? $user['name'] : $user['email'], "amount" => number_format_autoprecision($address['balance']), "received" => number_format_autoprecision($balance['balance']), "currency" => get_currency_abbr($address['currency']), "currency_name" => get_currency_name($address['currency']), "address" => $address['address'], "explorer" => get_explorer_address($address['currency'], $address['address']), "url" => absolute_url(url_for("user#user_premium")), "reminder" => $reminder, "cancelled" => $cancelled)); crypto_log("Sent e-mail to " . htmlspecialchars($user['email']) . "."); } }
* * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE * ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE * LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE * POSSIBILITY OF SUCH DAMAGE. */ $oper_count = 0; $service_count = 0; $service_server_count = 0; foreach ($this->users as $num => $user) { if ($user->isService()) { $service_count++; } if ($user->isOper()) { $oper_count++; } } foreach ($this->servers as $num => $serv) { if ($serv->isService()) { $service_server_count++; } } db_queryf("insert into stats_history \n\t\t(date, servers, users, channels, accounts, opers, services, service_servers) \n\t\tvalues ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')", db_date(time()), count($this->servers), count($this->users), count($this->channels), count($this->accounts), $oper_count, $service_count, $service_server_count);
/* * ircPlanet Services for ircu * Copyright (c) 2005 Brian Cline. * All rights reserved. * * Redistribution and use in source and binary forms, with or without * modification, are permitted provided that the following conditions are met: * 1. Redistributions of source code must retain the above copyright notice, * this list of conditions and the following disclaimer. * 2. Redistributions in binary form must reproduce the above copyright notice, * this list of conditions and the following disclaimer in the documentation * and/or other materials provided with the distribution. * 3. Neither the name of ircPlanet nor the names of its contributors may be * used to endorse or promote products derived from this software without * specific prior written permission. * * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE * ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE * LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE * POSSIBILITY OF SUCH DAMAGE. */ db_queryf("insert into stats_servers (server_name, `desc`, start_date, max_users, isService) " . "values ('%s', '%s', '%s', '%s', '%s')", $server->getName(), $server->getDesc(), db_date($server->getStartTs()), $server->getMaxUsers(), $server->isService());
<table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td class="tabfonte" colspan="4"> <hr> </td> </tr> <tr> <td class="tabfonte" width="18%"> Data Inicio Atividades:</td> <td class="tabfonte" width="21%"> <?php echo db_date($q02_dtinic, '/'); ?> </td> <td class="tabfonte" width="14%"> Data Baixa:</td> <td class="tabfonte" width="47%"> <?php echo db_date($q02_dtbaix, '/'); ?> </td> </tr> <tr> <td class="tabfonte" width="18%"> </td> <td class="tabfonte" width="21%"> </td> <td class="tabfonte" width="14%"> </td> <td class="tabfonte" width="47%"> </td> </tr> <tr> <td class="tabfonte" width="18%"> Inscrição Estadual:</td> <td class="tabfonte" width="21%"> <?php echo $z01_incest;
</tr> <tr> <td width="24%"><strong><font size="2" color="black" face="Arial, Helvetica, sans-serif">Valor à Recolher:</font></strong></td> <td width="76%"><font size="2" color="black" face="Arial, Helvetica, sans-serif"> <?php echo $valorpagamento; ?> </font></td> </tr> <tr> <td width="24%"><strong><font size="2" color="black" face="Arial, Helvetica, sans-serif">Data vencimento:</font></strong></td> <td width="76%"><font size="2" color="black" face="Arial, Helvetica, sans-serif"> <?php echo db_date($datavencimento, '/'); ?> </font></td> </tr> <tr> <td width="24%" valign="top"><strong><font size="2" color="black" face="Arial, Helvetica, sans-serif">Observações:</font></strong></td> <td width="76%"> <font size="2" color="black" face="Arial, Helvetica, sans-serif"> <?php echo substr($obsliber, 0, 40); ?> <br> <?php echo substr($obsliber, 40, 40); ?> <br>
// sort and display the results sort($t_category); if ($f_show_as_table) { html_begin(); html_head_begin(); html_css(); html_content_type(); html_head_end(); html_body_begin(); echo '<table class="width100"><tr><td></td>'; foreach ($t_category as $t_cat) { echo '<th>' . $t_cat . '</th>'; } echo '</tr>'; for ($t_ptr = 0; $t_ptr < $t_bin_count; $t_ptr++) { echo '<tr class="row-' . ($t_ptr % 2 + 1) . '"><td>' . $t_ptr . ' (' . db_date($t_marker[$t_ptr]) . ')' . '</td>'; foreach ($t_category as $t_cat) { echo '<td>' . (isset($t_data[$t_ptr][$t_cat]) ? $t_data[$t_ptr][$t_cat] : 0) . '</td>'; } echo '</tr>'; } echo '</table>'; html_body_end(); html_end(); } else { // reverse the array and reorder the data, if necessary $t_metrics = array(); for ($t_ptr = 0; $t_ptr < $t_bin_count; $t_ptr++) { $t = $t_bin_count - $t_ptr - 1; $t_metrics[0][$t_ptr] = $t_marker[$t]; $i = 0;
function weekly() { $year_week = cm_get('year_week', 'string') or $year_week = date('Y_W'); list($year, $week) = split('_', $year_week); $year = (int) $year; $week = (int) $week; if (isset($_GET['go'])) { $week += $_GET['go'] == 'prev' ? -1 : 1; if ($week == 0) { $year--; $week = 53; } elseif ($week == 54) { $year++; $week = 1; } } lg($week . ' week of ' . $year . ' year'); $first_jan = mktime(0, 0, 0, 1, 1, $year); $weekday_first_jan = (int) strftime('%w', $first_jan); $delta = 4 - $weekday_first_jan; if ($delta < 0) { $delta = $delta + 7; } $first_week_start = $first_jan + ($delta - 3) * 86400; $nth_week_start = $first_week_start + 86400 * 7 * ($week - 1); $nth_week_end = $nth_week_start + 86400 * 7 - 1; $date_start = db_date($nth_week_start); $date_end = db_date($nth_week_end); $sql_breakdown = ' SELECT SUM(outlay.value) AS sum, c.name FROM outlay INNER JOIN outlay_category c ON c.id = outlay.outlay_category_id WHERE outlay.created_at BETWEEN "' . $date_start . '" AND "' . $date_end . '" GROUP BY c.name '; $this->tpl->add('breakdown', db_fetch_all($sql_breakdown)); $sql = ' SELECT outlay.*, c.name, user.name as author_name, DAY(outlay.created_at) as weekday FROM outlay INNER JOIN outlay_category c ON c.id = outlay.outlay_category_id LEFT JOIN user ON user.id = outlay.user_id WHERE outlay.created_at BETWEEN "' . $date_start . '" AND "' . $date_end . '" ORDER BY MONTH(outlay.created_at), weekday ASC, c.name ASC, outlay.created_at '; $outlay_records = db_fetch_all($sql); $weekdata = array(); $prev_weekday = -1; $day->total = 0; $day->last_record_time = 0; $day->items = array(); $cat->total = 0; $cat->items = array(); $prev_cat = ''; foreach ($outlay_records as $outlay) { // add old category to day, if new cat or new day if ($prev_cat && $outlay->name !== $prev_cat || $prev_weekday !== -1 && $prev_weekday !== $outlay->weekday) { $day->total += $cat->total; $day->items[] = $cat; $last_record_time = $cat->items[count($cat->items) - 1]->created_at; if ($day->last_record_time < $last_record_time) { $day->last_record_time = $last_record_time; } $cat = new stdClass(); $cat->total = 0; $cat->items = array(); } // add old day to week, if new day if ($prev_weekday !== -1 && $prev_weekday !== $outlay->weekday) { $last_cat = $day->items[count($day->items) - 1]; $last_record_time = $last_cat->items[count($last_cat->items) - 1]->created_at; if ($day->last_record_time < $last_record_time) { $day->last_record_time = $last_record_time; } $weekdata[] = $day; $day = new stdClass(); $day->total = 0; $day->items = array(); } $cat->total += $outlay->value; $cat->items[] = $outlay; $prev_weekday = $outlay->weekday; $prev_cat = $outlay->name; } if ($prev_cat) { $day->total += $cat->total; $day->items[] = $cat; $last_record_time = $cat->items[count($cat->items) - 1]->created_at; if ($day->last_record_time < $last_record_time) { $day->last_record_time = $last_record_time; } } if ($prev_weekday !== -1) { $weekdata[] = $day; } $this->tpl->add('index', $outlay); $this->tpl->add('weekdata', $weekdata); $this->tpl->add('year', $year); //die(date('Y_W', $first_week_start)); $this->tpl->add('week', $week); $this->tpl->view('outlay.index'); }
} if ($this->getChannelRegCount($user->getAccountId()) >= MAX_CHAN_REGS) { $bot->noticef($user, 'You cannot register more than %d channels.', MAX_CHAN_REGS); return false; } $reg = $this->getChannelReg($chan_name); $chan = $this->getChannel($chan_name); if ($reg) { $bot->noticef($user, 'Sorry, %s is already registered.', $reg->getName()); return false; } if ($this->isBadchan($chan_name)) { $bot->noticef($user, 'Sorry, but you are not allowed to register %s.', $chan_name); return false; } if (!$chan || !$chan->isOp($user->getNumeric())) { $bot->noticef($user, 'You must be an op in %s in order to register it.', $chan_name); return false; } $create_ts = time(); if ($chan != NULL) { $create_ts = $chan->getTs(); } $reg = new DB_Channel($chan_name, $user->getAccountId()); $reg->setPurpose($purpose); $reg->setCreateTs($create_ts); $reg->setRegisterDate(db_date()); $reg->save(); $reg = $this->addChannelReg($reg); $bot->join($chan_name); $this->mode($chan_name, '+Ro ' . $bot->getNumeric());
<?php $events = db_query('SELECT e.id, e.title' . langExt() . ' title, e.start_date, t.color FROM cal_events e LEFT JOIN cal_events_types t ON e.type_id = t.id ' . getChannelsWhere('cal_events', 'e', 'event_id') . ' AND e.start_date > ' . db_date() . ' ORDER BY e.start_date ASC', 4); if (db_found($events)) { while ($e = db_fetch($events)) { $return .= ' <tr> <td width="80%"><a href="/' . $m['folder'] . '/event.php?id=' . $e['id'] . '" class="block" style="background-color:' . $e['color'] . ';">' . $e['title'] . '</a></td> <td width="20%" align="right">' . format_date($e['start_date'], "", "%b %d") . '</td> </tr>'; } } else { $return .= '<tr><td colspan="2" class="empty">' . getString('events_empty') . '</td></tr>'; }
$CRITERIO .= " AND facturas.folio =" . $_GET['flio']; } } if (isset($_GET['folio2']) && $_GET['folio2'] != "") { $CRITERIO .= " AND facturas.folio <=" . $_GET['folio2']; } if (isset($_GET['serie']) && $_GET['serie'] != "") { $CRITERIO .= " AND facturas.serie='" . $_GET['serie'] . "'"; } if (isset($_GET['diai']) && $_GET['diai'] != "") { $fechainicial = $_GET['aai'] . "-" . $_GET['mmi'] . "-" . $_GET['diai']; $CRITERIO .= " AND facturas.timestampemision >='" . $fechainicial . " 00:00:00'"; } if (isset($_GET['diat']) && $_GET['diat'] != "") { $fechafinal = $_GET['aat'] . "-" . $_GET['mmt'] . "-" . $_GET['diat']; $CRITERIO .= " AND facturas.timestampemision <='" . db_date($_GET['fechafinal']) . " 23:59:59'"; } if (isset($_GET['clnt']) && $_GET['clnt'] != "") { $CRITERIO .= " AND face_factura.razonsocial like '%" . $_GET['razonsocial'] . "%'"; } if (isset($_GET['status']) && $_GET['status'] >= 0 && $_GET['status'] >= 0) { $CRITERIO .= " AND facturas.estatus = '" . $_GET['status'] . "'"; } if (isset($_GET['ref3']) && !empty($_GET['ref3'])) { $CRITERIO .= " AND facturas.rfccliente like '%" . $_GET['ref3'] . "%'"; } } $maxRows_facturas = 64000; $pageNum_facturas = 0; if (isset($_GET['pageNum_facturas'])) { $pageNum_facturas = $_GET['pageNum_facturas'];
* ******************************************************* */ require_once "../../../lib/php/constantes.php"; require_once "{$RUTA_A}/Connections/fwk_db.php"; require_once "{$RUTA_A}/functions/utils.php"; if (isset($_POST['nfi']) && isset($_POST['nomprov']) && isset($_POST['tratamiento']) && isset($_POST['tipocompr']) && isset($_POST['pais']) && isset($_POST['ciudad']) && isset($_POST['direccion']) && isset($_POST['fax']) && isset($_POST['telefono']) && isset($_POST['fecha']) && isset($_POST['sexo']) && isset($_POST['dni']) && isset($_POST['usr'])) { require_once "{$RUTA_A}/functions/Proveedor.php"; $nfi = $_POST['nfi']; $proveedor_name = utf8_decode($_POST['nomprov']); $tratamiento = $_POST['tratamiento']; $tipocomp = $_POST['tipocompr']; $pais = $_POST['pais']; $ciudad = $_POST['ciudad']; $direccion = $_POST['direccion']; $fax = $_POST['fax']; $telefono = $_POST['telefono']; $fecha = db_date($_POST['fecha']); $sexo = $_POST['sexo']; $dni = $_POST['dni']; $user = $_POST['usr']; $sociedad = ""; $cnn = new conexion(); $query = sprintf("SELECT cc_sociedad_id FROM cecos AS cc JOIN empleado AS e ON e.idcentrocosto=cc.cc_id JOIN usuario AS u ON e.idfwk_usuario=u.u_id WHERE u.u_id='%s'", $user); $rst = $cnn->consultar($query); while ($fila = mysql_fetch_assoc($rst)) { $sociedad = sprintf("%s", $fila['cc_sociedad_id']); } $sql = "SELECT pro_id FROM proveedores WHERE pro_nif = '{$nfi}' AND pro_sociedad = '{$sociedad}'"; $res = $cnn->consultar($sql); $tot = mysql_num_rows($res); if (!$tot) { $proveedor = new Proveedor();
# -------------------------------------------------------- require_once 'core.php'; $t_core_path = config_get('core_path'); require_once $t_core_path . 'version_api.php'; form_security_validate('manage_proj_ver_copy'); auth_reauthenticate(); $f_project_id = gpc_get_int('project_id'); $f_other_project_id = gpc_get_int('other_project_id'); $f_copy_from = gpc_get_bool('copy_from'); $f_copy_to = gpc_get_bool('copy_to'); access_ensure_project_level(config_get('manage_project_threshold'), $f_project_id); access_ensure_project_level(config_get('manage_project_threshold'), $f_other_project_id); if ($f_copy_from) { $t_src_project_id = $f_other_project_id; $t_dst_project_id = $f_project_id; } else { if ($f_copy_to) { $t_src_project_id = $f_project_id; $t_dst_project_id = $f_other_project_id; } else { trigger_error(ERROR_VERSION_NO_ACTION, ERROR); } } $t_rows = version_get_all_rows($t_src_project_id); foreach ($t_rows as $t_row) { if (version_is_unique($t_row['version'], $t_dst_project_id)) { version_add($t_dst_project_id, $t_row['version'], $t_row['released'], $t_row['description'], db_date($t_row['date_order'])); } } form_security_purge('manage_proj_ver_copy'); print_header_redirect('manage_proj_edit_page.php?project_id=' . $f_project_id);
?> - <?php echo $z01_cep; ?> - <?php echo $z01_uf; ?> </td> </tr> <tr> <td class="tabfonte" width="19%" nowrap><strong>Data Inicio:</strong></td> <td class="tabfonte" width="81%"> <?php echo db_date($q02_dtinic, '/'); ?> </td> </tr> <?php for ($contador = 0; $contador < pg_numrows($result); $contador++) { db_fieldsmemory($result, $contador); ?> <?php } ?> </table></td> </tr> </table></td>
* AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE * ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE * LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE * POSSIBILITY OF SUCH DAMAGE. */ $last_update_ts = START_TIME; if (!empty($timer_data)) { $last_update_ts = $timer_data[0]; } $last_update = db_date($last_update_ts); /** * Check for new and updated account records since this timer last ran */ $res = db_query('select account_id, name, update_date ' . 'from accounts ' . "where create_date >= '{$last_update}' or update_date >= '{$last_update}'", false); while ($row = mysql_fetch_assoc($res)) { $account = $this->getAccount($row['name']); if (!$account) { /** * We've never seen this account before, so load it into memory and associate * it with any users who are using it. */ $account = new DB_User($row['account_id']); $account_key = strtolower($account->getName()); $this->accounts[$account_key] = $account; /**
function reporteSAT($fechainicial, $fechafinal, $idempresa) { global $database_f4, $f4; $result = array(); $CRITERIOG = ""; $CRITERIOCAN = ""; $CRITERIOGi = ""; if (isset($fechainicial) && $fechainicial != "") { $CRITERIOG .= " AND ((timestampemision >='" . db_date($fechainicial, 0, 0) . " 00:00:00'"; $CRITERIOGi .= " AND (fecha >='" . db_date($fechainicial, 0, 0) . " 00:00:00'"; $CRITERIOCAN = " OR (fechacancelacion>='" . db_date($fechainicial, 0, 0) . " 00:00:00')"; } if (isset($fechafinal) && $fechafinal != "") { $CRITERIOG .= " AND timestampemision <='" . db_date($fechafinal, 0, 0) . " 23:59:59')"; $CRITERIOGi .= " AND fecha <='" . db_date($fechafinal, 0, 0) . " 23:59:59')"; $CRITERIOCAN .= " AND fechacancelacion <='" . db_date($fechafinal, 0, 0) . " 23:59:59')"; } mysql_select_db($database_f4, $f4); $sqlReporte = sprintf("select rfccliente,serie,folio,cast(folio as unsigned) as folioint, noaprob,anoaprob, timestampemision >= '%s 00:00:00' as mismomes,\r\n date_format(timestampemision,'%%d/%%m/%%Y %%T') as timestampemision,monto,iva,facturas.estatus,fechacancelacion,\r\n fechacancelacion>'%s' as postcancela, tipocfd, empresa.rfc\r\n from facturas inner join empresa on (empresa.idempresa=facturas.idempresa) \r\n where facturas.idempresa=%s " . $CRITERIOG . " " . $CRITERIOCAN . " ORDER BY serie ASC, folioint ASC", db_date($fechainicial, 0, 0), db_date($fechafinal, 0, 0), $idempresa); $facturasg = mysql_query($sqlReporte, $f4) or die(__LINE__ . mysql_error()); $row_facturasg = mysql_fetch_assoc($facturasg); $totalRows_facturasg = mysql_num_rows($facturasg); $tmpToken = date('mY', strtotime(db_date($fechainicial, 0, 0))); $plain = "1" . $row_facturasg['rfc'] . $tmpToken . ".txt"; //$fp=fopen($plain,"w+"); $data = ""; if ($totalRows_facturasg > 0) { do { //iva excento no lleva valor. $valorIVA = number_format(abs($row_facturasg['iva']), 2, ".", ""); //tipo documento $TIPOCFD = "I"; if ($row_facturasg['tipocfd'] == 3) { $TIPOCFD = "E"; } if ($valorIVA < 0) { $valorIVA = ""; } //fputs($fp,print_r($row_facturasg,true)); if ($row_facturasg['postcancela'] == 1) { //la factura fue cancelada posterior a la fecha del reporte. $line = "|" . $row_facturasg['rfccliente'] . "|" . $row_facturasg['serie'] . "|" . intval($row_facturasg['folio']) . "|" . $row_facturasg['anoaprob'] . $row_facturasg['noaprob'] . "|" . $row_facturasg['timestampemision'] . "|" . number_format($row_facturasg['monto'], 2, ".", "") . "|" . $valorIVA . "|0|"; $line .= $TIPOCFD . "||||\n"; $data .= $line; } else { //registros cancelados en este mismo mes requieren de doble registro. if ($row_facturasg['estatus'] == 0) { $fechacfd = strtotime($row_facturasg['timestampemision']); $fechareporte = strtotime(db_date($fechainicial, 0, 0)); if ($row_facturasg['mismomes'] > 0) { $line = "|" . $row_facturasg['rfccliente'] . "|" . $row_facturasg['serie'] . "|" . intval($row_facturasg['folio']) . "|" . $row_facturasg['anoaprob'] . $row_facturasg['noaprob'] . "|" . $row_facturasg['timestampemision'] . "|" . number_format($row_facturasg['monto'], 2, ".", "") . "|" . $valorIVA . "|1|"; $line .= $TIPOCFD . "||||\n"; $data .= $line; } } $line = "|" . $row_facturasg['rfccliente'] . "|" . $row_facturasg['serie'] . "|" . intval($row_facturasg['folio']) . "|" . $row_facturasg['anoaprob'] . $row_facturasg['noaprob'] . "|" . $row_facturasg['timestampemision'] . "|" . number_format($row_facturasg['monto'], 2, ".", "") . "|" . $valorIVA . "|" . $row_facturasg['estatus'] . "|"; $line .= $TIPOCFD . "||||\n"; $data .= $line; } } while ($row_facturasg = mysql_fetch_assoc($facturasg)); $download = true; } $result['archivo'] = $plain; $result['data'] = $data; return $result; }
$summary[$job_type]['count']++; if ($job['is_error']) { $summary[$job_type]['errors']++; } $summary[$job_type]['last'] = $job['executed_at']; $sample_size++; } } crypto_log(print_r($summary, true)); // update the database // delete very old updates $q = db()->prepare("DELETE FROM external_status WHERE DATE_ADD(created_at, INTERVAL 30 DAY) < NOW()"); $q->execute(); // other statuses are marked as old $q = db()->prepare("UPDATE external_status SET is_recent=0"); $q->execute(); foreach ($summary as $key => $data) { $q = db()->prepare("INSERT INTO external_status SET is_recent=1, job_type=:key, job_count=:count, job_errors=:errors, job_first=:first, job_last=:last, sample_size=:sample_size"); $q->execute(array("key" => $key, "count" => $data['count'], "errors" => $data['errors'], "first" => db_date($data['first']), "last" => db_date($data['last']), "sample_size" => $sample_size)); // if there are no external_status_types for this job_type, insert one in $q = db()->prepare("SELECT * FROM external_status_types WHERE job_type=? LIMIT 1"); $q->execute(array($key)); if (!$q->fetch()) { crypto_log("No external_status_types found for job_type '" . htmlspecialchars($key) . "': inserting new mapping"); $q = db()->prepare("INSERT INTO external_status_types SET job_type=?"); $q->execute(array($key)); } // TODO add is_daily_data flag, summarise data through cleanup, etc } crypto_log("Complete from " . number_format($sample_size) . " job samples into " . number_format(count($summary)) . " summary values."); batch_footer();