public function onPreInit($param)
 {
     //error_reporting(E_ALL ^ E_NOTICE);
     $request_user = $_GET['user'];
     $request_password = $_GET['pass'];
     $authManager = $this->Application->getModule('auth');
     if (!$authManager->login($request_user, $request_password)) {
         exit;
     }
     $this->getResponse()->appendHeader("Content-Type:" . $this->header);
     echo '<?xml version="1.0" ?><tm_organisation>';
     $SQL = "SELECT * FROM tm_organisation";
     $Results = OrganisationRecord::finder()->findAllBySQL($SQL);
     foreach ($Results as $Result) {
         echo "<row idtm_organisation='" . $Result->idtm_organisation . "'>";
         echo "<parent_idtm_organisation>" . $Result->parent_idtm_organisation . "</parent_idtm_organisation>";
         if ($Result->org_name == '') {
             echo "<org_name>ERROR_NO_ORGNAME</org_name>";
         } else {
             echo "<org_name>" . $Result->org_name . "</org_name>";
         }
         if ($Result->org_matchkey == '') {
             echo "<org_matchkey>empty</org_matchkey>";
         } else {
             echo "<org_matchkey>" . $Result->org_matchkey . "</org_matchkey>";
         }
         echo "</row>";
     }
     echo '</tm_organisation>';
     exit;
 }
Exemplo n.º 2
0
 public function importTASK($data)
 {
     $Aufgabe = new AufgabenRecord();
     $Aufgabe->auf_tdate = $data[0];
     $Aufgabe->auf_cdate = date($data[0]);
     $Aufgabe->auf_tag = $data[3];
     $Aufgabe->auf_name = 'AC Imp';
     $Aufgabe->auf_zeichen_eigen = utf8_encode($data[7]);
     $Aufgabe->auf_zeichen_fremd = '';
     $Aufgabe->idta_aufgaben_type = 1;
     $Aufgabe->idtm_organisation = $this->responsible_idtm_organisation->Text;
     $Aufgabe->auf_tabelle = "tm_organisation";
     if ($data[2] * 1 < 1000) {
         $data[2] = '0' . $data[2];
     }
     $Organisation = OrganisationRecord::finder()->findByorg_fk_internal('0' . trim($data[2]));
     if (count($Organisation) == 1) {
         $Aufgabe->auf_id = $Organisation->idtm_organisation;
     } else {
         $Aufgabe->auf_id = $this->responsible_idtm_organisation->Text;
     }
     $Aufgabe->auf_done = $data[6];
     if ($data[5] != '') {
         $Aufgabe->auf_ddate = $data[5];
     } else {
         $Aufgabe->auf_ddate = $data[0];
     }
     $html_string = "<b>" . utf8_encode($data[8]) . "</b><br/>";
     $html_string .= utf8_encode($data[9]) . "<br/>";
     $html_string .= "<b>" . utf8_encode($data[10]) . "</b><br/>";
     $html_string .= utf8_encode($data[11]);
     $Aufgabe->auf_beschreibung = $html_string;
     $Aufgabe->save();
     unset($Aufgabe, $Organisation);
 }
Exemplo n.º 3
0
 private function generateListFields()
 {
     $this->idtm_organisation->DataSource = PFH::build_SQLPullDown(OrganisationRecord::finder(), "tm_organisation", array("idtm_organisation", "org_name"), "idta_organisation_type = 4");
     $this->idtm_organisation->dataBind();
     $this->idta_protokoll_ergebnistype->DataSource = PFH::build_SQLPullDown(ProtokollErgebnistypeRecord::finder(), "ta_protokoll_ergebnistype", array("idta_protokoll_ergebnistype", "prt_ergtype_name"));
     $this->idta_protokoll_ergebnistype->dataBind();
 }
 public function bindListBelegungsplan()
 {
     $criteria = new TActiveRecordCriteria();
     $criteria->Condition = "idtm_user > 0 ";
     $this->Belegungsplan->DataSource = OrganisationRecord::finder()->findAll($criteria);
     $this->Belegungsplan->dataBind();
 }
Exemplo n.º 5
0
 public function PFMailSend($sender, $param)
 {
     $Aufgabe = ProtokollDetailAufgabeView::finder()->findByidtm_protokoll_detail($param->CallbackParameter);
     $MailEmpfaenger = OrganisationRecord::finder()->findByPk($Aufgabe->idtm_organisation);
     $mail = new PHPMailer();
     $mail->From = "*****@*****.**";
     $mail->FromName = "planlogIQ";
     $mail->Host = "smtp.1und1.de";
     $mail->Mailer = "smtp";
     $mail->SMTPAuth = true;
     $mail->IsSendmail();
     //nur bei 1und1
     $mail->Username = "******";
     $mail->Password = "";
     $mail->AddAddress(KommunikationRecord::finder()->find('idtm_organisation=? AND kom_ismain=1 AND kom_type = 3', $Aufgabe->idtm_organisation)->kom_information, $MailEmpfaenger->org_name);
     $mail->Subject = $Aufgabe->prtdet_topic;
     $HTMLMessage = "Sehr geehrte(r) Frau/Herr " . $MailEmpfaenger->org_name . ",<br/><br/>";
     $HTMLMessage .= "die folgende Aufgabe wurde Ihnen zugeordnet:<br/>";
     $HTMLMessage .= "<p><table><tr><td bgcolor='#efefef'>TOP Nr.:</td><td>" . $Aufgabe->idtm_protokoll_detail_group . " </td><td bgcolor='#efefef'>Thema: </td><td>" . utf8_decode($Aufgabe->prtdet_topic) . "</td></tr>";
     $HTMLMessage .= "<tr><td bgcolor='#efefef'>Bis:</td><td colspan='3'><b>" . $Aufgabe->auf_tdate . "</b></td></tr></table>";
     $HTMLMessage .= "<p style='background-color:#efefef'><hr/>" . utf8_decode($Aufgabe->prtdet_descr) . "</p>";
     $HTMLMessage .= "<p style='background-color:#efefef'><hr/>" . utf8_decode($Aufgabe->auf_beschreibung) . "<hr/></p>";
     $HTMLMessage .= "Bitte nicht Antworten! Diese Mail wurde automatisch generiert...";
     $mail->MsgHTML($HTMLMessage);
     if (!$mail->Send()) {
         $this->PFMAILER->TEXT = "error sending the message";
     } else {
         $this->PFMAILER->TEXT = "..done..";
     }
 }
 private function load_all_cats($TTSQL)
 {
     $rows = OrganisationRecord::finder()->findAllbySQL($TTSQL);
     foreach ($rows as $row) {
         $this->subcats[$row->parent_idtm_organisation][] = $row->idtm_organisation;
         $this->parentcats[$row->idtm_organisation] = $row->parent_idtm_organisation;
     }
 }
