PHP ArcDB示例

示例#1

文件： ArcEmailForm.php 项目： CarlosOVillanueva/BIFROST

 function getContactMethods($id, $override = false)
 {
     $filter = $this->isBranch === false | $override === true ? "id_cust_contact" : "id_cust_branch";
     $gdbo = new ArcDB();
     $gdbo->dbConStr = $GLOBALS['globalDBCON'];
     $gdbo->dbType = $GLOBALS['globalDBTP'];
     $gdbo->dbSchema = $GLOBALS['globalDB'];
     $gdbo->sql = "\nSELECT \n_contact_method.contact_method as method,\n_contact_method.contact_method\nFROM _contact_method\nLEFT JOIN _contact_method_tp \nON _contact_method.id_contact_method_tp = _contact_method_tp.id_contact_method_tp\nWHERE _contact_method_tp.id_contact_method_tp = 1 AND " . $filter . "=" . $id;
     $gdbo->getRec();
     return $gdbo->dbData;
 }

示例#2

文件： ArcContactMethods.php 项目： CarlosOVillanueva/BIFROST

 function getMethods()
 {
     $gdbo = new ArcDB();
     $gdbo->dbConStr = $GLOBALS['globalDBCON'];
     $gdbo->dbType = $GLOBALS['globalDBTP'];
     $gdbo->dbSchema = $GLOBALS['globalDB'];
     $gdbo->sql = "\nSELECT\na.id_contact_method_tp,\na.contact_method_tp,\nb.id_contact_method_tp_grp,\nb.contact_method_tp_grp\nFROM\n_contact_method_tp a\nJOIN\n_contact_method_tp_grp b ON a.id_contact_method_tp_grp=b.id_contact_method_tp_grp\nORDER BY contact_method_tp_grp,contact_method_tp\n";
     $gdbo->getRec();
     $results = $gdbo->dbData;
     return $results;
 }

示例#3

文件： ArcEmail.php 项目： CarlosOVillanueva/BIFROST

 function addAuditRecord()
 {
     $gdbo = new ArcDB();
     $gdbo->dbConStr = $GLOBALS['globalDBCON'];
     $gdbo->dbType = $GLOBALS['globalDBTP'];
     $gdbo->dbSchema = $GLOBALS['globalDB'];
     $gdbo->dbTable = "_email_log";
     $_POST["id_sys_user"] = $GLOBALS['id_sys_user'];
     $_POST["email_log_recipient"] = $this->toEmail;
     $_POST["email_log_msg"] = bin2hex($this->message);
     $_POST["email_log_subject"] = $this->subject;
     $gdbo->insertRec();
 }

示例#4

文件： ArcDbExport.php 项目： CarlosOVillanueva/BIFROST

<?php

/*
Author: Carlos Omar Villanueva
*/
require_once "_lib/php/auth.php";
$dbo = new ArcDB();
$dboData = (array) json_decode(decrypt($_POST["DBO"]));
unset($dboData["dbCols"]);
unset($dboData["dbData"]);
$inc = 1;
$debug = 1;
foreach ($dboData as $Column => $Data) {
    $comma = $inc != 1 ? "," : "";
    $dbo->{$Column} = $Data;
    $inc = $inc + 1;
}
$dbo->dbLimit = null;
$dbo->getRec();
$aRecordset_cols = $dbo->dbCols;
$aRecordset = $dbo->getAssociative();
header("Pragma: public");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Content-Type: application/force-download");
header("Content-Type: application/octet-stream");
header("Content-Type: application/download");
header("Content-Disposition: attachment;filename=export.csv");
header("Content-Transfer-Encoding: binary ");
$start = microtime(TRUE);
set_time_limit(330);

示例#5

文件： ArcFilterRec.php 项目： CarlosOVillanueva/BIFROST

<?php

require_once "_lib/php/auth.php";
$dbo = new ArcDB();
$dboData = (array) json_decode(decrypt($_POST["DBO"]));
unset($dboData["dbCols"]);
unset($dboData["dbData"]);
$inc = 1;
foreach ($dboData as $Column => $Data) {
    $comma = $inc != 1 ? "," : "";
    $dbo->{$Column} = $Data;
    $inc = $inc + 1;
}
if (isset($dbo->dependents)) {
    $dependents = json_decode($dbo->dependents);
    foreach ($dependents as $element => $name) {
        echo '<script>$("' . $name . '").prop("disabled",true);</script>';
    }
}
$attributes = isset($dbo->attributes) ? $dbo->attributes : "";
$recID = isset($dbo->id) ? $dbo->id : "";
if (!empty($_POST["VAL"])) {
    $dbo->sql = $dbo->sql . " " . $dbo->dbFilter . hex2str($_POST["VAL"]);
    $dbo->getRec();
    $results = $dbo->dbData;
    $count = $dbo->dbRows;
    $disabled = "";
} else {
    $results = array();
    $disabled = 'disabled="disabled"';
}