PHP trade::get_pl_id_by_partner_and_type Examples

Example #1

File: storage_trait.cl.php Project: ut8ia/proBase

 function insert_new_item($pr_id, $i_status)
 {
     // place id - virtual procurement storage for current partner
     $pl_id = trade::get_pl_id_by_partner_and_type($this->user['p_id'], 1);
     $sql = "INSERT INTO `ITEMS`(\r`I_ID`,\r`I_PR_ID`,\r`I_PL_ID`,\r`I_SERIAL`,\r`I_DESC`,\r`I_IS_ID`,\r`I_P_ID`\r) VALUES ('0','" . (int) $pr_id . "','" . $pl_id . "','','','" . (int) $i_status . "','" . $this->user['p_id'] . "');";
     $result = $this->mysqli->query($sql);
     return $this->mysqli->insert_id;
 }