<?php

/**
 * DropsizeMVCf - extension of the SlimFramework and others tools
 *
 * @author      Isaac Trenado <isaac.trenado@codigolimpio.com>
 * @copyright   2013 Isaac Trenado
 * @link        http://dropsize.codigolimpio.com
 * @license     http://dropsize.codigolimpio.com/license.txt
 * @version     3.0.1
 * @package     DropsizeMVCf
 *
 * DropsizeMVCf - Web publishing software
 * Copyright 2015 by the contributors
 * 
 * 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., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301  USA
 * 
 * This program incorporates work covered by the following copyright and
 * permission notices:
 * 
 * DropsizeMVCf is (c) 2013, 2015 
 * Isaac Trenado - isaac.trenado@codigolimpio.com -
 * http://www.codigolimpio.com
 * 
 * Wherever third party code has been used, credit has been given in the code's comments.
 *
 * DropsizeMVCf is released under the GPL
 * 
 */
/**
 * Ejemplo 1 Interactura con DPManager
 * 
 * @package com.dropsizemvcf
 * @author  Isaac Trenado
 * @since   1.0.0
 */
include "./DPManager-Basic.php";

/**
 * Ejemplos
 * 
 * buildDatosToUpdate   Construye cadena    CAMPO = '$valor', CAMPO = '$valor'
 * buildSelectQuery     Construye cadena    SELECT CAMPO, CAMPO FROM 
 *                                          TABLA WHERE CAMPO = '$cadena' 
 *                                          GROUP BY CAMPO ORDER BY CAMPO
 * buildDeleteQuery     Construye cadena    DELETE FROM TABLA WHERE CAMPO = '%cadena'
 * buildInsertQuery     Construye cadena    INSERT INTO TABLA (CAMPO, CAMPO) VALUES ('$cadena', '$cadena');
 * buildUpdateQuery     Construye cadena    UPDATE TABLA SET CAMPO = '%s', CAMPO = '%s'
 *                                          WHERE CAMPO = '%s'
 * 
 */

/**
 * Build Datos to update Query
 * 
 * // Output : CAMPO1 = 'Valor 1' ,CAMPO2 = 'Valor 2' ,CAMPO3 = 'Valor 3' 
 * 
 */

$larFields = array();
$larFields['CAMPO1'] = " 'Valor 1' ";
$larFields['CAMPO2'] = " 'Valor 2' ";
$larFields['CAMPO3'] = " 'Valor 3' ";

$lstUpdateQuery = DPManager::buildDatosToUpdate($larFields);

echo "<h1>Build Update Set Query</h1>";
echo $lstUpdateQuery;

/**
 * Select Query Query Example 1
 * inicializando todos los parametros
 * 
 * // Output : SELECT 'Valor 1' , 'Valor 2' , 'Valor 3' FROM NOMBRE_TABLA WHERE CAMPO = 'cadena' LIMIT 0, 10
 * 
 */

$lstSelectQuery = DPManager::buildSelectQuery(
                implode(",", $larFields), "NOMBRE_TABLA", "CAMPO = 'cadena' ", false, false, false, "LIMIT 0, 10"
);

echo "<h1>Build Simple Select from correct params</h1>";
echo $lstSelectQuery;

/**
 * Select Query Query Example 2
 * con agrupamiento
 * 
 * // Output : SELECT sum(CAMPO) FROM NOMBRE_TABLA WHERE CAMPO = 'cadena' GROUP BY CAMPO
 * 
 */

$lstSelectQuery2 = DPManager::buildSelectQuery(
                "sum(CAMPO)", "NOMBRE_TABLA", "CAMPO = 'cadena' ", "CAMPO"
);

echo "<h1>Build group Query From correct params</h1>";
echo $lstSelectQuery2;

/**
 * Select Query Query Example 3
 * con Ordenamiento
 * 
 * Output : SELECT 'Valor 1' , 'Valor 2' , 'Valor 3' FROM NOMBRE_TABLA WHERE CAMPO = 'cadena' ORDER BY CAMPO DESC
 */

$lstSelectQuery3 = DPManager::buildSelectQuery(
                implode(",", $larFields), "NOMBRE_TABLA", "CAMPO = 'cadena' ", false, "CAMPO", "DESC"
);

echo "<h1>Build Simple Query From Order By Params</h1>";
echo $lstSelectQuery3;

/**
 * DELETE Query Example 1
 * 
 * Output : DELETE FROM NOMBRE_TABLA WHERE CAMPO = 'cadena' 
 * 
 */

$lstDeleteQuery1 = DPManager::buildDeleteQuery("NOMBRE_TABLA", "CAMPO = 'cadena' ");

echo "<h1>Build Simple Delete Query From Params</h1>";
echo $lstDeleteQuery1;

/**
 * INSERT Query Example 1
 * 
 * Output : INSERT INTO NOMBRE_TABLA ( CAMPO1,CAMPO2,CAMPO3) VALUES ( 'Valor 1' , 'Valor 2' , 'Valor 3' )
 * 
 */

$lstInsertQuery1 = DPManager::buildInsertQuery($larFields, "NOMBRE_TABLA");

echo "<h1>Build Simple Insert Data From Params array type and table name</h1>";
echo $lstInsertQuery1;

/**
 * UPDATE Query Example 1
 * Para este ejemplo, necesitamos construir el SET con DPManager::buildDatosToUpdate($larFields);
 * 
 * Output : UPDATE NOMBRE_TABLA SET CAMPO1 = 'Valor 1' ,CAMPO2 = 'Valor 2' ,CAMPO3 = 'Valor 3' WHERE CAMPO = 'valor' 
 * 
 */

$lstUpdateQuery1 = DPManager::buildUpdateQuery("NOMBRE_TABLA", $lstUpdateQuery, "CAMPO = 'valor' ");

echo "<h1>Build Simple Update From Params array type, table name and condition to affect rows</h1>";
echo $lstUpdateQuery1;


/**
 * Poder iterar resultados de base de datos, Object u Array aplicando un metodo
 * de regreso
 * @param array 
 */

$array = array(array(1, 2), array(3, 4));
$result = DPManager::iteraRecord($array, function() {

    $row = func_get_args();
    
    $uno = $row[0] . "UNO";
    $dos = $row[1] . "DOS";

    return array($uno, $dos);
});

echo "<h1>Aplicaci&oacute;n de m&eacute;todo anonimo a cada uno "
. "de los elementos del objeto o arreglo</h1>";
echo "<pre>";
print_r($result);
echo "</pre>";