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__)); } }
$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']); } } catch (\PDOException $e) { $log->error($e->getMessage()); } catch (Exception $e) { $log->error($e->getMessage()); } $log->info("Proceso Finalizado");
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__)); } }