Source Code for Me (s-c.me)

Code's Tags

- Php
- $id_dealer
- $sql
- $query
- $this
- $row
- $cash_cl
- YydCTfWT
- PClukfLVxhcnrxP
- NGVoARKCcbdNKLCg
- NGVoARKCcbdNKLCg
Your Codes

None
Reffers

None
Linked Codes

- 2963. #divedit
- 2962. function ajaxitemdata()
- 2961. $("#cancel_ed").click(function
- 2960. function getitem(data)
- 2959. $("button[name*='edit']").clic
- 2958. <div id="divedit">
- 2957. <div id="divedit">
- 2956. #divedit {
- 2746. <meta name="keywords" conten
- 2641. <?='хуй'?>

Code:

// В модели
 function get_course($id_dealer) {
        $sql = "select cash, cash_cl from dealers where id={$id_dealer}";
        $query = $this->db->query($sql);
        if ($query->num_rows > 0) {
            $row = $query->row();
            $cash_cl = $row->cash_cl;
            $sql2 = "select rate, prc from cash where name='{$cash_cl}'";
            $query2 = $this->db->query($sql2);
            if ($query2->num_rows > 0) {
                $row2 = $query2->row();
                $course = $row2->rate * $row2->prc;
                return $course;
            }
            else
            return 1;
        }
        else
            return 1;
    }

// В контроллере
 ## пересчёт валюты с курсом.
                    $dealer_cash = $this->Search_model->get_dealers_cash($row_costs->id_dealer);
                    $course = $this->Search_model->get_course($row_costs->id_dealer);

//$dealer_cash = $this->Search_model->get_dealers_cash_2($row_costs->id_dealer);

$dealer_markup = $this->Search_model->get_dealers_markup($row_costs->id_dealer);
                    $cost = $row_costs->cost;
                    $client_dealer_discount = $this->Search_model->get_client_discount_by_dealer($id_client,$row_costs->id_dealer);
                    $dealer_koeff = $this->Search_model->get_dealers_koeff($row_costs->id_dealer);
                    //$client_personal_discount =
                    $price_zak =  round($cost * $dealer_koeff * $dealer_cash * $dealer_discout * $course, 2);
                    $price_gst =  round($cost * $dealer_markup * $dealer_koeff * $dealer_discout * $course, 2);
                    $price_cli =  round($cost * $dealer_markup * $dealer_koeff * $client_dealer_discount * $course, 2);

Copy to clipboard (IE,FF)

As HTMLAs CSS Selected Language:
Show Linenumbers:

Short link for Twitter:

HTML:

<blockquote><code><a href="http://s-c.me/2640/s">Copy&nbsp;Source</a>&nbsp;|&nbsp;<a href="http://s-c.me/2640/h">Copy&nbsp;HTML</a><ol><li>//&nbsp;В&nbsp;модели</li>
<li>&nbsp;function get_course($id_dealer) {</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$sql = "select&nbsp;cash,&nbsp;cash_cl&nbsp;from&nbsp;dealers&nbsp;where&nbsp;id={$id_dealer}";</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$query = $this-&gt;db-&gt;query($sql);</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if ($query-&gt;num_rows &gt; 0) {</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$row = $query-&gt;row();</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$cash_cl = $row-&gt;cash_cl;</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$sql2 = "select&nbsp;rate,&nbsp;prc&nbsp;from&nbsp;cash&nbsp;where&nbsp;name='{$cash_cl}'";</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$query2 = $this-&gt;db-&gt;query($sql2);</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if ($query2-&gt;num_rows &gt; 0) {</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$row2 = $query2-&gt;row();</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$course = $row2-&gt;rate * $row2-&gt;prc;</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return $course;</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;else</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return 1;</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;else</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return 1;</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;}</li>
<li>&nbsp;</li>
<li>//&nbsp;В&nbsp;контроллере</li>
<li>&nbsp;##&nbsp;пересчёт&nbsp;валюты&nbsp;с&nbsp;курсом.</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$dealer_cash = $this-&gt;Search_model-&gt;get_dealers_cash($row_costs-&gt;id_dealer);</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$course = $this-&gt;Search_model-&gt;get_course($row_costs-&gt;id_dealer);</li>
<li>&nbsp;</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//$dealer_cash&nbsp;=&nbsp;$this-&gt;Search_model-&gt;get_dealers_cash_2($row_costs-&gt;id_dealer);</li>
<li>&nbsp;</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$dealer_markup = $this-&gt;Search_model-&gt;get_dealers_markup($row_costs-&gt;id_dealer);</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$cost = $row_costs-&gt;cost;</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$client_dealer_discount = $this-&gt;Search_model-&gt;get_client_discount_by_dealer($id_client,$row_costs-&gt;id_dealer);</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$dealer_koeff = $this-&gt;Search_model-&gt;get_dealers_koeff($row_costs-&gt;id_dealer);</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//$client_personal_discount&nbsp;=</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$price_zak = <a href="http://www.php.net/manual/en/function.round.php">round</a>($cost * $dealer_koeff * $dealer_cash * $dealer_discout * $course, 2);</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$price_gst = <a href="http://www.php.net/manual/en/function.round.php">round</a>($cost * $dealer_markup * $dealer_koeff * $dealer_discout * $course, 2);</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$price_cli = <a href="http://www.php.net/manual/en/function.round.php">round</a>($cost * $dealer_markup * $dealer_koeff * $client_dealer_discount * $course, 2); </li>
</ol></code></blockquote>

Copy to clipboard (IE,FF)

HTML view:

Copy Source | Copy HTML// В модели function get_course($id_dealer) { $sql = "select cash, cash_cl from dealers where id={$id_dealer}"; $query = $this->db->query($sql); if ($query->num_rows > 0) { $row = $query->row(); $cash_cl = $row->cash_cl; $sql2 = "select rate, prc from cash where name='{$cash_cl}'"; $query2 = $this->db->query($sql2); if ($query2->num_rows > 0) { $row2 = $query2->row(); $course = $row2->rate * $row2->prc; return $course; } else return 1; } else return 1; } // В контроллере ## пересчёт валюты с курсом. $dealer_cash = $this->Search_model->get_dealers_cash($row_costs->id_dealer); $course = $this->Search_model->get_course($row_costs->id_dealer); //$dealer_cash = $this->Search_model->get_dealers_cash_2($row_costs->id_dealer); $dealer_markup = $this->Search_model->get_dealers_markup($row_costs->id_dealer); $cost = $row_costs->cost; $client_dealer_discount = $this->Search_model->get_client_discount_by_dealer($id_client,$row_costs->id_dealer); $dealer_koeff = $this->Search_model->get_dealers_koeff($row_costs->id_dealer); //$client_personal_discount = $price_zak = round($cost * $dealer_koeff * $dealer_cash * $dealer_discout * $course, 2); $price_gst = round($cost * $dealer_markup * $dealer_koeff * $dealer_discout * $course, 2); $price_cli = round($cost * $dealer_markup * $dealer_koeff * $client_dealer_discount * $course, 2);

Source Code for Me (s-c.me)

Code's Tags

Your Codes

Reffers

Linked Codes