Exemplo n.º 7
0
 public function bindListOrgListe()
 {
     $criteria = new TActiveRecordCriteria();
     $criteria->Condition = "idtm_organisation = :suchtext1";
     $criteria->Parameters[':suchtext1'] = $this->idtm_organisation;
     $this->OrgListe->DataSource = OrganisationRecord::finder()->findAll($criteria);
     $this->OrgListe->dataBind();
 }
Exemplo n.º 8
0
 public function onLoad($param)
 {
     parent::onLoad($param);
     //Globale definition f�r dieses Dokument
     $this->finder = TTZieleRecord::finder();
     $this->MASTERRECORD = new TTZieleRecord();
     if (!$this->isPostBack && !$this->isCallback) {
         switch ($this->Request['modus']) {
             case 0:
                 //hier checken wir, wieviele schritte noch den gleichen Vater haben
                 $myPreStepOne = TTZieleRecord::finder()->findAllBySql("SELECT idtm_prozess FROM tt_ziele WHERE idtt_ziele = '" . $this->Request[$this->primarykey] . "'");
                 $prozess_counter = count(TTZieleRecord::finder()->findAllBySql("SELECT idtt_ziele FROM tt_ziele WHERE idtm_ziele = '" . $myPreStepOne[0]->idtm_ziele . "'"));
                 $this->idtm_prozess->DataSource = PFH::build_SQLPullDown(ProzessRecord::finder(), "tm_prozess", array("idtm_prozess", "pro_name"), "idta_prozess_type = 3");
                 $this->idtm_prozess->dataBind();
                 $HRKEYTest = new PFHierarchyPullDown();
                 $HRKEYTest->setStructureTable("tm_ziele");
                 $HRKEYTest->setRecordClass(ZieleRecord::finder());
                 $HRKEYTest->setPKField("idtm_ziele");
                 $HRKEYTest->setField("zie_name");
                 $HRKEYTest->setSQLCondition("idta_ziele_type = 3 OR idta_ziele_type=1 OR idta_ziele_type=2");
                 $HRKEYTest->letsrun();
                 $this->idtm_ziele->DataSource = $HRKEYTest->myTree;
                 $this->idtm_ziele->dataBind();
                 $sql = "SELECT idtm_organisation, org_name FROM tm_organisation WHERE idta_organisation_type = 4";
                 $data = PFH::convertdbObjectArray(OrganisationRecord::finder()->findAllBySql($sql), array("idtm_organisation", "org_name"));
                 $this->idtm_organisation->DataSource = $data;
                 $this->idtm_organisation->dataBind();
                 break;
             case 1:
                 //hier checken wir, wieviele schritte noch den gleichen Vater haben
                 $myPreStepOne = TTZieleRecord::finder()->findAllBySql("SELECT idtm_ziele FROM tt_ziele WHERE idtt_ziele = '" . $this->Request[$this->primarykey] . "'");
                 $prozess_counter = count(TTZieleRecord::finder()->findAllBySql("SELECT * FROM tt_ziele WHERE idtm_ziele = '" . $myPreStepOne[0]->idtm_ziele . "'"));
                 $this->edidtm_prozess->DataSource = PFH::build_SQLPullDown(ProzessRecord::finder(), "tm_prozess", array("idtm_prozess", "pro_name"), "idta_prozess_type = 3");
                 $this->edidtm_prozess->dataBind();
                 $this->edidtm_organisation->DataSource = PFH::build_SQLPullDown(OrganisationRecord::finder(), "tm_organisation", array("idtm_organisation", "org_name"), "idta_organisation_type=4");
                 $this->edidtm_organisation->dataBind();
                 $HRKEYTest = new PFHierarchyPullDown();
                 $HRKEYTest->setStructureTable("tm_ziele");
                 $HRKEYTest->setRecordClass(ZieleRecord::finder());
                 $HRKEYTest->setPKField("idtm_ziele");
                 $HRKEYTest->setField("zie_name");
                 $HRKEYTest->setSQLCondition("idta_ziele_type = 3 OR idta_ziele_type=1 OR idta_ziele_type=2");
                 $HRKEYTest->letsrun();
                 $this->edidtm_ziele->DataSource = $HRKEYTest->myTree;
                 $this->edidtm_ziele->dataBind();
                 $this->fillValues($this->getSelected($this->Request[$this->primarykey]));
                 $this->Tedauf_id->Text = $this->Request[$this->primarykey];
                 //the parameters for the RiskValueContainer
                 $this->RiskValueContainer->RCedrcv_tabelle->Text = "tt_ziele";
                 $this->RiskValueContainer->RCedrcv_id->Text = $this->Request[$this->primarykey];
                 break;
             default:
                 break;
         }
         $this->viewPanel->ActiveViewIndex = $this->Request['modus'];
     }
 }
