mysql - CodeIgniter PHP Combing all rows in Database to display one value -


i'm looking help, i'm looking show numeric value combination of table looks this

finplanincomeid (pk) financialplanid (fk) weekly (int) fortnightly (int) monthly (int)

i want rows of weekly fortnightly , monthly add make master value have done far this.

model.php

    public function getincome($data) {                  $condition = "debt.[debtid] = '".$data."' , ";         $condition .= "fp.[financialplanid] = fpi.[financialplanid] , ";     $condition .= "debt.[debtid] = fp.[debtid] , ";     $condition .= "fp.[active] = 1 , ";     $condition .= "debt.[clientid] in (select [client_id] [clientportal].[dbo].[ci_user_access] [user_id] = '".$this->session->userdata['logged_in']['id']."')";       $this->db->select ('fp.[debtid], fp.[active], fpi.[financialplanid], fpi.[weekly], fpi.[fortnightly], fpi.[monthly], fpi.[weekly]*4 totalweekly, fpi.[monthly] totalmonthly, fpi.[fortnightly]*2 totalfortnightly');     $this->db->from('[focus].[dbo].[finplanincome] fpi');     $this->db->join('[focus].[dbo].[financialplan] fp', 'fp.[financialplanid] = fpi.[financialplanid]');     $this->db->join('[focus].[dbo].[debt] debt', 'fp.[debtid] = debt.[debtid]');     $this->db->where($condition);     $query = $this->db->get();      return $query->result_array();             }

controller.php

   public function overview()     {       if($this->_core())     {         $income = $this->accounts_database->getincome($this->session->userdata('debtid'));          $data = array(             'income1'       => $income[0]['totalmonthly'],             'income2'       => $income[0]['totalfortnightly'],             'income3'       => $income[0]['totalweekly']             );          $this->load->view('account_overview_view',$data);      } }

view.php

<td>income: <?php  $total = $income1 + $income2 + $income3; print($total); ?> </td>

ive tried cut done of code show parts matter. in nutshell trying take rows of weekly, fortnightly , monthly , combine them master table $total on view display value, have there works adds first row , doesn't rest.

any great.

edit: working sql 

select        isnull((sum (isnull(fpi.weekly, 0)) * 4) + sum (isnull(fpi.monthly, 0)) + (sum (isnull(fpi.fortnightly, 0)) * 2), 0)  financialplan fp inner join dbo.finplanincome fpi      on fp.financialplanid = fpi.financialplanid debtid = 1 , active = 1`


-

Comments

Post a Comment

Popular posts from this blog

python - How to insert QWidgets in the middle of a Layout? -

Image
i'm using qt framework build graphical user interface. use qgridlayout position qwidgets neatly. gui looks this: my application regularly adds new widgets gui @ runtime. these new widgets not added @ end of qlayout, somewhere in middle. the procedure bit cumbersome. applied on figure above, need take out widg_c , widg_d , ... qgridlayout. next, add widg_x and widg_y , , put other widgets again. how remove widgets qgridlayout: for in reversed(range(mygridlayout.count())): self.itemat(i).widget().setparent(none) ### as long you're dealing small amount of widgets, procedure not disaster. in application display lot of small widgets - perhaps 50 or more! application freezes second while procedure ongoing, annoying user. there way insert widgets somewhere in qlayout, without need take out other widgets? edit: apparently solution qvboxlayout simple. use function insertwidget(..) instead of addwidget(..) . docs can found link: http://doc.qt.io/qt-5/qboxlayou
Read more

python - serve multiple gunicorn django instances under nginx ubuntu -

i need serve 2 webs apps (django) on gunicorn under different domain names using nginx on ubuntu. started using tutorial: https://www.digitalocean.com/community/tutorials/how-to-set-up-django-with-postgres-nginx-and-gunicorn-on-ubuntu-16-04 it worked fine 1 using that. tried same thing second gives me 502 gateway second domain. tried following tutorial: http://michal.karzynski.pl/blog/2013/10/29/serving-multiple-django-applications-with-nginx-gunicorn-supervisor/ i'm @ part run gunicorn start script: sudo bin/gunicorn_start i response: starting webuildblack root traceback (most recent call last): file "/home/devin/webuildblack/bin/gunicorn", line 7, in <module> gunicorn.app.wsgiapp import run importerror: no module named 'gunicorn.app'; 'gunicorn' not package you have named program gunicorn.py gunicorn -package. rename file , remove gunicorn.pyc file.
Read more

module - Prestashop displayPaymentReturn hook url -

i new prestashop developer , trying create paymentmodule. have got show payment method can not proceed purchase because not know hot works. does know should redirect run hooddisplaypaymentreturn method? i happy if explain me complete navigation map make purchase. anyway, can find relation between hooks , pages? when have new module payment rely on simplest provided prestashop: bankwire. inside can find 3 hooks. hookpayment: public function hookpayment($params) { if (!$this->active) return; if (!$this->checkcurrency($params['cart'])) return; $this->smarty->assign(array( 'this_path' => $this->_path, 'this_path_bw' => $this->_path, 'this_path_ssl' => tools::getshopdomainssl(true, true).__ps_base_uri__.'modules/'.$this->name.'/' )); return $this->display(__file__, 'payment.tpl'); } hookdisplaypaymenteu: public fun
Read more