function crearItemsDeCarga($id)
{
begin();
if ($this->cargaExists($id)) {
if (!$this->eliminarItemsDeCarga($id)) {
rollback();
}
}
$sql = "INSERT INTO cargas (id_reparto, id_producto, cantidad, fecha_update)\n SELECT t1.id_reparto, \n t4.id_producto,\n SUM(t3.cantidad_detalle_venta) cantidad,\n NOW()\n FROM repartos t1\n INNER JOIN ventas t2 ON t1.id_reparto=t2.id_reparto\n INNER JOIN detalle_ventas t3 ON t2.id_venta=t3.id_venta\n INNER JOIN productos t4 ON t3.id_producto=t4.id_producto\n WHERE t1.id_reparto != 1 AND t1.id_reparto = {$id}\n GROUP BY t4.id_producto\n ORDER BY detalle_producto";
if (!mysql_query($sql)) {
die('Error: ' . mysql_error());
rollback();
return false;
} else {
commit();
return true;
}
}
function begin()
{
echo "\r\n+------------------------\r\n| [ 1 ] 生成Model \r\n| [ 2 ] 生成Action \r\n| [ 0 ] 退出\r\n+------------------------\r\n输入数字选择:";
$number = trim(fgets(STDIN, 256));
//fscanf(STDIN, "%d\n", $number); // 从 STDIN 读取数字
switch ($number) {
case 0:
break;
case 1:
echo "输入Model名称[例如 User，留空生成当前数据库的全部Model类 ]:";
$model = trim(fgets(STDIN, 256));
if (strpos($model, ',')) {
echo "批量生成Model...\n";
$models = explode(',', $model);
foreach ($models as $model) {
buildModel($model);
}
} else {
// 生成指定的Model类
buildModel($model);
}
begin();
break;
case 2:
// 生成指定的Action类
echo "输入Action名称[例如 User ]:";
$action = trim(fgets(STDIN, 256));
buildAction($action);
begin();
break;
default:
begin();
}
}
function insert_sql_data( $db_conn, $p_campaigns, $p_headers, $p_details )
// insert the header and detail data into the file
// with appropriate safeguards to ensure full
// completion or rollback of the transaction.
{
GLOBAL $msg_log;
$success = TRUE;
// Wrap all this in a transaction
// First, turn off autocommit
$qry = "set autocommit=0";
//pre_echo( $qry );
$success = mysql_query( $qry, $db_conn );
// Second, take care of all ALTER TABLE queries. Due to a (documented)
// glitch in MySQL, these commands force a transaction to commit,
// which sucks.
if ($success)
{ // Create the temp_header table
$qry = "CREATE TEMPORARY TABLE temp_header LIKE contract_header";
//pre_echo( $qry );
$success = mysql_query( $qry, $db_conn );
if (!$success)
{
message_log_append( $msg_log, mysql_error( $db_conn ), MSG_LOG_ERROR );
}
}
if ($success)
{ // Create the temp_detail table
$qry = "CREATE TEMPORARY TABLE temp_detail LIKE contract_detail";
//pre_echo( $qry );
$success = mysql_query( $qry, $db_conn );
if (!$success)
{
message_log_append( $msg_log, mysql_error( $db_conn ), MSG_LOG_ERROR );
}
}
if ($success)
{ // Delete the Seq field from table temp_header
$qry = "ALTER TABLE temp_header DROP COLUMN Seq";
//pre_echo( $qry );
$success = mysql_query( $qry, $db_conn );
if (!$success)
{
message_log_append( $msg_log, mysql_error( $db_conn ), MSG_LOG_ERROR );
}
}
if ($success)
{ // Delete the Line column from table temp_detail
$qry = "ALTER TABLE temp_detail DROP COLUMN Line";
//pre_echo( $qry );
$success = mysql_query( $qry, $db_conn );
if (!$success)
{
message_log_append( $msg_log, mysql_error( $db_conn ), MSG_LOG_ERROR );
}
}
// loop through the campaigns, headers, and details to insert the
// data into the SQL database. Keep solid track of all error
// results so that we can ROLLBACK on any error.
if ($success)
{
//echo "<pre>";
//var_dump( $p_campaigns ); echo "</pre><br>";
$success = begin( $db_conn );
if (!$success)
{
message_log_append( $msg_log, "Error in START TRANSACTION: " . mysql_error( $db_conn ), MSG_LOG_ERROR );
}
}
// do the work here, and keep track of $success
// If we need to create a new agency record, do that here.
$new_agency = FALSE;
if ($success && is_null( $p_campaigns[0][ 'Agency Record' ]))
{
$agent_name = $p_campaigns[0][ 'Agency Name' ];
$rate = DEFAULT_AGENCY_RATE / 10;
if ($success = agency_insert( $db_conn, $agent_name, $rate, $aindex ))
{
$p_campaigns[0][ 'Agency Record' ] = agency_record( $agent_name, OPERATOR_NAME );
$success = !is_null( $p_campaigns[0][ 'Agency Record' ]);
} // if agency_insert
if ($success)
{
$new_agency = TRUE;
message_log_append( $msg_log, "Agency created: " .
"Seq = $aindex, Name = '$agent_name'", MSG_LOG_WARNING );
}
else
{
message_log_append( $msg_log, "Error while creating " . "Agency '$agent_name': " . mysql_error( $db_conn ), MSG_LOG_ERROR );
}
} // if null agency record
// If we need to create a new customer record, do that here.
$new_customer = FALSE;
if ($success && is_null( $p_campaigns[0][ 'Customer Record' ]))
{
$cust_name = $p_campaigns[0][ 'Customer Name' ];
$rate = DEFAULT_CUST_DISCOUNT;
if ($success = customer_insert( $db_conn, $cust_name, $rate, $cindex ))
{
$p_campaigns[0][ 'Customer Record' ] = cust_record( $cust_name, OPERATOR_NAME );
$success = !is_null( $p_campaigns[0][ 'Customer Record' ]);
} // if customer_insert
if ($success)
{
$new_customer = TRUE;
message_log_append( $msg_log, "Customer created: " . "Seq = $cindex, Name = '$cust_name'", MSG_LOG_WARNING );
}
else
{
message_log_append( $msg_log, "Error while creating " . "Customer '$cust_name' " . mysql_error( $db_conn ), MSG_LOG_ERROR );
}
} // if null customer record
if ($success)
{
// build the list of header fields, in order with 'quote required' flag
// [n][0] is field name, [n][1] is boolean T=quote required, F=not
$hdr_flds = build_header_field_array();
// A SQL INSERT statement lead-in
$hdr_sql = "INSERT INTO temp_header ( ";
$hdr_sql .= fld_list( $hdr_flds ) . ") VALUES\n";
// build the list of detail fields, in order with 'quote required' flag
// [n][0] is field name, [n][1] is boolean T=quote required, F=not
$det_flds = build_detail_field_array();
// A SQL INSERT statement lead-in
$det_sql = "INSERT INTO temp_detail ( ";
$det_sql .= fld_list( $det_flds ) . ") VALUES ";
// Here we go. We'll loop through each contract header record,
// and its accompanying detail records.
$n_inserted = 0;
while ($success && (list( $key ) = each( $p_headers )))
{
if (count( $p_details[ $key ] ) > 0)
{
// If we created a new agency or customer above, update
// the respective header fields.
if ($new_customer)
{
$p_headers[ $key ][ 'CIndex' ] = $cindex;
$p_headers[ $key ][ 'Discount' ] = $p_campaigns[0][ 'Customer Record' ][ 'Discount' ];
}
if ($new_agency)
{
$p_headers[ $key ][ 'AIndex' ] = $aindex;
$p_headers[ $key ][ 'AgencyComm' ] = $p_campaigns[0][ 'Agency Record' ][ 'Rate' ];
}
$row = data_values( $hdr_flds, $p_headers[ $key ] );
$sql_header = $hdr_sql; // INSERT INTO ... VALUES
$sql_header .= "(" . $row . ");";
$rows = "";
foreach ($p_details[ $key ] as $line)
{
$rows .= ",\n( " . data_values( $det_flds, $line ) . " )";
}
$rows = substr( $rows, 1 ); // remove comma-newline
$sql_detail = $det_sql; // INSERT INTO ... VALUES
$sql_detail .= $rows;
if ($success = do_insert( $db_conn, $sql_header, $sql_detail ))
{
$n_inserted++;
}
} // if detail count > 0
} // while success and each key
} // if success
if ($success)
{
$success = commit( $db_conn );
if ($success)
{
message_log_append( $msg_log, "$n_inserted contract" . ($n_inserted == 1 ? '' : 's') . " imported" );
}
else
{
message_log_append( $msg_log, "Error in COMMIT TRANSACTION: " . mysql_error( $db_conn ), MSG_LOG_ERROR );
if (!rollback( $db_conn ))
{
message_log_append( $msg_log, "Error in ROLLBACK TRANSACTION: " . mysql_error( $db_conn ), MSG_LOG_ERROR );
}
}
}
else
{
if (!rollback( $db_conn ))
{
message_log_append( $msg_log, "Error in ROLLBACK TRANSACTION: " . mysql_error( $db_conn ), MSG_LOG_ERROR );
}
} // if success
return( $success );
} // insert_sql_data
function save($oData)
{
if (!$oData["id_orden_compra"]) {
begin();
$detalle = array();
$cabecera = array();
$cabecera = explode("@@", $oData["cabecera"]);
$detalle = explode("||", $oData["detalle"]);
$sql = "INSERT INTO ordenes_compra (id_proveedor, fecha_orden_compra, nro_orden_compra, generada)\r\n\t\t\t\t\tVALUES (" . $cabecera[0] . ", '" . dateToMySQL($cabecera[1]) . "', " . $cabecera[2] . ", 1)";
if (!mysql_query($sql)) {
die('Error: ' . mysql_error());
rollback();
return false;
} else {
$id = mysql_insert_id();
foreach ($detalle as $detail) {
$values = explode("@@", $detail);
$sql = "INSERT INTO detalle_ordenes_compra (id_orden_compra, id_producto, cantidad_detalle_orden_compra) VALUES (" . $id . ", " . $values[0] . ", " . $values[1] . ")";
if (!mysql_query($sql)) {
die('Error: ' . mysql_error());
rollback();
break;
}
}
if ($cabecera[2]) {
$nroVta = $cabecera[2] + 1;
}
$sql = "UPDATE parametros SET valor_parametro = " . $nroVta . " WHERE nombre_parametro='nro_orden_compra'";
if (!mysql_query($sql)) {
die('Error: ' . mysql_error());
rollback();
break;
} else {
commit();
return true;
}
return false;
}
} else {
$sql = "delete from detalle_ordenes_compra where id_orden_compra=" . $oData["id_orden_compra"];
getRS($sql);
$sql = "delete from ordenes_compra where id_orden_compra=" . $oData["id_orden_compra"];
getRS($sql);
begin();
$detalle = array();
$cabecera = array();
$cabecera = explode("@@", $oData["cabecera"]);
$detalle = explode("||", $oData["detalle"]);
$sql = "INSERT INTO ordenes_compra (id_proveedor, fecha_orden_compra, nro_orden_compra, generada)\r\n\t\t\t\t\tVALUES (" . $cabecera[0] . ", '" . dateToMySQL($cabecera[1]) . "', " . $cabecera[2] . ", 1)";
if (!mysql_query($sql)) {
die('Error: ' . mysql_error());
rollback();
return false;
} else {
$id = mysql_insert_id();
foreach ($detalle as $detail) {
$values = explode("@@", $detail);
$sql = "INSERT INTO detalle_ordenes_compra (id_orden_compra, id_producto, cantidad_detalle_orden_compra) VALUES (" . $id . ", " . $values[0] . ", " . $values[1] . ")";
if (!mysql_query($sql)) {
die('Error: ' . mysql_error());
rollback();
break;
}
}
if ($cabecera[2]) {
$nroVta = $cabecera[2] + 1;
}
$sql = "UPDATE parametros SET valor_parametro = " . $nroVta . " WHERE nombre_parametro='nro_orden_compra'";
if (!mysql_query($sql)) {
die('Error: ' . mysql_error());
rollback();
break;
} else {
commit();
return true;
}
return false;
}
}
}
function begin($startX, $startY)
{
if ($startY > 0 && $startY == $startX) {
begin($startY - 1, $startY - 1, $board);
}
if ($startX > 0) {
begin($startX - 1, $startY, $board);
}
$board = newBoard();
$board[$startY][$startX] = 1;
//the first move location will be "1"
echo "Starting at: (" . $startY . "," . $startX . ")\n";
$solution = solve($board, $startY, $startX, 2);
}
function do_install()
{
// {{{
if (isset($_POST['database_type']) && isset($_POST['database_host']) && isset($_POST['database_user']) && isset($_POST['database_name'])) {
global $database_dsn;
$database_dsn = "{$_POST['database_type']}:user={$_POST['database_user']};password={$_POST['database_password']};host={$_POST['database_host']};dbname={$_POST['database_name']}";
install_process();
} else {
if (file_exists("auto_install.conf")) {
install_process(trim(file_get_contents("auto_install.conf")));
unlink("auto_install.conf");
} else {
begin();
}
}
}
public function rewind()
{
begin($this->_config);
}
function lexer_performAction(&$yy, $yy_, $avoiding_name_collisions, $YY_START = null)
{
$YYSTATE = $YY_START;
switch ($avoiding_name_collisions) {
case 0:
return 15;
break;
case 1:
return 15;
break;
case 2:
this . popState();
this . begin('STRING');
return 11;
break;
case 3:
this . popState();
return 15;
break;
case 4:
this . begin('SINGLE_QUOTE_ON');
return 'SINGLE_QUOTE_ON';
break;
case 5:
this . begin('SINGLE_QUOTE_ON');
return 10;
break;
case 6:
return 15;
break;
case 7:
return 15;
break;
case 8:
this . popState();
this . begin('STRING');
return 11;
break;
case 9:
this . popState();
return 15;
break;
case 10:
this . begin('DOUBLE_QUOTE_ON');
return 10;
break;
case 11:
this . begin('DOUBLE_QUOTE_ON');
return 10;
break;
case 12:
return 14;
break;
case 13:
this . popState();
return 7;
break;
case 14:
this . popState();
return 13;
break;
case 15:
return 12;
break;
case 16:
return 15;
break;
case 17:
return 15;
break;
case 18:
return 15;
break;
case 19:
return 15;
break;
case 20:
return 8;
break;
case 21:
this . begin('STRING');
return 15;
break;
case 22:
return 5;
break;
}
}
<?php
/*
* The MIT License
*
* Copyright 2015 ekow.
*
* Permission is hereby granted, free of charge, to any person obtaining a copy
* of this software and associated documentation files (the "Software"), to deal
* in the Software without restriction, including without limitation the rights
* to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
* copies of the Software, and to permit persons to whom the Software is
* furnished to do so, subject to the following conditions:
*
* The above copyright notice and this permission notice shall be included in
* all copies or substantial portions of the Software.
*
* THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
* IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
* FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
* AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
* LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
* OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
* THE SOFTWARE.
*/
begin()->table('some_table')->column('id')->type('integer')->nulls(false)->column('some_field')->type('string')->column('another_field')->type('string')->primaryKey('id')->autoIncrement()->end();
function saveIndiceEstacional($oData)
{
begin();
$sql = "SELECT * FROM indices_estacionales WHERE id_producto = " . $oData["id_producto"];
$result = getRS($sql);
if (!getNrosRows($result)) {
$dur_periodo = $this->getDuracionPeriodo();
$cant_dias_anio = date("z", mktime(0, 0, 0, 12, 31, date("Y"))) + 1;
$periodo_x_anio = number_format($cant_dias_anio / $dur_periodo);
for ($i = 0; $i < $periodo_x_anio; $i++) {
if ($i + 1 == $oData["nro_estacion"]) {
$sql = "INSERT INTO indices_estacionales (id_producto, orden, valor) VALUES (" . $oData["id_producto"] . "," . ($i + 1) . ", " . $oData["indice_estacional"] . ")";
} else {
$sql = "INSERT INTO indices_estacionales (id_producto, orden) VALUES (" . $oData["id_producto"] . "," . ($i + 1) . ")";
}
$rs = getRS($sql);
if (!$rs) {
die('Error: ' . mysql_error());
rollback();
} else {
commit();
}
}
} else {
$sql = "SELECT * FROM indices_estacionales WHERE id_producto = " . $oData["id_producto"] . " and orden = " . $oData["nro_estacion"];
$result = getRS($sql);
if (!getNrosRows($result)) {
$sql = "INSERT INTO indices_estacionales (id_producto, orden, valor) VALUES (" . $oData["id_producto"] . "," . $oData["nro_estacion"] . ", " . $oData["indice_estacional"] . ")";
$rs = getRS($sql);
if (!$rs) {
die('Error: ' . mysql_error());
rollback();
}
} else {
$sql = "UPDATE indices_estacionales SET valor = " . $oData["indice_estacional"] . " WHERE id_producto = " . $oData["id_producto"] . " AND orden = " . $oData["nro_estacion"];
$rs = getRS($sql);
if (!$rs) {
die('Error: ' . mysql_error());
rollback();
}
}
}
}
<?php
/*
* The MIT License
*
* Copyright 2014 ekow.
*
* Permission is hereby granted, free of charge, to any person obtaining a copy
* of this software and associated documentation files (the "Software"), to deal
* in the Software without restriction, including without limitation the rights
* to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
* copies of the Software, and to permit persons to whom the Software is
* furnished to do so, subject to the following conditions:
*
* The above copyright notice and this permission notice shall be included in
* all copies or substantial portions of the Software.
*
* THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
* IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
* FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
* AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
* LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
* OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
* THE SOFTWARE.
*/
begin()->table('users')->column('branch_id')->type('integer')->nulls(true)->column('picture_id')->type('integer')->nulls(true)->column('department_id')->type('integer')->nulls(true)->column('phone')->type('string')->nulls(true)->column('email')->type('string')->nulls(false)->column('user_status')->type('double')->nulls(true)->column('other_names')->type('string')->nulls(true)->column('last_name')->type('string')->nulls(false)->column('first_name')->type('string')->nulls(false)->column('role_id')->type('integer')->nulls(true)->column('password')->type('string')->nulls(false)->column('user_name')->type('string')->nulls(false)->column('user_id')->type('integer')->nulls(false)->primaryKey('user_id')->name('user_id_pk')->autoIncrement()->unique('user_name')->name('user_name_uk')->table('roles')->column('role_name')->type('string')->nulls(true)->column('role_id')->type('integer')->nulls(false)->primaryKey('role_id')->name('role_id_pk')->autoIncrement()->table('departments')->column('department_name')->type('string')->nulls(false)->column('department_id')->type('integer')->nulls(false)->primaryKey('department_id')->name('department_id_pk')->autoIncrement()->table('temporary_roles')->column('tag')->type('string')->nulls(true)->column('original_role_id')->type('integer')->nulls(true)->column('active')->type('boolean')->nulls(true)->column('expires')->type('timestamp')->nulls(true)->column('created')->type('timestamp')->nulls(true)->column('user_id')->type('integer')->nulls(true)->column('new_role_id')->type('integer')->nulls(true)->column('temporary_role_id')->type('integer')->nulls(false)->primaryKey('temporary_role_id')->name('temporary_role_id_pk')->autoIncrement()->table('suppliers')->column('user_id')->type('integer')->nulls(true)->column('telephone')->type('string')->nulls(true)->column('address')->type('string')->nulls(true)->column('supplier_name')->type('string')->nulls(false)->column('supplier_id')->type('integer')->nulls(false)->primaryKey('supplier_id')->name('supplier_id_pk')->autoIncrement()->table('countries')->column('currency_symbol')->type('string')->nulls(true)->column('currency')->type('string')->nulls(true)->column('nationality')->type('string')->nulls(true)->column('country_code')->type('string')->nulls(true)->column('country_name')->type('string')->nulls(false)->column('country_id')->type('integer')->nulls(false)->primaryKey('country_id')->name('country_id_pk')->autoIncrement()->unique('country_name')->name('country_name_uk')->table('permissions')->column('module')->type('string')->nulls(true)->column('value')->type('double')->nulls(false)->column('permission')->type('string')->nulls(true)->column('role_id')->type('integer')->nulls(false)->column('permission_id')->type('integer')->nulls(false)->primaryKey('permission_id')->name('perm_id_pk')->autoIncrement()->table('notes')->column('user_id')->type('integer')->nulls(false)->column('item_type')->type('string')->nulls(false)->column('item_id')->type('integer')->nulls(false)->column('note_time')->type('timestamp')->nulls(false)->column('note')->type('string')->nulls(true)->column('note_id')->type('integer')->nulls(false)->primaryKey('note_id')->name('notes_note_id_pk')->autoIncrement()->table('regions')->column('country_id')->type('integer')->nulls(false)->column('name')->type('string')->nulls(false)->column('region_code')->type('string')->nulls(false)->column('region_id')->type('integer')->nulls(false)->primaryKey('region_id')->name('region_id_pk')->autoIncrement()->unique('name')->name('region_name_uk')->table('note_attachments')->column('object_id')->type('integer')->nulls(true)->column('note_id')->type('integer')->nulls(true)->column('description')->type('string')->nulls(true)->column('note_attachment_id')->type('integer')->nulls(false)->primaryKey('note_attachment_id')->name('note_attachments_pkey')->autoIncrement()->table('branches')->column('city_id')->type('integer')->nulls(true)->column('address')->type('text')->nulls(true)->column('branch_name')->type('string')->nulls(false)->column('branch_id')->type('integer')->nulls(false)->primaryKey('branch_id')->name('branches_pkey')->autoIncrement()->table('clients')->column('branch_id')->type('integer')->nulls(false)->column('marital_status')->type('double')->nulls(true)->column('gender')->type('double')->nulls(true)->column('nationality_id')->type('integer')->nulls(true)->column('company_name')->type('string')->nulls(true)->column('contact_person')->type('string')->nulls(true)->column('in_trust_for')->type('string')->nulls(true)->column('country_id')->type('integer')->nulls(true)->column('id_issue_date')->type('date')->nulls(true)->column('id_issue_place')->type('string')->nulls(true)->column('signature')->type('string')->nulls(true)->column('scanned_id')->type('string')->nulls(true)->column('picture')->type('string')->nulls(true)->column('occupation')->type('string')->nulls(true)->column('residential_status')->type('double')->nulls(true)->column('id_number')->type('string')->nulls(false)->column('id_type_id')->type('integer')->nulls(false)->column('city_id')->type('integer')->nulls(true)->column('birth_date')->type('date')->nulls(true)->column('email')->type('string')->nulls(true)->column('fax')->type('string')->nulls(true)->column('mobile')->type('string')->nulls(true)->column('contact_tel')->type('string')->nulls(true)->column('residential_address')->type('string')->nulls(true)->column('mailing_address')->type('string')->nulls(false)->column('previous_names')->type('string')->nulls(true)->column('other_names')->type('string')->nulls(true)->column('first_name')->type('string')->nulls(true)->column('surname')->type('string')->nulls(true)->column('title')->type('string')->nulls(true)->column('account_type')->type('double')->nulls(false)->column('main_client_id')->type('integer')->nulls(false)->primaryKey('main_client_id')->name('clients_main_client_id_pk')->autoIncrement()->table('identification_types')->column('id_name')->type('string')->nulls(false)->column('id_type_id')->type('integer')->nulls(false)->primaryKey('id_type_id')->name('id_type_id_pk')->autoIncrement()->table('client_users')->column('status')->type('integer')->nulls(false)->column('user_name')->type('string')->nulls(false)->column('password')->type('string')->nulls(false)->column('membership_id')->type('integer')->nulls(true)->column('main_client_id')->type('integer')->nulls(true)->column('client_user_id')->type('integer')->nulls(false)->primaryKey('client_user_id')->name('client_users_client_user_id_pk')->autoIncrement()->table('client_joint_accounts')->column('mobile')->type('string')->nulls(true)->column('id_issue_date')->type('date')->nulls(true)->column('id_issue_place')->type('string')->nulls(true)->column('id_number')->type('string')->nulls(true)->column('id_type_id')->type('integer')->nulls(true)->column('office_telephone')->type('string')->nulls(true)->column('telephone')->type('string')->nulls(true)->column('address')->type('string')->nulls(true)->column('previous_names')->type('string')->nulls(true)->column('other_names')->type('string')->nulls(true)->column('first_name')->type('string')->nulls(false)->column('surname')->type('string')->nulls(false)->column('title')->type('string')->nulls(true)->column('main_client_id')->type('integer')->nulls(false)->column('joint_account_id')->type('integer')->nulls(false)->primaryKey('joint_account_id')->name('joint_account_id_pk')->autoIncrement()->table('cities')->column('region_id')->type('integer')->nulls(false)->column('city_name')->type('string')->nulls(false)->column('city_id')->type('integer')->nulls(false)->primaryKey('city_id')->name('city_id_pk')->autoIncrement()->unique('city_name')->name('city_name_uk')->table('bank_branches')->column('sort_code')->type('string')->nulls(false)->defaultValue("0")->column('address')->type('string')->nulls(true)->column('branch_name')->type('string')->nulls(false)->column('bank_id')->type('integer')->nulls(false)->column('bank_branch_id')->type('integer')->nulls(false)->primaryKey('bank_branch_id')->name('bank_branch_id_pk')->autoIncrement()->table('banks')->column('swift_code')->type('string')->nulls(true)->defaultValue("0")->column('bank_code')->type('string')->nulls(false)->defaultValue("0")->column('bank_name')->type('string')->nulls(false)->column('bank_id')->type('integer')->nulls(false)->primaryKey('bank_id')->name('bank_id_pk')->autoIncrement()->unique('bank_name')->name('bank_name_uk')->table('api_keys')->column('secret')->type('string')->nulls(false)->column('key')->type('string')->nulls(false)->column('active')->type('boolean')->nulls(false)->column('user_id')->type('integer')->nulls(false)->column('api_key_id')->type('integer')->nulls(false)->primaryKey('api_key_id')->name('api_keys_pkey')->autoIncrement()->table('relationships')->column('relationship_name')->type('string')->nulls(false)->column('relationship_id')->type('integer')->nulls(false)->primaryKey('relationship_id')->name('relationship_id_pk')->autoIncrement()->table('notifications')->column('subject')->type('string')->nulls(true)->column('email')->type('text')->nulls(true)->column('sms')->type('text')->nulls(true)->column('tag')->type('string')->nulls(true)->column('notification_id')->type('integer')->nulls(false)->primaryKey('notification_id')->name('notifications_pkey')->autoIncrement()->table('holidays')->column('holiday_date')->type('date')->nulls(false)->column('name')->type('string')->nulls(false)->column('holiday_id')->type('integer')->nulls(false)->primaryKey('holiday_id')->name('holidays_holiday_id_pk')->autoIncrement()->table('configurations')->column('value')->type('string')->nulls(true)->column('key')->type('string')->nulls(true)->column('configuration_id')->type('integer')->nulls(false)->primaryKey('configuration_id')->name('configuration_id_pk')->autoIncrement()->unique('key')->name('key_uk')->table('cheque_formats')->column('data')->type('text')->nulls(false)->column('description')->type('string')->nulls(false)->column('cheque_format_id')->type('integer')->nulls(false)->primaryKey('cheque_format_id')->name('cheque_formats_cheque_format_id_pk')->autoIncrement()->table('binary_objects')->column('data')->type('blob')->nulls(true)->column('object_id')->type('integer')->nulls(false)->primaryKey('object_id')->name('binary_objects_pkey')->autoIncrement()->table('audit_trail_data')->column('data')->type('text')->nulls(true)->column('audit_trail_id')->type('integer')->nulls(false)->column('audit_trail_data_id')->type('integer')->nulls(false)->primaryKey('audit_trail_data_id')->name('audit_trail_data_id_pk')->autoIncrement()->index('audit_trail_id')->name('audit_trail_id_idx')->table('audit_trail')->column('data')->type('text')->nulls(true)->column('type')->type('double')->nulls(false)->column('audit_date')->type('timestamp')->nulls(false)->column('description')->type('string')->nulls(false)->column('item_type')->type('string')->nulls(false)->column('item_id')->type('integer')->nulls(false)->column('user_id')->type('integer')->nulls(false)->column('audit_trail_id')->type('integer')->nulls(false)->primaryKey('audit_trail_id')->name('audit_trail_audit_id_pk')->autoIncrement()->index('item_id')->name('audit_trail_item_id_idx')->table('locations')->column('address')->type('string')->nulls(true)->column('name')->type('string')->nulls(true)->column('location_id')->type('integer')->nulls(false)->primaryKey('location_id')->name('location_id_pk')->autoIncrement()->view('users_view')->definition("SELECT * FROM users JOIN roles USING (role_id)")->view('countries_view')->definition("SELECT * FROM countries JOIN regions USING (country_id)")->table('users')->foreignKey('branch_id')->references(reftable('branches'))->columns('branch_id')->table('users')->foreignKey('department_id')->references(reftable('departments'))->columns('department_id')->table('users')->foreignKey('role_id')->references(reftable('roles'))->columns('role_id')->name('users_role_id_fk')->table('temporary_roles')->foreignKey('new_role_id')->references(reftable('roles'))->columns('role_id')->name('temporary_rol_new_role_id_fk')->table('temporary_roles')->foreignKey('original_role_id')->references(reftable('roles'))->columns('role_id')->name('temporary_rol_orig_role_id_fk')->table('temporary_roles')->foreignKey('user_id')->references(reftable('users'))->columns('user_id')->name('temporary_roles_user_id_fk')->table('suppliers')->foreignKey('user_id')->references(reftable('users'))->columns('user_id')->name('suppliers_user_id_fk')->table('permissions')->foreignKey('role_id')->references(reftable('roles'))->columns('role_id')->name('permissios_role_id_fk')->table('notes')->foreignKey('user_id')->references(reftable('users'))->columns('user_id')->name('notes_user_id_fk')->table('regions')->foreignKey('country_id')->references(reftable('countries'))->columns('country_id')->name('regions_country_id_fk')->table('note_attachments')->foreignKey('note_id')->references(reftable('notes'))->columns('note_id')->name('note_attachments_note_id_fkey')->table('clients')->foreignKey('branch_id')->references(reftable('branches'))->columns('branch_id')->name('clients_branch_id_fkey')->table('clients')->foreignKey('city_id')->references(reftable('cities'))->columns('city_id')->name('clients_city_id_fk')->table('clients')->foreignKey('country_id')->references(reftable('countries'))->columns('country_id')->name('clients_country_id_fk')->table('clients')->foreignKey('id_type_id')->references(reftable('identification_types'))->columns('id_type_id')->name('clients_id_type_id_fk')->table('clients')->foreignKey('nationality_id')->references(reftable('countries'))->columns('country_id')->name('clients_nationality_id_fk')->table('client_users')->foreignKey('main_client_id')->references(reftable('clients'))->columns('main_client_id')->name('client_users_main_client_id_fk')->table('client_joint_accounts')->foreignKey('id_type_id')->references(reftable('identification_types'))->columns('id_type_id')->name('client_joint_id_type_id_fk')->table('client_joint_accounts')->foreignKey('main_client_id')->references(reftable('clients'))->columns('main_client_id')->name('client_joint_main_client_id_fk')->table('cities')->foreignKey('region_id')->references(reftable('regions'))->columns('region_id')->name('cities_region_id_fk')->table('bank_branches')->foreignKey('bank_id')->references(reftable('banks'))->columns('bank_id')->name('branch_bank_id_fk')->table('api_keys')->foreignKey('user_id')->references(reftable('users'))->columns('user_id')->name('api_keys_user_id_fkey')->end();
function file_begin($filename)
{
return begin(explode(".", $filename));
}
//Verificando que la conexion se haya hecho a la BD
if (!$conexion_base) {
die ('No se encuentra la base de datos seleccionada : ' . mysql_error());
}
$lNumber = $_POST['leaseNum'];
$sDate = $_POST['sDate'];
$eDate = $_POST['eDate'];
$duration = $_POST['duration'];
$studentID = $_POST['student'];
$placeNum = $_POST['room'];
$contrato = "INSERT INTO Lease VALUES ('$lNumber', '$sDate', '$eDate', '$duration', '$studentID', '$placeNum')";
begin(); // Empieza la transaccion
$result = mysql_query($contrato);
if(!$result) {
rollback(); // Si hubo un error se le da rollback
echo 'Hubo un error';
exit;
}
else {
commit(); //Si fue exitosa se lleva a cabo
echo 'Operación realizada con éxito';
}
function do_install()
{
// {{{
if (isset($_POST['database_dsn'])) {
install_process($_POST['database_dsn']);
} else {
if (file_exists("auto_install.conf")) {
install_process(trim(file_get_contents("auto_install.conf")));
unlink("auto_install.conf");
} else {
begin();
}
}
}
<?php
/*
* The MIT License
*
* Copyright 2014 ekow.
*
* Permission is hereby granted, free of charge, to any person obtaining a copy
* of this software and associated documentation files (the "Software"), to deal
* in the Software without restriction, including without limitation the rights
* to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
* copies of the Software, and to permit persons to whom the Software is
* furnished to do so, subject to the following conditions:
*
* The above copyright notice and this permission notice shall be included in
* all copies or substantial portions of the Software.
*
* THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
* IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
* FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
* AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
* LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
* OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
* THE SOFTWARE.
*/
begin()->table('roles')->column('role_name')->type('string')->nulls(false)->table('users')->column('user_name')->rename('username')->end();
<html>
<body>
<?php
$scriptName = "ViewUserInfo.php";
include "PHPprinter.php";
$startTime = getMicroTime();
$userId = $HTTP_POST_VARS['userId'];
if ($userId == null) {
$userId = $HTTP_GET_VARS['userId'];
if ($userId == null) {
printError($scriptName, $startTime, "Viewing user information", "You must provide an item identifier!<br>");
exit;
}
}
getDatabaseLink($link);
begin($link);
$userResult = mysql_query("SELECT * FROM users WHERE users.id={$userId}", $link) or die("ERROR: Query failed");
if (mysql_num_rows($userResult) == 0) {
commit($link);
die("<h3>ERROR: Sorry, but this user does not exist.</h3><br>\n");
}
printHTMLheader("RUBiS: View user information");
// Get general information about the user
$userRow = mysql_fetch_array($userResult);
$firstname = $userRow["firstname"];
$lastname = $userRow["lastname"];
$nickname = $userRow["nickname"];
$email = $userRow["email"];
$creationDate = $userRow["creation_date"];
$rating = $userRow["rating"];
print "<h2>Information about " . $nickname . "<br></h2>";
<?php
/*
* The MIT License
*
* Copyright 2015 ekow.
*
* Permission is hereby granted, free of charge, to any person obtaining a copy
* of this software and associated documentation files (the "Software"), to deal
* in the Software without restriction, including without limitation the rights
* to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
* copies of the Software, and to permit persons to whom the Software is
* furnished to do so, subject to the following conditions:
*
* The above copyright notice and this permission notice shall be included in
* all copies or substantial portions of the Software.
*
* THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
* IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
* FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
* AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
* LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
* OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
* THE SOFTWARE.
*/
begin()->table('some_table')->rename('some_other_table')->end();
// can change row on a different page without unique key
if (!$result) {
break;
}
$affected += $connection->affected_rows;
}
queries_redirect(remove_from_uri(), lang('%d item(s) have been affected.', $affected), $result);
}
} elseif (is_string($file = get_file("csv_file", true))) {
//! character set
cookie("adminer_import", "output=" . urlencode($adminer_import["output"]) . "&format=" . urlencode($_POST["separator"]));
$result = true;
$cols = array_keys($fields);
preg_match_all('~(?>"[^"]*"|[^"\\r\\n]+)+~', $file, $matches);
$affected = count($matches[0]);
begin();
$separator = $_POST["separator"] == "csv" ? "," : ($_POST["separator"] == "tsv" ? "\t" : ";");
foreach ($matches[0] as $key => $val) {
preg_match_all("~((\"[^\"]*\")+|[^{$separator}]*){$separator}~", $val . $separator, $matches2);
if (!$key && !array_diff($matches2[1], $cols)) {
//! doesn't work with column names containing ",\n
// first row corresponds to column names - use it for table structure
$cols = $matches2[1];
$affected--;
} else {
$set = array();
foreach ($matches2[1] as $i => $col) {
$set[idf_escape($cols[$i])] = $col == "" && $fields[$cols[$i]]["null"] ? "NULL" : q(str_replace('""', '"', preg_replace('~^"|"$~', '', $col)));
}
$result = insert_update($TABLE, $set, $primary);
if (!$result) {
function executePolitica_SR()
{
$sql = "SELECT *\r\n\t\t\t\tFROM productos p\r\n\t\t\t\t INNER JOIN agotamientos_permitidos ap\r\n\t\t\t\t\tON ap.id_agotamiento = p.id_agotamiento\r\n\t\t\t\tWHERE id_politica = 2";
$rs = getRS($sql);
if (getNrosRows($rs)) {
$flag = false;
while ($row = getRow($rs)) {
$sql = "SELECT *\r\n\t\t\t\t\t\tFROM ordenes_compra oc\r\n\t\t\t\t\t\t INNER JOIN detalle_ordenes_compra doc\r\n\t\t\t\t\t\t\tON doc.id_orden_compra = oc.id_orden_compra\r\n\t\t\t\t\t\t\t AND id_producto = " . $row["id_producto"] . "\r\n\t\t\t\t\t\tORDER BY fecha_orden_compra DESC LIMIT 1";
$rsOC = getRS($sql);
$rowOC = getRow($rsOC);
$fechaOC = $rowOC["fecha_orden_compra"];
$fechaActual = date("Y-m-d");
$diferencia = getDiferenciaEntreFechas($fechaOC, $fechaActual);
$R = $row["tpo_de_reaprovisionamiento_producto"];
if ($diferencia >= $R) {
$R = $R / 7;
// lo convierto a semanas
$A = $row["costo_de_emision_producto"];
$oData = array();
$oData["id_producto"] = $row["id_producto"];
$D = $this->getDemandaAnual($oData);
$H = $row["tasa_de_almacenamiento_producto"] * $row["precio_unitario_producto"];
$Q = number_format(sqrt(2 * $A * $D / $H));
$agotamiento = $row["agotamientos_perm_x_anio"];
$N = number_format($D / $Q);
$nivel_de_serv = 1 - $agotamiento / $N;
$k = $this->getFactorDeSeguridad($nivel_de_serv);
$data = $this->getMinTpoDeEntregaAndProv($oData);
$te = $data["tpo_de_entrega"];
$te_sobre_durEnSem = $te / $this->getDuracionPeriodoEnSemanas();
$days = number_format($te * 7 + $R);
$desv_std = $this->getDesvStd($oData, $days) * $te_sobre_durEnSem;
$SS = $k * $desv_std;
$mu_e = $this->getDemanda($oData, $days) * $te_sobre_durEnSem;
$S = number_format($mu_e + $SS);
if ($row["stock_actual_producto"] < $S) {
begin();
$sql = "UPDATE productos SET nivel_s_producto={$S}, stock_seguridad_producto={$SS} WHERE id_producto=" . $oData["id_producto"];
if (!getRS($sql)) {
rollback();
return false;
} else {
$exp = new ExpertoOrdenes();
$nro_orden = $exp->getNroOrdenCompra();
$sql = "INSERT INTO ordenes_compra (fecha_orden_compra, nro_orden_compra, generada, id_proveedor)\r\n\t\t\t\t\t\t\t\t\tVALUES ('" . date("Y-m-d") . "', " . $nro_orden . ", 0, " . $data["id_proveedor"] . ")";
if (!getRS($sql)) {
rollback();
return false;
} else {
$id = mysql_insert_id();
$cant = $S - $row["stock_actual_producto"];
$sql = "INSERT INTO detalle_ordenes_compra (id_orden_compra, id_producto, cantidad_detalle_orden_compra) VALUES (" . $id . ", " . $oData["id_producto"] . ", " . $cant . ")";
if (!getRS($sql)) {
rollback();
return false;
} else {
$nro_orden += 1;
$sql = "UPDATE parametros SET valor_parametro = " . $nro_orden . " WHERE nombre_parametro='nro_orden_compra'";
if (!mysql_query($sql)) {
die('Error: ' . mysql_error());
rollback();
return false;
} else {
commit();
$flag = true;
}
}
}
}
}
}
}
return $flag;
}
return false;
}
