Saved Bookmarks
| 1. |
Solve : codeigniter some error? |
|
Answer» I have a problem with the codeigniter, because when I view it in the browser., the expected output wont show,, instead it will only view my php codes. help me figure it out,,,I just get this output: db->query($sql); return $query; } function promoteMDUpdates($newMD, $rowBaseshop, $newLevelFromDate, $currentLevelEndDate, $newLevelEndDate) { /* 12:18 PM 2/11/2008 Update latest record of member_level with new endDate Insert new record to member_level with new MD, new fromDate and new endDate This will be a function that can and will be called by itself. */ //echo ""; //echo $rowBaseshop['lastName'].", ".$rowBaseshop['firstName']." ".$rowBaseshop['middleName']." (".$rowBaseshop['code'].")"; //echo " "; $sql = "UPDATE member SET MD = ".$this->db->escape($newMD)." , editedBy = ".$this->db->escape($this->session->userdata('userID')).", editedDate = ".$this->db->escape(NOWDATE)." WHERE code = '".$rowBaseshop['code']."' LIMIT 1; "; //echo " "; $this->db->query($sql); /* 10:19 AM 2/7/2008 If the baseshop member was recruited AFTER the MD's promotion, only update any records existing in member_level Else update the member_level and insert a new record */ $recruitedAfterPromotion = "FALSE"; // A flag to determine if baseshop member is recruited before or after the MD's promotion $sql = "SELECT * FROM member_level WHERE code = '".$rowBaseshop['code']."' "; $query = $this->db->query($sql); foreach($query->result_array() as $rowBaseshopML) { if($rowBaseshopML['fromDate'] > (substr($newLevelFromDate, 0, 10))) { $recruitedAfterPromotion = "TRUE"; } } //echo "flag? ".$recruitedAfterPromotion; //echo " "; if($recruitedAfterPromotion == "TRUE") { //echo " Recruited after promotion "; if( ($rowBaseshopML['endDate'] >= (substr($newLevelFromDate, 0, 10)) AND ($rowBaseshopML['endDate'] != FINALDATE)) ) { $sql = "UPDATE member_level SET endDate = ".$this->db->escape(substr($currentLevelEndDate, 0, 10)).", recruiter = ".$this->db->escape($newMD)." , MD = ".$this->db->escape($newMD)." , editedBy = ".$this->db->escape($this->session->userdata('userID')).", editedDate = ".$this->db->escape(NOWDATE)." WHERE code = '".$rowBaseshop['code']."' AND MD = '".$rowBaseshop['MD']."'; "; } else { $sql = "UPDATE member_level SET recruiter = ".$this->db->escape($_POST['code'])." , MD = ".$this->db->escape($newMD)." , editedBy = ".$this->db->escape($this->session->userdata('userID')).", editedDate = ".$this->db->escape(NOWDATE)." WHERE code = '".$rowBaseshop['code']."' AND MD = '".$rowBaseshop['MD']."'; "; } //echo "flagsql: ".$sql; //echo " "; $this->db->query($sql); } else { //echo " Recruited before promotion "; $sql = "UPDATE member_level SET endDate = ".$this->db->escape(substr($currentLevelEndDate, 0, 10)).", editedBy = ".$this->db->escape($this->session->userdata('userID')).", editedDate = ".$this->db->escape(NOWDATE)." WHERE code = '".$rowBaseshop['code']."' AND endDate = '".FINALDATE."' LIMIT 1; "; //echo $sql; //echo " "; $this->db->query($sql); $sql = "INSERT INTO member_level ( code, level, fromDate, endDate, recruiter, MD, createdBy, createdDate, editedBy, editedDate ) VALUES (" .$this->db->escape($rowBaseshop['code']).", " .$this->db->escape($rowBaseshop['level']).", " .$this->db->escape(substr($newLevelFromDate, 0, 10)).", " .$this->db->escape(substr($newLevelEndDate, 0, 10)).", " .$this->db->escape($rowBaseshop['recruiter']).", " .$this->db->escape($newMD).", " .$this->db->escape($this->session->userdata('userID')).", " .$this->db->escape(NOWDATE).", " .$this->db->escape($this->session->userdata('userID')).", " .$this->db->escape(NOWDATE)." )"; //echo $sql; $this->db->query($sql); } //search for this member's recruits and update their MDs as well by calling this function $sql = "SELECT * FROM member WHERE recruiter = '".$rowBaseshop['code']."' AND code != '".$_POST['exchangeLeg']."' ORDER BY lastName ASC"; $query = $this->db->query($sql); $rowBaseshop = $query->row_array(); if( $query->num_rows() > 0 ) { //echo " recruits: ".$query->num_rows(); foreach($query->result_array() as $rowBaseshop) { $this->adminmodel->promoteMDUpdates($newMD, $rowBaseshop, $newLevelFromDate, $currentLevelEndDate, $newLevelEndDate); } } //echo ""; //echo " "; } function getMemberLevel2($code, $effectivityDate) { // gets the member's level from the member_level table $sql = "SELECT * FROM member_level WHERE code = '".$code."' AND ('".$effectivityDate."' >= fromDate AND endDate >= '".$effectivityDate."') LIMIT 1"; $query = $this->db->query($sql); if($query->num_rows() > 0) { $row = $query->row(); return $row->level; } else { show_error('Error: Level not found for '.$code.' during the business date '.$effectivityDate); } } function sortHierarchy($hierarchy) { function _levelCompare($a, $b) { if($a['level'] == $b['level']) { if($a['rate'] < $b['rate']) { return 1; } else { return -1; } } elseif($a['level'] < $b['level']) { return -1; } else { return 1; } } usort($hierarchy, '_levelCompare'); return $hierarchy; } function fetchDate($dateYear=NULL, $dateMonth=NULL, $dateDay=NULL) { if($dateYear AND $dateMonth AND $dateDay) { $formattedDate = $dateYear."-".$dateMonth."-".$dateDay; } else { show_error('Incomplete Date fields'); } return $formattedDate; } function getMD($code, $info) { $sql = "SELECT MD FROM member WHERE code = ".$this->db->escape($code)." LIMIT 1"; $query = $this->db->query($sql); if($query->num_rows() > 0) { $row = $query->row(); $MDCode = $row->MD; } $sql = "SELECT * FROM member WHERE code = ".$this->db->escape($MDCode)." LIMIT 1"; $query = $this->db->query($sql); if($query->num_rows() > 0) { $row = $query->row(); } if($info == "name") { $memberName = $row->lastName.", ".$row->firstName." ".$row->middleName; return $memberName; } else { return $row->code; } } function createMemberInfo2($code, $name, $level, $generation, $rate, $payout, $execBonus, $WTRate, $CBRRate) { /* 4:56 PM 1/9/2008 Removed the element 'execRate' because that value is now used by 'rate' 3:57 PM 1/2/2008 Similar to createMemberInfo, except that it ALSO sets the other values that otherwise need to be computed. Used mainly for Company, CEO-MD Bonus, and Bonus Pool. */ $payout = round($payout, 2); $wtax = round(($payout * $WTRate),2); $cbr = round(($payout * $CBRRate),2); $netPayout = round(($payout - ($wtax + $cbr)),2); $member = array( 'code' => $code, 'name' => $name, 'level' => $level, 'generation' => $generation, 'rate' => $rate, 'payout' => $payout, 'execBonus' => $execBonus, 'wtax' => $wtax, 'cbr' => $cbr, 'netPayout' => $netPayout ); return $member; } function createMemberInfo($code, $name, $level, $generation, $rate, $payout) { //$payout = number_format($payout,'2','.',','); $member = array( 'code' => $code, 'name' => $name, 'level' => $level, 'generation' => $generation, 'rate' => $rate, 'payout' => $payout ); return $member; } function getExecutiveCommission($rate, $commission) { $executiveCommission = $commission * $rate; return $executiveCommission; } function getExecutiveCommissionVersion1 ($level, $SMDRate, $NMDRate, $levelSMD, $levelNMD, $SMDCommission, $NMDCommission, $netCommission) { $executiveCommission[] = array(); if($level == $levelSMD AND $SMDCommission == NULL) { //echo "SMD"; $executiveCommission['payout'] = $netCommission * $SMDRate; $executiveCommission['rate'] = $SMDRate; } elseif($level == $levelNMD AND $NMDCommission == NULL) { //echo "NMD"; $executiveCommission['payout'] = $netCommission * $NMDRate; $executiveCommission['rate'] = $NMDRate; if($SMDCommission == NULL) { $executiveCommission['payout'] += $netCommission * $SMDRate; $executiveCommission['rate'] = $NMDRate."(+".$SMDRate.")" ; } } else { $executiveCommission['payout'] = 0; $executiveCommission['rate'] = 0; } return $executiveCommission; /*if(($MDInfo['level'] > $levelMD) AND (($SMDCommission == NULL) OR ($NMDCommission == NULL)) ) { if($MDInfo['level'] == $levelSMD) { $executiveRate = $SMDRate; $SMDCommission = $executiveCommission = $netCommission * $executiveRate; } elseif($MDInfo['level'] == $levelNMD) { $executiveRate = $NMDRate; $NMDCommission = $executiveCommission = $netCommission * $executiveRate; } echo " Executive Commision: P".$executiveCommission." ( Rate: ".$executiveRate.")"; } */ } function getMDGenerationRateLeftover($code) { /* Get leftover commission from MD Generations */ switch($code) { case '1': $companyMDGenerationCommissionRate = 0.0975; break; case '2': $companyMDGenerationCommissionRate = 0.0475; break; case '3': $companyMDGenerationCommissionRate = 0.0275; break; case '4': $companyMDGenerationCommissionRate = 0.0125; break; case '5': $companyMDGenerationCommissionRate = 0.025; break; case '6': $companyMDGenerationCommissionRate = 0; break; default: $companyMDGenerationCommissionRate = 0.1925; break; } return $companyMDGenerationCommissionRate; } function getName($code, $table) { $sql = "SELECT * FROM ".$table." WHERE code = ".$this->db->escape($code)." LIMIT 1"; $query = $this->db->query($sql); if($query->num_rows() > 0) { $row = $query->row(); } $memberName = $row->lastName.", ".$row->firstName." ".$row->middleName; return $memberName; } function getMemberInfo($code, $effectivityDate=NULL) { $memberInfo = NULL; $sql = "SELECT * FROM member WHERE code = ".$this->db->escape($code)." LIMIT 1"; $query = $this->db->query($sql); //echo $query->num_rows(); if($query->num_rows() > 0) { $row = $query->row(); $memberInfo['code'] = $row->code; $memberInfo['lastName'] = $row->lastName; $memberInfo['firstName'] = $row->firstName; $memberInfo['middleName'] = $row->middleName; $memberInfo['level'] = $row->level; $memberInfo['MD'] = $row->MD; $memberInfo['recruiter'] = $row->recruiter; $query->free_result(); if($effectivityDate != NULL) { //echo " recruiterWithEffDate: ".$memberInfo['code']." ".$effectivityDate." "; $sql = "SELECT * FROM member_level WHERE code = '".$memberInfo['code']."' AND ('".$effectivityDate."' >= fromDate AND endDate >= '".$effectivityDate."') LIMIT 1"; //echo $sql; exit(); $query = $this->db->query($sql); if($query->num_rows() > 0) { $row = $query->row(); $memberInfo['level'] = $row->level; } else { $errorMessage = $code." does not exist in the database. This code refers to either the agent or part of the agent's hierarchy. Please check the member's database."; show_error($errorMessage); } } return $memberInfo; } else { $errorMessage = $code." does not exist in the database. This code refers to either the agent or part of the agent's hierarchy. Please check the member's database."; show_error($errorMessage); //quit(); //$data['details'] = $code." does not exist in the database"; //$this->load->view('error',$data); } } function getRecruiter($agentCode, $effectivityDate) { $sql = "SELECT * FROM member_level WHERE code = '".$agentCode."' AND ('".$effectivityDate."' >= fromDate AND endDate >= '".$effectivityDate."') LIMIT 1"; $query = $this->db->query($sql); if($query->num_rows() > 0) { $row = $query->row(); $getRecuiter = $row->recruiter; $query->free_result(); return $getRecuiter; } else { $errorMessage = $code." does not exist in the database. This code refers to either the agent or part of the agent's hierarchy. # Please check the member's database."; show_error($errorMessage); } } function getMemberRate($level) { //KBNotes 9:39 AM 12/15/2007: Are the level and rates fixed or should they be retrieved from a database? switch($level) { case '10': //Trainee Associate $memberRate = .32; break; case '20': //Associate $memberRate = .32; break; case '30': //FA $memberRate = .42; break; case '40': //SA $memberRate = .52; break; case '50': //MD $memberRate = .65; break; case '60': //SMD $memberRate = .65; break; case '70': //NMD $memberRate = .65; break; case '80': //CEO $memberRate = .65; break; default: $memberRate = .65; break; } return $memberRate; } function getGenerationRate($MDGeneration) { switch($MDGeneration) { case '1': $MDGenerationRate = .095; break; case '2': $MDGenerationRate = .05; break; case '3': $MDGenerationRate = .02; break; case '4': $MDGenerationRate = .015; break; case '5': $MDGenerationRate = .01; break; case '6': $MDGenerationRate = .0025; break; case '0': //CEO $MDGenerationRate = .01; break; default: $MDGenerationRate = 0; break; } return $MDGenerationRate; } function getGeneration($code, $levelCEO) { //$currentMD = $code; //$CEO = "0019AF"; //KBNOTE: change this to the CEO code later $counter = 0; $sql = "SELECT level, MD from member WHERE code = '$code' LIMIT 1"; $query = $this->db->query($sql); $row = $query->row(); $query->free_result(); //while($currentMD != $CEO) { while($row['level'] < $levelCEO) { $sql = "SELECT level, MD from member WHERE code = '".$row['MD']."' LIMIT 1"; $query = $this->db->query($sql); $row = $query->row(); $query->free_result(); //$currentMD = $row->MD; $counter += 1; } return $counter; } function getPartnerName($code) { //temp setup if($code == "PLPI") { return "Prudentialife Plans, Inc."; } elseif($code == "PLOP") { return "Prudentialife OPTIMA Funds, Inc."; } elseif($code == "PLHC") { return "Prudentialife HealthCare, Inc."; } elseif($code == "GP") { return "Generali Pilipinas"; } elseif($code == "PHI") { return "Philam Insurance"; } } function getProductName($code) { //temp setup if($code == "0005") { return "Life - Traditional - Basic"; } elseif($code == "0010") { return "Life - Traditional - Value Plus"; } elseif($code == "0015") { return "Life - Traditional - Premium"; } elseif($code == "0020") { return "Life - Flexi - Basic"; } elseif($code == "0025") { return "Life - Flexi - Value Plus"; } elseif($code == "0030") { return "Life - Flexi - Premium"; } elseif($code == "0035") { return "Life - Cremation - Basic"; } elseif($code == "0040") { return "Life - Cremation - Value Plus"; } elseif($code == "0045") { return "Life - Cremation - Premium"; } elseif($code == "0050") { return "Pension - Fund Starter"; } elseif($code == "0055") { return "Pension - Fund Builder"; } elseif($code == "0060") { return "Pension - Fund Builder Plus"; } elseif($code == "0065") { return "Pension - Premium Fund Builder"; } elseif($code == "0070") { return "Pension - Fund Secure"; } elseif($code == "0075") { return "Pension - Silver Fund Saver"; } elseif($code == "0080") { return "Pension - Wealth Builder"; } elseif($code == "0081") { return "Pension - Wealth Multiplier"; } elseif($code == "0082") { return "Pension - Wealth Multiplier Plus"; } elseif($code == "0085") { return "Education - PowerEd Persona A"; } elseif($code == "0090") { return "Education - PowerEd Persona B"; } elseif($code == "0095") { return "Education - PowerEd Prima"; } elseif($code == "0100") { return "Education - PowerEd Magna"; } elseif($code == "0105") { return "Education - PowerEd Summa"; } elseif($code == "0110") { return "Education - PowerEd Omni"; } elseif($code == "0115") { return "Primelife"; } elseif($code == "0120") { return "Serenity Gold"; } elseif($code == "0125") { return "Health Protect Plan 100"; } elseif($code == "0130") { return "Health Protect Plan 200"; } elseif($code == "0135") { return "Health Protect Plus - Plan 100"; } elseif($code == "0140") { return "Health Protect Plus - Plan 200"; } elseif($code == "0141") { return "Welcare Card Elite"; } elseif($code == "0150") { return "General Homeowner Protect"; } elseif($code == "0155") { return "Fire Commercial"; } elseif($code == "0160") { return "Commercial Vehicle"; } elseif($code == "0165") { return "Group Accident"; } elseif($code == "0170") { return "Private Car"; } elseif($code == "0175") { return "Fire General Business-Restaurant"; } elseif($code == "0180") { return "Fire Retail"; } else { $strSQL = "select *" ." "."from product" ." "."where code = {$this->db->escape($code)}"; $query = $this->db->query($strSQL); if ($query->num_rows() > 0) { $row = $query->row(); return $row->desc; } } } function getScholasticLevel($code) { if($code == "E") { return "Elementary"; } elseif($code == "HS") { return "High School"; } elseif($code == "C") { return "College"; } } function getModeOfPayment($code) { if($code == "SC") { return "Spot Cash"; } elseif($code == "A") { return "Annual"; } elseif($code == "SA") { return "Semi-Annual"; } elseif($code == "Q") { return "Quarterly"; } elseif($code == "M") { return "Monthly"; } } function getSaleType($code) { if($code == "I") { return "Individual"; } elseif($code == "G") { return "Group"; } } function getAdmin($code){ $sql = "SELECT * FROM users_admin WHERE id = ".$this->db->escape($code)." LIMIT 1"; $query = $this->db->query($sql); $row = $query->row(); if($query->num_rows() == 0) { return NULL; } else { return $row->lastName.", ".$row->firstName." ".$row->middleName; } } function getClientName($code) { $sql = "SELECT * FROM client WHERE code = '".$code."' LIMIT 1"; $query = $this->db->query($sql); $row = $query->row(); $query->free_result(); return $row->lastName.", ".$row->firstName." ".$row->middleName; } function getAgent($code){ $sql = "SELECT * FROM member WHERE code = ".$this->db->escape($code)." LIMIT 1"; $query = $this->db->query($sql); $row = $query->row(); if($query->num_rows() == 0) { return NULL; } else { return $row->lastName.", ".$row->firstName." ".$row->middleName; } } /** * Function for client's status by Joseph Ian G. * * param unknown_type $code * return unknown */ /*function getStatus($code) { $sql = "SELECT * FROM client WHERE code = '".$code."' LIMIT 1"; $query = $this->db->query($sql); $row = $query->row(); $query->free_result(); return $row->lastName.", ".$row->firstName." ".$row->middleName; }*/ function checkField($field, $fieldType) { if ($field==NULL) { return "".$fieldType." field missing. # "; } } function validateCode($code, $codeType, $table) { //echo "foobar ".$code; $errorMessage = ""; if($table == "client") { $sql = "SELECT * FROM client WHERE code = ".$this->db->escape($code)." LIMIT 1"; } else { $sql = "SELECT * FROM member WHERE code = ".$this->db->escape($code)." LIMIT 1"; } $query = $this->db->query($sql); if($query->num_rows() == 0) { $errorMessage .= "The ".$codeType." code is invalid or missing. "; } $query->free_result(); return $errorMessage; } function getMemberLevel($level) { $sql = "SELECT * FROM level WHERE code = ".$level." LIMIT 1"; $query = $this->db->query($sql); $row = $query->row(); $query->free_result(); return $row->name; } function getMonth($month) { $monthName = NULL; switch($month) { case "01": $monthName = "January"; break; case "02": $monthName = "February"; break; case "03": $monthName = "March"; break; case "04": $monthName = "April"; break; case "05": $monthName = "May"; break; case "06": $monthName = "June"; break; case "07": $monthName = "July"; break; case "08": $monthName = "August"; break; case "09": $monthName = "September"; break; case "10": $monthName = "October"; break; case "11": $monthName = "November"; break; case "12": $monthName = "December"; break; } return $monthName; } function getTitle($myTable, $myId) { $tempQuery = $this->db->getwhere($myTable, array(id => $myId) ); $tempRow = $tempQuery->row(); $tempQuery->free_result(); return $tempRow->title; } function getTalents($talentTypeId, $bookId) { //Get all the records that are related to this bookId. $query = $this->db->getwhere(relvar_books_talents, array(books_id => $bookId, talent_types_id => $talentTypeId) ); $num_rows = $query->num_rows(); for($i=0; $i < $num_rows; $i++) { $row = $query->row($i); $query2 = $this->db->getwhere(talents, array(id => $row->talents_id) ); $row2 = $query2->row(); $talents_string .= "id.">".$row2->first_name." ".$row2->middle_name." ".$row2->last_name.", "; } $talents_string = trim($talents_string); $talents_string = rtrim($talents_string, ','); $query->free_result(); return $talents_string; } function dropdownTalents($talentType, $query, $talent_types_id, $bookID) { //echo $bookID; //Create the drop down list $options = array(); foreach($query as $objectArray) { foreach($objectArray->result() as $row) { $fullName = $row->last_name.", ".$row->first_name." ".$row->middle_name; $options[$row->id] = $fullName; } } //Use asort to ALPHABETICALLY sort the names without re-indexing them. asort($options); $data = array( 'name' => $talentType.'[]', 'id' => $talentType, 'size' => '3', 'style' => 'width:50%', ); if($bookID) { //Get the selected writers who wrote in this bookCover $selected = array(); $whereArray = array(books_id=> $bookID, talent_types_id => $talent_types_id); $getTalents = $this->db->getwhere('relvar_books_talents', $whereArray ); //echo $getTalents->num_rows(); foreach($getTalents->result() as $tempRow) { $sql = $this->db->getwhere('talents', array(id => $tempRow->talents_id) ); foreach($sql->result() as $row){ $selected[] = $row->id; } } return form_multiselect($data, $options, $selected); } else { return form_multiselect($data, $options); } } function dropdownTalentsForAdd($talentType, $query, $talent_types_id) { //echo $bookID; //Create the drop down list $options = array(); foreach($query as $objectArray) { foreach($objectArray->result() as $row) { $fullName = $row->last_name.", ".$row->first_name." ".$row->middle_name; $options[$row->id] = $fullName; } } //Use asort to alphabetically sort the names without re-indexing them. asort($options); $data = array( 'name' => $talentType.'[]', 'id' => $talentType, 'size' => '3', 'style' => 'width:50%', ); return form_multiselect($data, $options); } function getTalentsController($talentID) { $query = $this->db->getwhere('relvar_talents_talent_types', array(talent_types_id => $talentID) ); $talentsArray = array(); foreach($query->result() as $row) { //echo "foo ". $tempRow->talents_id; $talentsArray[] = $this->db->getwhere('talents', array(id => $row->talents_id) ); //$getWriters[] = $sql->row(); } return $talentsArray; } function getAPV($code) { $sql = "SELECT * FROM client_product_app WHERE agent1 = '".$code."' OR agent2 = '".$code."' ORDER BY businessDate DESC"; $query = $this->db->query($sql); if($query->num_rows() > 0) { echo " "; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; foreach($query->result() as $row){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo " Application Number Business Type APV Business Date ".$row->applicationNumber." ".$row->businessType." ".$row->apv." ".$row->businessDate." "; echo " "; } $query->free_result(); } } ?> Fatal error: Class 'Adminmodel' not found in C:\wamp\www\brokerage\system\libraries\Loader.php on line 184 Are you running it on a test server on just through a browser? e.g. is the address - http://localhost/page.php or: file:///C:\Documents\page.phpdude mura man n og orasyon ang imo expected output mka buang og bsahon Quote from: marjune on August 01, 2009, 05:26:10 AM dude mura man n og orasyon ang imo expected output mka buang og bsahon Wha..?Old topic. Locked. |
|