예제 #1
0
 protected function __construct($db, $awsAccessKey, $awsSecretAccessKey, $kissmetricsBucket)
 {
     parent::__construct();
     $this->db = $db;
     $this->db->connect();
     $this->kissmetricsBucket = $kissmetricsBucket;
     $this->s3 = new S3($awsAccessKey, $awsSecretAccessKey);
 }
예제 #2
0
 protected function __construct()
 {
     parent::__construct();
     global $awsAccessKey;
     global $awsSecretAccessKey;
     global $kissmetricsBucket;
     global $db;
     $this->kissmetrics = \library\vendor\Kissmetrics::getInstance($db, $awsAccessKey, $awsSecretAccessKey, $kissmetricsBucket);
 }
예제 #3
0
파일: faq.php 프로젝트: RicardoPiuco/pi_db
 function __construct()
 {
     parent::__construct();
 }
예제 #4
0
 function sendFeedbackComment($sqlDataArray = array())
 {
     $this->dataArray = array('comment_name' => FormElements::getPostString('sendFeedbackName', true), 'comment_email' => FormElements::getPostString('sendFeedbackEmail', true), 'comment_content' => FormElements::getPostString('sendFeedbackContent', true), 'comment_date' => date('Y-m-d'));
     if (!in_array('errorRequiredField', $this->dataArray)) {
         $addComment = $this->db->insert('comment', $this->dataArray);
         if ($addComment > 0) {
             $this->dataArray = array('pirna_code' => $sqlDataArray['pirna_code'], 'comment_id' => $addComment);
             $addRel = $this->db->insert('rel_comment_pirna', $this->dataArray);
             echo 'success/Your comment will be checked soon.';
             parent::generateLog('sent a comment to pirna: ' . $sqlDataArray['pirna_code'], 'attempts', '220');
         } else {
             echo 'error/Please Check the Information Sent.';
             parent::generateLog('error sending a comment to pirna: ' . $sqlDataArray['pirna_code'], 'attempts', '221');
         }
     } else {
         echo 'error/Please Check the Information Sent.';
         parent::generateLog('error sending a comment to pirna: ' . $sqlDataArray['pirna_code'], 'attempts', '221');
     }
 }
