Example #1
0
 public function save()
 {
     // yo thau ma project save huna aaucha
     // yei bata feri "index.php" ma falne jun chai profile ma jancha
     $proj = new Project();
     if (isset($_POST['single_date']) && $_POST['single_date'] != "") {
         $proj->setStart_date($_POST['single_date']);
     } else {
         if (isset($_POST['start_date'])) {
             $proj->setStart_date($_POST['start_date']);
             if (isset($_POST['end_date'])) {
                 $proj->setEnd_date($_POST['end_date']);
             } else {
                 $proj->setEnd_date("");
             }
         } else {
             $proj->setStart_date("");
             $proj->setEnd_date("");
         }
     }
     $proj->setTitle($_POST['project_title']);
     $proj->setObjectives($_POST['project_objectives']);
     $proj->setShortdes($_POST['short_desc']);
     $proj->setLocation($_POST['location']);
     if (isset($_POST['amount'])) {
         $proj->setBudget($_POST['amount']);
     } else {
         $proj->setBudget(NULL);
     }
     if (isset($_POST['requirement1'])) {
         $proj->setRequirement($_POST['requirement1']);
     } else {
         $proj->setRequirement("");
     }
     if (isset($_POST['requirement2'])) {
         $proj->setRequirement($_POST['requirement2']);
     }
     if (isset($_POST['requirement3'])) {
         $proj->setRequirement($_POST['requirement3']);
     }
     if (isset($_POST['requirement4'])) {
         $proj->setRequirement($_POST['requirement4']);
     }
     if (isset($_POST['requirement5'])) {
         $proj->setRequirement($_POST['requirement5']);
     }
     if (isset($_POST['cb_volunteer'])) {
         if (isset($_POST['number_volunteer'])) {
             $proj->setVolunteer($_POST['number_volunteer']);
         } else {
             $proj->setVolunteer(1);
         }
     } else {
         $proj->setVolunteer(0);
     }
     if (isset($_POST['cb_otherorg'])) {
         if (isset($_POST['organization1'])) {
             $proj->setOrganization($_POST['organization1']);
         } else {
             $proj->setOrganization("");
         }
         if (isset($_POST['organization2'])) {
             $proj->setOrganization($_POST['organization2']);
         }
         if (isset($_POST['organization3'])) {
             $proj->setOrganization($_POST['organization3']);
         }
         if (isset($_POST['organization4'])) {
             $proj->setOrganization($_POST['organization4']);
         }
         if (isset($_POST['organization5'])) {
             $proj->setOrganization($_POST['organization5']);
         }
     } else {
         $proj->setOrganization("");
     }
     if (isset($_FILES['banner_image'])) {
         if ($_FILES['banner_image']['name'] != "") {
             $filename = $_FILES['banner_image']['name'];
             $path = ROOT_PATH . "/profile/project_image/";
             move_uploaded_file($_FILES['banner_image']['tmp_name'], $path . $filename);
             $savepath = BASE_URL . "/profile/project_image/";
             $proj->setBanner_image($savepath . $filename);
         } else {
             $filename = "default.jpg";
             $savepath = BASE_URL . "/profile/project_image/";
             $proj->setBanner_image($savepath . $filename);
         }
     } else {
         $savepath = BASE_URL . "/profile/project_image/";
         $proj->setBanner_image($savepath . "default.jpg");
     }
     if (isset($_FILES['project_proposal'])) {
         if ($_FILES['project_proposal']['name'] != "") {
             $filename = $_FILES['project_proposal']['name'];
             $path = ROOT_PATH . "/profile/project_proposal/";
             move_uploaded_file($_FILES['project_proposal']['tmp_name'], $path . $filename);
             $savepath = BASE_URL . "/profile/project_proposal/";
             $proj->setProject_proposal($savepath . $filename);
         } else {
             $filename = "default.docx";
             $savepath = BASE_URL . "/profile/project_proposal/";
             $proj->setProject_proposal($savepath . $filename);
         }
     } else {
         $savepath = BASE_URL . "/profile/project_proposal/";
         $proj->setProject_proposal($savepath . "default.docx");
     }
     if (isset($_POST['project_video'])) {
         $string = $_POST['project_video'];
         $search = '#(.*?)(?:href="https?://)?(?:www\\.)?(?:youtu\\.be/|youtube\\.com(?:/embed/|/v/|/watch?.*?v=))([\\w\\-]{10,12}).*#x';
         $replace = 'http:/utube.com/embed/$2';
         $url = preg_replace($search, $replace, $string);
         $proj->setVideourl($url);
     } else {
         $proj->setVideourl("");
     }
     if (isset($_POST['details'])) {
         $proj->setDetail($_POST['details']);
     } else {
         $proj->setDetail("");
     }
     $proj->setStatus(1);
     $id = $this->projectrepository->insert($proj);
 }
 public function get_by_id($project_id)
 {
     $proj = null;
     $this->database->connect();
     $sql = "SELECT * FROM projects WHERE project_id=?";
     //prepare the statement
     $statement = $this->database->initialize($sql);
     //Bind the parameters
     $statement->bind_param("i", $project_id);
     //Execute the above statement
     $statement->execute();
     //Bind the result
     $statement->bind_result($project_id, $start_date, $end_date, $title, $objectives, $short_desc, $location, $budget, $volunteer, $banner_image, $project_proposal, $video_url, $detail, $status, $u_id);
     while ($statement->fetch()) {
         $proj = new Project();
         $proj->setProject_id($project_id);
         $proj->setStart_date($start_date);
         $proj->setEnd_date($end_date);
         $proj->setTitle($title);
         $proj->setObjectives($objectives);
         $proj->setShortdes($short_desc);
         $proj->setLocation($location);
         $proj->setBudget($budget);
         $proj->setVolunteer($volunteer);
         $proj->setBanner_image($banner_image);
         $proj->setProject_proposal($project_proposal);
         $proj->setVideourl($video_url);
         $proj->setDetail($detail);
         $proj->setStatus($status);
         $proj->setUid($u_id);
     }
     //Close Connection
     $this->database->close();
     return $proj;
 }