Exemplo n.º 9
0
 public function callback_MyCallbackDrop($sender, $param)
 {
     if ($this->page->isCallback) {
         $theObjectContainingParameters = $param->CallbackParameter;
         $Record = OrganisationRecord::finder()->findBy_idtm_organisation($theObjectContainingParameters->idtm_organisation);
         $Record->parent_idtm_organisation = $theObjectContainingParameters->parent_idtm_organisation;
         $Record->save();
     }
 }
Exemplo n.º 10
0
 public function dtgList_sortCommand($sender, $param)
 {
     $criteria = new TActiveRecordCriteria();
     $criteria->Condition = "idta_organisation_type = :suchtext1";
     $criteria->Parameters[':suchtext1'] = $this->WINOrgaidta_organisation_type->Text;
     $criteria->OrdersBy[$param->SortExpression] = 'ASC';
     $this->PrtListe->DataSource = OrganisationRecord::finder()->findAll($criteria);
     $this->PrtListe->dataBind();
 }
Exemplo n.º 11
0
 public function onLoad($param)
 {
     parent::onLoad($param);
     if (!$this->isPostBack && !$this->isCallback) {
         $criteria = new TActiveRecordCriteria();
         $criteria->Condition = "idta_organisation_type LIKE 4";
         $this->generateStakeMap(OrganisationRecord::finder()->findAll($criteria), "Stakeholder-Map");
         $this->bindListStake(OrganisationRecord::finder()->findAll($criteria));
     }
 }
Exemplo n.º 12
0
 public function loadPartei($sender, $param)
 {
     $MeinRecord = RechnungRecord::finder()->findByPK($param->Item->idtm_rechnung->Text);
     $OrganisationFrom = OrganisationRecord::finder()->findByPK($MeinRecord->idtm_organisation_from);
     $OrganisationTo = OrganisationRecord::finder()->findByPK($MeinRecord->idtm_organisation_to);
     $this->idtm_organisation_from->Text = $MeinRecord->idtm_organisation_from;
     $this->idtm_organisation_to->Text = $MeinRecord->idtm_organisation_to;
     $this->TO_org_uid->Text = $OrganisationTo->org_uid;
     $this->FROM_org_uid->Text = $OrganisationFrom->org_uid;
 }
Exemplo n.º 13
0
 public function onLoad($param)
 {
     //Globale definition f�r dieses Dokument
     $this->finder = VerteilerRecord::finder();
     $this->MASTERRECORD = new VerteilerRecord();
     parent::onLoad($param);
     if (!$this->isPostBack && !$this->isCallback) {
         $this->ttidtm_organisation->DataSource = PFH::build_SQLPullDown(OrganisationRecord::finder(), "tm_organisation", array("idtm_organisation", "org_name"), "idta_organisation_type=4");
         $this->ttidtm_organisation->dataBind();
         $this->bindListVerteiler();
     }
 }
Exemplo n.º 14
0
 public function bindRepeaterOrganisation5($sender, $param)
 {
     $item = $param->Item;
     if ($item->ItemType === 'Item' || $item->ItemType === 'AlternatingItem') {
         $criteria = new TActiveRecordCriteria();
         $criteria->Condition = "idta_organisation_type = :suchtext1 AND parent_idtm_organisation = :suchtext2";
         $criteria->Parameters[':suchtext1'] = 4;
         $criteria->Parameters[':suchtext2'] = $item->Data->idtm_organisation;
         $item->RepOrganisation4->DataSource = OrganisationRecord::finder()->findAll($criteria);
         $item->RepOrganisation4->dataBind();
     }
 }
Exemplo n.º 15
0
 public function createRfCPullDown()
 {
     //Als erstes die Organisation
     $this->RfCedsuggest_idtm_organisation->DataSource = PFH::build_SQLPullDown(OrganisationRecord::finder(), "tm_organisation", array("idtm_organisation", "org_name"), "idta_organisation_type = 4");
     $this->RfCedsuggest_idtm_organisation->dataBind();
     //Als erstes die Organisation
     $this->RfCedgenemigt_idtm_organisation->DataSource = PFH::build_SQLPullDown(OrganisationRecord::finder(), "tm_organisation", array("idtm_organisation", "org_name"), "idta_organisation_type = 4");
     $this->RfCedgenemigt_idtm_organisation->dataBind();
     //einlesen der aktivitaeten
     $this->RfCedidtm_activity->DataSource = PFH::build_SQLPullDownAdvanced(ActivityRecord::finder(), "tm_activity", array("idtm_activity", "act_pspcode", "act_name"));
     $this->RfCedidtm_activity->dataBind();
 }
Exemplo n.º 16
0
 public function edbuildZielePullDown()
 {
     foreach ($this->edProtokollDetailGroupList->Items as $Gitem) {
         //if($Gitem->ItemType==='Item' || $Gitem->ItemType==='AlternatingItem'){
         foreach ($Gitem->edProtokollDetailList->Items as $item) {
             $item->edidtm_activity->DataSource = PFH::build_SQLPullDown(TTZieleRecord::finder(), "tt_ziele", array("idtm_activity", "ttzie_name"));
             $item->edidtm_activity->dataBind();
             $item->edidta_protokoll_ergebnistype->DataSource = PFH::build_SQLPullDown(ProtokollErgebnistypeRecord::finder(), "ta_protokoll_ergebnistype", array("idta_protokoll_ergebnistype", "prt_ergtype_name"));
             $item->edidta_protokoll_ergebnistype->dataBind();
             $item->Aedidtm_organisation->DataSource = PFH::build_SQLPullDown(OrganisationRecord::finder(), "tm_organisation", array("idtm_organisation", "org_name"), "idta_organisation_type = 4");
             $item->Aedidtm_organisation->dataBind();
         }
         //}
     }
 }
