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>";