public function GET__PDO()
{
try {
$coPDO = new PDO("mysql:host={$this->Host};dbname={$this->Schema};charset=UTF8", $this->UserName, $this->Password);
$coPDO->query("SET NAMES 'utf8'");
$coPDO->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
ccGeneral::EXCEPTION___Process($e, debug_backtrace());
}
return $coPDO;
}
public static function RUN__Query__INSERT($Queries, $PDO)
{
$bSuccess = true;
try {
$PDO->beginTransaction();
foreach ($Queries as $Query) {
$PDO->exec($Query);
}
$PDO->commit();
} catch (Exception $e) {
$PDO->rollBack();
$bSuccess = $e;
ccGeneral::EXCEPTION___Process($e, debug_backtrace());
}
return $bSuccess;
}
public static function vwNews($Inputs)
{
$PDO = ccPDO::___GET("lbxxdb50", false);
$Query = "CALL vwNews(:inUser__Id);";
try {
$SP = $PDO->prepare($Query);
$SP->bindValue(':inUser__Id', $Inputs['Id'], PDO::PARAM_INT);
$SP->execute();
$ResultsSets = array();
while ($SP->columnCount() > 0) {
$Response = $SP->fetchAll(PDO::FETCH_ASSOC);
$ResultsSets[] = $Response;
$SP->nextRowset();
}
} catch (Exception $e) {
ccGeneral::EXCEPTION___Process($e, debug_backtrace());
}
return $ResultsSets;
}
public static function MYSQL___Mirror($Function__Name, $Inputs)
{
$Remote = new stdClass();
$Local = new stdClass();
try {
$Remote->PDO = ccPDO::___GET("lbxxdb50", false, "www.loopbill.com");
$Remote->PDO->setAttribute(PDO::ATTR_AUTOCOMMIT, 0);
$Remote->PDO->beginTransaction();
$Remote->Results = call_user_func($Function__Name, $Remote->PDO, $Inputs);
$Local->PDO = ccPDO::___GET("lbxxdb50", false, "localhost");
$Local->PDO->setAttribute(PDO::ATTR_AUTOCOMMIT, 0);
$Local->PDO->beginTransaction();
$Local->Results = call_user_func($Function__Name, $Local->PDO, $Inputs);
$Remote->PDO->commit();
$Local->PDO->commit();
} catch (Exception $e) {
$Remote->PDO->rollBack();
$Local->PDO->rollBack();
echo "ERROR: An error occured while executing, please review.";
ccGeneral::EXCEPTION___Process($e, debug_backtrace());
}
// return $Remote->Results;
return $Local->Results;
}
<?php
$Path_Root = ccGeneral::GET___Path__Root();
require_once $Path_Root . '/Admin/PHP/Models/TXT.Types.php';
class ccPhrase__Custom
{
public $iPhrases = array();
public $Value;
// <editor-fold defaultstate="collapsed" desc="CONSTRUCT">
public static function __NEW_AFTER___N(ccTXT__Phrases__Facts $Phrases, $A_Phrase, $N_Phrases)
{
$Phrase_Custom = new ccPhrase__Custom();
$iPhrase_Frst = $Phrases->Retained->GET__iPhrase__Max() + $A_Phrase;
$iPhrase_Last = $Phrases->Retained->GET__iPhrase__Max() + $N_Phrases;
for ($iPhrase_C = $iPhrase_Frst; $iPhrase_C <= $iPhrase_Last; $iPhrase_C++) {
$Phrase_C = $Phrases->__slice($iPhrase_C);
$Phrase_Custom->ADD___After($iPhrase_C, $Phrase_C);
}
return $Phrase_Custom;
}
public static function __NEW_AFTER___N_whLine(ccTXT__Phrases__Facts $Phrases, $A_Phrase_Frst, $N_Lines)
{
$Phrase_Custom = new self();
$iPhrase_Frst = $Phrases->Retained->GET__iPhrase__Max() + $A_Phrase_Frst;
$iLine_Frst = $Phrases->iLines[$iPhrase_Frst][0];
for ($iPhrase_C = $iPhrase_Frst; $iPhrase_C < count($Phrases->Values); $iPhrase_C++) {
$Phrase_C = $Phrases->__slice($iPhrase_C);
if ($Phrase_C->Status === 0) {
break;
}
$Line_Count = $Phrase_C->iLine - $iLine_Frst;
public static function MOVE__Files($Files__Names, $From, $To)
{
$Path__Root = ccGeneral::GET___Path__Root();
foreach ($Files__Names as $File__Name) {
$Path__From = $Path__Root . '/Tickets/' . $From . '/Originals/' . $File__Name;
$Path__To = $Path__Root . '/Tickets/' . $To . '/Originals/' . $File__Name;
rename($Path__From, $Path__To);
$Path__From = $Path__Root . '/Tickets/' . $From . '/Thumbnails/' . $File__Name;
$Path__To = $Path__Root . '/Tickets/' . $To . '/Thumbnails/' . $File__Name;
rename($Path__From, $Path__To);
$File_TXT = pathinfo($File__Name, PATHINFO_FILENAME) . '.txt';
$Path__From = $Path__Root . '/Tickets/' . $From . '/TXT/' . $File_TXT;
if (file_exists($Path__From) === true) {
$Path__To = $Path__Root . '/Tickets/' . $To . '/TXT/' . $File_TXT;
rename($Path__From, $Path__To);
}
}
$bSuccess = true;
return $bSuccess;
}
