<?php
require_once 'vendor/autoload.php';
$app = new \Slim\App();
$pdo = new \Slim\PDO\Database('mysql:host=localhost;dbname=CoursPHP;', 'root', '11Dennis');
$container = $app->getContainer();
// Register component on container
$container['view'] = function ($container) {
$view = new \Slim\Views\Twig('views', ['cache' => false]);
$view->addExtension(new \Slim\Views\TwigExtension($container['router'], $container['request']->getUri()));
return $view;
};
$app->get('/', function ($request, $response, $args) {
require_once "DB.php";
global $pdo;
$stt = $pdo->select()->from('jeu_video')->execute();
$jeux = $stt->fetchAll(PDO::FETCH_OBJ);
return $this->view->render($response, 'jeux.twig', ['jeux' => $jeux]);
/*
$rows = array('<table>');
$rows[] = '<tr><th>ID</th><th>Nom</th></tr>';
while ($row = $stt->fetch(PDO::FETCH_OBJ)) {
$nom = $row->nom;
$rows[] = '<tr><td>'.$row->ID."</td><td><a href='$nom'>".$row->nom.'</a></td></tr>';
}
$rows[] = '</table>';
$input = file_get_contents('pages/liste.tpl');
$output = str_replace('{{jeux}}', implode(PHP_EOL, $rows), $input);
return $response->write($output);*/
});
$app->get('/{name}', function ($request, $response, $args) {
<?php
// DIC configuration
$container = $app->getContainer();
// view renderer
$container['renderer'] = function ($c) {
$settings = $c->get('settings')['renderer'];
return new Slim\Views\PhpRenderer($settings['template_path']);
};
// monolog
$container['logger'] = function ($c) {
$settings = $c->get('settings')['logger'];
$logger = new Monolog\Logger($settings['name']);
$logger->pushProcessor(new Monolog\Processor\UidProcessor());
$logger->pushHandler(new Monolog\Handler\StreamHandler($settings['path'], Monolog\Logger::DEBUG));
return $logger;
};
// database
$container['database'] = function ($c) {
$settings = $c->get('settings')['database'];
$d = new \Slim\PDO\Database($settings['dsn'], $settings['usr'], $settings['pwd']);
$d->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
return $d;
};
$container['errorHandler'] = function ($c) {
return function ($request, $response, $exception) use($c) {
return $c['response']->withStatus(500)->withHeader('Content-Type', 'text/html')->write($exception);
};
};
use Monolog\Handler\StreamHandler;
try {
// create a log channel
$log = new Logger(basename(__FILE__, ".php"));
$log->pushHandler(new StreamHandler(dirname(dirname(__FILE__)) . '/logs/your.log', Logger::DEBUG));
/* $log->pushProcessor(function ($record) {
$record['extra']['dummy'] = 'Hello world!';
return $record;
});
*
*/
// add records to the log
$log->info('Inicializando proceso ', array("linea " => __LINE__));
$pdo = new \Slim\PDO\Database(DSN_, USR_, PASSWD_);
$compania = new Compania();
$compania->__set("apiKey", APIKEY_);
$compania->obtener();
$response = $compania->__get("response");
if ($response['status'] == 'exito') {
foreach ($response["body"] as $key => $obj) {
$log->info(print_r($obj, true));
$insertStatement = $pdo->insert(array('id', 'name', 'industry', 'website', 'country', 'countrycode', 'cid', 'tagid', 'parent_type', 'parentid'))->into('lkp_companies')->values(array($obj->id, $obj->name, $obj->industry, $obj->website, $obj->country, $obj->countrycode, $obj->cid, 123, 'lkp_companies', $obj->id));
$insertId = $insertStatement->execute();
}
$log->info("Proceso Complento");
} else {
$log->error("Respuesta erronea");
$log->error($response['message']);
}
public function obtener()
{
try {
$pdo = new \Slim\PDO\Database(BD_DNS_, BD_USER_, BD_PWD_);
//Conexion::getInstance();
$qry = $pdo->select(array('id'))->from('lkp_projects');
$result = $qry->execute();
foreach ($result as $key => $value) {
$idProject = $value['id'];
$this->log->addInfo("id del proyecto " . $idProject, array(basename(__FILE__) . "::" . __LINE__));
$taskApi = new Task();
$taskApi->__set("apiKey", APIKEY_);
$this->log->addInfo("Inicio flujo de Task", array(basename(__FILE__) . "::" . __LINE__));
$taskApi->obtener($idProject);
$response = "";
$response = $taskApi->__get("response");
if ($response['status'] == "exito" && count($response['body']) > 0) {
$this->log->addInfo("Respuesta de api exitosa", array(basename(__FILE__) . "::" . __LINE__));
$values = array();
$pdo = new \Slim\PDO\Database(BD_DNS_, BD_USER_, BD_PWD_);
//Conexion::getInstance();
foreach ($response['body'] as $key => $value) {
$keys = array();
$insertValue = array();
foreach ($value as $keyB => $valueB) {
array_push($keys, $keyB);
array_push($insertValue, empty($valueB) || $valueB == '' ? 'null' : $valueB);
}
if (isset($insertValue[9])) {
foreach ($insertValue[9] as $keyC => $valueC) {
$keysB = array();
$insertValueB = array();
foreach ($valueC as $keyD => $valueD) {
array_push($keysB, $keyD);
array_push($insertValueB, empty($valueD) || $valueD == '' ? 'null' : $valueD);
}
$this->log->addDebug("Insert lkp_tasks", array(basename(__FILE__) . "::" . __LINE__));
$this->log->addDebug(print_r($keysB, true), array(basename(__FILE__) . "::" . __LINE__));
$this->log->addDebug(print_r($insertValueB, true), array(basename(__FILE__) . "::" . __LINE__));
$insertStatement = $pdo->insert($keysB)->into('lkp_tasks')->values($insertValueB);
$insertId = $insertStatement->execute();
$this->insertRel($valueC);
}
//fin foreach
}
unset($keys[9]);
unset($insertValue[9]);
$this->log->addDebug(print_r($insertValue, true), array(basename(__FILE__) . "::" . __LINE__));
$insertStatement = $pdo->insert($keys)->into('lkp_task_lists')->values($insertValue);
$this->log->addInfo(print_r($insertValue, true));
$insertId = $insertStatement->execute();
$this->insertRelTask($value);
}
} else {
$this->log->addInfo("Sin recursos encontrados", array(basename(__FILE__) . "::" . __LINE__));
}
}
//foreach resulset
} catch (PDOException $e) {
$this->log->addError("PDOException", array(basename(__FILE__) . "::" . __LINE__));
$this->log->addError($e->getMessage(), array(basename(__FILE__) . "::" . __LINE__));
} catch (\Exception $e) {
$this->log->addError(" ", array(basename(__FILE__) . "::" . __LINE__));
$this->log->addError($e->getMessage(), array(basename(__FILE__) . "::" . __LINE__));
}
}
public function obtener()
{
try {
$compania = new CategoryProject();
$compania->__set("apiKey", APIKEY_);
$this->log->addInfo("Inicio flujo de CategoryProject", array(basename(__FILE__) . "::" . __LINE__));
$compania->obtener();
$response = $compania->__get("response");
if ($response['status'] == "exito" && count($response['body']) > 0) {
$this->log->addInfo("Respuesta de api exitosa", array(basename(__FILE__) . "::" . __LINE__));
$values = array();
$pdo = new \Slim\PDO\Database(BD_DNS_, BD_USER_, BD_PWD_);
//Conexion::getInstance();
foreach ($response['body'] as $key => $value) {
$keys = array();
$insertValue = array();
foreach ($value as $keyB => $valueB) {
array_push($keys, $keyB);
array_push($insertValue, empty($valueB) || $valueB == '' ? 0 : $valueB);
}
$this->log->addInfo(print_r($keys, true), array(basename(__FILE__) . "::" . __LINE__));
$this->log->addInfo(print_r($insertValue, true), array(basename(__FILE__) . "::" . __LINE__));
$insertStatement = $pdo->insert($keys)->into('lkp_categories')->values($insertValue);
$insertId = $insertStatement->execute();
}
} else {
$this->log->addInfo("Sin recursos encontrados", array(basename(__FILE__) . "::" . __LINE__));
}
} catch (Exception $e) {
$this->log->addInfo("Error de BD", array(basename(__FILE__) . "::" . __LINE__));
$this->log->addInfo($e->getMessage(), array(basename(__FILE__) . "::" . __LINE__));
}
}
public function obtener()
{
try {
$compania = new Compania();
$compania->__set("apiKey", APIKEY_);
$this->log->addInfo("Inicio flujo de comanias", array(basename(__FILE__) . "::" . __LINE__));
$compania->obtener();
$response = $compania->__get("response");
if ($response['status'] == "exito" && count($response['body']) > 0) {
$this->log->addInfo("Respuesta de api exitosa", array(basename(__FILE__) . "::" . __LINE__));
$values = array();
$pdo = new \Slim\PDO\Database(BD_DNS_, BD_USER_, BD_PWD_);
//Conexion::getInstance();
foreach ($response['body'] as $key => $value) {
$keys = array();
$insertValue = array();
foreach ($value as $keyB => $valueB) {
array_push($keys, $keyB);
array_push($insertValue, empty($valueB) || $valueB == '' ? 0 : $valueB);
}
// INSERT INTO users ( id , usr , pwd ) VALUES ( ? , ? , ? )
$this->log->addDebug(print_r($keys, true), array(basename(__FILE__) . "::" . __LINE__));
$this->log->addDebug(print_r($insertValue, true), array(basename(__FILE__) . "::" . __LINE__));
$insertStatement = $pdo->insert($keys)->into('lkp_companies')->values($insertValue);
$insertId = $insertStatement->execute();
$this->insertRel($value);
}
}
} catch (PDOException $e) {
$this->log->addError("Error de BD", array(basename(__FILE__) . "::" . __LINE__));
$this->log->addError($e->getMessage(), array(basename(__FILE__) . "::" . __LINE__));
} catch (\Excetion $e) {
$this->log->addError("Inesperado ", array(basename(__FILE__) . "::" . __LINE__));
$this->log->addError($e->getMessage(), array(basename(__FILE__) . "::" . __LINE__));
}
}
<?php
//THIS FILE MUST NOT BE AVAILABLE IN PRODUCTION SYSTEMS!!!!
require __DIR__ . '/../vendor/autoload.php';
$database = new Slim\PDO\Database('mysql:host=localhost;dbname=projectist;charset=utf8', 'root', '');
$project_names = array('Inotice', 'Dongstrip', 'Overtaxon', 'Stattex', 'Stanhow', 'Sansailcity', 'Aceredcode', 'viaware', 'Sonla', 'Codefax', 'Goodfix', 'Transfase', 'unazoom', 'Canenix', 'X-zim', 'Bamdrill', 'Zoo-code', 'Medlane', 'Dingmedfax', 'zathcane', 'K-zone', 'Dan-ex', 'Unifinfan', 'Suntrans', 'Y-ex', 'zimla', 'Over-city', 'Doubleware', 'Plusing', 'templine', 'Geolex', 'Yearhex', 'Hatgofase', 'Stat-con', 'Media-tex', 'Redtom', 'J-tancore');
$sql = "TRUNCATE TABLE projects";
$database->exec($sql);
echo "Truncating the projects Table<br>";
foreach ($project_names as $project_name) {
//insert some projects
$project = new \App\Models\Project($database);
$project->CreateNew('code_test2', $project_name, 'owner_test', 'portfolio_test', 'rag_status_test');
$project->Save();
$project = null;
echo "saved Project {$project_name} <br>";
}