Exemplo n.º 17
0
 public function onLoad($param)
 {
     parent::onLoad($param);
     if (!$this->isPostBack && !$this->isCallback) {
         $this->idtm_termin = $this->Request['idtm_termin'];
         $this->idtm_protokoll = $this->Request['idtm_protokoll'];
         $this->getSelected();
         $this->thema->Text = $this->ProtokollRecord->prt_name;
         $this->prttyp->Text = ProtokollTypeRecord::finder()->findByPK($this->ProtokollRecord->idta_protokoll_type)->prt_type_name;
         $this->moderator->Text = OrganisationRecord::finder()->findByPK($this->ProtokollRecord->idtm_organisation)->org_name;
         $this->datum->Text = $this->ProtokollRecord->prt_cdate;
         $this->edTerminParticipantbindList();
         $this->edParticipantbindList();
         $this->bindRepProtokollDetail();
     }
 }
Exemplo n.º 18
0
 public function onLoad($param)
 {
     parent::onLoad($param);
     //Globale definition f�r dieses Dokument
     $this->finder = TTZieleRecord::finder();
     $this->MASTERRECORD = new TTZieleRecord();
     if (!$this->isPostBack && !$this->isCallback) {
         switch ($this->Request['modus']) {
             case 0:
                 //hier checken wir, wieviele schritte noch den gleichen Vater haben
                 $myPreStepOne = TTZieleRecord::finder()->findAllBySql("SELECT idtm_prozess FROM tt_ziele WHERE idtt_ziele = '" . $this->Request[$this->primarykey] . "'");
                 $prozess_counter = count(TTZieleRecord::finder()->findAllBySql("SELECT idtt_ziele FROM tt_ziele WHERE idtm_ziele = '" . $myPreStepOne[0]->idtm_ziele . "'"));
                 $this->idtm_prozess->DataSource = PFH::build_SQLPullDown(ProzessRecord::finder(), "tm_prozess", array("idtm_prozess", "pro_name"), "idta_prozess_type = 3");
                 $this->idtm_prozess->dataBind();
                 $this->idtm_ziele->DataSource = PFH::build_SQLPullDown(ZieleRecord::finder(), "tm_ziele", array("idtm_ziele", "zie_name"), "(idta_ziele_type = 1 OR idta_ziele_type = 3)");
                 $this->idtm_ziele->dataBind();
                 $sql = "SELECT idtm_organisation, org_name FROM tm_organisation WHERE idta_organisation_type = 4";
                 $data = PFH::convertdbObjectArray(OrganisationRecord::finder()->findAllBySql($sql), array("idtm_organisation", "org_name"));
                 $this->idtm_organisation->DataSource = $data;
                 $this->idtm_organisation->dataBind();
                 break;
             case 1:
                 //hier checken wir, wieviele schritte noch den gleichen Vater haben
                 $myPreStepOne = TTZieleRecord::finder()->findAllBySql("SELECT idtm_ziele FROM tt_ziele WHERE idtt_ziele = '" . $this->Request[$this->primarykey] . "'");
                 $prozess_counter = count(TTZieleRecord::finder()->findAllBySql("SELECT * FROM tt_ziele WHERE idtm_ziele = '" . $myPreStepOne[0]->idtm_ziele . "'"));
                 $this->edidtm_prozess->DataSource = PFH::build_SQLPullDown(ProzessRecord::finder(), "tm_prozess", array("idtm_prozess", "pro_name"), "idta_prozess_type = 3");
                 $this->edidtm_prozess->dataBind();
                 $this->edidtm_organisation->DataSource = PFH::build_SQLPullDown(OrganisationRecord::finder(), "tm_organisation", array("idtm_organisation", "org_name"), "idta_organisation_type=4");
                 $this->edidtm_organisation->dataBind();
                 $this->edidtm_ziele->DataSource = PFH::build_SQLPullDown(ZieleRecord::finder(), "tm_ziele", array("idtm_ziele", "zie_name"), "(idta_ziele_type = 1 OR idta_ziele_type = 3)");
                 $this->edidtm_ziele->dataBind();
                 $this->Aedidtm_organisation->DataSource = PFH::build_SQLPullDown(OrganisationRecord::finder(), "tm_organisation", array("idtm_organisation", "org_name"), "idta_organisation_type=4");
                 $this->Aedidtm_organisation->dataBind();
                 $this->fillValues($this->getSelected($this->Request[$this->primarykey]));
                 $this->Aedauf_id->Text = $this->Request[$this->primarykey];
                 $this->bindListAufgaben();
                 break;
             default:
                 break;
         }
         $this->viewPanel->ActiveViewIndex = $this->Request['modus'];
     }
 }
Exemplo n.º 19
0
 public function onLoad($param)
 {
     parent::onLoad($param);
     if (!$this->isPostBack && !$this->isCallback) {
         $this->idtm_activity = $this->Request['idtm_activity'];
         $this->getSelected();
         $this->ActivityZielebindList();
         $this->bindListAufgaben();
         $this->bindListInput();
         $this->bindListOutput();
         $this->bindListProtokollDetail();
         $this->act_pspcode->Text = $this->ActivityRecord->act_pspcode;
         $this->act_name->Text = $this->ActivityRecord->act_name;
         $this->act_dauer->Text = $this->ActivityRecord->act_dauer;
         $this->act_descr->Text = $this->ActivityRecord->act_descr;
         $this->act_dauerIST->Text = "0";
         $this->idtm_organisation->Text = OrganisationRecord::finder()->findByPk($this->ActivityRecord->idtm_organisation)->org_name;
         $this->act_startdate->Text = $this->ActivityRecord->act_startdate;
         $this->act_enddate->Text = $this->ActivityRecord->act_enddate;
     }
 }
