SupplierContactModel.php
2.53 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
<?php
namespace App\Model;
use Illuminate\Database\Eloquent\Model;
use Request;
class SupplierContactModel extends Model
{
protected $connection = 'web';
protected $table = 'supplier_contact';
public $timestamps = false;
public function AddInfo($SupplierID = '', $data = '')
{
if (empty($SupplierID) || empty($data) || !is_array($data)) {
return false;
}
$Add = array();
foreach ($data as $k => $v) {
foreach ($v as $kk => $vv) {
$Add[$kk][$k] = $vv;
$Add[$kk]['supplier_id'] = $SupplierID;
}
}
foreach ($Add as $v) {
$this->insert($v);
}
return true;
}
public function AddContactInfo($data = '', $is_update = false)
{
if (empty($data) || !is_array($data)) {
return false;
}
if ($is_update) { // 更新
$supplier_id = $data['supplier_id'];
unset($data['supplier_id']);
$this->where('supplier_id', '=', $supplier_id)->update($data);
} else {
$this->insert($data);
}
}
public function SaveInfo($SupplierID = '', $data = '')
{
if ($SupplierID <= 0) {
return false;
}
$this->where('supplier_id', '=', $SupplierID)->delete();
return $this->AddInfo($SupplierID, $data);
}
public function ContactInfo($SupplierID = '')
{
$collert = Request::only('supplier_id');
$collert = TrimX($collert, true, ['supplier_id']);
empty($collert) && $collert['supplier_id'] = $SupplierID;
if (empty($collert['supplier_id'])) {
return false;
}
$info = $this->where('supplier_id', '=', $collert['supplier_id'])->get();
if (!$info) {
return false;
}
$info = $info->toArray();
return $info;
}
//获取未完整的联系方式
public function getNotCompletedContacts($supplierId, $codeId)
{
$notCompleteContacts = SupplierContactModel::where('supplier_id', $supplierId)
->where('can_check_uids', $codeId)
->where(function ($q) {
$q->where('supplier_consignee', '')
->orWhere('supplier_position', '')
->orWhere('supplier_email', '')
->orWhere('supplier_mobile', '')
->orWhere('supplier_telephone', '');
})->get();
return !empty($notCompleteContacts) ? $notCompleteContacts->toArray() : [];
}
}