public function onLoad($param)
{
parent::onLoad($param);
if (!$this->isPostBack && !$this->isCallback) {
if ($this->Request['rqidtm_ziele'] != '') {
$this->rqidtm_ziele = $this->Request['rqidtm_ziele'];
}
$HRKEYtop = new PFHierarchyPullDown();
$HRKEYtop->setStructureTable("tm_ziele");
$HRKEYtop->setRecordClass(ZieleRecord::finder());
$HRKEYtop->setPKField("idtm_ziele");
$HRKEYtop->setField("zie_name");
$HRKEYtop->setSQLCondition("idta_ziele_type=1");
$HRKEYtop->letsrun();
$this->idtm_ziele->DataSource = $HRKEYtop->myTree;
$this->idtm_ziele->dataBind();
$NEWRECORD = $this->NewRecord;
$NEWRECORD->setText("neues Element anlegen");
$NEWRECORD->setToPage("ziele.zieleview");
$NEWRECORD->setGetVariables('modus=0');
$NEWSTRECORD = $this->NewStepRecord;
$NEWSTRECORD->setText("operatives Ziel anlegen");
$NEWSTRECORD->setToPage("ziele.ttzieleview");
$NEWSTRECORD->setGetVariables('modus=0');
$this->bindListOrgListe();
}
}
public function onLoad($param)
{
parent::onLoad($param);
if (!$this->IsPostBack) {
$this->setViewState("clicks", 0);
}
}
public function onLoad($param)
{
parent::onLoad($param);
$this->dbConexion = Conexion::getConexion($this->Application, "dbpr");
Conexion::createConfiguracion();
$fechaInicial = $_REQUEST['id'];
$fechafinal = $_REQUEST['id2'];
$fecha_actual = date("Y-m-d H:i:s");
$this->lblfechaActual->Text = $fecha_actual;
$this->lblfechaInicial->Text = $fechaInicial;
$this->lblfechafinal->Text = $fechafinal;
$consulta = "SELECT sum(diferencia) AS saldoFinalTotal_1 FROM repdetallemovtos";
$comando = $this->dbConexion->createCommand($consulta);
$resultado = $comando->query()->readAll();
$this->lblsaldoFinalTotal->Text = $resultado[0]["saldoFinalTotal_1"];
$this->mostrarDatosGriddetalle_movtos();
$consulta = " SELECT sum(totalSemana) as totalSemana, sum(totalQuincena) as totalQuincena, sum(totalActivos) as totalActivos, sum(totalJubilados) as totalJubilados, sum(granTotal) as granTotal FROM Desglose_abonos";
$comando = $this->dbConexion->createCommand($consulta);
$resultado = $comando->query()->readAll();
$this->lblTotalSemanas->Text = $resultado[0]["totalSemana"];
$this->lblTotalquicena->Text = $resultado[0]["totalQuincena"];
$this->lblTotalactivos->Text = $resultado[0]["totalActivos"];
$this->lblTotalJubilados->Text = $resultado[0]["totalJubilados"];
$this->lblSubTotal->Text = $resultado[0]["granTotal"];
$this->mostrarDatosGridNomina();
$this->mostrarDatosGridMovimiento8();
//$this->mostrarDatosGriddetalle_desglose ();
}
public function onLoad($param)
{
parent::onLoad($param);
if (!$this->isPostBack && !$this->isCallback) {
$this->clearLog(null, null);
}
}
public function onLoad($param)
{
parent::onLoad($param);
$handler = $this->Application->getErrorHandler();
$this->ErrorCode->setText($handler->getErrorCode());
$this->ErrorMessage->setText($handler->getErrorMessage());
}
public function onLoad($param)
{
parent::onLoad($param);
if (!$this->User->IsAdmin()) {
return;
}
require "config.php";
$data = array();
/*
** 2006-04-06 PDurden - Walk through the files in the repository
** location. If the file is a directory, check to see if the repository
** name exists. If the name does not exist, then add it to the data
** array
*/
if ($handle = opendir($svn_repos_loc)) {
while (false !== ($dir = readdir($handle))) {
if ($dir != "." && $dir != "..") {
$file = $svn_repos_loc . DIRECTORY_SEPARATOR . $dir;
if (is_dir($file)) {
if (!$this->Module->repositoryExists($dir)) {
$data[] = array('repositoryname' => $dir);
}
}
}
}
closedir($handle);
}
$this->RepositoryTable->setDataSource($data);
$this->RepositoryTable->dataBind();
}
public function onLoad($param)
{
parent::onLoad($param);
if (!$this->isPostBack and !$this->isCallBack) {
$this->Lbl->setText(date("h:m:s"));
}
}
public function onLoad($param)
{
parent::onLoad($param);
if (!$this->IsPostBack) {
$this->bind_lstTranslations();
}
}
public function onLoad($param)
{
parent::onLoad($param);
$this->cn = new DbCon($this, "db");
$this->codigo = $this->hidFacebook->Value;
//mt_rand();
}
public function onLoad($param)
{
parent::onLoad($param);
if (!$this->isPostBack && !$this->isCallback) {
$this->bindListOrgListe();
}
}
public function onLoad($param)
{
parent::onLoad($param);
$idUser = null;
$idUser = (int) $this->Request['idUser'];
$this->zone_list_add_racquets_customer->Visible = true;
$this->editable->Visible = false;
$this->Page->Title = Prado::localize('ManageCustomersRacquets');
$this->LBL_LIST_RACQUETS_TO_ADD->Text = Prado::localize('SelectRacquet');
$this->Search_2->ImageUrl = $this->Page->Theme->BaseUrl . '/images/' . $this->getApplication()->getGlobalization()->Culture . '/search.gif';
$this->Cancel_2->ImageUrl = $this->Page->Theme->BaseUrl . '/images/' . $this->getApplication()->getGlobalization()->Culture . '/cancel.gif';
$this->Save->ImageUrl = $this->Page->Theme->BaseUrl . '/images/' . $this->getApplication()->getGlobalization()->Culture . '/save.gif';
$this->Cancel_3->ImageUrl = $this->Page->Theme->BaseUrl . '/images/' . $this->getApplication()->getGlobalization()->Culture . '/cancel.gif';
$this->Help->ImageUrl = $this->Page->Theme->BaseUrl . '/images/' . $this->getApplication()->getGlobalization()->Culture . '/help.gif';
$this->btnCancelSelect->ImageUrl = $this->Page->Theme->BaseUrl . '/images/' . $this->getApplication()->getGlobalization()->Culture . '/cancel.gif';
if (!$this->IsPostBack) {
$this->DataGridAddRacquets->DataSource = $this->DataAddRacquets;
$this->DataGridAddRacquets->dataBind();
}
if ($this->User->UserDB->type_user_id == 4) {
$this->Save->Visible = false;
} else {
$this->Save->Visible = true;
}
}
public function onLoad($param)
{
parent::onLoad($param);
$userid = $this->User->getId();
if ($this->User->IsAdmin()) {
$results = $this->Module->Database->Execute("SELECT * FROM repositories ORDER BY name");
} else {
$results = $this->Module->Database->Execute("SELECT * FROM repositories WHERE ownerid=" . makeSqlString($userid));
}
if ($results) {
$data = array();
while (!$results->EOF) {
$fields = $results->fields;
$owner = $this->Module->getUserName($fields['ownerid']);
$repoID = $fields['id'];
$descrResults = $this->Module->Database->Execute("SELECT * FROM repo_descriptions WHERE repo_id=" . makeSqlString($repoID));
$descrFields = $descrResults->fields;
if ($descrFields['id']) {
$description = wordwrap(htmlspecialchars($descrFields['description']), 40, "<br />\n");
$description = $descrFields['description'];
} else {
$description = "No description for " . $fields['name'] . " repository";
}
$data[] = array('id' => $fields['id'], 'repositoryname' => $fields['name'], 'owner' => $owner, 'description' => $description);
$results->MoveNext();
$this->RepositoryTable->setDataSource($data);
}
$results->Close();
}
$this->dataBind();
}
public function onLoad($param)
{
parent::onLoad($param);
$this->dbConexion = Conexion::getConexion($this->Application, "db");
Conexion::createConfiguracion();
if (!$this->IsPostBack) {
if (isset($this->Request["nota"])) {
$nota = Conexion::Retorna_Registro($this->dbConexion, "notas", array("id_nota" => $this->Request["nota"]));
if (count($nota) > 0) {
if ($nota[0]["id_status"] == 2) {
$usuario = Conexion::Retorna_Campo($this->dbConexion, "usuarios", "nombre", array("id_usuario" => $nota[0]["id_usuario"]));
$this->txtVendedor->Text = $usuario;
$this->txtFecha->Text = date("d-m-Y", strtotime($nota[0]["generada"]));
$this->txtHora->Text = date("H:i:s", strtotime($nota[0]["generada"]));
$this->txtGenerales->Text = "Datos de la empresa";
$consulta = "SELECT p.Codigo, p.Descripcion, np.Cantidad, np.Precio, np.cantidad * np.precio AS Total " . "FROM productos p JOIN notas_productos np ON p.id_producto = np.id_producto " . "WHERE np.id_nota = :id_nota";
$comando = $this->dbConexion->createCommand($consulta);
$comando->bindValue(":id_nota", $this->Request["nota"]);
$resultado = $comando->query()->readAll();
$this->dgProductos->DataSource = $resultado;
$this->dgProductos->dataBind();
} elseif ($nota[0]["id_status"] == 1) {
$this->getClientScript()->registerBeginScript("entregada", "alert('La nota solicitada no ha sido pagada.');\n" . "document.location.href = 'index.php?page=Entrega';\n");
} else {
$this->getClientScript()->registerBeginScript("entregada", "alert('La nota solicitada ya ha sido entregada.');\n" . "document.location.href = 'index.php?page=Entrega';\n");
}
} else {
$this->getClientScript()->registerBeginScript("sin_nota", "alert('La nota solicitada no existe');\n" . "document.location.href = 'index.php?page=Entrega';\n");
}
}
}
}
public function onLoad($param)
{
//Globale definition f�r dieses Dokument
$this->finder = TerminRecord::finder();
$this->MASTERRECORD = new TerminRecord();
$this->setUserStartId($this->user->getStartNode($this->user->getUserId($this->user->Name), "tm_activity"));
date_default_timezone_set('Europe/Berlin');
parent::onLoad($param);
if (!$this->isPostBack && !$this->isCallback) {
$HRKEYTest = new PFHierarchyPullDown();
$HRKEYTest->setStructureTable("tm_activity");
$HRKEYTest->setRecordClass(ActivityRecord::finder());
$HRKEYTest->setPKField("idtm_activity");
$HRKEYTest->setField("act_name");
$HRKEYTest->setStartNode($this->UserStartId);
$HRKEYTest->setSQLCondition("idta_activity_type = 2");
$HRKEYTest->letsrun();
$this->FFidtm_activity->DataSource = $HRKEYTest->myTree;
$this->FFidtm_activity->dataBind();
$tmpstartdate = new DateTime();
$this->ter_startdate->setDate($tmpstartdate->format("Y-m-d"));
$this->ter_enddate->setDate($tmpstartdate->format("Y-m-d"));
$this->ttidtm_ressource->DataSource = PFH::build_SQLPullDown(RessourceRecord::finder(), "tm_ressource", array("idtm_ressource", "res_name"), "idta_ressource_type>1");
$this->ttidtm_ressource->dataBind();
$this->bindListTermin();
}
}
public function onLoad($param)
{
parent::onLoad($sender, $param);
if (!$this->IsPostBack && !$this->isCallback) {
$this->bindList();
}
}
public function onLoad($param)
{
parent::onLoad($param);
//if($this->IsPostBack && $this->IsValid)
if ($this->IsPostBack) {
$def = $this->ClassDefinition;
$def->reset();
$def->ClassName = $this->ClassName->Text;
$def->ParentClass = $this->ParentClass->Text;
$def->Interfaces = $this->Interfaces->Text;
$def->Comments = $this->Comments->Text;
$def->Author = $this->AuthorName->Text;
$def->Email = $this->AuthorEmail->Text;
foreach ($this->PropertyList->Items as $item) {
$property = new PropertyDefinition();
$property->Name = $item->PropertyName->Text;
$property->Type = $item->PropertyType->Text;
$property->DefaultValue = $item->DefaultValue->Text;
$property->ReadOnly = $item->ReadOnly->Checked;
$property->IsProtected = $item->IsProtected->Checked;
$property->Comments = $item->Comments->Text;
$property->Storage = $item->Storage->Text;
$def->Properties[] = $property;
}
foreach ($this->EventList->Items as $item) {
$event = new EventDefinition();
$event->Name = $item->EventName->Text;
$event->Comments = $item->Comments->Text;
$def->Events[] = $event;
}
}
}
public function onLoad($param)
{
parent::onLoad($param);
$this->dbConexion = Conexion::getConexion($this->Application, "dbpr");
Conexion::createConfiguracion();
$idcontrato = $_REQUEST['id'];
$consulta = "SELECT c.id_contrato AS contrato, s.importe AS importe ,s.importeCheque AS ImporteDeCheque,t.nombre AS nombre ,c.entrega_cheque AS FechaDeCheque, s.descuento AS descuento\n\t\t\t\t\t,(SELECT sindicato FROM catsindicatos WHERE cve_sindicato = t.sindicato) AS Sindicato,plazo as plazo,saldo_anterior as saldo_anterior,entrega_real as entrega_real\n\t\t\t\t\t,(SELECT COUNT(*) AS movimientos FROM movimientos WHERE id_tipo_movto = 2 and id_contrato = c.id_contrato) AS AbonosRealizados\n\t\t\t\t\t,(SELECT COUNT(*) AS movimientos FROM movimientos WHERE id_contrato = c.id_contrato) AS MovimientosRealizados\n\t\t\t\t\t,(SELECT (SUM(cargo) - SUM(abono) ) AS saldo FROM movimientos WHERE id_contrato = c.id_contrato) AS SaldoActual\n\t\t\t\t\t,s.descuento as descuento\n\t\t\t\t\tFROM contrato AS c\n\t\t\t\t\tLEFT JOIN solicitud AS s\tON c.id_solicitud = s.id_solicitud\n\t\t\t\t\tLEFT JOIN sujetos AS t ON t.numero = s.titular\t\n\t\t\t\t\tWHERE c.id_contrato = :idcontrato";
$comando = $this->dbConexion->createCommand($consulta);
$comando->bindValue(":idcontrato", $idcontrato);
$result = $comando->query()->readAll();
if (count($result) > 0) {
$plazo = $result[0]["plazo"];
$seguro = 0.0;
$saldoAnterior = $result[0]["saldo_anterior"];
$this->lblContrato2->Text = $result[0]["contrato"];
$this->lblNombre3->Text = $result[0]["nombre"];
$this->lblSindicato4->Text = $result[0]["Sindicato"];
$this->lblPrestamo2->Text = $result[0]["importe"];
$intereses = THttpUtility::htmlEncode(round($this->lblPrestamo2->Text * $plazo * (1.0 / 100)));
$this->lblImporteDeCheque3->Text = $result[0]["ImporteDeCheque"];
$this->lblDescuentoQuincenal4->Text = $result[0]["descuento"];
$this->lblInteres2->Text = $intereses;
$cheque = $this->lblPrestamo2->Text - ($intereses + $saldoAnterior + $seguro);
$this->lblImporteDeCheque3->Text = $cheque;
$this->lblFechaDeCheque3->Text = $result[0]["entrega_real"];
$this->lblAbonosRealizados4->Text = $result[0]["AbonosRealizados"];
$this->mostrarDatosGrid();
}
}
public function onLoad($param)
{
parent::onLoad($param);
$this->Page->Title = Prado::localize('ManageCustomersRacquets');
$this->Search->ImageUrl = $this->Page->Theme->BaseUrl . '/images/' . $this->getApplication()->getGlobalization()->Culture . '/search.gif';
$this->Cancel->ImageUrl = $this->Page->Theme->BaseUrl . '/images/' . $this->getApplication()->getGlobalization()->Culture . '/cancel.gif';
$this->Search_1->ImageUrl = $this->Page->Theme->BaseUrl . '/images/' . $this->getApplication()->getGlobalization()->Culture . '/search.gif';
$this->Cancel_1->ImageUrl = $this->Page->Theme->BaseUrl . '/images/' . $this->getApplication()->getGlobalization()->Culture . '/cancel.gif';
$this->Search_2->ImageUrl = $this->Page->Theme->BaseUrl . '/images/' . $this->getApplication()->getGlobalization()->Culture . '/search.gif';
$this->Cancel_2->ImageUrl = $this->Page->Theme->BaseUrl . '/images/' . $this->getApplication()->getGlobalization()->Culture . '/cancel.gif';
$this->btnAddRacquet->ImageUrl = $this->Page->Theme->BaseUrl . '/images/' . $this->getApplication()->getGlobalization()->Culture . '/new-racquet.gif';
$this->Save->ImageUrl = $this->Page->Theme->BaseUrl . '/images/' . $this->getApplication()->getGlobalization()->Culture . '/save.gif';
$this->Cancel_3->ImageUrl = $this->Page->Theme->BaseUrl . '/images/' . $this->getApplication()->getGlobalization()->Culture . '/cancel.gif';
$this->Help->ImageUrl = $this->Page->Theme->BaseUrl . '/images/' . $this->getApplication()->getGlobalization()->Culture . '/help.gif';
$this->btnCancelSelect->ImageUrl = $this->Page->Theme->BaseUrl . '/images/' . $this->getApplication()->getGlobalization()->Culture . '/cancel.gif';
if (!$this->IsPostBack) {
$this->ResetAll();
$this->DataGridCustomers->DataSource = $this->Data;
$this->DataGridCustomers->dataBind();
$idUser = null;
$idUser = (int) $this->Request['idUser'];
if ($idUser != null) {
$i = 0;
foreach ($this->Data as $row) {
if ($row['id'] == $idUser) {
$this->DataGridCustomers->SelectedItemIndex = $i;
$this->selectBackCustomer($idUser);
}
$i++;
}
}
}
}
public function onLoad($param)
{
parent::onLoad($param);
$list = $this->getPageList(dirname(__FILE__), '');
$this->List->DataSource = $list;
$this->List->dataBind();
}
public function onLoad($param)
{
parent::onLoad($param);
$this->dbConexion = Conexion::getConexion($this->Application, "db");
Conexion::createConfiguracion();
if (!$this->isPostBack) {
if (array_search("nusr", $this->User->Roles)) {
//Lee el archivo menu.xml para buscar los permisos de acceso a páginas que tenga activos para mostrar opciones
$this->permisos = array();
$this->asignados = array();
$doc = new TXmlDocument();
$doc->loadFromFile("protected/layouts/menu.xml");
$x = $doc->getElements();
$this->leeMenuXml($x);
$this->cblPermisos->setDataSource($this->permisos);
$this->cblPermisos->dataBind();
}
$this->Enlaza_Coord();
$this->Enlaza_Usuario();
if (!array_search("nusr", $this->User->Roles)) {
$this->addlUsuarios->SelectedValue = $this->User->Name;
$this->addlUsuarios_Callback(null, null);
$this->addlUsuarios->Visible = false;
$this->alblUsuarios->Visible = false;
$this->alblPermisos->Visible = false;
$this->atxtUsuario->Enabled = false;
}
}
}
public function onLoad($param)
{
parent::onLoad($param);
$checkNewsletter = nNewsletterRecord::finder()->findByStatus(1);
if ($checkNewsletter) {
$layout = nLayoutRecord::finder()->findBy_nNewsletterID($checkNewsletter->ID);
$mail = new PHPMailer();
$mail->isSendmail();
$mail->setFrom('*****@*****.**', 'First Last');
$mail->addReplyTo('*****@*****.**');
$lista = nSenderRecord::finder()->findAll('nLayoutID = ? AND Status = 0 LIMIT 25', $layout->ID);
foreach ($lista as $person) {
$mail->addAddress($person->Email);
$mail->Subject = $checkNewsletter->Name;
$mail->msgHTML($layout->HtmlText);
if ($mail->send()) {
$person->Status = 1;
$person->save();
} else {
$person->Status = 5;
$person->save();
echo "Mailer Error: " . $mail->ErrorInfo;
}
}
if (empty($lista)) {
$checkNewsletter->Status = 0;
$checkNewsletter->save();
}
}
die;
}
public function onLoad($param)
{
parent::onLoad($param);
if (!$this->IsPostBack) {
$this->Session->open();
if (!isset($this->Session['customer'])) {
// There customer is missing in the session, redirect to login page.
$this->Response->redirect($this->Service->constructUrl('Login', null, true));
} else {
if (!isset($this->Session['infoscreenid'])) {
// The infoscreenid is missing in the session, redirect to list.
$this->Response->redirect($this->Service->constructUrl('ListInfoscreens', null, true));
} else {
$customer = $this->Session['customer'];
$infoscreenid = $this->Session['infoscreenid'];
$infoscreen = $customer->getInfoscreen($infoscreenid);
$this->Title->Data = $infoscreen->getTitle();
$this->Motd->Data = $infoscreen->GetMotd();
$this->Rows->Data = $infoscreen->getSettingValue("rowstoshow");
$this->Cycle->Data = $infoscreen->getSettingValue("cycleinterval");
$this->Color->Data = $infoscreen->getSettingValue("color");
$this->Lang->DataSource = array("en" => "EN", "nl" => "NL", "de" => "DE", "fr" => "FR");
$this->Lang->dataBind();
}
}
}
}
public function onLoad($param)
{
parent::onLoad($param);
if (!$this->IsPostBack) {
$this->datepicker->setTimeStamp(time());
}
}
public function onLoad($param)
{
parent::onLoad($param);
if (!$this->isPostBack && !$this->isCallback) {
$this->bind_lstUser();
}
}
public function onLoad($param)
{
parent::onLoad($param);
if (!$this->IsPostBack && !$this->IsCallback) {
$this->resetClicked(null, null);
}
}
public function onLoad($param)
{
parent::onLoad($param);
if (!$this->IsPostBack && !$this->IsCallBack) {
//falls etwas zum start benoetigt wuerde
}
}
public function onLoad($param)
{
parent::onLoad($param);
date_default_timezone_set('Europe/Berlin');
if (!$this->IsPostBack || !$this->IsCallBack) {
$sql = "SELECT idta_organisation_type, org_type_name FROM ta_organisation_type";
$data = PFH::convertdbObjectArray(OrganisationTypeRecord::finder()->findAllBySql($sql), array("idta_organisation_type", "org_type_name"));
$this->RCedidta_organisation_type->DataSource = $data;
$this->RCedidta_organisation_type->dataBind();
$this->RCedidta_organisation_art->DataSource = $this->idta_organisation_art;
$this->RCedidta_organisation_art->dataBind();
$this->RCedorg_idtm_user_role->DataSource = PFH::build_SQLPullDown(UserRoleRecord::finder(), "tm_user_role", array("idtm_user_role", "user_role_name"));
$this->RCedorg_idtm_user_role->dataBind();
$this->RCedidta_branche->DataSource = PFH::build_SQLPullDown(BrancheRecord::finder(), "ta_branche", array("idta_branche", "bra_name"));
$this->RCedidta_branche->dataBind();
$this->RCedidtm_ressource->DataSource = PFH::build_SQLPullDown(RessourceRecord::finder(), "tm_ressource", array("idtm_ressource", "res_name"));
$this->RCedidtm_ressource->dataBind();
$this->RCedidtm_country->DataSource = PFH::build_SQLPullDown(CountryRecord::finder(), "tm_country", array("idtm_country", "country_iso"));
$this->RCedidtm_country->dataBind();
$this->RCedkom_type->DataSource = array(1 => "Telefon", "Fax", "Mail");
$this->RCedkom_type->dataBind();
$this->RCedorg_status->DataSource = array(0 => "offen", "interessant", "nicht interessant", "Kunde", "EX-Kunde");
$this->RCedorg_status->dataBind();
if (isset($_GET['idtm_organisation'])) {
$this->view_Organisation($_GET['idtm_organisation']);
} else {
$this->view_Organisation(1);
}
//$this->bindListOrgListe();
}
}
public function onLoad($param)
{
parent::onLoad($param);
$this->dbConexion = Conexion::getConexion($this->Application, "dbpr");
Conexion::createConfiguracion();
$this->mostrarDatosGrid();
}
public function onLoad($param)
{
parent::onLoad($param);
$this->dbConexion = Conexion::getConexion($this->Application, "db");
Conexion::createConfiguracion();
if (!$this->IsPostBack) {
if (isset($this->Request["nota"])) {
$subtotal = Conexion::Retorna_Campo($this->dbConexion, "notas_productos", "SUM(precio * cantidad)", array("id_nota" => $this->Request["nota"]));
$datos_nota = Conexion::Retorna_Registro($this->dbConexion, "notas", array("id_nota" => $this->Request["nota"]));
if ($datos_nota[0]["vales"] > 0) {
$vale = Conexion::Retorna_Campo($this->dbConexion, "parametros", "valor", array("llave" => "vale"));
$descuento = $vale * $datos_nota[0]["vales"];
} else {
$descuento = $subtotal * $datos_nota[0]["descuento"] / 100;
}
$this->lblNota->Text = $this->Request["nota"];
$this->lblSubtotal->Text = $subtotal;
$this->lblDescuento->Text = $descuento;
$this->lblTotal->Text = $subtotal - $descuento;
$this->Master->Page->Title = "Nota " . $this->Request["nota"];
$consulta = "SELECT p.Descripcion, np.Cantidad, np.Precio, np.cantidad * np.precio AS Total " . "FROM productos p JOIN notas_productos np ON p.id_producto = np.id_producto " . "WHERE np.id_nota = :id_nota";
$comando = $this->dbConexion->createCommand($consulta);
$comando->bindValue(":id_nota", $this->Request["nota"]);
$resultado = $comando->query()->readAll();
$this->dgProductos->DataSource = $resultado;
$this->dgProductos->dataBind();
}
}
}
public function onLoad($param)
{
parent::onLoad($param);
$this->filter = isset($_GET[self::FILTER]) ? $_GET[self::FILTER] : '';
if (strlen($this->filter) > 0) {
$this->filter = strtoupper($this->filter[0]);
}
$this->ShowAll->setEnabled($this->filter >= 'A' && $this->filter <= 'Z');
$filters = $this->Filters;
for ($f = 65; $f <= 90; ++$f) {
$char = chr($f);
$link = $this->createComponent('THyperLink', $char);
$link->Text = $char;
$link->Enabled = $this->filter !== $char;
$link->NavigateUrl = $this->Request->constructUrl($this->ID, array(self::FILTER => $char));
$filters->addBody(' ');
// separating space
$filters->addBody($link);
}
if (strlen($this->filter)) {
$rs = $this->db->Execute("SELECT * FROM tblEntry WHERE upper(name) like '{$this->filter}%'");
} else {
$rs = $this->db->Execute('SELECT * FROM tblEntry');
}
$this->EntryTable->setDataSource($rs);
$this->dataBind();
}