Exemplo n.º 20
0
 public function bindDropDown()
 {
     $this->idta_bericht_type->DataSource = PFH::build_SQLPullDown(BerichtTypeRecord::finder(), "ta_bericht_type", array("idta_bericht_type", "ber_type_name"));
     $this->idta_bericht_type->dataBind();
     $HRKEYTest = new PFHierarchyPullDown();
     $HRKEYTest->setStructureTable("tm_organisation");
     $HRKEYTest->setRecordClass(OrganisationRecord::finder());
     $HRKEYTest->setPKField("idtm_organisation");
     $HRKEYTest->setField("org_name");
     $HRKEYTest->letsrun();
     $this->rcidtm_organisation->DataSource = $HRKEYTest->myTree;
     $this->rcidtm_organisation->dataBind();
     $ar_ber_zyklus = array(0 => 'select', 1 => 'daily', 2 => 'weekly', 3 => 'monthly');
     $ar_ber_zyklus_gap = array(1 => 'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday', 'Sunday');
     //            for($i=0;$i<=30;$i++){
     //                $ar_ber_zyklus_gap[$i]=$i+1;
     //            }
     $this->ber_zyklus->DataSource = $ar_ber_zyklus;
     $this->ber_zyklus->dataBind();
     $this->ber_zyklus_gap->DataSource = $ar_ber_zyklus_gap;
     $this->ber_zyklus_gap->dataBind();
 }
Exemplo n.º 21
0
 private function AdressHeader($idtm_organisation)
 {
     $Organisation = OrganisationRecord::finder()->findBy_idtm_organisation($idtm_organisation);
     $sql = "SELECT ta_adresse.* FROM ta_adresse INNER JOIN tm_organisation_has_ta_adresse ON ta_adresse.idta_adresse = tm_organisation_has_ta_adresse.idta_adresse WHERE tm_organisation_has_ta_adresse.idtm_organisation = " . $idtm_organisation . " AND adresse_ismain = 1";
     $Adresse = AdresseRecord::finder()->findBySQL($sql);
     $this->pdf->SetY(48);
     $this->pdf->SetX(24);
     $this->pdf->SetFont('Arial', '', 7);
     $this->pdf->Cell(85, 4, 'Philipp Frenzel, Biberstrasse 8/23, 1010 Wien', 'B', 1);
     $this->pdf->SetX(28);
     $this->pdf->SetFont('Arial', 'B', 12);
     $this->pdf->Cell(0, 10, utf8_decode($Organisation->org_name));
     $this->pdf->Ln(5);
     $this->pdf->SetX(28);
     $this->pdf->SetFont('Arial', '', 11);
     $this->pdf->Cell(0, 10, utf8_decode($Adresse->adresse_street));
     $this->pdf->Ln(5);
     $this->pdf->SetX(28);
     $this->pdf->SetFont('Arial', '', 11);
     $this->pdf->Cell(0, 10, utf8_decode($Adresse->adresse_zip) . " " . utf8_decode($Adresse->adresse_town));
     $this->pdf->Ln(9);
 }
Exemplo n.º 22
0
 public function PFMailSend($sender, $param)
 {
     $Aufgabe = AufgabenRecord::finder()->findByPK($sender->CommandParameter);
     $mail = new PHPMailer();
     $mail->From = "*****@*****.**";
     $mail->FromName = "planlogIQ";
     $mail->Host = "smtp.1und1.de";
     $mail->Mailer = "smtp";
     $mail->SMTPAuth = true;
     $mail->IsSendmail();
     //nur bei 1und1
     $mail->Username = "******";
     $mail->Password = "";
     $mail->AddAddress(KommunikationRecord::finder()->find('idtm_organisation=? AND kom_ismain=1 AND kom_type = 3', $Aufgabe->auf_idtm_organisation)->kom_information, OrganisationRecord::finder()->findByPK($Aufgabe->auf_idtm_organisation)->org_name);
     $mail->Subject = $Aufgabe->auf_name;
     $mail->MsgHTML($Aufgabe->auf_beschreibung);
     if (!$mail->Send()) {
         $this->PFMAILER->TEXT = "There was an error sending the message";
     } else {
         $this->PFMAILER->TEXT = "..done..";
     }
 }
