121
$request = $this->Request();
$params = [
":step_id" => $request->newStep,
":id" => $request->leadId
];
return $this->db->updateParams('ro_leads',["step_id" => ":step_id"], "id=:id", $params);
}
public function GetFull(int $id)
{
$params = [
":id" => $id
];
$sqlLead = __DIR__ . "/sql/leads/getLead.sql";
$sqlObjects = __DIR__ . "/sql/leads/getObjectsLead.sql";
$sqlComments = __DIR__ . "/sql/leads/getCommentsLead.sql";
$lead = $this->db->queryRowFile($sqlLead, $params);
$lead["objects"] = $this->db->queryRowsFile($sqlObjects, $params);
$lead["comments"] = $this->db->queryRowsFile($sqlComments, $params);
return $lead;
}
public function AddComment($commentInfo)
{
$params = [
"leads_id" => $commentInfo->leadId,
"comment_name" => $commentInfo->textComment
];
$newComment = $this->db->insert('ro_leads_comment', $params);
return $this->db->where('ro_leads_comment', "id = $newComment", true, "comment_name, creation_date");
}
public function GetAddressObject($address)
{
$params = [
":full_address" => "%$address%"
];
$sql = __DIR__ ."/sql/leads/getAddressObject.sql";
return $this->db->queryRowsFile($sql, $params);
}
public function AddObject($obj)
{
$params = [