21use Luracast\Restler\RestException;
23require_once DOL_DOCUMENT_ROOT.
'/supplier_proposal/class/supplier_proposal.class.php';
37 public static $FIELDS = array(
44 public $supplier_proposal;
64 public function delete(
$id)
66 if (!DolibarrApiAccess::$user->hasRight(
'supplier_proposal',
'supprimer')) {
67 throw new RestException(403);
69 $result = $this->supplier_proposal->fetch(
$id);
71 throw new RestException(404,
'Supplier Proposal not found');
75 throw new RestException(403,
'Access not allowed for login '.DolibarrApiAccess::$user->login);
78 if (!$this->supplier_proposal->delete(DolibarrApiAccess::$user)) {
79 throw new RestException(500,
'Error when delete Supplier Proposal : '.$this->supplier_proposal->error);
85 'message' =>
'Supplier Proposal deleted'
102 if (!DolibarrApiAccess::$user->hasRight(
'supplier_proposal',
'lire')) {
103 throw new RestException(403);
106 $result = $this->supplier_proposal->fetch(
$id);
108 throw new RestException(404,
'Supplier Proposal not found');
112 throw new RestException(403,
'Access not allowed for login '.DolibarrApiAccess::$user->login);
115 $this->supplier_proposal->fetchObjectLinked();
127 public function post($request_data =
null)
129 if (!DolibarrApiAccess::$user->hasRight(
'supplier_proposal',
'creer')) {
130 throw new RestException(403,
"Insufficiant rights");
133 $result = $this->
_validate($request_data);
135 foreach ($request_data as $field => $value) {
136 if ($field ===
'caller') {
138 $this->supplier_proposal->context[
'caller'] = $request_data[
'caller'];
142 $this->supplier_proposal->$field = $value;
151 if ($this->supplier_proposal->create(DolibarrApiAccess::$user) < 0) {
152 throw new RestException(500,
"Error creating supplier proposal", array_merge(array($this->supplier_proposal->error), $this->supplier_proposal->errors));
155 return $this->supplier_proposal->id;
167 public function put(
$id, $request_data =
null)
169 if (!DolibarrApiAccess::$user->hasRight(
'supplier_proposal',
'creer')) {
170 throw new RestException(403);
173 $result = $this->supplier_proposal->fetch(
$id);
175 throw new RestException(404,
'Supplier proposal not found');
179 throw new RestException(403,
'Access not allowed for login '.DolibarrApiAccess::$user->login);
181 foreach ($request_data as $field => $value) {
182 if ($field ==
'id') {
185 if ($field ===
'caller') {
187 $this->supplier_proposal->context[
'caller'] = $request_data[
'caller'];
190 if ($field ==
'array_options' && is_array($value)) {
191 foreach ($value as $index => $val) {
192 $this->supplier_proposal->array_options[$index] = $val;
196 $this->supplier_proposal->$field = $value;
199 if ($this->supplier_proposal->update(DolibarrApiAccess::$user) > 0) {
200 return $this->
get(
$id);
202 throw new RestException(500, $this->supplier_proposal->error);
223 public function index($sortfield =
"t.rowid", $sortorder =
'ASC', $limit = 100, $page = 0, $thirdparty_ids =
'', $sqlfilters =
'', $properties =
'', $pagination_data =
false)
225 if (!DolibarrApiAccess::$user->hasRight(
'supplier_proposal',
'lire')) {
226 throw new RestException(403);
232 $socids = DolibarrApiAccess::$user->socid ?: $thirdparty_ids;
236 if (!DolibarrApiAccess::$user->hasRight(
'societe',
'client',
'voir') && !$socids) {
237 $search_sale = DolibarrApiAccess::$user->id;
240 $sql =
"SELECT t.rowid";
241 $sql .=
" FROM ".MAIN_DB_PREFIX.
"supplier_proposal AS t";
242 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"supplier_proposal_extrafields AS ef ON (ef.fk_object = t.rowid)";
243 $sql .=
' WHERE t.entity IN ('.getEntity(
'propal').
')';
245 $sql .=
" AND t.fk_soc IN (".$this->db->sanitize($socids).
")";
248 if ($search_sale && $search_sale !=
'-1') {
249 if ($search_sale == -2) {
250 $sql .=
" AND NOT EXISTS (SELECT sc.fk_soc FROM ".MAIN_DB_PREFIX.
"societe_commerciaux as sc WHERE sc.fk_soc = t.fk_soc)";
251 } elseif ($search_sale > 0) {
252 $sql .=
" AND EXISTS (SELECT sc.fk_soc FROM ".MAIN_DB_PREFIX.
"societe_commerciaux as sc WHERE sc.fk_soc = t.fk_soc AND sc.fk_user = ".((int) $search_sale).
")";
260 throw new RestException(400,
'Error when validating parameter sqlfilters -> '.$errormessage);
265 $sqlTotals = str_replace(
'SELECT t.rowid',
'SELECT count(t.rowid) as total', $sql);
267 $sql .= $this->db->order($sortfield, $sortorder);
272 $offset = $limit * $page;
274 $sql .= $this->db->plimit($limit + 1, $offset);
277 $result = $this->db->query($sql);
280 $num = $this->db->num_rows($result);
281 $min = min($num, ($limit <= 0 ? $num : $limit));
284 $obj = $this->db->fetch_object($result);
286 if ($propal_static->fetch($obj->rowid)) {
292 throw new RestException(503,
'Error when retrieving supplier proposal list : '.$this->db->lasterror());
296 if ($pagination_data) {
297 $totalsResult = $this->db->query($sqlTotals);
298 $total = $this->db->fetch_object($totalsResult)->total;
303 $obj_ret[
'data'] = $tmp;
304 $obj_ret[
'pagination'] = [
305 'total' => (int) $total,
307 'page_count' => ceil((
int) $total / $limit),
325 if ($data ===
null) {
329 foreach (SupplierProposals::$FIELDS as $field) {
330 if (!isset($data[$field])) {
331 throw new RestException(400,
"$field field missing");
333 $propal[$field] = $data[$field];
$id
Support class for third parties, contacts, members, users or resources.
if(! $sortfield) if(! $sortorder) $object
_filterObjectProperties($object, $properties)
Filter properties that will be returned on object.
static _checkAccessToResource($resource, $resource_id=0, $dbtablename='', $feature2='', $dbt_keyfield='fk_soc', $dbt_select='rowid')
Check access by user to a given resource.
Class to manage price ask supplier.
put($id, $request_data=null)
Update supplier proposal general fields (won't touch lines of supplier proposal)
__construct()
Constructor.
post($request_data=null)
Create supplier proposal (price request) object.
index($sortfield="t.rowid", $sortorder='ASC', $limit=100, $page=0, $thirdparty_ids='', $sqlfilters='', $properties='', $pagination_data=false)
List supplier proposals.
_cleanObjectDatas($object)
Clean sensible object datas @phpstan-template T.
_validate($data)
Validate fields before create or update object.
forgeSQLFromUniversalSearchCriteria($filter, &$errorstr='', $noand=0, $nopar=0, $noerror=0)
forgeSQLFromUniversalSearchCriteria