예제 #5
0
    function searchCluster($sqlDataArray = array())
    {
        if (isset($_POST['search'])) {
            $this->dataArray = array('cluster_chromosome' => FormElements::getPostInteger('inputSearchChromosome', true), 'cluster_start' => FormElements::getPostInteger('inputSearchStart', true), 'cluster_end' => FormElements::getPostInteger('inputSearchEnd', true));
            $this->formToken = FormElements::getPostString('token', true);
            parent::checkFormRequired($this->dataArray);
            parent::checkFormToken($this->formToken, 'search/cluster');
        } elseif (isset($_GET['cluster_chromosome']) && isset($_GET['cluster_start']) && isset($_GET['cluster_end'])) {
            $this->dataArray = array('cluster_chromosome' => FormElements::filterInteger($_GET['cluster_chromosome'], true), 'cluster_start' => FormElements::filterInteger($_GET['cluster_start'], true), 'cluster_end' => FormElements::filterInteger($_GET['cluster_end'], true));
        }
        if (!in_array('errorRequiredField', $this->dataArray) && (isset($_GET['cluster_chromosome']) || $this->formToken === Session::getSession('formToken')) && !FlashMessages::hasFlashMessage()) {
            $cookieData = date('Y-m-d') . '|cluster|' . 'cluster_chromosome|' . $this->dataArray['cluster_chromosome'] . '|cluster_start|' . $this->dataArray['cluster_start'] . '|cluster_end|' . $this->dataArray['cluster_end'];
            if (isset($_COOKIE['pirna_db_cache_search'])) {
                $newData = $_COOKIE['pirna_db_cache_search'] . '@' . $cookieData;
            } else {
                $newData = $cookieData;
            }
            setcookie('pirna_db_cache_search', $newData, time() + 86400 * 30 * 30, '/');
            Session::unsetSession('formToken');
            $this->sqlAllResults = 'SELECT cluster_code,
																		 cluster_chromosome,
																		 cluster_start,
																		 cluster_end  
															FROM cluster 
															WHERE cluster_chromosome = ' . $this->dataArray['cluster_chromosome'] . ' AND 
																		cluster_start >= ' . $this->dataArray['cluster_start'] . ' AND 
																		cluster_end <= ' . $this->dataArray['cluster_end'];
            $this->allResults = $this->db->select($this->sqlAllResults);
            $this->results[0] = count($this->allResults);
            $this->results[1] = ceil($this->results[0] / $sqlDataArray['maximumQuantity']);
            $this->sql = 'SELECT cluster_code,
													 cluster_chromosome,
													 cluster_start,
													 cluster_end  
										FROM cluster 
										WHERE cluster_chromosome = ' . $this->dataArray['cluster_chromosome'] . ' AND 
													cluster_start >= ' . $this->dataArray['cluster_start'] . ' AND 
													cluster_end <= ' . $this->dataArray['cluster_end'] . '
										LIMIT :initialItem, :maximumQuantity';
            $this->results[2] = $this->db->select($this->sql, $sqlDataArray);
            $this->results[3] = '?cluster_chromosome=' . $this->dataArray['cluster_chromosome'] . '&' . 'cluster_start=' . $this->dataArray['cluster_start'] . '&' . 'cluster_end=' . $this->dataArray['cluster_end'];
            if ($this->results[0] > 0) {
                return $this->results;
            } else {
                FlashMessages::setFlashMessage('noresult', '<b>Not Found!</b><br />None cluster was found using your query..');
            }
        }
    }
예제 #6
0
 function sendCreateInfo($type = null)
 {
     if ($type === 'faq') {
         $this->table = 'faq';
         $this->dataArray = array('faq_title' => FormElements::getPostString('createFaqTitle', true), 'faq_content' => FormElements::getPostString('createFaqContent', true), 'faq_type' => FormElements::getPostString('createFaqType', true));
     } elseif ($type === 'article') {
         $this->table = 'system_article';
         $this->dataArray = array('article_title' => FormElements::getPostString('createArticleTitle', true), 'article_author' => FormElements::getPostString('createArticleAuthor', true), 'article_journal' => FormElements::getPostString('createArticleJournal', true), 'article_date' => FormElements::getPostString('createArticleDate', true), 'article_reference' => FormElements::getPostString('createArticleReference', true));
     } elseif ($type === 'informations') {
         $this->table = 'general_text';
         $this->dataArray = array('text_content' => FormElements::getPostString('createInformationsContent', true), 'text_type' => FormElements::getPostString('createInformationsType', true));
     } elseif ($type === 'update') {
         $this->table = 'info_update';
         $this->dataArray = array('info_update_title' => FormElements::getPostString('createUpdateTitle', true), 'info_update_content' => FormElements::getPostString('createUpdateContent', true));
     } else {
         FlashMessages::setFlashMessage('error', '<b>Error!</b><br />This Section Does not Exists.');
     }
     $this->formToken = FormElements::getPostString('token', true);
     parent::checkFormRequired($this->dataArray);
     parent::checkFormToken($this->formToken, 'administration/createinfo/' . $type);
     if (!FlashMessages::hasFlashMessage()) {
         Session::unsetSession('formToken');
         $this->resultsDelete = $this->db->insert($this->table, $this->dataArray);
         if (count($this->resultsDelete) === 1) {
             FlashMessages::setFlashMessage('success', '<b>Success!</b><br />Succesfully Created.');
         } else {
             FlashMessages::setFlashMessage('error', '<b>Error!</b><br />Unsuccesfully Created.');
         }
     }
 }