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);
<?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);