Exemplo n.º 23
0
 public function RCSavedButtonClicked($sender, $param)
 {
     $tempus = 'RCed' . $this->RCprimarykey;
     if ($this->RCedorganisation_edit_status->Text == '1') {
         $RCEditRecord = OrganisationRecord::finder()->findByPK($this->{$tempus}->Text);
     } else {
         $RCEditRecord = new OrganisationRecord();
     }
     //HIDDEN
     foreach ($this->RChiddenfields as $recordfield) {
         $edrecordfield = 'RCed' . $recordfield;
         $RCEditRecord->{$recordfield} = $this->{$edrecordfield}->Value;
     }
     //DATUM
     foreach ($this->RCdatfields as $recordfield) {
         $edrecordfield = 'RCed' . $recordfield;
         $RCEditRecord->{$recordfield} = date('Y-m-d', $this->{$edrecordfield}->TimeStamp);
     }
     //BOOL
     foreach ($this->RCboolfields as $recordfield) {
         $edrecordfield = 'RCed' . $recordfield;
         $RCEditRecord->{$recordfield} = $this->{$edrecordfield}->Checked ? 1 : 0;
     }
     foreach ($this->RCtimefields as $recordfield) {
         $edrecordfield = 'RCed' . $recordfield;
         $RCEditRecord->{$recordfield} = $this->{$edrecordfield}->Text;
     }
     foreach ($this->RCfields as $recordfield) {
         $edrecordfield = 'RCed' . $recordfield;
         $RCEditRecord->{$recordfield} = $this->{$edrecordfield}->Text;
     }
     $RCEditRecord->save();
     $this->saveBankkonto($RCEditRecord->idtm_organisation);
     $this->saveObjekt($RCEditRecord->idtm_organisation);
     if ($this->RCedorganisation_edit_status->Text == '0') {
         $org_name = $RCEditRecord->org_name;
         $this->getPage()->getClientScript()->registerEndScript('X', "tree.insertNewChild(tree.getSelectedItemId()||0,{$RCEditRecord->idtm_organisation},'{$org_name}')");
     }
     $this->view_Organisation($RCEditRecord->idtm_organisation);
     //        if($RCEditRecord->parent_idtm_organisation!=1){
     //            $this->bindListChildOrgListe();
     //        }
     //$this->bindListOrgListe();
 }
 private function ProtokollHeader($idtm_protokoll)
 {
     $Protokoll = ProtokollRecord::finder()->findBy_idtm_protokoll($idtm_protokoll);
     $this->pdf->SetXY(25, 60);
     $this->pdf->SetDrawColor(43, 51, 43);
     $this->pdf->SetFont('Helvetica', '', 10);
     $this->pdf->Cell(185, 5, strtoupper('Protokollnotiz zum Termin am ' . date('j.n.Y', strtotime($Protokoll->prt_cdate))), 0, 0, 'B', 0);
     $this->pdf->Ln();
     $this->pdf->SetX(25);
     $this->pdf->SetDrawColor(43, 51, 43);
     $this->pdf->SetFont('Helvetica', '', 10);
     $this->pdf->Cell(185, 5, strtoupper('Projekt: ' . utf8_decode($Protokoll->idtm_termin)), 0, 0, 'B', 0);
     $this->pdf->Ln();
     //$this->pdf->SetX(28);
     $this->pdf->SetXY(25, 105);
     $this->pdf->SetDrawColor(43, 51, 43);
     $this->pdf->SetFont('Arial', '', 10);
     $this->pdf->Cell(50, 5, 'Thema ', 'B');
     $this->pdf->Cell(100, 5, utf8_decode($Protokoll->prt_name), 'B', 1);
     $this->pdf->SetX(25);
     $this->pdf->SetFont('Arial', '', 10);
     $this->pdf->Cell(50, 5, 'Moderator ', 'B');
     $this->pdf->SetFont('Arial', '', 10);
     $this->pdf->Cell(100, 5, utf8_decode(OrganisationRecord::finder()->findByidtm_organisation($Protokoll->idtm_organisation)->org_name), 'B', 1);
     $this->pdf->SetX(25);
     $this->pdf->SetFont('Arial', '', 10);
     $this->pdf->Cell(50, 5, 'Typ ', 'B');
     $this->pdf->SetFont('Arial', '', 10);
     $this->pdf->Cell(100, 5, utf8_decode(ProtokollTypeRecord::finder()->findByPK($Protokoll->idta_protokoll_type)->prt_type_name), 'B', 1);
     $this->pdf->SetX(25);
     $this->pdf->SetFont('Arial', '', 10);
     $this->pdf->Cell(50, 5, 'Ort ', 'B');
     $this->pdf->SetFont('Arial', '', 10);
     $this->pdf->Cell(100, 5, utf8_decode($Protokoll->prt_location), 'B', 1);
     $this->pdf->SetX(25);
     $this->pdf->SetFont('Arial', '', 10);
     $this->pdf->Cell(50, 5, 'Datum ', 'B');
     $this->pdf->SetFont('Arial', '', 10);
     $this->pdf->Cell(100, 5, utf8_decode($Protokoll->prt_cdate), 'B', 1);
     $this->pdf->Ln();
     $this->pdf->SetX(25);
     $this->pdf->SetFont('Arial', '', 10);
     $this->pdf->Cell(50, 5, 'Eingeladen ', 'B', 0);
     $this->pdf->SetFont('Arial', '', 10);
     $criteria = new TActiveRecordCriteria();
     $criteria->Condition = "idtm_activity = :suchtext";
     $criteria->Parameters[':suchtext'] = $Protokoll->idtm_termin;
     $criteria->OrdersBy["idtm_organisation"] = 'asc';
     $AnwesendPP = ActivityParticipantsView::finder()->findAll($criteria);
     $i = 0;
     foreach ($AnwesendPP as $InvitedP) {
         if ($i > 0) {
             $this->pdf->SetX(25);
             $this->pdf->SetFont('Arial', '', 10);
             $this->pdf->Cell(50, 5, ' ', 'B');
         }
         $this->pdf->Cell(50, 5, utf8_decode(OrganisationRecord::finder()->findByPK($InvitedP->idtm_organisation)->org_vorname) . ' ' . utf8_decode($InvitedP->org_name), 'B', 0);
         $this->pdf->Cell(50, 5, $InvitedP->act_part_anwesend == 1 ? 'anwesend' : '', 'B', 1);
         $i++;
     }
     $this->pdf->Ln();
 }
 public function setText($text)
 {
     $SelectedOrga = OrganisationRecord::finder()->findByPK($text);
     $this->XXXsuggest_idtm_organisation->Text = $SelectedOrga->org_vorname . ' ' . $SelectedOrga->org_name;
     return $this->setViewState('Text', $text, '');
 }
Exemplo n.º 26
0
 public function checkOrganisationName($sender, $param)
 {
     // valid if the username is not found in the database
     $param->IsValid = OrganisationRecord::finder()->findByidtm_organisation($this->Tedsuggest_idtm_organisation->Text) === null;
 }
