/**
* Whenever controller is created, load the model and the template.
*
* @param \Psr\Http\Message\ServerRequestInterface $request
* @param \Psr\Http\Message\ResponseInterface $response
* @param $route
* @param $hooks
* @param $plugin_manager
* @param $pdo
*/
public function __construct($request, $response, $route, $hooks, $plugin_manager, $pdo)
{
$this->request = $request;
$this->response = $response;
if ($this->grantAccess()) {
$model = $route['model']['class'];
/* Check if model class extends the core model */
if ($model == 'Leap\\Core\\Model' || is_subclass_of($model, "Leap\\Core\\Model")) {
/* Create the model instance */
$this->model = new $model($pdo);
} else {
if (class_exists($route['model']['class'])) {
printr("Model class '" . $model . "' does not extend the base 'Leap\\Core\\Model' class");
} else {
printr("Model class '" . $model . "' not found");
}
}
$this->hooks = $hooks;
$this->plugin_manager = $plugin_manager;
/* TODO: pass whole route variable */
$this->template = new Template($route['template'], $route['page'], $hooks, $this->plugin_manager->enabled_plugins, $route['stylesheets'], $route['scripts']);
$this->page = $route['page'];
$this->init();
$this->access = true;
if (isset($route['title'])) {
$this->set('title', $route['title']);
} else {
$tmp_page = explode("/", explode(".", $this->page['value'])[0]);
$this->set('title', ucfirst(end($tmp_page)));
}
} else {
$this->access = false;
}
}
function printrx($data)
{
if (isset($_COOKIE['debug']) && $_COOKIE['debug']) {
printr($data);
die;
}
}
protected function format($values = false)
{
$query = "SET ";
$cvs = [];
printr($values);
$count = count($this->sets);
for ($i = 0; $i < $count; $i++) {
// Grab an individual set
$set = $this->sets[$i];
// Set the column for the query
$query .= $set->Column() . " = ";
// Parse the value. This is used because we don't know if the value should be a value, column,
// or static statement (ie UNIX_TIMESTAMP()).
$ret = self::parseValue($values, $set->BoundColumn(), $set->Value());
// The first element in the array will be the value to be added
$query .= $ret[1];
// The second element determines if the column has an associated value that the DatabaseManager
// will need or not
if ($ret[0]) {
$cvs[] = $set;
}
//new CVPair($set->Column(), $set->Value());
// Append as needed to maintain a CSV list
if ($i < $count - 1) {
$query .= ", ";
}
}
// Return the query along with the cvs's as needed
return [$query, $cvs];
}
function errorHandler($msg, $error)
{
if (!error_reporting()) {
return;
}
printr($error['message'], "Error");
}
public function fnFrete($tipoFrete = null, $idPedido = null)
{
$idPedido = sqlvalue($idPedido, false);
$tipoFrete = sqlvalue($tipoFrete, false);
if (isset($tipoFrete) and isset($idPedido)) {
$queryPeso = "SELECT \r\n\t\t\t\t\t\t\t ROUND((SUM((IFNULL(PROD.ALTURA_CM,0)*PEIT.QUANTIDADE))*SUM((IFNULL(PROD.LARGURA_CM,0)*PEIT.QUANTIDADE))*SUM((IFNULL(PROD.PROFUNDIDADE_CM,0)*PEIT.QUANTIDADE)))/6000,2) TOTAL_PESO_CUBICO,\r\n\t\t\t\t\t\t\t ROUND(SUM((IFNULL(PROD.PESO_KG,0)*PEIT.QUANTIDADE)),2) TOTAL_PESO_KG,\r\n\t\t\t\t\t\t\t ROUND(SUM((IFNULL(PROD.ALTURA_CM,0)*PEIT.QUANTIDADE)),2) TOTAL_ALTURA,\r\n\t\t\t\t\t\t\t ROUND(SUM((IFNULL(PROD.LARGURA_CM,0)*PEIT.QUANTIDADE)),2) TOTAL_LARGURA,\r\n\t\t\t\t\t\t\t ROUND(SUM((IFNULL(PROD.PROFUNDIDADE_CM,0)*PEIT.QUANTIDADE)),2) TOTAL_PROFUNDIDADE,\r\n\t\t\t\t\t\t\t PEEN.CEP_ID_CEP\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\tFROM\r\n\t\t\t\t\t\t\t e_PEDIDO PEDI,\r\n\t\t\t\t\t\t\t e_PEDIDO_ITEM PEIT,\r\n\t\t\t\t\t\t\t e_PRODUTO_COMBINACAO_ATRIBUTO_VALOR PCAV,\r\n\t\t\t\t\t\t\t e_PRODUTO_COMBINACAO PRCO,\r\n\t\t\t\t\t\t\t e_PRODUTO PROD,\r\n\t\t\t\t\t\t\t e_PEDIDO_ENDERECO PEEN\r\n\t\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\t PEDI.ID_PEDIDO = PEIT.PEDI_ID_PEDIDO\r\n\t\t\t\t\t\t\tAND PEIT.PCAV_ID_PRODUTO_COMBINACAO_ATRIBUTO_VALOR = PCAV.ID_PRODUTO_COMBINACAO_ATRIBUTO_VALOR\r\n\t\t\t\t\t\t\tAND PCAV.PRCO_ID_PRODUTO_COMBINACAO = PRCO.ID_PRODUTO_COMBINACAO\r\n\t\t\t\t\t\t\tAND PRCO.PROD_ID_PRODUTO = PROD.ID_PRODUTO\r\n\t\t\t\t\t\t\tAND PEDI.ID_PEDIDO = " . $idPedido . "\r\n\t\t\t\t\t\t\tAND PEDI.ID_PEDIDO = PEEN.PEDI_ID_PEDIDO\r\n\t\t\t\t\t\t\tGROUP BY\r\n\t\t\t\t\t\t\t\tPEEN.CEP_ID_CEP";
$resultQueryPeso = $mysqli->ExecutarSQL($queryPeso);
$rowQueryPeso = @mssql_fetch_array($resultQueryPeso);
$totalPesoCubico = number_format($rowQueryPeso["TOTAL_PESO_CUBICO"], 2, ',', '.');
$totalPesoKg = number_format($rowQueryPeso["TOTAL_PESO_KG"], 2, ',', '.');
$totalAltura = number_format($rowQueryPeso["TOTAL_ALTURA"], 2, ',', '.');
$totalLargura = number_format($rowQueryPeso["TOTAL_LARGURA"], 2, ',', '.');
$totalProfundidade = number_format($rowQueryPeso["TOTAL_PROFUNDIDADE"], 2, ',', '.');
$cepDestino = $rowQueryPeso["CEP_ID_CEP"];
if ($totalAltura <= 105 or $totalLargura <= 105 or $totalProfundidade <= 105) {
/*WEBSERVICE CORREIOS*/
$xml = simplexml_load_file("http://ws.correios.com.br/calculador/CalcPrecoPrazo.aspx?nCdEmpresa=08132828&sDsSenha=02804744&sCepOrigem=93525240&sCepDestino=" . $cepDestino . "&nVlPeso=" . $totalPesoKg . "&nCdFormato=1&nVlComprimento=" . $totalProfundidade . "&nVlAltura=" . $totalAltura . "&nVlLargura=" . $totalLargura . "&sCdMaoPropria=n&nVlValorDeclarado=0&sCdAvisoRecebimento=n&nCdServico=" . $tipoFrete . "&nVlDiametro=0&StrRetorno=xml&nIndicaCalculo=3");
//printr($xml);
} else {
$xml = "";
$tipoFrete = ID_TIPO_FRETE_TRANSP_PADRAO;
}
}
if ($xml->cServico->Codigo) {
$valorFrete = formataPrecoInsert($xml->cServico->Valor);
$codErro = $xml->cServico->Erro;
$MsgErro = $xml->cServico->MsgErro;
if ($codErro == '0') {
$retorno = array(array("VALOR_FRETE" => $valorFrete));
$mysqli->ExecutarSQL("UPDATE e_PEDIDO SET VALOR_FRETE = " . $valorFrete . ", TIFR_ID_TIPO_FRETE = " . $tipoFrete . " WHERE ID_PEDIDO = " . $idPedido . "");
} else {
$retorno = array(array("MENSAGEM_ERRO" => $MsgErro, "COD_ERRO" => $codErro));
//printr($retorno);
}
} else {
if (isset($tipoFrete)) {
$tipoFrete = sqlvalue($tipoFrete, true);
} else {
$tipoFrete = "PEDI.TIFR_ID_TIPO_FRETE";
}
if ($totalPesoCubico > $totalPesoKg) {
if ($totalPesoCubico > PESO_MAXIMO_CORREIOS) {
$adicionalTotalPesoCubico = $totalPesoCubico / PESO_MAXIMO_CORREIOS;
$peso = PESO_MAXIMO_CORREIOS;
$coluna = "IFNULL(PRUF.VALOR_FRETE, 0)*" . $adicionalTotalPesoCubico;
} else {
$peso = $totalPesoCubico;
$coluna = "IFNULL(PRUF.VALOR_FRETE, 0)";
}
} else {
$peso = $totalPesoKg;
$coluna = "IFNULL(PRUF.VALOR_FRETE, 0)";
}
$query = "DECLARE @FRETE_GRATIS VARCHAR(1),\r\n\t\t\t\t\t\t\t\t@VALOR_FRETE NUMERIC(14,4),\r\n\t\t\t\t\t\t\t\t@TIPO_FRETE VARCHAR(10),\r\n\t\t\t\t\t\t\t\t@PESO_TOTAL NUMERIC(14,4)\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t\tSET @PESO_TOTAL = " . $peso . "\r\n\t\t\t\t\t\tSET @TIPO_FRETE = " . $tipoFrete . "\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t\tIF(@TIPO_FRETE <> " . ID_TIPO_FRETE_TRANSP_PADRAO . ")\r\n\t\t\t\t\t\tBEGIN\r\n\t\t\t\t\t\t\tSELECT \r\n\t\t\t\t\t\t\t\t@FRETE_GRATIS = IFNULL(PRUF.FRETE_GRATIS, 'N'),\r\n\t\t\t\t\t\t\t\t@VALOR_FRETE = ROUND(" . $coluna . ",2),\r\n\t\t\t\t\t\t\t\t@TIPO_FRETE = " . $tipoFrete . " \r\n\t\t\t\t\t\t\tFROM\r\n\t\t\t\t\t\t\t\te_PEDIDO PEDI,\r\n\t\t\t\t\t\t\t\te_PEDIDO_ENDERECO PEEN,\r\n\t\t\t\t\t\t\t\te_MUNICIPIO MUNI,\r\n\t\t\t\t\t\t\t\te_CEP_PRECIFICACAO_UF PRUF\r\n\t\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\t\tPEDI.ID_PEDIDO = PEEN.PEDI_ID_PEDIDO\r\n\t\t\t\t\t\t\tAND PEDI.ID_PEDIDO = " . $idPedido . "\r\n\t\t\t\t\t\t\tAND PEEN.MUNI_ID_MUNICIPIO = MUNI.ID_MUNICIPIO\r\n\t\t\t\t\t\t\tAND PRUF.TIFR_ID_TIPO_FRETE = " . $tipoFrete . "\r\n\t\t\t\t\t\t\tAND MUNI.UNFE_ID_ESTADO = PRUF.UNFE_ID_ESTADO\r\n\t\t\t\t\t\t\tAND " . $peso . " BETWEEN PRUF.PESO_INICIAL AND PRUF.PESO_FINAL\r\n\t\t\t\t\t\t\tAND PEEN.CEP_ID_CEP BETWEEN PRUF.CEP_INICIAL AND PRUF.CEP_FINAL\r\n\t\t\t\t\t\tEND\r\n\t\t\t\t\t\tELSE\r\n\t\t\t\t\t\tBEGIN\r\n\t\t\t\t\t\t\tIF EXISTS (\r\n\t\t\t\t\t\t\t\tSELECT \r\n\t\t\t\t\t\t\t\t\t1\r\n\t\t\t\t\t\t\t\tFROM\r\n\t\t\t\t\t\t\t\t\te_PEDIDO PEDI,\r\n\t\t\t\t\t\t\t\t\te_PEDIDO_ENDERECO PEEN,\r\n\t\t\t\t\t\t\t\t\te_MUNICIPIO MUNI,\r\n\t\t\t\t\t\t\t\t\te_PRECIFICACAO_TRANSP PRUF\r\n\t\t\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\t\t\tPEDI.ID_PEDIDO = PEEN.PEDI_ID_PEDIDO\r\n\t\t\t\t\t\t\t\tAND PEDI.ID_PEDIDO = " . $idPedido . "\r\n\t\t\t\t\t\t\t\tAND PEEN.MUNI_ID_MUNICIPIO = MUNI.ID_MUNICIPIO\r\n\t\t\t\t\t\t\t\tAND PRUF.TIFR_ID_TIPO_FRETE = " . $tipoFrete . "\r\n\t\t\t\t\t\t\t\tAND MUNI.UNFE_ID_ESTADO = PRUF.UNFE_ID_ESTADO\r\n\t\t\t\t\t\t\t\tAND MUNI.ID_MUNICIPIO = IFNULL(PRUF.MUNI_ID_MUNICIPIO,0)\r\n\t\t\t\t\t\t\t)\r\n\t\t\t\t\t\t\tBEGIN\r\n\t\t\t\t\t\t\t\tSELECT \r\n\t\t\t\t\t\t\t\t\t@FRETE_GRATIS = 'N',\r\n\t\t\t\t\t\t\t\t\t@VALOR_FRETE = ((@PESO_TOTAL*PRUF.FRETE_KG)+PRUF.TAXA_FRETE_KG)+IFNULL(PRUF.PEDAGIO,0)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t+ TIFR.TAS_VALOR\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t+ CASE WHEN ((SUM(PEIT.PRECO_UNITARIO_VENDA*PEIT.QUANTIDADE)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t+SUM(IFNULL(PEIT.VALOR_PACOTE_PRESENTE,0)*PEIT.QUANTIDADE)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t-IFNULL(PEIT.VALOR_DESCONTO,0))*TIFR.GRIS_PERCENTUAL)/100 < TIFR.GRIS_MINIMO\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tTHEN TIFR.GRIS_MINIMO\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tELSE ((SUM(PEIT.PRECO_UNITARIO_VENDA*PEIT.QUANTIDADE)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t+SUM(IFNULL(PEIT.VALOR_PACOTE_PRESENTE,0)*PEIT.QUANTIDADE)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t-IFNULL(PEIT.VALOR_DESCONTO,0))*TIFR.GRIS_PERCENTUAL)/100\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tEND,\r\n\t\t\t\t\t\t\t\t\t@TIPO_FRETE = " . $tipoFrete . "\r\n\t\t\t\t\t\t\t\tFROM\r\n\t\t\t\t\t\t\t\t\te_PEDIDO PEDI,\r\n\t\t\t\t\t\t\t\t\te_PEDIDO_ENDERECO PEEN,\r\n\t\t\t\t\t\t\t\t\te_MUNICIPIO MUNI,\r\n\t\t\t\t\t\t\t\t\te_PRECIFICACAO_TRANSP PRUF,\r\n\t\t\t\t\t\t\t\t\te_TIPO_FRETE TIFR,\r\n\t\t\t\t\t\t\t\t\te_PEDIDO_ITEM PEIT\r\n\t\t\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\t\t\tPEDI.ID_PEDIDO = PEEN.PEDI_ID_PEDIDO\r\n\t\t\t\t\t\t\t\tAND PEDI.ID_PEDIDO = " . $idPedido . "\r\n\t\t\t\t\t\t\t\tAND PEEN.MUNI_ID_MUNICIPIO = MUNI.ID_MUNICIPIO\r\n\t\t\t\t\t\t\t\tAND PRUF.TIFR_ID_TIPO_FRETE = " . $tipoFrete . "\r\n\t\t\t\t\t\t\t\tAND MUNI.UNFE_ID_ESTADO = PRUF.UNFE_ID_ESTADO\r\n\t\t\t\t\t\t\t\tAND PRUF.MUNI_ID_MUNICIPIO = MUNI.ID_MUNICIPIO\r\n\t\t\t\t\t\t\t\tAND PRUF.TIFR_ID_TIPO_FRETE = TIFR.ID_TIPO_FRETE\r\n\t\t\t\t\t\t\t\tAND PEDI.ID_PEDIDO = PEIT.PEDI_ID_PEDIDO\r\n\t\t\t\t\t\t\t\tGROUP BY\r\n\t\t\t\t\t\t\t\t((@PESO_TOTAL*PRUF.FRETE_KG)+PRUF.TAXA_FRETE_KG)+IFNULL(PRUF.PEDAGIO,0),\r\n\t\t\t\t\t\t\t\tTIFR.GRIS_MINIMO,\r\n\t\t\t\t\t\t\t\tTIFR.GRIS_PERCENTUAL,\r\n\t\t\t\t\t\t\t\tTIFR.TAS_VALOR,\r\n\t\t\t\t\t\t\t\tPEIT.VALOR_DESCONTO\r\n\t\t\t\t\t\t\tEND\r\n\t\t\t\t\t\t\tELSE\r\n\t\t\t\t\t\t\tBEGIN\r\n\t\t\t\t\t\t\t\tSELECT \r\n\t\t\t\t\t\t\t\t\t@FRETE_GRATIS = 'N',\r\n\t\t\t\t\t\t\t\t\t@VALOR_FRETE = ((@PESO_TOTAL*PRUF.FRETE_KG)+PRUF.TAXA_FRETE_KG)+IFNULL(PRUF.PEDAGIO,0)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t+ TIFR.TAS_VALOR\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t+ CASE WHEN ((SUM(PEIT.PRECO_UNITARIO_VENDA*PEIT.QUANTIDADE)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t+SUM(IFNULL(PEIT.VALOR_PACOTE_PRESENTE,0)*PEIT.QUANTIDADE)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t-IFNULL(PEIT.VALOR_DESCONTO,0))*TIFR.GRIS_PERCENTUAL)/100 < TIFR.GRIS_MINIMO\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tTHEN TIFR.GRIS_MINIMO\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tELSE ((SUM(PEIT.PRECO_UNITARIO_VENDA*PEIT.QUANTIDADE)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t+SUM(IFNULL(PEIT.VALOR_PACOTE_PRESENTE,0)*PEIT.QUANTIDADE)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t-IFNULL(PEIT.VALOR_DESCONTO,0))*TIFR.GRIS_PERCENTUAL)/100\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tEND,\r\n\t\t\t\t\t\t\t\t\t@TIPO_FRETE = " . $tipoFrete . "\r\n\t\t\t\t\t\t\t\tFROM\r\n\t\t\t\t\t\t\t\t\te_PEDIDO PEDI,\r\n\t\t\t\t\t\t\t\t\te_PEDIDO_ENDERECO PEEN,\r\n\t\t\t\t\t\t\t\t\te_MUNICIPIO MUNI,\r\n\t\t\t\t\t\t\t\t\te_PRECIFICACAO_TRANSP PRUF,\r\n\t\t\t\t\t\t\t\t\te_TIPO_FRETE TIFR,\r\n\t\t\t\t\t\t\t\t\te_PEDIDO_ITEM PEIT\r\n\t\t\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\t\t\tPEDI.ID_PEDIDO = PEEN.PEDI_ID_PEDIDO\r\n\t\t\t\t\t\t\t\tAND PEDI.ID_PEDIDO = " . $idPedido . "\r\n\t\t\t\t\t\t\t\tAND PEEN.MUNI_ID_MUNICIPIO = MUNI.ID_MUNICIPIO\r\n\t\t\t\t\t\t\t\tAND PRUF.TIFR_ID_TIPO_FRETE = " . $tipoFrete . "\r\n\t\t\t\t\t\t\t\tAND MUNI.UNFE_ID_ESTADO = PRUF.UNFE_ID_ESTADO\r\n\t\t\t\t\t\t\t\tAND PRUF.MUNI_ID_MUNICIPIO IS NULL\r\n\t\t\t\t\t\t\t\tAND PRUF.TIFR_ID_TIPO_FRETE = TIFR.ID_TIPO_FRETE\r\n\t\t\t\t\t\t\t\tAND PEDI.ID_PEDIDO = PEIT.PEDI_ID_PEDIDO\r\n\t\t\t\t\t\t\t\tGROUP BY\r\n\t\t\t\t\t\t\t\t((@PESO_TOTAL*PRUF.FRETE_KG)+PRUF.TAXA_FRETE_KG)+IFNULL(PRUF.PEDAGIO,0),\r\n\t\t\t\t\t\t\t\tTIFR.GRIS_MINIMO,\r\n\t\t\t\t\t\t\t\tTIFR.GRIS_PERCENTUAL,\r\n\t\t\t\t\t\t\t\tTIFR.TAS_VALOR,\r\n\t\t\t\t\t\t\t\tPEIT.VALOR_DESCONTO\r\n\t\t\t\t\t\t\tEND\r\n\t\t\t\t\t\t\t\r\n\t\t\t\t\t\tEND\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t\tUPDATE e_PEDIDO SET VALOR_FRETE = @VALOR_FRETE, FRETE_GRATIS = @FRETE_GRATIS, TIFR_ID_TIPO_FRETE = @TIPO_FRETE \r\n\t\t\t\t\t\tWHERE ID_PEDIDO = " . $idPedido . ";\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t\tSELECT @FRETE_GRATIS FRETE_GRATIS, @VALOR_FRETE VALOR_FRETE";
printr($query);
$retorno = $mysqli->ConsultarSQL($query);
}
//fim else xml
return $retorno;
}
function login()
{
printr($_POST['referer']);
$referer = isset($_POST['referer']) && !empty($_POST['referer']) ? $_POST['referer'] : _BASE_URL_ . "/manager/posts/view_all";
if (!trim($_POST['user_id']) || !trim($_POST['password'])) {
msg_page("Required fields are missing.");
}
$data = array("user_id" => trim(strval($_POST['user_id'])), "password" => SHA1($_POST['password'] . SALT));
$user = $this->User->getUser("*", $data);
if ($this->User->count > 0) {
if ($user['level'] >= 5) {
$_SESSION['LOGIN_NO'] = $user["id"];
$_SESSION['LOGIN_ID'] = $user["user_id"];
$_SESSION['LOGIN_NAME'] = $user["name"];
$_SESSION['LOGIN_EMAIL'] = $user["email"];
$_SESSION['LOGIN_LEVEL'] = $user["level"];
/*check is save id */
$is_save_id = isset($_POST['is_save_id']) ? trim(strval($_POST['is_save_id'])) : "N";
if ($is_save_id == "Y") {
setcookie("is_save_id", "Y", time() + 60 * 60 * 24 * 365, "/");
setcookie("LOGIN_ID", $user['user_id'], time() + 60 * 60 * 24 * 365, "/");
} else {
setcookie("is_save_id", "", time() + 60 * 60 * 24 * 365, "/");
}
} else {
msg_page("You do not have permission to access.");
}
} else {
msg_page("information does not match.");
}
printr($referer);
redirect($referer);
}
function get_partner($id)
{
$sql = "select * from partner where id = :id";
$res = $this->db->query($sql, array(":id" => $id));
if (count($res) == 0) {
printr('no data');
}
//$res = $res[0];
return $res;
}
function errorHandler($msg, $error)
{
if (!error_reporting()) {
return;
}
$dir = dirname(__FILE__) . '/';
$rpath = str_replace($dir, '', $error['context']);
printr($error['message'], "Error");
printr($rpath, "Context");
}
private function parseTemplate($template, $data)
{
printr($data);
$keys = array_keys($data);
$values = array_values($data);
// key prep for replace
array_walk($keys, function (&$value, $key) {
$value = "[-{$value}-]";
});
// replace the basic or easy stuff
$partial = str_replace($keys, $values, $template);
$partial = $this->parseLogic($partial, $keys, $values);
return $partial;
}
/**
* getComments
*
* @param string $url
* @param string $type
* @param string $params
*
* @return void
*/
function getComments($url, $type, $params)
{
$comments = '';
switch ($type) {
case 'video':
$comments = getVideoComments($url, $params);
break;
default:
printr(debug_backtrace());
die("Invalid Type for getComments");
break;
}
return $comments;
}
function test()
{
$request = Yaf_Dispatcher::getInstance()->getRequest();
$type = key($request->getParams());
$params = array();
$params['request'] = $request->getRequest();
$params['query'] = $request->getQuery();
$params['post'] = $request->getPost();
$params['input'] = file_get_contents('php://input');
$isJson = false;
if (array_key_exists('_json', $params['query'])) {
$isJson = true;
unset($params['query']['_json'], $params['request']['_json']);
}
if ($type == 'param') {
printr($params, true, false, true);
} elseif ($type == 'curl') {
$str = 'curl';
if (!empty($params['post'])) {
if (!empty($params['query']['json']) && $params['query']['json'] == 'yes') {
$str .= ' -X POST -d ' . escapeshellarg($params['input']);
} else {
$str .= ' -X POST -d ' . escapeshellarg(http_build_query($params['post']));
}
}
if (!empty($params['query'])) {
$qstr = '';
if (!empty($params['query']['_url'])) {
$qstr .= $params['query']['_url'] . '?';
unset($params['query']['_url'], $params['request']['_url']);
} else {
$qstr .= '?';
}
$qstr .= http_build_query($params['query']);
$str .= ' ' . escapeshellarg($qstr);
}
if ($isJson) {
$str = json_encode($str);
}
echo $str;
} else {
echo 'api error, contact the administrator';
}
}
function printr($a, $l = 0)
{
if (is_array($a)) {
foreach ($a as $b => $sa) {
if (count($sa) < 2) {
if (!is_array($sa)) {
echo str_repeat(' ', $l) . $b . " => " . $sa . "\n";
} else {
if (!is_numeric($b)) {
echo str_repeat(' ', $l) . $b . "\n";
}
}
} else {
echo str_repeat(' ', $l) . $b . "\n";
}
printr($sa, $l + 1);
}
}
}
$dependenton =& $task->getDependentOn();
if (count($dependenton) == 1 && $dependenton[100]) {
//skip if only one user - the 100 user
} else {
$return .= '<dependenton>';
reset($dependenton);
while (list($id, $link_type) = each($dependenton)) {
$return .= '<task id="' . $id . '" linktype="' . $link_type . '"></task>';
}
$return .= '</dependenton>';
}
$return .= '<notes>' . $task->getDetails() . '</notes>';
$return .= '</task>';
}
$return .= '</tasks>';
printr($return, 'download XML');
print $return;
} else {
print $return . '<response handle="error">';
print '<error><description>' . $gforgeresult["errormessage"] . '</description></error>';
}
print '</response>';
print '</xml>';
}
break;
//MSPCheckin
//MSPCheckin
case $result["REQUEST"] == "upload":
if (trim($result["ACTION"]) == "Checkin") {
$gforgeresult = MSPCheckin($result["session_id"], $result["subproject"][0]["id"], $result["tasks"]);
print '<?xml version="1.0"?>';
/**
* array or obj print to html and exit
*/
function printr2($var, $title = null)
{
printr($var, $title);
exit;
}
function mw_newPost($args) {
global $wpdb, $post_default_category;
$this->escape($args);
$blog_ID = $args[0]; // we will support this in the near future
$user_login = $args[1];
$user_pass = $args[2];
$content_struct = $args[3];
$publish = $args[4];
if (!$this->login_pass_ok($user_login, $user_pass)) {
return $this->error;
}
$user = set_current_user(0, $user_login);
if ( !current_user_can('publish_posts') )
return new IXR_Error(401, 'Sorry, you can not post on this weblog or category.');
$post_author = $user->ID;
$post_title = $content_struct['title'];
$post_content = apply_filters( 'content_save_pre', $content_struct['description'] );
$post_status = $publish ? 'publish' : 'draft';
$post_excerpt = $content_struct['mt_excerpt'];
$post_more = $content_struct['mt_text_more'];
$comment_status = (empty($content_struct['mt_allow_comments'])) ?
get_option('default_comment_status')
: $content_struct['mt_allow_comments'];
$ping_status = (empty($content_struct['mt_allow_pings'])) ?
get_option('default_ping_status')
: $content_struct['mt_allow_pings'];
if ($post_more) {
$post_content = $post_content . "\n<!--more-->\n" . $post_more;
}
$to_ping = $content_struct['mt_tb_ping_urls'];
if ( is_array($to_ping) )
$to_ping = implode(' ', $to_ping);
// Do some timestamp voodoo
$dateCreatedd = $content_struct['dateCreated'];
if (!empty($dateCreatedd)) {
$dateCreated = $dateCreatedd->getIso();
$post_date = get_date_from_gmt(iso8601_to_datetime($dateCreated));
$post_date_gmt = iso8601_to_datetime($dateCreated, GMT);
} else {
$post_date = current_time('mysql');
$post_date_gmt = current_time('mysql', 1);
}
$catnames = $content_struct['categories'];
logIO('O', 'Post cats: ' . printr($catnames,true));
$post_category = array();
if (is_array($catnames)) {
foreach ($catnames as $cat) {
$post_category[] = get_cat_ID($cat);
}
}
// We've got all the data -- post it:
$postdata = compact('post_author', 'post_date', 'post_date_gmt', 'post_content', 'post_title', 'post_category', 'post_status', 'post_excerpt', 'comment_status', 'ping_status', 'to_ping');
$post_ID = wp_insert_post($postdata);
if (!$post_ID) {
return new IXR_Error(500, 'Sorry, your entry could not be posted. Something wrong happened.');
}
$this->attach_uploads( $post_ID, $post_content );
logIO('O', "Posted ! ID: $post_ID");
return strval($post_ID);
}
<form method="post">
<select name='option' title='Options'>
<?php
echo get_options('options', 'key', 'key', @$_POST['option']);
?>
</select>
<select name='group' title='Groups of options'>
<?php
echo get_options('options_groups', 'group', 'group', @$_POST['group']);
?>
</select>
<select name='type' title='Type of variable'>
<?php
echo array2options(Options::types(), @$_POST['type']);
?>
</select>
<input type='hidden' name='action' value='update' />
<input type='submit' class='input-large' value='Update' />
</form>
<?php
if (isset($_POST)) {
if (isset($_POST['action']) && $_POST['action'] == 'update') {
Options::set($_POST['option'], Options::get($_POST['option']), $_POST['type'], $_POST['group']);
}
}
echo "<br />Options: <hr />";
printr(Options::getList(false, 'META Data'));
/**
LINK TYPES -
SS . Start to Start
SF . Start to Finish
FS . Finish to Start
FF . Finish to Finish
params:
$session_hash
$group_project_id (subproject_id)
$tasks =
array(
id=>1,
msproj_id=>p1,
parent_id=>4,
parent_msproj_id=>p5
name=>'Task Name',
duration=>5,
work=>40,
start_date=>'10/1/04',
end_date=>'10/8/04',
percent_complete=>'50',
priority=>'medium',
resources=>array(
array(user_name=>'unix_name'),
...
),
dependenton=>array(
array( 'task_id'=>'55', 'msproj_id'=44, 'task_name'=>'Task Name', 'link_type'='SS' ),
...
)
notes=>'notes'
),
Return:
$array[success]=true;
**OR**
$array[success]=false;
$array[errormessage]='Invalid Subproject';
$array[resourcename]=array(
'Michael',
'Jon',
...
)
$array[usernames]=array(
array(user_id=>55,user_name='Jon Doe'),
array(user_id=>87,user_name='Foo'),
...
)
*/
function &MSPCheckin($session_hash, $group_project_id, $tasks)
{
global $primap;
printr($tasks, 'MSPCheckin::in-tasks');
if (!session_continue($session_hash)) {
$array['success'] = false;
$array['errormessage'] = 'Could Not Continue Session';
}
return pm_import_tasks($group_project_id, $tasks);
}
$proxyUrls = file_get_contents($inputFile);
$proxyUrls = explode("\n", $proxyUrls);
if (!$proxyUrls) {
printError('File is Empty.');
exit(1);
}
foreach ($proxyUrls as $proxyUrl) {
printr('------------------------------');
printr($proxyUrl);
if (empty($proxyUrl)) {
printr('This line is NULL. So Skip.');
continue;
}
if (substr($proxyUrl, 0, 1) === '#') {
printr('This line is #. So Skip.');
continue;
}
$proxy = array("http" => array("proxy" => $proxyUrl, 'request_fulluri' => true));
$proxyContext = stream_context_create($proxy);
$getHtml = @file_get_contents($url, false, $proxyContext);
if ($getHtml) {
printr("OK : This proxy is alive !");
} else {
printr("NG : This proxy is fail !");
}
}
printr('------------------------------');
printr('*****************************************************************************');
printr('End check proxy.');
printr('*****************************************************************************');
exit(0);
/**
* @since 1.0
* @access private
*/
function _save($term_id)
{
printr($term);
$real_post_id = isset($_POST['post_ID']) ? $_POST['post_ID'] : NULL;
// check autosave
if (defined('DOING_AUTOSAVE') and DOING_AUTOSAVE and !$this->autosave) {
return $post_id;
}
// make sure data came from our meta box, verify nonce
$nonce = isset($_POST[$this->id . '_nonce']) ? $_POST[$this->id . '_nonce'] : NULL;
if (!wp_verify_nonce($nonce, $this->id)) {
return $post_id;
}
// check user permissions
if ($_POST['post_type'] == 'page') {
if (!current_user_can('edit_page', $post_id)) {
return $post_id;
}
} else {
if (!current_user_can('edit_post', $post_id)) {
return $post_id;
}
}
// authentication passed, save data
$new_data = isset($_POST[$this->id]) ? $_POST[$this->id] : NULL;
WPAlchemy_MetaBox::clean($new_data);
if (empty($new_data)) {
$new_data = NULL;
}
// filter: save
if ($this->has_filter('save')) {
$new_data = $this->apply_filters('save', $new_data, $real_post_id);
/**
* halt saving
* @since 1.3.4
*/
if (FALSE === $new_data) {
return $post_id;
}
WPAlchemy_MetaBox::clean($new_data);
}
// get current fields, use $real_post_id (checked for in both modes)
$current_fields = get_post_meta($real_post_id, $this->id . '_fields', TRUE);
if ($this->mode == WPALCHEMY_MODE_EXTRACT) {
$new_fields = array();
if (is_array($new_data)) {
foreach ($new_data as $k => $v) {
$field = $this->prefix . $k;
array_push($new_fields, $field);
$new_value = $new_data[$k];
if (is_null($new_value)) {
delete_post_meta($post_id, $field);
} else {
update_post_meta($post_id, $field, $new_value);
}
}
}
$diff_fields = array_diff((array) $current_fields, $new_fields);
if (is_array($diff_fields)) {
foreach ($diff_fields as $field) {
delete_post_meta($post_id, $field);
}
}
delete_post_meta($post_id, $this->id . '_fields');
if (!empty($new_fields)) {
add_post_meta($post_id, $this->id . '_fields', $new_fields, TRUE);
}
// keep data tidy, delete values if previously using WPALCHEMY_MODE_ARRAY
delete_post_meta($post_id, $this->id);
} else {
if (is_null($new_data)) {
delete_post_meta($post_id, $this->id);
} else {
update_post_meta($post_id, $this->id, $new_data);
}
// keep data tidy, delete values if previously using WPALCHEMY_MODE_EXTRACT
if (is_array($current_fields)) {
foreach ($current_fields as $field) {
delete_post_meta($post_id, $field);
}
delete_post_meta($post_id, $this->id . '_fields');
}
}
// action: save
if ($this->has_action('save')) {
$this->do_action('save', $new_data, $real_post_id);
}
return $post_id;
}
function get_notice($id, $notice_uni = "")
{
$memo = array();
$req = "select * from notices where notice_id=" . $id . " ";
$resultat = mysql_query($req);
if ($r = mysql_fetch_object($resultat)) {
$code = $r->code;
$notice_extern = $this->info['harvest']->havest_notice($code);
foreach ($notice_extern as $contens) {
if ($this->info['fields'][$contens['xml_id']]) {
if ($this->info['fields'][$contens['xml_id']]['flagtodo'] == 1) {
// on remplace les champs par les nouvelles valeurs
$memo[] = $contens;
foreach ($notice_uni[f] as $index => $uni_field) {
if ($contens['ufield'] && $contens['usubfield']) {
// si champ et sous champ, on delete les anciens champs/sous-champ
} elseif ($contens['ufield']) {
// si pas de sous champ on efface tout
}
}
} else {
if ($this->info['fields'][$contens['xml_id']]['flagtodo'] == 2) {
// on ajoute
}
}
}
}
printr($memo);
printr($notice_uni[f]);
}
}
/**
* printr은 임시로 쓰고 지우는 놈인데 이놈은 코드 안에 남겨 둘 생각으로 만든 놈.
* @param $var
* @param null $title
*/
function debug_print($var, $title = NULL)
{
$style = "background-color: #ddd; color: #000; padding: 5px; font-size: 14px; margin: 5px 0";
$title_style = "color: darkred;";
printr($var, $title, $style, $title_style);
}
public function postFinishSignUp(SignUpFinish $req)
{
/** @var User $user */
$user = unserialize(session('signup.user'));
try {
\DB::transaction(function () use($req, $user) {
if ($req->email) {
$user->email = $req->email;
}
$user->username = $req->username;
$user->throwOnValidation = true;
//todo: https://github.com/laravel-ardent/ardent/issues/279
$user->save();
$this->saveLinks($user, true);
$this->saveLinks($user);
//those fields should not be "pulled" as an error might rise and their values can be reused in a 2nd try
session()->remove('signup.user');
session()->remove('signup.relations');
});
} catch (InvalidModelException $e) {
return redirect()->action('AuthController@getSignUp')->with('social_error', true)->with('provider', $req->provider)->withErrors($e->getErrors());
} catch (\Exception $e) {
\Log::error(class_basename($e) . ' during social auth (' . printr($_GET) . '): [' . $e->getCode() . '] ' . $e->getMessage());
return redirect()->action('AuthController@getSignUp')->with('social_error', true)->with('provider', $req->provider);
}
return $this->loginAfterSignUp($user, $req->provider);
}
function printTime($message, $as_html_comment = false)
{
if ($as_html_comment) {
echo '<!-- Timer: ';
}
$as_html_comment ? print $message . ' ' . $this->getTime() : printr($message . ' ' . $this->getTime());
if ($as_html_comment) {
echo ' -->';
}
}
/**
* Expanded version - smazat jeden nebo vice zaznamu z tabulky.
*
* @param string $table_name - jméno tabulky
* @param array $where_array - seznam podmínek<br/>
* [] - column = sloupec; value - int nebo string nebo value_mysql = now(); symbol
* @param string $limit_string - doplnit limit string
*/
public function DBDelete($table_name, $where_array, $limit_string)
{
// PDO - MySQL
// vznik chyby v PDO
$mysql_pdo_error = false;
// slozit si podminku s otaznikama
$where_pom = "";
if ($where_array != null) {
foreach ($where_array as $index => $item) {
// pridat AND
if ($where_pom != "") {
$where_pom .= "AND ";
}
// pokud neexistuje klic column, tak preskocit
if (!key_exists("column", $item)) {
echo "asi chyba v metode DBDelete - chybi klic column <br/>";
continue;
}
$column = $item["column"];
$symbol = $item["symbol"];
if (key_exists("value", $item)) {
$value_pom = "?";
} else {
if (key_exists("value_mysql", $item)) {
$value_pom = $item["value_mysql"];
}
}
// je to systemove, vlozit rovnou - POZOR na SQL injection, tady to muze projit
//echo "`$column` $symbol $value_pom ";
$where_pom .= "`{$column}` {$symbol} {$value_pom} ";
}
}
// doplnit slovo where
if (trim($where_pom) != "") {
$where_pom = "where {$where_pom}";
}
// 1) pripravit dotaz s dotaznikama
$query = "delete from `" . $table_name . "` {$where_pom} {$limit_string};";
//echo $query;
// 2) pripravit si statement
$statement = $this->connection->prepare($query);
// 3) NAVAZAT HODNOTY k otaznikum dle poradi od 1
$bind_param_number = 1;
if ($where_array != null) {
foreach ($where_array as $index => $item) {
if (key_exists("value", $item)) {
$value = $item["value"];
//echo "navazuju value: $value";
$statement->bindValue($bind_param_number, $value);
// vzdy musim dat value, abych si nesparoval promennou (to nechci)
$bind_param_number++;
}
}
}
// 4) provest dotaz
$statement->execute();
// 5) kontrola chyb
$errors = $statement->errorInfo();
//printr($errors);
if ($errors[0] + 0 > 0) {
// nalezena chyba
$mysql_pdo_error = true;
}
// 6) nacist data a vratit
if ($mysql_pdo_error == false) {
// tady nevim, co bych vracel - smazani se podarilo
} else {
echo "Chyba v dotazu - PDOStatement::errorInfo(): ";
printr($errors);
echo "SQL dotaz: {$query}";
}
}
echo 'ID_CONEXION_DESPUES_DE_SACAR_EL_CABLE=';
var_dump($id_con);
echo "<BR>";
echo 'RES_DESPUES_DE_SACAR_EL_CABLE=';
var_dump($res);
echo "<BR>";
$ftpInst2->cerrarConexion($id_con);
exit;
//LISTADO DE ARCHIVOS
$ftpInst1 = new FTPDriver();
$id_con = $ftpInst1->conexion("200.69.243.17", "ftp_factory", "Facturitas");
$archivos = array();
$archivos = $ftpInst1->listarNORecursivamente($id_con, ".");
printr($archivos);
$ftpInst1->listarRecursivamente($id_con, ".", $archivos);
printr($archivos);
exit;
//LISTADO DE ARCHIVOS
$ftpInst1 = new FTPDriver();
$id_con = $ftpInst1->conexion("200.69.243.17", "ftp_factory", "Facturitas");
$contenidos = $ftpInst1->listadoArchivos($id_con, './hockey/');
$ftpInst1->cerrarConexion($id_con);
print_r($contenidos);
//AGREGAR UN ARCHIVO
$ftpInst3 = new FTPDriver();
$id_con = $ftpInst3->conexion("200.69.243.17", "ftp_factory", "Facturitas");
//abrir algun archivo para lectura
$archivoRemoto = 'somefileREMOTO.txt';
$archivoLocal = 'C:\\Documents and Settings\\mmartini\\Escritorio\\somefileLOCALL.txt';
$apuntador = fopen($archivoLocal, 'r');
$res = $ftpInst3->agregarArchivo($id_con, $archivoRemoto, $apuntador);
/**
* Validate the IPN notification
*
* @return boolean
*/
public function validateIpn()
{
global $org_options;
do_action('action_hook_espresso_log', __FILE__, __FUNCTION__, '');
// make sure the WP_Http class is loaded
if (!class_exists('WP_Http')) {
include_once ABSPATH . WPINC . '/class-http.php';
}
$this->ipnData = $_REQUEST;
$transactionKey = isset($this->ipnData['transactionKey']) && !empty($this->ipnData['transactionKey']) ? sanitize_text_field($this->ipnData['transactionKey']) : FALSE;
if (!$transactionKey && $this->testMode) {
return TRUE;
}
if ($transactionKey) {
// set the data we're sending'
$post_args = array('method' => 'POST', 'timeout' => 30, 'headers' => array('Referer' => get_permalink($org_options['notify_url'])), 'body' => array('ps_store_id' => $this->settings['moneris_hpp_ps_store_id'], 'hpp_key' => $this->settings['moneris_hpp_key'], 'transactionKey' => $transactionKey));
$response = wp_remote_request($this->_verification_url, $post_args);
if (is_wp_error($response)) {
$error = $response->errors['http_request_failed'][0];
$this->moneris_hpp_log($error, TRUE);
return $error;
}
$verification = simplexml_load_string($response['body']);
if ($this->testMode && WP_DEBUG && current_user_can('update_core')) {
// super user can see debug info
printr($this->ipnData, '$this->ipnData <br /><span style="font-size:10px;font-weight:normal;">' . __FILE__ . '<br />line no: ' . __LINE__ . '</span>', 'auto');
printr($verification, '$verification <br /><span style="font-size:10px;font-weight:normal;">' . __FILE__ . '<br />line no: ' . __LINE__ . '</span>', 'auto');
}
if (absint($verification->response_code) <= 50 && (double) $verification->amount == (double) $this->ipnData['charge_total'] && $verification->status == 'Valid-Approved') {
return TRUE;
} else {
$log_entry = 'Transaction failed verification, & ';
$log_entry .= 'order_id = ' . $verification->order_id . ', & ';
$log_entry .= 'response_code = ' . $verification->response_code . ', & ';
$log_entry .= 'amount = ' . $verification->amount . ', & ';
$log_entry .= 'txn_num = ' . $verification->txn_num . ', & ';
$log_entry .= 'transactionKey = ' . $verification->transactionKey . ', & ';
$log_entry .= 'status = ' . $verification->status;
$log_entry .= "\nipnData\n";
foreach ($this->ipnData as $key => $value) {
$log_entry .= $key . ' = ' . $value . ', & ';
}
$this->moneris_hpp_log($log_entry, TRUE);
return FALSE;
}
} else {
$this->moneris_hpp_log('No transactionKey or an Invalid transactionKey was returned.', TRUE);
return FALSE;
// __( 'An error occurred. No Transaction Key was received from the payment gateway.' );
}
}
// pripojeni k db
$db_connection = $app->GetConnection();
// vytvorit objekt, ktery mi poskytne pristup k DB a vlozit mu connector k DB
$predmety = new predmety($db_connection);
// nacist vstupy - napr. ID clanku, ktery mam zobrazit
$id = @$_REQUEST["id"] + 0;
// nebo q = pozadovane url, ktere jsem dostal z .htaccess
// zpracovat si data pro vystup
// nejake vypocty apod
$a = 1;
$b = 2;
//$c = $a + $b;
$c = $app->Secti($a, $b);
// nacist vsechny predmety
$predmety_data = $predmety->LoadAllPredmety();
echo "Predmety:";
printr($predmety_data);
// specialni funkce pro vypis
// Vypis dat
// TODO nevypisovat to primo, ale s vyuzitim sablonovaciho systemu
// v nejhorsim to musi byt aspon v oddelenem souboru v casti templates nebo view
echo "<html>";
echo "<head>";
echo "</head>";
echo "<body>";
echo "<h1>Moje aplikace</h1>";
echo "Použitá databáze: " . DB_DATABASE_NAME . "<br/>";
echo "c = {$c} <br/>";
echo "</body>";
echo "</html>";
// Konec vypis dat
} elseif (GET('ajax_method') == 'savePanelConfig' && $can_edit && GET('panel_id') < 1000) {
$ajax =& new Window_Panel_Ajax();
$config['rows'] = GET('rows') ? GET('rows') : 3;
$config['cols'] = GET('cols') ? GET('cols') : 2;
$ajax->saveConfig('panel', $config);
} elseif (GET('ajax_method') == 'moveWindow' && GET('panel_id') < 1000) {
$ajax =& new Window_Panel_Ajax();
$opts_from = $ajax->loadConfig(GET('from'));
$opts_to = $ajax->loadConfig(GET('to'));
echo $ajax->saveConfig(GET('to'), $opts_from);
echo $ajax->saveConfig(GET('from'), $opts_to);
} elseif (GET('panel_id') >= 1000) {
echo _("Can not change configuration in .avt files");
} else {
echo _("Not recognized AJAX method: '") . GET('ajax_method') . "'";
printr($_GET);
}
exit;
//
// Load Panel settings from config
//
} else {
$ajax =& new Window_Panel_Ajax();
$filename = GET('panel_id') >= 1000 ? $configs_dir . "/" . $tabsavt[GET('panel_id')]['tab_file'] : null;
$options = $ajax->loadConfig('panel', $filename);
$rows = isset($options['rows']) ? $options['rows'] : 3;
$cols = isset($options['cols']) ? $options['cols'] : 2;
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
function mw_newPost($args)
{
global $wpdb, $post_default_category;
$this->escape($args);
$blog_ID = (int) $args[0];
// we will support this in the near future
$user_login = $args[1];
$user_pass = $args[2];
$content_struct = $args[3];
$publish = $args[4];
if (!$this->login_pass_ok($user_login, $user_pass)) {
return $this->error;
}
$user = set_current_user(0, $user_login);
$cap = $publish ? 'publish_posts' : 'edit_posts';
$error_message = __('Sorry, you are not allowed to publish posts on this blog.');
$post_type = 'post';
if (!empty($content_struct['post_type'])) {
if ($content_struct['post_type'] == 'page') {
$cap = $publish ? 'publish_pages' : 'edit_pages';
$error_message = __('Sorry, you are not allowed to publish pages on this blog.');
$post_type = 'page';
} elseif ($content_type['post_type'] == 'post') {
// This is the default, no changes needed
} else {
// No other post_type values are allowed here
return new IXR_Error(401, __('Invalid post type.'));
}
}
if (!current_user_can($cap)) {
return new IXR_Error(401, $error_message);
}
// Let WordPress generate the post_name (slug) unless
// one has been provided.
$post_name = "";
if (isset($content_struct["wp_slug"])) {
$post_name = $content_struct["wp_slug"];
}
// Only use a password if one was given.
if (isset($content_struct["wp_password"])) {
$post_password = $content_struct["wp_password"];
}
// Only set a post parent if one was provided.
if (isset($content_struct["wp_page_parent_id"])) {
$post_parent = $content_struct["wp_page_parent_id"];
}
// Only set the menu_order if it was provided.
if (isset($content_struct["wp_page_order"])) {
$menu_order = $content_struct["wp_page_order"];
}
$post_author = $user->ID;
// If an author id was provided then use it instead.
if (isset($content_struct["wp_author_id"]) && $user->ID != $content_struct["wp_author_id"]) {
switch ($post_type) {
case "post":
if (!current_user_can("edit_others_posts")) {
return new IXR_Error(401, __("You are not allowed to post as this user"));
}
break;
case "page":
if (!current_user_can("edit_others_pages")) {
return new IXR_Error(401, __("You are not allowed to create pages as this user"));
}
break;
default:
return new IXR_Error(401, __("Invalid post type."));
break;
}
$post_author = $content_struct["wp_author_id"];
}
$post_title = $content_struct['title'];
$post_content = apply_filters('content_save_pre', $content_struct['description']);
$post_status = $publish ? 'publish' : 'draft';
$post_excerpt = $content_struct['mt_excerpt'];
$post_more = $content_struct['mt_text_more'];
$tags_input = $content_struct['mt_keywords'];
if (isset($content_struct["mt_allow_comments"])) {
if (!is_numeric($content_struct["mt_allow_comments"])) {
switch ($content_struct["mt_allow_comments"]) {
case "closed":
$comment_status = "closed";
break;
case "open":
$comment_status = "open";
break;
default:
$comment_status = get_option("default_comment_status");
break;
}
} else {
switch ((int) $content_struct["mt_allow_comments"]) {
case 0:
$comment_status = "closed";
break;
case 1:
$comment_status = "open";
break;
default:
$comment_status = get_option("default_comment_status");
break;
}
}
} else {
$comment_status = get_option("default_comment_status");
}
if (isset($content_struct["mt_allow_pings"])) {
if (!is_numeric($content_struct["mt_allow_pings"])) {
switch ($content_struct['mt_allow_pings']) {
case "closed":
$ping_status = "closed";
break;
case "open":
$ping_status = "open";
break;
default:
$ping_status = get_option("default_ping_status");
break;
}
} else {
switch ((int) $content_struct["mt_allow_pings"]) {
case 0:
$ping_status = "closed";
break;
case 1:
$ping_status = "open";
break;
default:
$ping_status = get_option("default_ping_status");
break;
}
}
} else {
$ping_status = get_option("default_ping_status");
}
if ($post_more) {
$post_content = $post_content . "\n<!--more-->\n" . $post_more;
}
$to_ping = $content_struct['mt_tb_ping_urls'];
if (is_array($to_ping)) {
$to_ping = implode(' ', $to_ping);
}
// Do some timestamp voodoo
$dateCreatedd = $content_struct['dateCreated'];
if (!empty($dateCreatedd)) {
$dateCreated = $dateCreatedd->getIso();
$post_date = get_date_from_gmt(iso8601_to_datetime($dateCreated));
$post_date_gmt = iso8601_to_datetime($dateCreated, GMT);
} else {
$post_date = current_time('mysql');
$post_date_gmt = current_time('mysql', 1);
}
$catnames = $content_struct['categories'];
logIO('O', 'Post cats: ' . printr($catnames, true));
$post_category = array();
if (is_array($catnames)) {
foreach ($catnames as $cat) {
$post_category[] = get_cat_ID($cat);
}
}
// We've got all the data -- post it:
$postdata = compact('post_author', 'post_date', 'post_date_gmt', 'post_content', 'post_title', 'post_category', 'post_status', 'post_excerpt', 'comment_status', 'ping_status', 'to_ping', 'post_type', 'post_name', 'post_password', 'post_parent', 'menu_order', 'tags_input');
$post_ID = wp_insert_post($postdata);
if (is_wp_error($post_ID)) {
return new IXR_Error(500, $post_ID->get_error_message());
}
if (!$post_ID) {
return new IXR_Error(500, __('Sorry, your entry could not be posted. Something wrong happened.'));
}
$this->attach_uploads($post_ID, $post_content);
logIO('O', "Posted ! ID: {$post_ID}");
return strval($post_ID);
}
/**
* Funkce vlozi predmet do databaze.
*
* @param assoc. array $predmet - asociativni pole, klice odpovidaji atributum
*/
function CreatePredmet($predmet)
{
if ($this->connection_type == DB_CONNECTION_USE_PDO_MYSQL) {
// MySql
// SLOZIT TEXT STATEMENTU s otaznikama
$insert_columns = "`datum_vlozeni`";
$insert_values = "now()";
if ($predmet != null) {
foreach ($predmet as $column => $value) {
// pridat carky
if ($insert_columns != "") {
$insert_columns .= ", ";
}
if ($insert_columns != "") {
$insert_values .= ", ";
}
$insert_columns .= "`{$column}`";
$insert_values .= "?";
}
}
// slozit query
// Poznámka: název tabulky by měl být přes PHP konstantu
$stmt_text = "insert into `predmety` ({$insert_columns}) values ({$insert_values});";
echo "SQL pro INSERT - statement: " . $stmt_text;
$stmt = $this->connection->prepare($stmt_text);
//printr($stmt);
// NAVAZAT HODNOTY k otaznikum dle poradi od 1
$bind_param_number = 1;
if ($predmet != null) {
foreach ($predmet as $column => $value) {
$stmt->bindValue($bind_param_number, $value);
// vzdy musim dat value, abych si nesparoval promennou (to nechci)
$bind_param_number++;
}
}
// provest dotaz
$stmt->execute();
// tohle by urcilo ID typu auto increment pro prave vlozeny predmet
//$item_id = $this->connection->lastInsertId();
$item_id = 999;
return $item_id;
// KONEC MySql
} else {
// Oracle
// SLOZIT TEXT STATEMENTU s otaznikama
$insert_columns = "";
$insert_values = "";
if ($predmet != null) {
foreach ($predmet as $column => $value) {
// pridat carky
if ($insert_columns != "") {
$insert_columns .= ", ";
}
if ($insert_values != "") {
$insert_values .= ", ";
}
$insert_columns .= "{$column}";
$insert_values .= ":{$column}";
}
}
// slozit query
// Poznámka: název tabulky by měl být přes PHP konstantu
$stmt_text = "insert into predmety ({$insert_columns}) values ({$insert_values})";
echo "SQL pro INSERT - statement: " . $stmt_text;
$stmt = oci_parse($this->connection, $stmt_text);
// NAVAZAT HODNOTY k otaznikum dle poradi od 1
if ($predmet != null) {
foreach ($predmet as $column => $value) {
// tuto chybu nasel Martin Zíma
oci_bind_by_name($stmt, ":{$column}", $predmet[$column]);
//oci_bind_by_name($stmt, ":$column", $value); - nefunguje, viz http://www.php.net/manual/en/function.oci-bind-by-name.php
}
}
// provest dotaz
$result = oci_execute($stmt, OCI_COMMIT_ON_SUCCESS);
//printr($result);
$chyba = oci_error($stmt);
printr($chyba);
// KONEC Oracle
}
}
