public function ObtenerDetallesArt($pvcID)
{
try {
$AccesoDatos = new AD();
$vlcScript = "SELECT * FROM fve_prod WHERE prod_id =" . "'" . $pvcID . "'";
return $AccesoDatos->RetornarResultado($vlcScript);
} catch (Exception $e) {
echo $ERROR_MESSAGE;
}
}
public function ObtenerZonas()
{
try {
//Crea instancia de Acceso a datos
$AccesoDatos = new AD();
//Crea el script a ejecutar
$vlcScript = "SELECT * FROM fve_zon";
//retornar datos
return $AccesoDatos->RetornarResultado($vlcScript);
} catch (Exception $exc) {
//Lanza la excepcion
echo $exc->getTraceAsString();
}
}
function __construct($end_switch = false)
{
CORE::summon(__FILE__);
if ($end_switch) {
self::$endClass = __CLASS__ . "_BACKEND";
} else {
self::$endClass = __CLASS__ . "_FRONTEND";
}
new self::$endClass();
}
public function ActualizarProducto($vloProducto)
{
//Variable de respuesta
$vloRes = false;
try {
//Si el parametro es un arreglo
if (is_array($vloProducto)) {
//Crea acceso a datos
$AccesoDatos = new AD();
//Define el script
$query = sprintf("UPDATE fve_prod \n SET tip_prod_id = %d,\n prod_nom = '%s',\n prod_desc = '%s',\n prod_prc_act = %g,\n prod_fec_cmb_prc = Now(),\n prod_sts = %d,\n prod_prm = %d,\n prod_rut_img = '%s',\n prod_unit_med = '%s' \n WHERE prod_id = %d ", mysql_real_escape_string($vloProducto['tip_prod_id']), mysql_real_escape_string($vloProducto['prod_nom']), mysql_real_escape_string($vloProducto['prod_desc']), mysql_real_escape_string($vloProducto['prod_prc_act']), mysql_real_escape_string($vloProducto['prod_sts']), mysql_real_escape_string($vloProducto['prod_prm']), mysql_real_escape_string($vloProducto['prod_rut_img']), mysql_real_escape_string($vloProducto['prod_unit_med']), mysql_real_escape_string($vloProducto['prod_id']));
//Ejecuta el comando
$vloResult = $AccesoDatos->RetornarResultado($query);
//Cuento el total de registros afectados
$TotalRegAfectados = mysql_affected_rows();
//Asigno el resultado de la consulta
$vloRes = $TotalRegAfectados > 0;
}
} catch (Exception $ex) {
$vloRes = false;
}
return $vloRes;
}
public function GuardarDetalle($pvcIDEncPedido, $pvoListaProductos)
{
$vlcScript = '';
$vlnIDDet = 1;
$vlnSubTotal = 0;
try {
$vloAD = new AD();
$sqlArray = array();
//Por cada producto manda a crea una instancia
foreach ($pvoListaProductos as $vloProducto) {
//Calcula el subtotal
$vlnSubTotal = $vloProducto['cantidad'] * $vloProducto['precio'];
//Crea arreglo de articulos a almacenar
$sqlArray[] = "('" . $pvcIDEncPedido . "'," . $vlnIDDet . ",'" . $vloProducto['id'] . "'," . $vloProducto['cantidad'] . "," . $vlnSubTotal . ")";
//aumenta el id del detalle del pedido
$vlnIDDet++;
}
$vlcScript = " INSERT INTO fve_ped_det(ped_enc_id,ped_det_id,prod_id,ped_det_can_prod,ped_det_mont) " . "VALUES " . implode(',', $sqlArray);
$vloAD->EjecutarComando($vlcScript);
} catch (Exception $exc) {
echo $exc->getTraceAsString();
}
}
/**
* (non-PHPdoc)
* @see IUserSourceInterface::getUser()
* 获取用户信息
* @since 1.0.0
*/
public function getUser($userInfo)
{
$userName = $userInfo['userName'];
$password = $userInfo['password'];
//扩展信息
$host_str = 'ad_ldap_host';
$port_str = 'ad_ldap_port';
$baseCn_str = 'ad_ldap_base_cn';
$coding_str = 'ad_coding';
$department_str = 'ad_sync_department';
$syncDepartment = MiniOption::getInstance()->getOptionValue($department_str);
$ldapHost = MiniOption::getInstance()->getOptionValue($host_str);
if ($ldapHost === NULL) {
$this->errorCode = self::LDAP_INIT_ERROR;
return false;
}
$ldapPort = MiniOption::getInstance()->getOptionValue($port_str);
if ($ldapPort === NULL) {
$this->errorCode = self::LDAP_INIT_ERROR;
return false;
}
$ldapBaseCn = MiniOption::getInstance()->getOptionValue($baseCn_str);
if ($ldapBaseCn === NULL) {
$this->errorCode = self::LDAP_INIT_ERROR;
return false;
}
$ldapCoding = MiniOption::getInstance()->getOptionValue($coding_str);
if ($ldapCoding === NULL) {
$ldapCoding = "GB2312";
}
if (empty($ldapHost) || empty($ldapPort) || empty($ldapBaseCn)) {
$this->errorCode = self::LDAP_INIT_ERROR;
return false;
}
//链接AD服务器
$ad = new AD();
$ad->setHost($ldapHost);
$ad->setFilter($ldapBaseCn);
$ad->setCoding($ldapCoding);
$ad->setPort($ldapPort);
$ad->setSyncDepartment($syncDepartment);
$result = $ad->getMember($userName, $password);
if (!$result) {
$this->errorCode = MConst::ERROR_PASSWORD_INVALID;
// 用户名不存在
return false;
}
return $result;
}
function validate($value)
{
$res = AD::validate($value);
return $res;
if ($res[0] && $res[1] != "") {
$mod_lines = array();
$lines = explode("\n", $res[1]);
for ($i = 0; $i < count($lines); $i++) {
$line = $lines[$i];
if (substr($line, 0, 1) != "#") {
$line = $this->prefix . $line;
}
$mod_lines[] = $line;
}
$res[1] = join("\n", $mod_lines);
}
return $res;
}
function __construct()
{
list($cate, $args) = CORE::$args;
self::$temp = CORE::$temp_main;
if (!empty($cate)) {
self::$cate = SEO::origin('products_cate', $cate);
$func++;
}
if (!empty($args)) {
self::$id = SEO::origin('products', $args);
$func++;
}
switch ($func) {
case 0:
self::$temp["MAIN"] = 'ogs-products-tpl.html';
AD::$cate = 4;
new AD();
SEO::load('products');
if (empty(SEO::$data["h1"])) {
SEO::$data["h1"] = CORE::$lang["products"];
}
SEO::output();
CRUMBS::fetch('products');
break;
case 1:
self::$temp["MAIN"] = 'ogs-products-list-tpl.html';
self::row();
break;
default:
self::$temp["MAIN"] = 'ogs-products-detail-tpl.html';
self::detail();
break;
}
self::nav();
CORE::res_init('fix', 'css');
new VIEW(CORE::$temp_option["HULL"], self::$temp, false, false);
}
/**
* Creates a User from AD data
*/
private function createADUser()
{
try {
// Create User from AD data
$ADUserData = AD::getUser(Session::get('user'));
$data = array('location_id' => Location::getIdFromName($ADUserData['office']), 'ad_account' => $ADUserData['account'], 'employee_id' => $ADUserData['employeeid'], 'display_name' => $ADUserData['displayname'], 'email' => $ADUserData['email'], 'active' => 0);
} catch (\Exception $e) {
// Log Error
return $this->handleRideShareLogError($e, 'Unable to access User data.');
}
try {
// Create User in DB
User::create($data);
} catch (\Exception $e) {
return $this->handleRideShareLogError($e, 'Unable to create User.');
}
}
// Route::get('/admin/getUserDetails/{user_id}', 'AdminController@getUserDetails');
// Route::get('/admin/getUserSubmissions/{user_id}', 'AdminController@getUserSubmissions');
Route::post('/admin/toggleUserActiveState/{user_id}', 'AdminController@toggleUserActiveState');
Route::get('/admin/getUserSubmissionsDataTable/{user_id}', 'AdminController@getUserSubmissionsDataTable');
Route::post('/admin/toggleSubmissionActiveState/{submission_id}', 'AdminController@toggleSubmissionActiveState');
Route::post('/admin/addNewSubmission', 'AdminController@addNewSubmission');
Route::get('/admin/getEditSubmissionForm/{submission_id}', 'AdminController@getEditSubmissionForm');
Route::post('/admin/updateSubmission/{submission_id}', 'AdminController@updateSubmission');
Route::post('/admin/addNewUser', 'AdminController@addNewUser');
Route::get('/admin/activateUser/{user_id}', 'AdminController@activateUser');
Route::get('/admin/deactivateUser/{user_id}', 'AdminController@deactivateUser');
Route::get('/admin', 'AdminController@index');
### AD Routes
Route::get('/AD/search/{user}', function ($user) {
return AD::searchUsers($user);
});
Route::get('/AD/getUser/{user}', function ($user) {
return AD::getUser($user);
});
### Resources
Route::resource('locations', 'LocationsController');
Route::resource('method_types', 'MethodTypesController');
Route::resource('passenger_types', 'PassengerTypesController');
Route::resource('additional_fields', 'AdditionalFieldsController');
Route::resource('lmp_combinations', 'LmpCombinationsController');
Route::resource('additional_field_dependencies', 'AdditionalFieldDependenciesController');
Route::resource('users', 'UsersController');
Route::resource('permissions', 'PermissionsController');
Route::resource('user_permissions', 'UserPermissionsController');
Route::resource('submissions', 'SubmissionsController');
Route::resource('additional_field_submissions', 'AdditionalFieldSubmissionsController');
private static function detail($id)
{
$rsnum = CRUD::dataFetch('ad', array('id' => $id));
if (!empty($rsnum)) {
list($row) = CRUD::$data;
foreach ($row as $field => $var) {
switch ($field) {
case "cateID":
VIEW::assignGlobal("VALUE_" . strtoupper($field) . "_OPTION", AD::cateSelect($var));
break;
case "status":
VIEW::assignGlobal("VALUE_" . strtoupper($field) . "_CK" . $var, 'selected');
break;
default:
VIEW::assignGlobal("VALUE_" . strtoupper($field), $var);
break;
}
}
IMAGES::output('ad', $row["id"]);
SEO::load($row["seo_id"]);
SEO::output();
$last_page = SESS::get("PAGE");
if (!empty($last_page)) {
VIEW::assignGlobal("VALUE_BACK_LINK", CORE::$manage . "ad/page-{$last_page}/");
} else {
VIEW::assignGlobal("VALUE_BACK_LINK", CORE::$manage . "ad/");
}
} else {
self::$temp["MAIN"] = self::$temp_option["MSG"];
CORE::msg(self::$lang["no_args"], CORE::$manage . 'ad/');
}
}
/**
* Returns a User's info from AD data
*/
private function getADUserInfo($ad_account)
{
try {
// Get User info from Active Directory
$ADUserData = AD::getUser($ad_account);
$data = array('location_id' => Location::getIdFromName($ADUserData['office']), 'ad_account' => $ADUserData['account'], 'employee_id' => $ADUserData['employeeid'], 'display_name' => $ADUserData['displayname'], 'email' => $ADUserData['email'], 'active' => '1');
return $data;
} catch (\Exception $e) {
// Log Error
Session::flash('alert_danger', 'Unable to access User AD data.');
return $this->handleRideShareLogError($e, 'Unable to access User AD data.');
}
}
function __construct($uid, $uidType = OUSER_LOGIN)
{
// parent::__construct(array(OLDAP_DN,OLDAP_DN1), array( 'cn',
parent::__construct(OLDAP_DN, array('cn', 'samaccountname', 'telephonenumber', 'manager', 'mail', 'department', 'description', 'useraccountcontrol', 'directreports', 'userworkstations', 'lastlogon', 'lastlogoff', 'lastlogontimestamp', 'badpasswordtime', 'logoncount', 'memberof', 'pwdlastset', 'whencreated', 'whenchanged', 'employeeid'));
$uid = str_replace(array('(', ')'), array('\\(', '\\)'), $uid);
switch ($uidType) {
case OUSER_FULLNAME:
$i = strpos($uid, ',');
$uid = substr($uid, 3, $i - 3);
case OUSER_CN:
$this->_execute('(&(cn=' . $uid . ')(&(objectClass=user)(!(objectClass=computer))))');
break;
case OUSER_TAB:
//5.2.2
$this->_execute('(&(employeeid=' . $uid . ')(&(objectClass=user)(!(objectClass=computer))))');
break;
default:
$this->_execute('(&(|(userPrincipalName=' . $uid . ')(SAMAccountName=' . $uid . '))(&(objectClass=user)(!(objectClass=computer))))');
}
if ($this->count > 1) {
for ($i = 0; $i < $this->count; $i++) {
$this->userworkstations[$i] = explode(',', $this->userworkstations[$i]);
//5.0.2
}
} else {
$this->userworkstations = explode(',', $this->userworkstations);
//5.0.2
}
}
// $filter = "(samaccountname=$aacount*)";
} else {
header("Location: login.php");
exit;
}
// ****************************************************************************************
// Passwort aus Session holen
// ****************************************************************************************
if (isset($_SESSION['pwd'])) {
$pwd = $_SESSION['pwd'];
}
// ****************************************************************************************
// AD Objekt erzeugen
// ****************************************************************************************
$adh = new ADHelper();
$ad = new AD($ad_ldap_server, $ad_auth_user, $ad_auth_pass, $ldap_usr_predom, $stadtleser_dn);
$ldapconn = $ad->get_ADConnection();
// ****************************************************************************************
// Mysql Connection herstellen und verbinden
// ****************************************************************************************
$mysqlconn = mysql_connect($mysqlhost, $mysqluser, $mysqlpwd);
if (!mysql_select_db($mysqldb, $mysqlconn)) {
exit("SQL Select-DB ist fehlgeschlagen");
}
$showdetails = 0;
// ****************************************************************************************
// verzweigen wenn Benutzer aktivieren geklickt wurde
// ****************************************************************************************
if (isset($_POST['aktivierebenutzer'])) {
if ($_POST['aktivierebenutzer'] == "freischalten") {
// echo "<html><head>";