Exemplo n.º 27
0
 public function editPrtAufgabe($sender, $param)
 {
     if ($param->CommandName == "edit") {
         $this->prtAufgabenDialog->setDisplay("Dynamic");
         $this->initPullDowns();
         $AufgabeRecord = AufgabenRecord::finder()->findByPK($param->CommandParameter);
         $this->Tedidtm_aufgaben->Text = $AufgabeRecord->idtm_aufgaben;
         $this->Tedauf_tabelle->Text = $AufgabeRecord->auf_tabelle;
         $this->Tedauf_id->Text = $AufgabeRecord->auf_id;
         $this->idtm_organisation->Text = $AufgabeRecord->idtm_organisation;
         $this->auf_idtm_organisation->Text = $AufgabeRecord->auf_idtm_organisation;
         $this->auf_priority->Text = $AufgabeRecord->auf_priority;
         $this->auf_dauer->Text = $AufgabeRecord->auf_dauer;
         //$AEditRecord->auf_name = $this->prtdet_topic->Text;
         $this->auf_beschreibung->Text = $AufgabeRecord->auf_beschreibung;
         $this->auf_tdate->setDate($AufgabeRecord->auf_tdate);
         $this->auf_ddate->setDate($AufgabeRecord->auf_ddate);
         $this->auf_done->setChecked($AufgabeRecord->auf_done);
         $this->Tedauf_edit_status->Text = 1;
         $this->AddOrSaveButtonPRTAUF->Text = "speichern";
         $this->getPage()->getClientScript()->registerEndScript('XCOL', "constructCollapsableFieldsets();");
     }
     if ($param->CommandName == "taskdone") {
         $tmpstartdate = new DateTime();
         $AufgabenRecord = AufgabenRecord::finder()->findByPK($param->CommandParameter);
         $AufgabenRecord->auf_done = 1;
         $AufgabenRecord->auf_ddate = $tmpstartdate->format("Y-m-d");
         $AufgabenRecord->save();
         $this->bindListPrtAufgaben();
     }
     if ($param->CommandName == "mail") {
         $Aufgabe = AufgabenRecord::finder()->findByPK($param->CommandParameter);
         $MailEmpfaenger = OrganisationRecord::finder()->findByPk($Aufgabe->idtm_organisation);
         $mail = new PHPMailer();
         $mail->From = "*****@*****.**";
         $mail->FromName = "planlogIQ";
         $mail->Host = "smtp.1und1.de";
         $mail->Mailer = "smtp";
         $mail->SMTPAuth = true;
         $mail->IsSendmail();
         //nur bei 1und1
         $mail->Username = "******";
         $mail->Password = "";
         $mail->AddAddress(KommunikationRecord::finder()->find('idtm_organisation=? AND kom_ismain=1 AND kom_type = 3', $Aufgabe->idtm_organisation)->kom_information, $MailEmpfaenger->org_name);
         $mail->Subject = $Aufgabe->auf_name;
         $HTMLMessage = "Sehr geehrte(r) Frau/Herr " . $MailEmpfaenger->org_name . ",<br/><br/>";
         $HTMLMessage .= "die folgende Aufgabe wurde Ihnen zugeordnet:<br/>";
         $HTMLMessage .= "<p><table><tr><td bgcolor='#efefef'>Task Nr.:</td><td>" . $Aufgabe->idtm_aufgaben . " </td><td bgcolor='#efefef'>Thema: </td><td>" . utf8_decode($Aufgabe->auf_name) . "</td></tr>";
         $HTMLMessage .= "<tr><td bgcolor='#efefef'>Bis:</td><td colspan='3'><b>" . $Aufgabe->auf_tdate . "</b></td></tr></table>";
         //$HTMLMessage.="<p style='background-color:#efefef'><hr/>".utf8_decode($Aufgabe->prtdet_descr)."</p>";
         $HTMLMessage .= "<p style='background-color:#efefef'><hr/>" . utf8_decode($Aufgabe->auf_beschreibung) . "<hr/></p>";
         $HTMLMessage .= "Bitte nicht Antworten! Diese Mail wurde automatisch generiert...";
         $mail->MsgHTML($HTMLMessage);
         if (!$mail->Send()) {
             $this->getPage()->getClientScript()->registerEndScript('XER', "alert('Fehler!');");
         } else {
             $this->getPage()->getClientScript()->registerEndScript('XER', "alert('Done')");
         }
     }
 }
Exemplo n.º 28
0
 public static function initOrganisationStruktur()
 {
     $OrganisationType = OrganisationTypeRecord::finder()->findAll();
     if (count($OrganisationType) >= 1) {
         foreach ($OrganisationType as $OrgType) {
             $Organisation = OrganisationRecord::finder()->findByorg_fk_internal($OrgType->org_type_name);
             if (count($Organisation) != 1) {
                 $Organisation = new OrganisationRecord();
             }
             $Organisation->idta_organisation_type = 1;
             $Organisation->idta_organisation_art = 1;
             $Organisation->idtm_ressource = 1;
             $Organisation->org_name = $OrgType->org_type_name;
             $Organisation->org_fk_internal = $OrgType->org_type_name;
             $Organisation->parent_idtm_organisation = 1;
             $Organisation->save();
             /*foreach(range('A','Z') as $i){
                   $OrgChild = OrganisationRecord::finder()->findByorg_fk_internal($OrgType->org_type_name.$i);
                   if(count($OrgChild)!=1){
                       $OrgChild = new OrganisationRecord();
                   }
                   $OrgChild->idta_organisation_type = 1;
                   $OrgChild->idta_organisation_art = 1;
                   $OrgChild->idtm_ressource = 1;
                   $OrgChild->org_name = $i;
                   $OrgChild->org_fk_internal = $OrgType->org_type_name.$i;
                   $OrgChild->parent_idtm_organisation = $Organisation->idtm_organisation;
                   $OrgChild->save();
               }*/
             unset($Organisation);
         }
     }
 }
