public function dodajAction()
{
$dodajFirme = new Application_Form_FirmyDodaj();
if ($this->getRequest()->isPost()) {
// $firmy = new Application_Model_DbTable_;
$submit = $this->getRequest()->getParam('submit');
if (isset($submit)) {
if ($dodajFirme->isValid($this->getRequest()->getPost())) {
$data = $dodajFirme->getValues();
$mail = new TS_Mail();
$mail->send(array('to' => array('*****@*****.**', '*****@*****.**', '*****@*****.**'), 'subject' => 'Nowa Firma!', 'view' => array('script' => 'nowa-firma', 'params' => array('data' => $data))));
}
}
}
$this->view->dodajFirme = $dodajFirme;
}
public function removeAction()
{
$Newsletters = new Application_Model_DbTable_Newsletter();
$select = $Newsletters->select($Newsletters, array('id'))->where('email LIKE ?', $this->getRequest()->getParam("email"))->where('czy_potwierdzone = "t"');
$newsletter = $Newsletters->fetchAll($select);
if (count($newsletter) > 0) {
$this->view->exist = true;
$hash = TS_Salt::getSalt2();
$data = array('ciag' => $hash);
$Newsletters->update($data, array('id = ?' => intval($newsletter[0]->id)));
$fullBaseUrl = $this->view->serverUrl() . $this->view->baseUrl();
$urlParams = array('hash' => $hash);
$mail = new TS_Mail();
$mail_dane = array('to' => $this->getRequest()->getParam("email"), 'subject' => 'Potwierdzenie usunięcia newslettera', 'view' => array('script' => 'confirm-remove-newsletter', 'params' => array('baseUrl' => $fullBaseUrl, 'url' => $this->_helper->url('confirm-remove', 'newsletter', null, $urlParams))));
/**/
$mail->send($mail_dane);
} else {
$this->view->exist = false;
}
}
public function indexAction()
{
// action body
$request = $this->getRequest();
if ($request->isPost()) {
$post = $request->getPost();
$required = array('email', 'tytul', 'wiadomosc');
$ile_poprawnych = count($required);
$zwroconych = 0;
$empty = new Zend_Validate_NotEmpty();
// email
$isvalidEmail = new Zend_Validate_EmailAddress(Zend_Validate_Hostname::ALLOW_DNS | Zend_Validate_Hostname::ALLOW_LOCAL);
if ($empty->isValid($post['email']) || $isvalidEmail->isValid($post['email'])) {
$zwroconych++;
}
// tytul
if ($empty->isValid($post['tytul'])) {
$zwroconych++;
}
// wiadomosc
if ($empty->isValid($post['wiadomosc'])) {
$zwroconych++;
}
// pliki
$pliki = false;
$attachment = array();
$sciezka = TS_Url::realPath(APPLICATION_PATH . '/../public/images/tresci/kontakt/');
$adapter = new Zend_File_Transfer_Adapter_Http();
$adapter->addValidator('Count', false, array('min' => 0, 'max' => 10))->addValidator('Size', false, array('max' => 10485760))->addValidator('Extension', false, array('extension' => 'gif,jpg,png,bmp,swf,tiff,wmv,mp4,mov,avi,swf,wav,mp3,3gp,wma,pdf,rtf,txt,doc,docx,odt'))->setDestination($sciezka);
$files = $adapter->getFileInfo();
//$filessize = $adapter->getFileSize();
if (count($files) > 0 && $files['pliki_0_']['name'] != '') {
$pliki = true;
}
if ($pliki) {
$ile_poprawnych += count($files);
$session = md5(date("Y-m-d H:i:s"));
foreach ($files as $fieldname => $fileinfo) {
//var_dump($fileinfo);
if ($adapter->isUploaded($fileinfo['name']) && $adapter->isValid($fileinfo['name'])) {
$ext = pathinfo($fileinfo['name']);
$newfilename = TS_Url::getUrl($ext['filename']) . '_' . date('Ymdhs') . '.' . $ext['extension'];
$adapter->addFilter('Rename', array('target' => $sciezka . $newfilename, 'overwrite' => true));
$adapter->receive($fieldname);
$attachment[] = $sciezka . $newfilename;
$UploadPliki = new Application_Model_DbTable_UploadPliki();
$data = array('nazwa' => $newfilename, 'data_dodania' => date("Y-m-d H:i:s"), 'session' => $session);
$UploadPliki->createRow($data)->save();
$zwroconych++;
}
}
//var_dump($adapter->getMessages());
}
//pliki /**/
//echo $zwroconych . '/' . $ile_poprawnych . '<br>';
if ($zwroconych == $ile_poprawnych) {
$Maile = new Application_Model_DbTable_UstawieniaMaile();
switch ($post['do']) {
case "dyzurny":
$CosCiekawego = new Application_Model_DbTable_CosCiekawego();
$data = array('imie' => $post['imie'], 'nazwisko' => $post['nazwisko'], 'mail' => $post['email'], 'telefon' => $post['telefon'], 'tytul' => $post['tytul'], 'wiadomosc' => $post['wiadomosc'], 'data_dodania' => date("Y-m-d H:i:s"), 'czy_aktywne' => "n", 'wyswietlanie' => "ts");
$idCosCiekawego = $CosCiekawego->createRow($data)->save();
if ($pliki) {
//$UploadPliki = new Application_Model_DbTable_UploadPliki();
$select = $UploadPliki->select()->from($UploadPliki, array('id'))->where('session = ?', $session);
$uploadowanepliki = $UploadPliki->fetchAll($select);
if (count($uploadowanepliki)) {
$CosCiekawegoPliki = new Application_Model_DbTable_CosCiekawegoPliki();
foreach ($UploadPliki->fetchAll($select) as $plik) {
$data = array('id_cos_ciekawego' => $idCosCiekawego, 'id_pliku' => $plik->id);
$CosCiekawegoPliki->createRow($data)->save();
}
}
}
/**/
$mail = $Maile->find(15)->current();
$post['do'] = $mail->wartosc;
break;
case "redakcja":
$mail = $Maile->find(1)->current();
$post['do'] = $mail->wartosc;
break;
case "reklama":
$mail = $Maile->find(7)->current();
$post['do'] = $mail->wartosc;
break;
case "konkursy":
$mail = $Maile->find(16)->current();
$post['do'] = $mail->wartosc;
break;
case "sport":
$mail = $Maile->find(17)->current();
$post['do'] = $mail->wartosc;
break;
case "kultura":
$mail = $Maile->find(18)->current();
$post['do'] = $mail->wartosc;
break;
default:
$mail = $Maile->find(1)->current();
$post['do'] = $mail->wartosc;
break;
}
//$post['do'] = '*****@*****.**';
$mail = new TS_Mail();
$mail_dane = array('to' => $post['do'], 'subject' => "ze strony TS (" . $post['tytul'] . ")", 'view' => array('script' => 'kontakt', 'params' => array('imie' => $post['imie'], 'nazwisko' => $post['nazwisko'], 'telefon' => $post['telefon'], 'email' => $post['email'], 'tytul' => $post['tytul'], 'wiadomosc' => $post['wiadomosc'], 'pliki' => $attachment)), 'attachment' => $attachment);
$mail->send($mail_dane);
$this->view->post = true;
} else {
//$this->view->post = $post;
//$this->view->file_messages = $adapter->getMessages();
}
} else {
$this->view->post = false;
$this->view->do = $this->getRequest()->getParam('do');
}
}
public function kupwydaniepojedynczepktAction()
{
// action body
$Numer = new Application_Model_DbTable_Numery();
$select = $Numer->fetchRow($Numer->select()->from($Numer, array('id', 'tytul', 'foto'))->where('id = ?', intval($this->getRequest()->getParam("id")))->where('czy_wyswietlac = ?', 1)->where('od_kiedy_wyswietlac <= ?', new Zend_Db_Expr('NOW()')));
//
if (count($select) > 0) {
$this->view->numer = $select;
} else {
throw new Zend_Controller_Action_Exception(404);
}
$auth = Zend_Auth::getInstance();
if (!$auth->hasIdentity()) {
$this->view->logowanieduze = new Application_Form_LogowanieDuze();
} else {
$this->view->user = TS_Auth::getFullIdentity($auth->getIdentity());
$this->view->postUrl = $this->view->url(array('controller' => 'Wydania', 'action' => 'kupwydaniepojedynczepkt', 'id' => intval($this->getRequest()->getParam("id"))), 'default', TRUE);
if ($this->_request->isXmlHttpRequest()) {
$this->_helper->layout->disableLayout();
$this->_helper->viewRenderer->setNoRender(true);
// $this->getResponse()->setHeader('Content-Type', 'application/json');
$post = $this->_request->getPost();
$return = array('konsumenckie' => true, 'punkty' => true, 'wydaniaLinki' => array());
$ile_poprawnych = count($return) - 1;
$zwroconych = 0;
// regulamin
if ($post['konsumenckie'] == 'false') {
$return['konsumenckie'] = false;
} else {
$zwroconych++;
}
/**/
// pnkty
if ($this->view->user->punkty <= 0) {
$return['punkty'] = false;
} else {
$zwroconych++;
}
/**/
if ($ile_poprawnych == $zwroconych) {
$Numer = new Application_Model_DbTable_Numery();
$Numer->update(array('wersja_elektroniczna_zakupy' => new Zend_Db_Expr('wersja_elektroniczna_zakupy + 1')), array('id = ?' => intval($this->getRequest()->getParam("id"))));
$Zakup = new Application_Model_DbTable_WydaniaPrenumerataZakup();
$data = array('id_wydania' => intval($this->getRequest()->getParam("id")), 'id_prenumeratora' => $this->view->user->id, 'data_zakupu' => new Zend_Db_Expr('NOW()'));
$id_zakupu = $Zakup->createRow($data)->save();
$User = new Application_Model_DbTable_UzytkownicyWww();
$User->update(array('punkty' => new Zend_Db_Expr('punkty - 1')), array('id = ?' => intval($this->view->user->id)));
$WydaniePliki = new Application_Model_DbTable_WydaniaPliki();
$select = $WydaniePliki->select()->where('id_numeru = ?', intval($this->getRequest()->getParam("id")));
//$return['test'] = $select->__toString();
$wydaniapliki = $WydaniePliki->fetchAll($select);
$WydaniaPlikiUzyciaPrenumerata = new Application_Model_DbTable_WydaniaPlikiUzyciaPrenumerata();
foreach ($wydaniapliki as $wydaniaplik) {
$data = array('id_zakupu' => $id_zakupu, 'id_pliku' => $wydaniaplik['id'], 'liczba_uzyc' => 0);
$WydaniaPlikiUzyciaPrenumerata->createRow($data)->save();
}
$fullBaseUrl = $this->view->serverUrl() . $this->view->baseUrl();
$mail = new TS_Mail();
$mail_dane = array('to' => $this->view->user->email, 'subject' => 'Pobieranie e-wydania', 'view' => array('script' => 'pobierzwydanieprenumerata', 'params' => array('tytul_numeru' => $Numer->pokazTytul(intval($this->getRequest()->getParam("id"))), 'wydaniapliki' => $wydaniapliki, 'zakup' => $id_zakupu, 'baseUrl' => $fullBaseUrl)));
/**/
$mail->send($mail_dane);
if (isset($wydaniapliki) && count($wydaniapliki) > 0 && isset($id_zakupu)) {
$return['wydaniaLinki'] = $this->generujLinki($wydaniapliki, 'pkt', $id_zakupu);
}
}
echo json_encode($return);
}
}
}
public function potwierdzDotPayAction()
{
$rodzaj = $this->getRequest()->getParam("rodzaj");
$post = $this->getRequest()->getPost();
$OgloszenieZamowienia = new Application_Model_DbTable_OgloszeniaZamowienia();
$OgloszenieZamowieniaSql = $OgloszenieZamowienia->select(array('id_ogloszeniodawcy', 'cena_ost'))->where('id = ?', $post["control"]);
$ogloszenie = $OgloszenieZamowienia->fetchRow($OgloszenieZamowieniaSql);
switch ($rodzaj) {
// URLC
case "urlc":
$this->_helper->layout->disableLayout();
$this->_helper->viewRenderer->setNoRender(true);
if ($ogloszenie && intval($ogloszenie['cena_ost']) == intval($post['amount'])) {
$OgloszenieUsers = new Application_Model_DbTable_OgloszeniaUsers();
$OgloszenieUsersSql = $OgloszenieUsers->select(array('email'))->where('id = ?', $ogloszenie['id_ogloszeniodawcy']);
$ogloszenieUser = $OgloszenieUsers->fetchRow($OgloszenieUsersSql);
switch ($post["status"]) {
case "OK":
$dane = array('status_plat' => 'autoryzacja udana', 'status_zam' => 'zapłacone', 'data_zaplaty' => new Zend_Db_Expr('NOW()'));
$OgloszenieZamowienia->update($dane, array('id = ?' => $post["control"]));
if ($ogloszenieUser) {
$mail = new TS_Mail();
$mail->send(array('to' => $ogloszenieUser['email'], 'subject' => 'Potwierdzenie nadania ogłoszenia', 'body' => "Płatność DotPay została zakończona powodzeniem. Autoryzacja udana."));
}
break;
case "FAIL":
$dane = array('status_plat' => 'brak autoryzacji', 'status_zam' => 'niepotwierdzone');
$OgloszenieZamowienia->update($dane, array('id = ?' => $post["control"]));
if ($ogloszenieUser) {
$mail = new TS_Mail();
$mail->send(array('to' => $ogloszenieUser['email'], 'subject' => 'Potwierdzenie nadania ogłoszenia', 'body' => "Płatność została zakończona niepowodzeniem. Brak autoryzacji."));
}
break;
}
}
echo "OK";
break;
// URL
// URL
case "url":
switch ($post["status"]) {
case "OK":
if ($ogloszenie) {
if (intval($ogloszenie['cena_ost']) == intval($post['amount'])) {
$this->view->status = 'OK';
} else {
$this->view->status = 'błąd cenowy';
}
} else {
$this->view->status = 'nie ma ogloszenia';
}
break;
case "FAIL":
$this->view->status = 'FAIL';
break;
}
break;
}
}
public function przypomnijhasloAction()
{
// action body
if ($this->_request->isXmlHttpRequest()) {
$this->_helper->layout->disableLayout();
$this->_helper->viewRenderer->setNoRender(true);
$post = $this->_request->getPost();
$return = array('email' => true);
$ile_poprawnych = count($return);
$zwroconych = 0;
// email
$empty = new Zend_Validate_NotEmpty();
$isvalidEmail = new Zend_Validate_EmailAddress(Zend_Validate_Hostname::ALLOW_DNS | Zend_Validate_Hostname::ALLOW_LOCAL);
$emailIsNotExist = new Zend_Validate_Db_NoRecordExists(array('table' => 'ts_wydania_prenumerata_users_pl', 'field' => 'email', 'exclude' => '(czy_aktywne<>"Y") AND (email="' . $post['email'] . '")'));
//$return['email'] = !$emailIsExist->isValid($post['email']);
if (!$empty->isValid($post['email'])) {
$return['email'] = 'null';
} elseif (!$isvalidEmail->isValid($post['email'])) {
$return['email'] = 'wrong';
} elseif ($emailIsNotExist->isValid($post['email'])) {
$return['email'] = 'unexist';
} else {
$zwroconych++;
}
/**/
// finalizowanie
if ($ile_poprawnych == $zwroconych) {
try {
$salt = TS_Salt::getSalt3();
$User = new Application_Model_DbTable_UzytkownicyWww();
//$post["email"] = $User->getAdapter()->quote($post["email"]);
$dane = array('salt' => $salt);
$User->update($dane, array('email = ?' => $post["email"]));
//$request = Zend_Controller_Front::getInstance()->getRequest();
//$baseUrl = $request->getScheme() . '://' . $request->getHttpHost();
$baseUrl = $this->view->serverUrl() . $this->view->baseUrl();
$mail = new TS_Mail();
$mail_dane = array('to' => $post['email'], 'subject' => 'Zmiana hasła', 'view' => array('script' => 'zmianahasla', 'params' => array('salt' => $baseUrl . '/user-przypomnijhaslopotwierdz.htm?salt=' . $salt)));
$mail->send($mail_dane);
} catch (Exception $ex) {
die($ex->getMessage());
}
}
/**/
echo json_encode($return);
} else {
$this->view->podajmaila = new Application_Form_PodajMaila();
}
}
