Beispiel #1
0
 private function TXT_Action__31($DB)
 {
     $Phrase_A1 = ccPhrase__Custom::__NEW_AFTER___N_whType_whLine($this, +1, 0);
     if (substr_count($Phrase_A1->Value, '/') === 2) {
         $IN_Format = "d/m/y";
     } elseif (substr_count($Phrase_A1->Value, '-') === 2) {
         $IN_Format = "d-m-y";
     }
     if ($IN_Format === null) {
         return;
     }
     $Phrase_A1->Value = ccTXT__Value::CLEAN__Spaces($Phrase_A1->Value);
     $Phrase_A2 = ccPhrase__Custom::__NEW_AFTER___N_whType_whLine($this, +3, 0);
     if (ccTXT__Type::Value__("Has_Digits__Only__Ignore_Signs", $Phrase_A2->Value) === true && strpos($Phrase_A2->Value, ":") !== false) {
         if (substr_count($Phrase_A2->Value, ':') === 1) {
             $IN_Format .= " H:i";
         } elseif (substr_count($Phrase_A2->Value, ':') === 2) {
             $IN_Format .= " H:i:s";
         }
         $Phrase_A2->Value = ccTXT__Value::CLEAN__Spaces($Phrase_A2->Value);
         $Phrase_A1->Value = $Phrase_A1->Value . " " . $Phrase_A2->Value;
     }
     $Timezone = new DateTimeZone('ART');
     $Value = DateTime::createFromFormat($IN_Format, $Phrase_A1->Value, $Timezone);
     if (is_a($Value, "DateTime") === false) {
         $this->Retained->SET__State("Unexpected_Type");
         return;
     }
     array_unshift($Phrase_A1->iPhrases, $Phrase_A1->iPhrases[0] - 1);
     array_unshift($Phrase_A2->iPhrases, $Phrase_A2->iPhrases[0] - 1);
     $Phrase_A1->iPhrases = array_merge($Phrase_A1->iPhrases, $Phrase_A2->iPhrases);
     $Class = $this->Retained->GET___Class___FROM___Match_Fact($DB, $Value->format("Y-m-d H:i:s"), $Phrase_A1);
     return $Class;
 }
<?php

require_once "../../../Web/PHP/Models/General.php";
require "../Views/Admin.php";
require_once "../../../Web/PHP/Models/PDO.php";
require_once "../Models/General.php";
require_once "../Models/TXT.php";
require_once "../Models/LB_DB.php";
//require_once '../Z_Dev/Dev.php';
$Inputs = filter_input_array(INPUT_GET);
$Inputs['TXT__Value'] = ccTXT__Value::CLEAN_FOR__DB($Inputs['TXT__Value']);
$Results = ccAdmin::MYSQL___Mirror("ccLB_Proc::CREATE___TXT_Fact_Object_Action__Id", $Inputs);
echo json_encode($Results);
Beispiel #3
0
<?php

require_once "../../../PHP/Models/General.php";
require "../Views/Admin__vw.php";
require_once "../../../PHP/Models/PDO.php";
require_once "./TXT.php";
$TXT = filter_input(INPUT_GET, 'TXT__Value');
$Action__Name = filter_input(INPUT_GET, 'Action__Name');
$TXT__Value = ccTXT__Value::CLEAN_FOR__DB($TXT);
//$MySQL = ccPDO::___GET("lbproc", false);
$MySQL = ccPDO::___GET("lbxxdb50", false);
try {
    $FakeParam = $MySQL->prepare("SET @outTXT_Action__Id = -1");
    $FakeParam->execute();
    $SP = $MySQL->prepare("CALL CREATE___TXT_Action__Id(:inTXT__Value, :inAction__Name, @outTXT_Action__Id, :inPrint);");
    $SP->bindValue(':inTXT__Value', $TXT__Value, PDO::PARAM_STR);
    $SP->bindValue(':inAction__Name', $Action__Name, PDO::PARAM_STR);
    $SP->bindValue(':inPrint', 1, PDO::PARAM_BOOL);
    $SP->execute();
    $result = $SP->fetchAll(PDO::FETCH_ASSOC);
} catch (Exception $e) {
    throw $e->getMessage();
}
echo json_encode($result);