Exemplo n.º 29
0
 public function getUserOrgId($userId)
 {
     $UserRecord = OrganisationRecord::finder()->findByidtm_user($userId);
     if (count($UserRecord) == 1) {
         return $UserRecord->idtm_organisation;
     } else {
         return 0;
     }
 }
 public function onPreInit($param)
 {
     parent::onPreInit($param);
     $docname = "tempXML";
     $ext = "xml";
     $header = "application/xml";
     $target_encoding = "UTF-8";
     if (!isset($_GET['idta_berichte'])) {
         $this->idta_berichte = 0;
     } else {
         $this->idta_berichte = $_GET['idta_berichte'];
     }
     if ($this->idta_berichte == 0) {
         $myRecords = BerichteRecord::finder()->findAll();
         $doc = new TXmlDocument('1.0', $target_encoding);
         $doc->TagName = 'Reporting';
         foreach ($myRecords as $SingleReport) {
             $Report = new TXmlElement('Reports');
             $QVFile = new TXmlElement('QlikViewFile');
             $QVFile->Value = mb_convert_encoding($SingleReport->ber_local_path, $target_encoding);
             $Report->Elements[] = $QVFile;
             $BerName = new TXmlElement('ReportName');
             $BerName->Value = mb_convert_encoding($SingleReport->ber_name, $target_encoding);
             $Report->Elements[] = $BerName;
             $BerID = new TXmlElement('ReportId');
             $BerID->Value = mb_convert_encoding($SingleReport->ber_id, $target_encoding);
             $Report->Elements[] = $BerID;
             $BerMailSub = new TXmlElement('MailSubject');
             $BerMailSub->Value = mb_convert_encoding($SingleReport->ber_mail_subject, $target_encoding);
             $Report->Elements[] = $BerMailSub;
             $BerMailBody = new TXmlElement('MailBody');
             $BerMailBody->Value = mb_convert_encoding(htmlspecialchars_decode($SingleReport->ber_mail_body), $target_encoding);
             $Report->Elements[] = $BerMailBody;
             $Recipients = new TXmlElement('Recipients');
             $RCPS = BerichteOrganisationRecord::finder()->findAllByidta_berichte($SingleReport->idta_berichte);
             //schleife für alle empfänger
             foreach ($RCPS as $RCP) {
                 $USER = OrganisationRecord::finder()->findByPK($RCP->idtm_organisation);
                 $Mailer = new TXmlElement('Recipient');
                 $Mailer->setAttribute('ID', $RCP->bho_id);
                 $Mailer->setAttribute('TABLE', $RCP->bho_modul);
                 $Mailer->setAttribute('NTNAME', $USER->org_ntuser);
                 $Mailer->Value = mb_convert_encoding(htmlspecialchars_decode(KommunikationRecord::finder()->find('idtm_organisation=? AND kom_ismain=1 AND kom_type = 3', $RCP->idtm_organisation)->kom_information), $target_encoding);
                 $Recipients->Elements[] = $Mailer;
                 unset($Mailer);
             }
             $Report->Elements[] = $Recipients;
             $doc->Elements[] = $Report;
         }
     } else {
         $doc = new TXmlDocument('1.0', 'utf-8');
         $SingleReport = BerichteRecord::finder()->findByidta_berichte($this->idta_berichte);
         $doc->TagName = 'Reporting';
         $Report = new TXmlElement('Reports');
         $QVFile = new TXmlElement('QlikViewFile');
         $QVFile->Value = mb_convert_encoding($SingleReport->ber_local_path, $target_encoding);
         $Report->Elements[] = $QVFile;
         $BerName = new TXmlElement('ReportName');
         $BerName->Value = mb_convert_encoding($SingleReport->ber_name, $target_encoding);
         $Report->Elements[] = $BerName;
         $BerID = new TXmlElement('ReportId');
         $BerID->Value = mb_convert_encoding($SingleReport->ber_id, $target_encoding);
         $Report->Elements[] = $BerID;
         $BerMailSub = new TXmlElement('MailSubject');
         $BerMailSub->Value = mb_convert_encoding($SingleReport->ber_mail_subject, $target_encoding);
         $Report->Elements[] = $BerMailSub;
         $BerMailBody = new TXmlElement('MailBody');
         $BerMailBody->Value = mb_convert_encoding(htmlspecialchars_decode($SingleReport->ber_mail_body), $target_encoding);
         $Report->Elements[] = $BerMailBody;
         $Recipients = new TXmlElement('Recipients');
         $RCPS = BerichteOrganisationRecord::finder()->findAllByidta_berichte($SingleReport->idta_berichte);
         //schleife für alle empfänger
         foreach ($RCPS as $RCP) {
             $USER = OrganisationRecord::finder()->findByPK($RCP->idtm_organisation);
             $Mailer = new TXmlElement('Recipient');
             $Mailer->setAttribute('ID', $RCP->bho_id);
             $Mailer->setAttribute('TABLE', $RCP->bho_modul);
             $Mailer->setAttribute('NTNAME', $USER->org_ntuser);
             $Mailer->Value = mb_convert_encoding(htmlspecialchars_decode(KommunikationRecord::finder()->find('idtm_organisation=? AND kom_ismain=1 AND kom_type = 3', $RCP->idtm_organisation)->kom_information), $target_encoding);
             $Recipients->Elements[] = $Mailer;
             unset($Mailer);
         }
         $Report->Elements[] = $Recipients;
         $doc->Elements[] = $Report;
     }
     # $query=new TXmlElement('Query');
     # $query->setAttribute('ID','xxxx');
     # $proc->Elements[]=$query;
     #
     # $attr=new TXmlElement('Attr');
     # $attr->setAttribute('Name','aaa');
     # $attr->Value='1';
     # $query->Elements[]=$attr;
     $this->getResponse()->appendHeader("Content-Type:" . $header);
     $this->getResponse()->appendHeader("Content-Disposition:inline;filename=" . $docName . '.' . $ext);
     $doc->saveToFile('php://output');
     exit;
 }