/**
* Instantiate a console within Terminus
*
* ## OPTIONS
*
* [--site=<site>]
* : name of site to load
*
* @subcommand console
*/
public function console($args, $assoc_args)
{
$user = new User();
if (isset($assoc_args['site'])) {
$sitename = $assoc_args['site'];
$site_id = $this->sitesCache->findId($sitename);
$site = new Site($site_id);
}
eval(\Psy\sh());
}
public function getMatchers()
{
return ['extendsClass' => function ($subject, $key) {
return get_parent_class($subject) === $key;
}, 'moduleBeActive' => function ($subject) {
$module_name = implode('_', array_slice(explode('_', get_class($subject)), 0, 2));
eval(\Psy\sh());
return \Mage::getConfig()->getModuleConfig($module_name)->active;
}, 'beOnCodePool' => function ($subject, $codepool) {
$module_name = implode('_', array_slice(explode('_', get_class($subject)), 0, 2));
return \Mage::getConfig()->getModuleConfig($module_name)->codePool == $codepool;
}];
}
public function find()
{
$csv_sample = $this->csv_sample();
$this->original_columns = $this->csv_columns = $csv_sample[0];
$this->original_rows = $this->sample_rows = array_slice($csv_sample, 1);
$this->zip = new ZipColumnify($this);
$this->zip->find();
$this->address = new AddressColumnify($this);
$this->address->find();
$this->name = new NameColumnify($this);
$this->name->find();
$this->city = new CityStateColumnify($this, "city");
$city_result = $this->city->find();
$this->state = new CityStateColumnify($this, "state");
$state_result = $this->state->find();
// if state state or city were not found, the remaining columns
// will go through a more compex analysis to find possible
// mixed result "city/state".
if (!$state_result && !$city_result) {
eval(\Psy\sh());
$this->state->find_mixed();
}
return $this->format_columns();
}
protected function execute(InputInterface $input, OutputInterface $output)
{
eval(\Psy\sh());
}
<?php
require_once __DIR__ . '/../includes.php';
$file = "../documents/states.csv";
$handle = fopen($file, "r");
$i = 0;
$sql_statement = "INSERT IGNORE INTO `us_places` (`state`) VALUES ";
while (($data = fgetcsv($handle, 30, ",")) !== FALSE) {
if ($i != 0) {
$sql_statement .= " ('{$data['0']}'), ('{$data['1']}'),";
}
$i++;
}
fclose($handle);
$sql_statement = preg_replace("/,\$/", " ", $sql_statement);
$mysqli = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
$mysqli->query($sql_statement);
eval(\Psy\sh());
/**
* Save object Campus
**/
private function saveOrUpdate(Campus_vm $campusVm)
{
$msg = null;
if ($this->input->post()) {
$campusVm->populate();
if ($campusVm->validate()) {
$instituicao = $this->instituicao_bo->findOneBy($campusVm->getInstituicao());
$campus = new Entity\Campus();
$campus->setCidade($campusVm->getCidade());
$campus->setInstituicao($instituicao);
$campus->setNome($campusVm->getNome());
if ($campusVm->getIdCampus()) {
$this->campus_bo->updateCampus($campus);
} else {
$this->campus_bo->createCampus($campus);
}
if ($this->input->is_ajax_request()) {
echo json_encode($campus);
return;
} else {
redirect('instituicao/campus');
return;
}
} else {
$msg = 'Por favor, preencha todos os campos requeridos';
}
}
eval(\Psy\sh());
$instituicao_list = array_map(function ($d) {
return $d->getNome();
}, $this->instituicao_bo->list_all());
array_unshift($instituicao_list, 'Selecione...');
$this->load->view('campus/save_campus.html.php', array('title' => 'Campus', 'heading' => $campusVm->getIdCampus() ? 'Edit' : 'New', 'campusVm' => $campusVm, 'msg' => $msg, 'instituicao_list' => $instituicao_list));
}
/**
* Initiate an interactive PHP console
*
* @command self:console
*
* @option string $site_env Site & environment to access as `$site` and (optional) `$env`
*
* @usage terminus self:console
* Initiates an an interactive PHP console
* @usage terminus self:console <site>
* Initiates an interactive PHP console with access to an object representing <site>
* @usage terminus self:console <site>.<env>
* Initiates an interactive PHP console with access to an object representing <site> and its <env> environment
*
*/
public function console($site_env = null)
{
list($site, $env) = $this->getOptionalSiteEnv($site_env, null);
eval(\Psy\sh());
}
/**
* Instantiate a console within Terminus
*
* ## OPTIONS
*
* [--site=<site>]
* : name of site to load
*
* @subcommand console
*/
public function console($args, $assoc_args)
{
$user = Session::getUser();
if (isset($assoc_args['site'])) {
$site = $this->sites->get($this->input()->siteName(array('args' => $assoc_args)));
}
eval(\Psy\sh());
}
private function possible_city($possible_states, $query, $right_side = true)
{
eval(\Psy\sh());
foreach ($possible_states as $k => $possibly) {
$pattern = $right_side ? "/(\\w+) {$possibly}\$/i" : "/^{$possibly} (\\w+)/i";
if (preg_match($pattern, $query, $matches)) {
return $this->standard_search("city = '{$matches['1']}'", "city");
}
}
}
/**
* Parse output from SAP and transform to Collection
*
* @param array $result
*
* @return Collection
*/
public function parse($result)
{
// Clear all that spaces.
$result = array_trim($result);
// Get DATA and FIELDS SAP tables.
$data = collect($result['DATA']);
$fields = collect($result['FIELDS']);
// Get columns.
$columns = $fields->pluck('FIELDNAME')->toArray();
// If no raw rows early exit.
if ($data->count() === 0) {
return collect();
}
// Explode raw data rows and combine with columns.
$table = $data->pluck('WA')->transform(function ($item) use($columns) {
$values = array_trim(explode($this->parameters['DELIMITER'], $item));
if (count($values) != count($columns)) {
eval(\Psy\sh());
}
return array_combine($columns, $values);
});
// Apply transformations in corelation with fields type.
$fields->each(function ($field) use($table) {
// Transform dates.
if ($field['TYPE'] === 'D') {
$table->transform(function ($row) use($field) {
if ($row[$field['FIELDNAME']] == '00000000') {
$row[$field['FIELDNAME']] = null;
} else {
try {
$row[$field['FIELDNAME']] = Carbon::createFromFormat('Ymd', $row[$field['FIELDNAME']]);
} catch (\InvalidArgumentException $e) {
// Do nothing. Invalid format.
}
}
return $row;
});
}
});
return $table;
}
