public function run() { $church = new Church(); $church->name = 'Victory Church'; $church->email = '*****@*****.**'; $church->password = $_ENV['USER_PASS']; $church->address = '112 Main Street,'; $church->city = 'San Antonio'; $church->zipcode = '12345'; $church->phone_number = '123456789'; $church->denomination = 'Catholic'; $church->save(); $church1 = new Church(); $church1->name = 'Faithful'; $church1->email = '*****@*****.**'; $church1->password = $_ENV['USER_PASS']; $church1->address = '112 Navarro Street,'; $church1->city = 'San Antonio'; $church1->zipcode = '23456'; $church1->phone_number = '123456789'; $church->denomination = 'Baptist'; $church1->save(); $church2 = new Church(); $church2->name = 'Joyful'; $church2->email = '*****@*****.**'; $church2->password = $_ENV['USER_PASS']; $church2->address = '112 Commerce Street,'; $church2->city = 'San Antonio'; $church2->zipcode = '34567'; $church2->phone_number = '123456789'; $church->denomination = 'Methodist'; $church2->save(); $church3 = new Church(); $church3->name = 'Peaceful'; $church3->email = '*****@*****.**'; $church3->password = $_ENV['USER_PASS']; $church3->address = '112 Presa Street,'; $church3->city = 'San Antonio'; $church3->zipcode = '45678'; $church3->phone_number = '123456789'; $church->denomination = 'Protestant'; $church3->save(); }
public function getUser($attrib = "") { // echo $attrib;exit; $model = Users::model()->findByPk(Yii::app()->user->getId()); switch ($attrib) { case 'churchId': if (Yii::app()->session['church_id']) { return Yii::app()->session['church_id']; } else { return $model->church_id; } break; case 'fullname': return $model->user_fullname; break; case 'userId': return $model->user_id; break; case 'churchName': $church = Church::model()->findByPk($model->church_id); return $church->church_name; break; case 'churchCountry': $church = Church::model()->findByPk($model->church_id); return $church->address->country; break; case 'churchCity': $church = Church::model()->findByPk($model->church_id); return $church->address->city; break; case 'churchAddress': $church = Church::model()->findByPk($model->church_id); return $church->address->address_det; break; case 'latlng': $church = Church::model()->findByPk($model->church_id); return $church->latlng; break; case 'status': $church = Church::model()->findByPk($model->church_id); return $church->status; break; case 'userStatus': return $model->user_status; break; default: return $model->attributes; break; } }
/** * Store a newly created resource in storage. * * @return Response */ public function store() { $response = new stdClass(); $statusCode = 201; $in = Input::only('name', 'lat', 'lng', 'cid'); $rules = array('name' => 'required | alpha_spaces | unique:churches', 'lat' => 'numeric', 'lng' => 'numeric', 'cid' => 'integer'); $vd = Validator::make($in, $rules); if ($vd->fails()) { $errs = $vd->messages(); $statusCode = 400; $response = $errs->all(); if ($errs->has('name')) { // 教會已有建檔,嘗試建立教會與使用者之間的關係 $cid = Church::where('name', $in['name'])->pluck('id'); $statusCode = 201; // 先檢查是否已經加入教會 $uc = UserChurch::where('uid', Auth::user()->id)->first(); if ($uc && $uc->uid === Auth::user()->id) { $uc->cid = $cid; $uc->save(); } else { $relation = array('cid' => $cid, 'uid' => Auth::user()->id); UserChurch::firstOrCreate($relation); } $response = new stdClass(); return Response::json($response, $statusCode); } } else { $in['qlink'] = XUtil::makeQlink($in['name']); $church = Church::create($in); // 先檢查是否已經加入教會 $uc = UserChurch::where('uid', Auth::user()->id)->first(); if ($uc && $uc->uid === Auth::user()->id) { $uc->cid = $church->id; $uc->save(); } else { // 建立教會與使用者之間的關係 $relation = array('cid' => $church->id, 'uid' => Auth::user()->id); UserChurch::firstOrCreate($relation); } $response = new stdClass(); } return Response::json($response, $statusCode); }
<?php require_once __DIR__ . "/../../../Backend/SessionManager.php"; require_once __DIR__ . "/../../../Backend/RectorManager.php"; require_once __DIR__ . "/../../../Backend/ChurchManager.php"; if (!isset($_GET) || $_GET["nameChuch"] === NULL) { echo "KO"; die; } if ($_GET["status"] === 'insert' && ChurchManager::getSingleChurch('name', $_GET["nameChuch"]) !== NULL) { echo "KO"; } else { $status = $_GET["status"]; $church = new Church(); $church->setId(0); $church->setName($_GET["nameChuch"]); $church->setType($_GET["typeChurch"]); $church->setCode($_GET["codeChurch"]); $church->setAddress($_GET["addressChurch"]); $church->setColony($_GET["colonyChurch"]); $church->setPostalCode($_GET["postalCodeChurch"]); $church->setPhoneNumber($_GET["phoneNumberChurch"]); $church->setIdVicar(ChurchManager::getSingleVicar('name', $_GET["vicar"])->getId()); $church->setIdDean(ChurchManager::getSingleDean('name', $_GET["dean"])->getId()); $church->setIdCity(CityManager::getSingleCity('name', $_GET["city"])->getId()); $niches = $_GET["niche"]; if ($niches == 'true') { $niche = new Niche(); $niche->setMaxCol($_GET["maxCol"]); $niche->setMaxRow($_GET["maxRow"]); $niche->setSize($_GET["size"]);
public function run() { $group = new Group(); $group->group_name = 'Men Flag Football'; $group->address = '500 Devine Rd'; $group->city = 'San Antonio'; $group->zipcode = '78209'; $group->latitude = 29.476664; $group->longitude = -98.4773; $group->state = 'TX'; $group->meeting_day = 'Monday'; $group->meeting_time = '12:00'; $group->children = true; $group->description = 'Come play football with us. We play play fair and fun'; $group->user_id = User::findorFail(1)->id; $group->church_id = Church::findorFail(1)->id; $group->part_of_day = 'PM'; $group->save(); $group->categories()->attach(9); $group1 = new Group(); $group1->group_name = 'Women Bible Study'; $group1->address = '550 Fredericksburg Rd'; $group1->city = 'San Antonio'; $group1->zipcode = '78209'; $group1->latitude = 29.492532; $group1->longitude = -98.553601; $group1->state = 'TX'; $group1->meeting_day = 'Tuesday'; $group1->meeting_time = '02:00'; $group1->children = false; $group1->description = 'Come study the Bible and enrich your faith in God.'; $group1->user_id = User::findorFail(2)->id; $group1->church_id = Church::findorFail(2)->id; $group1->part_of_day = 'AM'; $group1->save(); $group1->categories()->attach(8); //the '1' is an id $group2 = new Group(); $group2->group_name = 'Women Volleyball'; $group2->address = '500 Bandera Rd'; $group2->city = 'San Antonio'; $group2->zipcode = '78209'; $group2->latitude = 29.45175; $group2->longitude = -98.54776699999999; $group2->state = 'TX'; $group2->meeting_day = 'Wednesday'; $group2->meeting_time = '01:00'; $group2->children = false; $group2->description = 'Come play volleyball with us. We play play fair and fun'; $group2->user_id = User::findorFail(3)->id; $group2->church_id = Church::findorFail(2)->id; $group2->part_of_day = 'AM'; $group2->save(); $group2->categories()->attach(8); $group3 = new Group(); $group3->group_name = 'Youth Choir'; $group3->address = '500 Castle Hills Rd'; $group3->city = 'San Antonio'; $group3->zipcode = '78209'; $group3->latitude = 29.496472; $group3->longitude = -98.47953099999999; $group3->state = 'TX'; $group3->meeting_day = 'Thursday'; $group3->meeting_time = '05:00'; $group3->children = true; $group3->description = 'In need of guitar players. Come practice with us regardless of all experiences.'; $group3->user_id = User::findorFail(4)->id; $group3->church_id = Church::findorFail(4)->id; $group3->part_of_day = 'PM'; $group3->save(); $group3->categories()->attach(11); $group4 = new Group(); $group4->group_name = 'Couple Counseling'; $group4->address = '500 Castle Hills Rd'; $group4->city = 'San Antonio'; $group4->zipcode = '78209'; $group4->latitude = 29.551683; $group4->longitude = -98.495223; $group4->state = 'TX'; $group4->meeting_day = 'Thursday'; $group4->meeting_time = '05:00'; $group4->children = true; $group4->description = 'Every Sunday we have couples counselors who will be willing to pray with couples and help them facilitate communication.'; $group4->user_id = User::findorFail(1)->id; $group4->church_id = Church::findorFail(1)->id; $group4->part_of_day = 'PM'; $group4->save(); $group4->categories()->attach(7); $group5 = new Group(); $group5->group_name = 'Singles Bible Study'; $group5->address = '2605 Juniper Springs Rd'; $group5->city = 'San Antonio'; $group5->zipcode = '78250'; $group5->latitude = 29.500374; $group5->longitude = -98.665559; $group5->state = 'TX'; $group5->meeting_day = 'Friday'; $group5->meeting_time = '07:00'; $group5->children = true; $group5->description = 'Come strengthen your knowledge of your individual story and how that intersects with the story of God. Our group meets every Friday at 7 PM.'; $group5->user_id = User::findorFail(2)->id; $group5->church_id = Church::findorFail(2)->id; $group5->part_of_day = 'PM'; $group5->save(); $group5->categories()->attach(6); $group6 = new Group(); $group6->group_name = 'Men Bible Study'; $group6->address = '2603 Potranco Rd'; $group6->city = 'San Antonio'; $group6->zipcode = '78210'; $group6->latitude = 29.397958; $group6->longitude = -98.46778500000001; $group6->state = 'TX'; $group6->meeting_day = 'Tuesday'; $group6->meeting_time = '06:00'; $group6->children = true; $group6->description = 'Come share your story and how that intersects with the story of God.'; $group6->user_id = User::findorFail(3)->id; $group6->church_id = Church::findorFail(3)->id; $group6->part_of_day = 'PM'; $group6->save(); $group6->categories()->attach(9); $group7 = new Group(); $group7->group_name = 'Spanish Bible Reading'; $group7->address = '2603 Huisache Rd'; $group7->city = 'San Antonio'; $group7->zipcode = '78237'; $group7->latitude = 29.414671; $group7->longitude = -98.566608; $group7->state = 'TX'; $group7->meeting_day = 'Wednesday'; $group7->meeting_time = '06:00'; $group7->children = true; $group7->description = 'Every Wednesday we read passages from the Bible and decipher their meanings in everday life.'; $group7->user_id = User::findorFail(4)->id; $group7->church_id = Church::findorFail(4)->id; $group7->part_of_day = 'PM'; $group7->save(); $group7->categories()->attach(10); $group8 = new Group(); $group8->group_name = 'Youth Bible Readings'; $group8->address = 'W Military Drive'; $group8->city = 'San Antonio'; $group8->zipcode = '78227'; $group8->latitude = 29.410404; $group8->longitude = -98.632561; $group8->state = 'TX'; $group8->meeting_day = 'Thursday'; $group8->meeting_time = '06:00'; $group8->children = true; $group8->description = 'Every Thursday we read passages from the bible and how it relates to teenagers and their lives.'; $group8->user_id = User::findorFail(1)->id; $group8->church_id = Church::findorFail(1)->id; $group8->part_of_day = 'PM'; $group8->save(); $group8->categories()->attach(10); $group9 = new Group(); $group9->group_name = 'Women Sewing Group'; $group9->address = 'Westover Hills Blvd'; $group9->city = 'San Antonio'; $group9->zipcode = '78251'; $group9->latitude = 29.465118; $group9->longitude = -98.676562; $group9->state = 'TX'; $group9->meeting_day = 'Monday'; $group9->meeting_time = '06:00'; $group9->children = true; $group9->description = 'Bring your sewing materials and ideas! We meet everday at 6 PM to 8PM. Snacks will be provided.'; $group9->user_id = User::findorFail(2)->id; $group9->church_id = Church::findorFail(2)->id; $group9->part_of_day = 'PM'; $group9->save(); $group9->categories()->attach(8); }
$churchRegistries = ChurchManager::simpleSearchChurch($simpleKeyword, $sortType, $numberPage); } else { if ($kid !== NULL) { $churchSearch = new Church(); $kid = $_GET["kid"]; $kName = $_GET["kName"]; $kType = $_GET["kType"]; $kCode = $_GET["kCode"]; $kAddress = $_GET["kAddress"]; $kColony = $_GET["kColony"]; $kPostalCode = $_GET["kPostalCode"]; $kPhonenumber = $_GET["kPhonenumber"]; $kDean = $_GET["kDean"]; $kVicar = $_GET["kVicar"]; $kCity = $_GET["kCity"]; $church = new Church(); $church->setId($kid); $church->setName($kName); $church->setType($kType); $church->setCode($kCode); $church->setAddress($kAddress); $church->setColony($kColony); $church->setPostalCode($kPostalCode); $church->setPhoneNumber($kPhonenumber); $church->setIdDean($kDean); $church->setIdVicar($kVicar); $church->setIdCity($kCity); $churchRegistries = ChurchManager::advancedSearchChurch($church, $sortType, $numberPage, 'AND'); } else { $churchRegistries = ChurchManager::getAllChurchs($sortType, $numberPage); }
public function getChurchall($per = 20) { $in = Input::only('apikey'); $out = array(); $rules = array('apikey' => 'required | alpha_num'); $vd = Validator::make($in, $rules); if ($vd->fails()) { return; } if ($in['apikey'] != 'ccea77120806') { return; } $rdata = array(); foreach (Church::orderBy('created_at', 'DESC')->get() as $church) { if ($church->status == 0) { $user_count = $church->users()->count(); $target_count = $church->targets()->count(); $church->user_count = $user_count; $church->target_count = $target_count; $church->setHidden(['id', 'lat', 'lng', 'updated_at', 'deleted_at', 'status', 'cid']); $rdata[] = $church; } } $current = Input::get('page') - 1; $data = array_slice($rdata, $current * $per, $per); $out = Paginator::make($data, count($rdata), $per); return Response::json($out); }
function church_validate($data) { $church = new Church(); if (strpos($data['fn'], "edit")) { $type = "edit"; } if (strpos($data['fn'], "delete")) { $type = "delete"; } if (strpos($data['fn'], "create")) { $type = "create"; } return $church->_validate($data, $type, false); }
<?php if ($_SESSION['login']['role'] < 2) { echo '<h2 style="text-align: center; vertical-align: middle">Página Restrita</h2>'; } else { include_once 'class/Church.php'; $id = filter_input(INPUT_GET, 'cod', FILTER_SANITIZE_NUMBER_INT); if (Church::getChurch("WHERE id_church = {$id}")) { $church = Church::getChurch("WHERE id_church = {$id}"); } else { echo '<script>window.location = "index.php"</script>'; } ?> <div class="row"> <div class="col-lg-12"> <h1 class="page-header">Alterar Igreja</h1> </div> </div> <div class="row"> <div class="col-lg-12"> <div class="col-md-6 col-md-offset-3"> <ul class="nav nav-wizard"> <li class="active" id="1"><a href="#">Dados da Igreja</a></li> <li class="disabled" id="2"><a href="#">Endereço</a></li> <li class="disabled" id="3"><a href="#">Finalizar</a></li> </ul> </div> </div> </div> <div class="row"> <div class="col-lg-12">
/** * Search one church by one similar name * * @author Jonathan Sandoval <*****@*****.**> * @param Church $church Pseudo-church with the data to search * @param string $order The type of sort of the Church * @param integer $begin The number of page to display the registry * @param string $operator To search with 'or' or 'and' * @return Array[Church] $churchs Church objects with the similar name or null */ static function advancedSearchChurch($church = null, $order = 'id', $begin = -1, $operator = 'AND') { if ($church === null) { return null; } $tableChurch = DatabaseManager::getNameTable('TABLE_CHURCH'); $tableVicar = DatabaseManager::getNameTable('TABLE_VICAR'); $tableDean = DatabaseManager::getNameTable('TABLE_DEAN'); $tableCity = DatabaseManager::getNameTable('TABLE_CITY'); $church->getId() <= 0 ? $id = '' : ($id = $church->getId()); $name = $church->getName(); $type = $church->getType(); $church->getCode() <= 0 ? $code = '' : ($code = $church->getCode()); $address = $church->getAddress(); $colony = $church->getColony(); $church->getPostalCode() <= 0 ? $postalCode = '' : ($postalCode = $church->getPostalCode()); $phoneNumber = $church->getPhoneNumber(); $vicar = $church->getIdVicar(); $dean = $church->getIdDean(); $city = $church->getIdCity(); $query = "SELECT {$tableChurch}.*\r\n FROM {$tableChurch} \r\n LEFT JOIN {$tableDean} ON {$tableChurch}.idDean = {$tableDean}.id\r\n LEFT JOIN {$tableVicar} ON {$tableChurch}.idVicar = {$tableVicar}.id\r\n LEFT JOIN {$tableCity} ON {$tableChurch}.idCity = {$tableCity}.id\r\n WHERE {$tableChurch}.id LIKE '%{$id}%' {$operator}\r\n {$tableChurch}.name LIKE '%{$name}%' {$operator}\r\n {$tableChurch}.type LIKE '%{$type}%' {$operator}\r\n {$tableChurch}.code LIKE '%{$code}%' {$operator}\r\n {$tableChurch}.address LIKE '%{$address}%' {$operator}\r\n {$tableChurch}.colony LIKE '%{$colony}%' {$operator}\r\n {$tableChurch}.postalCode LIKE '%{$postalCode}%' {$operator}\r\n {$tableChurch}.phoneNumber LIKE '%{$phoneNumber}%' {$operator}\r\n ({$tableDean}.id LIKE '%{$dean}%' OR\r\n {$tableDean}.name LIKE '%{$dean}%' ) {$operator}\r\n ({$tableVicar}.id LIKE '%{$vicar}%' OR\r\n {$tableVicar}.name LIKE '%{$vicar}%' ) {$operator}\r\n ({$tableCity}.id LIKE '%{$city}%' OR\r\n {$tableCity}.name LIKE '%{$city}%' )\r\n ORDER BY {$order}"; $query = $query . " LIMIT " . strval($begin * 10) . ", 11 "; $arrayChurchs = DatabaseManager::multiFetchAssoc($query); if ($arrayChurchs === null) { return null; } else { $i = 0; foreach ($arrayChurchs as $church) { if ($i == 10) { continue; } $churchs[] = self::ArrayToChurch($church); $i++; } return $churchs; } }
public function run() { $event = new CalendarEvent(); $event->title = 'Youth Concert'; $event->address = 'P Sherman 42 Wallaby Way'; $event->city = 'San Antonio'; $event->zipcode = '89203'; $event->date = '2016-09-02'; $event->time = '5:00'; $event->time_of_day = 'PM'; $event->cost = '$20.00'; $event->description = 'A youth concert at the Alamo Coliseum that runs from 5PM to 8PM'; $this->getImage($event); $event->category_id = Category::findorFail(1)->id; $event->user_id = User::findorFail(1)->id; $event->church_id = Church::findorFail(1)->id; $event->save(); // $event->users()->attach(1); $event1 = new CalendarEvent(); $event1->title = 'Adult Retreat'; $event1->address = 'P Allen 42 Wallaby Way'; $event1->city = 'San Antonio'; $event1->zipcode = '78201'; $event1->date = '2016-02-02'; $event1->time = '5:00'; $event1->time_of_day = 'PM'; $event1->cost = '$20.00'; $event1->description = 'An adult retreat at the Antonian that runs from Friday to Sunday'; $this->getImage($event1); $event1->category_id = Category::findorFail(2)->id; $event1->user_id = User::findorFail(2)->id; $event1->church_id = Church::findorFail(2)->id; $event1->save(); // $event->users()->attach(2); $event2 = new CalendarEvent(); $event2->title = 'Church Cook-out'; $event2->address = 'Loma Linda Express Way'; $event2->city = 'San Antonio'; $event2->zipcode = '78209'; $event2->date = '2016-03-02'; $event2->time = '3:00'; $event2->time_of_day = 'PM'; $event2->cost = '$20.00'; $event2->description = 'Come join the church for our yearly spring cookout'; $this->getImage($event2); $event2->category_id = Category::findorFail(11)->id; $event2->user_id = User::findorFail(3)->id; $event2->church_id = Church::findorFail(3)->id; $event2->save(); // $event->users()->attach(3); $event3 = new CalendarEvent(); $event3->title = 'Youth Choir Tryouts'; $event3->address = '204 Bandera Road'; $event3->city = 'San Antonio'; $event3->zipcode = '78228'; $event3->date = '2016-02-02'; $event->time = '2:00'; $event->time_of_day = 'PM'; $event3->cost = 'Free'; $event3->description = 'Play an instrument sing? Come tryout for the youth choir!'; $this->getImage($event3); $event3->category_id = Category::findorFail(1)->id; $event3->user_id = User::findorFail(4)->id; $event3->church_id = Church::findorFail(4)->id; $event3->save(); $event4 = new CalendarEvent(); $event4->title = 'Women Adult Retreat'; $event4->address = '265 W Military Road'; $event4->city = 'San Antonio'; $event4->zipcode = '78202'; $event4->date = '2016-04-02'; $event4->time = '5:00'; $event4->time_of_day = 'PM'; $event4->cost = 'Free'; $event4->description = 'Our church is having a women retreat up soon in April. Come by the pavillion after church on Sunday for more info!'; $this->getImage($event4); $event4->category_id = Category::findorFail(2)->id; $event4->user_id = User::findorFail(1)->id; $event4->church_id = Church::findorFail(1)->id; $event4->save(); $event5 = new CalendarEvent(); $event5->title = 'Spanish Mass'; $event5->address = '354 Bobcat Drive'; $event5->city = 'San Antonio'; $event5->zipcode = '78218'; $event5->date = '2015-05-02'; $event5->time = '2:00'; $event5->time_of_day = 'PM'; $event5->cost = 'Free'; $event5->description = 'Our church has decided to incorporate a Spanish mass at 2 PM every Sunday. Come and join us!'; $this->getImage($event5); $event5->category_id = Category::findorFail(10)->id; $event5->user_id = User::findorFail(2)->id; $event5->church_id = Church::findorFail(2)->id; $event5->save(); $event6 = new CalendarEvent(); $event6->title = 'Financial Classes'; $event6->address = '103 Bandera Road'; $event6->city = 'San Antonio'; $event6->zipcode = '78240'; $event6->date = '2016-08-02'; $event6->time = '5:00'; $event6->time_of_day = 'PM'; $event6->cost = 'Free'; $event6->description = 'Gordon Ramsey will be offering classes at Joyful Church regarding finances. Come our church pavillion for more info!'; $this->getImage($event6); $event6->category_id = Category::findorFail(7)->id; $event6->user_id = User::findorFail(3)->id; $event6->church_id = Church::findorFail(3)->id; $event6->save(); $event7 = new CalendarEvent(); $event7->title = 'Guitar Performance'; $event7->address = '105 Bandera Road'; $event7->city = 'San Antonio'; $event7->zipcode = '78202'; $event7->date = '2016-07-02'; $event7->time = '2:00'; $event7->time_of_day = 'PM'; $event7->cost = 'Free'; $event7->description = 'Watch the advanced and intermediate guitar ensemble perform renditions of Christmas tunes!'; $this->getImage($event7); $event7->category_id = Category::findorFail(1)->id; $event7->user_id = User::findorFail(4)->id; $event7->church_id = Church::findorFail(4)->id; $event7->save(); // $event->users()->attach(1); $event8 = new CalendarEvent(); $event8->title = 'Vacation Bible Study'; $event8->address = '3405 Bandera Road'; $event8->city = 'San Antonio'; $event8->zipcode = '78217'; $event8->date = '2016-06-02'; $event8->time = '6:00'; $event8->time_of_day = 'PM'; $event8->cost = 'Free'; $event8->description = 'Vacation Bible Study will be offered to kids ages 7-14 on Sunday at 6-8 PM for kids ages 7-11 and on Monday 6-8 PM for ages 12-14!'; $this->getImage($event8); $event8->category_id = Category::findorFail(4)->id; $event8->user_id = User::findorFail(1)->id; $event8->church_id = Church::findorFail(1)->id; $event8->save(); $event9 = new CalendarEvent(); $event9->title = 'Youth Sports'; $event9->address = '352 Fredericksburg Road'; $event9->city = 'San Antonio'; $event9->zipcode = '78254'; $event9->date = '2015-03-12'; $event9->time = '2:00'; $event9->time_of_day = 'PM'; $event9->cost = 'Free'; $event9->description = 'Youth intramural sports will begin in !'; $this->getImage($event9); $event9->category_id = Category::findorFail(3)->id; $event9->user_id = User::findorFail(2)->id; $event9->church_id = Church::findorFail(2)->id; $event9->save(); $event10 = new CalendarEvent(); $event10->title = 'Choir Concert'; $event10->address = '153 Bandera Road'; $event10->city = 'San Antonio'; $event10->zipcode = '78202'; $event10->date = '2015-05-02'; $event10->time = '7:00'; $event10->time_of_day = 'PM'; $event10->cost = 'Free'; $event10->description = 'Watch the girls and boys choir concert at 7 PM. They have been working hard on rehearsals for the past few months so come and support!'; $this->getImage($event10); $event10->category_id = Category::findorFail(1)->id; $event10->user_id = User::findorFail(3)->id; $event10->church_id = Church::findorFail(3)->id; $event10->save(); }
public static function getMissions($where = null) { $dados = Database::ReadAll("mission", "*", $where); if (!$dados) { return ''; } foreach ($dados as $dado) { $mission = new Mission(); $mission->setId($dado['ID_MISSION']); $mission->setName($dado['NAME_MISSION']); $mission->setDateBegin($dado['DATE_INICIAL']); $mission->setDateEnd($dado['DATE_END']); $mission->setStatus($dado['STATUS']); $team = Team::getTeam("WHERE id_team = " . $dado['ID_TEAM']); $mission->setTeam($team); if (!empty($dado['ID_ADDRESS'])) { $address = Address::getAddress("AND id_address = " . $dado['ID_ADDRESS']); $mission->setAddress($address); } if (!empty($dado['ID_CHURCH'])) { $church = Church::getChurch("WHERE id_church = " . $dado['ID_CHURCH']); $mission->setChurch($church); } $missions[] = $mission; } return $missions; }
</div> </form> </div> <!-- FIM PRIMEIRO PASSO - DADOS PESSOAIS --> <div class="step2Ig" style="display: none;"> <form id="formMissaoIgreja" class="form-horizontal"> <div class="form-group"> <label for="pass1" class="control-label col-lg-4">Igreja</label> <div class="col-lg-5"> <select name="ID_CHURCH" class="form-control" required> <option>Selecione a Igreja</option> <?php if (Church::getChurches()) { foreach (Church::getChurches() as $rel) { echo '<option value="' . $rel->getId() . '">' . $rel->getName() . '</option>'; } } ?> </select> </div> </div> <div class="form-group"> <div class="col-lg-4 col-lg-offset-4"> <button type="button" data-back="1" class="btn btn-primary back">Voltar</button> </div> <div class="col-md-4"> <button type="submit" class="btn btn-primary">Continue</button> </div> </div>
/** * Show the form for editing the specified resource. * * @param int $id * @return Response */ public function edit($id) { $group = Group::with('user')->where('id', '=', $id)->first(); if (Auth::check() && Auth::user()->id != $id) { Session::flash('errorMessage', 'Unauthorized to edit this group.'); return Redirect::action('HomeController@showHome'); } $categories = Category::where('type', '=', 'group')->lists('name', 'id'); $churches = Church::lists('name', 'id'); $meetingHour = substr($group->meeting_time, 0, 1) == '0' ? substr($group->meeting_time, 1, 1) : substr($group->meeting_time, 0, 2); $meetingMinutes = substr($group->meeting_time, -2, 2); return View::make('groups.edit')->with(array('group' => $group, 'categories' => $categories, 'churches' => $churches, 'meetingHour' => $meetingHour, 'meetingMinutes' => $meetingMinutes)); }
<?php Event::listen('cron.collectJobs', function () { Cron::add('daily new churches notification', $_ENV['CRON_DAILY'], function () { $churches = Church::yesterday(); if ($churches && $churches->count() > 0) { $data['churches'] = $churches; Mail::send('emails.dailynewchurches', $data, function ($message) { // michhsin@ccea.org.tw $message->to('*****@*****.**', '一領一禱告認領同工')->subject('一領一禱告認領:新加入教會通知 ' . date('Y/m/d'))->bcc('*****@*****.**', 'lancetw'); }); } }, true); }); /* |-------------------------------------------------------------------------- | Register The Laravel Class Loader |-------------------------------------------------------------------------- | | In addition to using Composer, you may use the Laravel class loader to | load your controllers and models. This is useful for keeping all of | your classes in the "global" namespace without Composer updating. | */ ClassLoader::addDirectories(array(app_path() . '/commands', app_path() . '/controllers', app_path() . '/models', app_path() . '/database/seeds')); /* |-------------------------------------------------------------------------- | Application Error Logger |-------------------------------------------------------------------------- | | Here we will configure the error logger setup for the application which
<?php session_cache_expire(25); session_start(); require_once 'bootstrap.php'; require_once 'modules/dashboard_widgets/dashboard_widgets.controller.php'; require_once 'modules/dashboard_widgets/dashboard_widgets_blocks.php'; $username = $_SESSION['log_username']; $version = NATURAL_VERSION; $_SESSION['dash_type'] = 2; $church = new Church(); $church->byID($_SESSION['log_church_id']); $user_full_name = $_SESSION['log_first_name'] . ' ' . $_SESSION['log_last_name'] . ' (' . $church->name . ')'; $db = DataConnection::readOnly(); $q = $db->files[$_SESSION['log_file_id']]; if (count($q) > 0) { $avatar = $q['uri']; } else { $avatar = "files/images/avatar/user.png"; } $menu = new Menu(); $menu_html = $twig->render('menu.html', array('links' => $menu->byLevel('church', $_SESSION['log_access_level']), 'first' => TRUE)); $template = $twig->loadTemplate('base.html'); $template->display(array('project_title' => TITLE, 'path_to_theme' => THEME_PATH, 'company' => NATURAL_COMPANY, 'version' => $version, 'page' => 'dashboard-main', 'menu' => $menu_html, 'avatar' => $avatar, 'admin' => true, 'skin' => 'skin-light-blue', 'show_profile_button' => true, 'admin_profile_button' => false, 'user_header' => 'user-header-company', 'skin_profile' => 'bg-light-blue', 'user_full_name' => $user_full_name, 'username' => $username, 'actual_date' => date('F jS, Y'), 'page_title' => 'Dashboard', 'page_subtitle' => 'Widgets', 'content' => dashboard_content()));
public static function getHistorys($where = null) { $dados = Database::ReadAll('history', '*', $where); if (!$dados) { return false; } foreach ($dados as $dado) { $history = new HistoryChurch(); $history->setId($dado['ID_HISTORY']); $history->setNamePastor($dado['NAME_PASTOR']); $church = Church::getChurch("WHERE id_church = " . $dado['ID_CHURCH']); $history->setChurch($church); $history->setDateInicial($dado['DATE_INICIAL']); $history->setDateFinal($dado['DATE_FINAL']); $historys[] = $history; } return $historys; }
<div class="table-responsive"> <table class="table table-striped table-bordered table-hover dataTables-example"> <thead> <tr> <th>ID</th> <th>Nome</th> <th>Pastor</th> <th>Endereço</th> <th>Status</th> <th>Ação</th> </tr> </thead> <tbody> <?php if (Church::getChurches() != '') { foreach (Church::getChurches() as $chur) { echo '<tr>'; echo '<td>' . $chur->getId() . '</td>'; echo '<td>' . '<a class="modalChurch" data-id="' . $chur->getId() . '" >' . $chur->getName() . '</a>' . '</td>'; echo '<td>' . $chur->getPastor() . '</td>'; echo '<td>' . $chur->getAddress()->getStreet() . ', ' . $chur->getAddress()->getNumber() . ' ' . $chur->getAddress()->getComplement() . ', ' . $chur->getAddress()->getDistrict() . ', ' . $chur->getAddress()->getCity() . '/' . $chur->getAddress()->getState() . '</td>'; echo '<td>' . $chur->getStatus() . '</td>'; if ($chur->getStatus() != 'Banido') { echo '<td>' . '<a href="forms.php?p=altIgreja&cod=' . $chur->getId() . '">' . '<i class="icon icon-pencil"></i> Editar' . '</a>' . '</td>'; } else { echo '<td></td>'; } echo '</tr>'; } } ?>
public function actionStatistics() { $churchcnt = Church::model()->count(); $rschcnt = ChurchSupplies::model()->count(); $usercnt = AppUsers::model()->count(); $this->render('statistics', array('churchcnt' => $churchcnt, 'rsccnt' => $rschcnt, 'usercnt' => $usercnt)); }
function getChurch($tid) { //TODO: delete getChurch(); try { $church = new Church($tid); $church->allowOldStructure(); return (array) $church; } catch (Exception $e) { //If there is no such church, we return an empty array(); //echo $e->getMessage(); return array(); } }
public static function getChurches() { $dados = Database::ReadAll("church", "*"); if (!$dados) { return ''; } foreach ($dados as $dado) { $church = new Church(); $church->setId($dado['ID_CHURCH']); $church->setName($dado['NAME_CHURCH']); $church->setPastor($dado['NAME_PASTOR']); $church->setStatus($dado['STATUS']); $address = Address::getAddress('AND a.id_address = ' . $dado['ID_ADDRESS']); $church->setAddress($address); $churches[] = $church; } return $churches; }
<p><label>Status</label>: <?php echo $team->getStatus(); ?> <p><label>Integrantes</label>:<br/> <?php foreach ($team->getMembers() as $member) { echo $member->getId() . ' - ' . $member->getName() . '<br />'; } ?> </p> <?php break; case 'church': $cod = filter_input(INPUT_POST, 'cod', FILTER_SANITIZE_NUMBER_INT); $chur = Church::getChurch('WHERE id_church = ' . $cod); ?> <p><label>Nome</label>: <?php echo $chur->getName(); ?> </p> <p><label>Pastor</label>: <?php echo $chur->getPastor(); ?> </p> <p><label>Status</label>: <?php echo $chur->getStatus(); ?> <h4>Endereço</h4> <p><label>CEP</label>: <?php