Sku.php 31 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825
  1. <?php
  2. namespace Goods\Lib;
  3. use Dever;
  4. class Sku
  5. {
  6. # 设置sku特殊字段
  7. private $col = array
  8. (
  9. 'code' => '商品条码号',
  10. 's_price' => '市场价',
  11. 'f_price' => '门店采购价',
  12. 'c_price' => '成本价',
  13. 'price' => '销售价',
  14. 'min' => '采购起订数',
  15. 'unit' => '计量单位',
  16. 'weight' => '重量(kg)',
  17. );
  18. private $unit = array
  19. (
  20. '请选择','件','箱','盒','袋','个','桶','台','套','瓶','罐','支','条','kg','g','L','ML'
  21. );
  22. # 主要价格字段
  23. private $main = 'price';
  24. public function __construct()
  25. {
  26. # 设置权限
  27. Dever::load('manage/auth.init');
  28. }
  29. public function config()
  30. {
  31. $data['action'] = Dever::url('goods/lib/sku.update');
  32. $data['goods_id'] = Dever::input('goods_id');
  33. $data['other'] = Dever::input('other');
  34. $data['other_id'] = Dever::input('other_id');
  35. if ($data['other']) {
  36. $data['other_col'] = $data['other'] . '_id';
  37. }
  38. $data['attr'] = Dever::input('attr');
  39. $data['key'] = Dever::input('key');
  40. $data['single_attr'] = Dever::input('single_attr');
  41. $data['single_key'] = Dever::input('single_key');
  42. $data['input_attr'] = Dever::input('input_attr');
  43. $data['input_key'] = Dever::input('input_key');
  44. $data['hook'] = Dever::input('hook');
  45. $data['set'] = $this->getSet($data['other']);
  46. return $data;
  47. }
  48. private function getSet($other)
  49. {
  50. if ($other) {
  51. if (Dever::project($other)) {
  52. $set = Dever::load($other . '/lib/sku')->set;
  53. if (!isset($set['price_type'])) {
  54. $set['price_type'] = false;
  55. }
  56. } else {
  57. Dever::alert($other . '不存在');
  58. }
  59. } else {
  60. $set = array('col' => $this->col, 'price_type' => false);
  61. }
  62. return $set;
  63. }
  64. public function show()
  65. {
  66. $config = Dever::load('goods/lib/sku')->config();
  67. return $this->table($config['goods_id'], $config['other'], $config['other_id'], $config['set'], true);
  68. }
  69. public function update_api()
  70. {
  71. $config = Dever::load('goods/lib/sku')->config();
  72. $where = array();
  73. if ($config['other']) {
  74. $where[$config['other_col']] = $config['other_id'];
  75. $where['goods_id'] = $config['goods_id'];
  76. $key = 'sku_id';
  77. $table = $config['other'] . '/goods';
  78. } else {
  79. $where['info_id'] = $config['goods_id'];
  80. $key = 'key';
  81. $table = 'goods/info';
  82. $w['option_info_id'] = $config['goods_id'];
  83. $w['set_state'] = 2;
  84. Dever::db('goods/info_sku')->updates($w);
  85. }
  86. $sku_table = $table . '_sku';
  87. $code = array();
  88. if ($config['key'] == -1) {
  89. if ($config['other']) {
  90. $info = Dever::db($table)->one($where);
  91. } else {
  92. $info = Dever::db($table)->one($config['goods_id']);
  93. }
  94. $update = $where;
  95. foreach ($config['set']['col'] as $k => $v) {
  96. $update[$k] = Dever::input($k);
  97. if (!$update[$k] && strstr($k, '_price')) {
  98. $update[$k] = 0;
  99. }
  100. if ($k == 'code') {
  101. if (!$update[$k]) {
  102. Dever::alert('商品条码号不能为空');
  103. }
  104. if (in_array($update[$k], $code)) {
  105. Dever::alert('商品条码号已重复');
  106. }
  107. $code[] = $update[$k];
  108. }
  109. }
  110. if ($info && $update) {
  111. $update['where_id'] = $info['id'];
  112. Dever::db($table)->update($update);
  113. unset($update['where_id']);
  114. }
  115. $where[$key] = -1;
  116. /*
  117. if ($config['other']) {
  118. $info_sku = Dever::db('goods/info_sku')->one(array('goods_id' => $config['goods_id'], 'key' => -1));
  119. $where[$key] = $info_sku['id'];
  120. }
  121. */
  122. $info = Dever::db($sku_table)->one($where);
  123. $update[$key] = $where[$key];
  124. Dever::config('base')->hook = false;
  125. if (!$info) {
  126. $state = Dever::db($sku_table)->insert($update);
  127. } else {
  128. $update['where_id'] = $info['id'];
  129. $update['state'] = 1;
  130. $state = Dever::db($sku_table)->update($update);
  131. }
  132. } elseif ($config['key']) {
  133. if (!is_array($config['key'])) {
  134. $config['key'] = explode(',', $config['key']);
  135. }
  136. $min = array();
  137. $cur_sku = false;
  138. $sku_id = false;
  139. foreach ($config['key'] as $k => $v) {
  140. $type = 1;
  141. if (strstr($v, '||')) {
  142. $temp = explode('||', $v);
  143. $v = $temp[0];
  144. $type = $temp[1];
  145. }
  146. if (isset($config['attr'][$k])) {
  147. $data = $where;
  148. if ($config['other']) {
  149. $sku = Dever::db('goods/info_sku')->one(array('key' => $v, 'info_id' => $config['goods_id']));
  150. if (!$sku) {
  151. continue;
  152. }
  153. $data[$key] = $sku['id'];
  154. $info = Dever::db($sku_table)->one($data);
  155. } else {
  156. $info = Dever::db('goods/info_sku')->one(array('key' => $v, 'info_id' => $config['goods_id']));
  157. $data['attr'] = $config['attr'][$k];
  158. $data[$key] = $v;
  159. }
  160. $data['type'] = $type;
  161. foreach ($config['set']['col'] as $k1 => $v1) {
  162. $value = Dever::input($k1);
  163. $cur_sku = false;
  164. if (isset($value[$k])) {
  165. $data[$k1] = $value[$k];
  166. if ($k1 == 'code') {
  167. if (!$data[$k1]) {
  168. Dever::alert('商品条码号不能为空');
  169. }
  170. if (in_array($data[$k1], $code)) {
  171. Dever::alert('商品条码号已重复');
  172. }
  173. $code[] = $data[$k1];
  174. }
  175. if ($k1 == $this->main) {
  176. if (!isset($min[$k1])) {
  177. $min = $data;
  178. $cur_sku = true;
  179. } elseif ($min[$k1] > $data[$k1]) {
  180. $min = $data;
  181. $cur_sku = true;
  182. }
  183. }
  184. }
  185. }
  186. Dever::config('base')->hook = false;
  187. if (!$info) {
  188. $temp = Dever::db($sku_table)->insert($data);
  189. if ($cur_sku) {
  190. $sku_id = $temp;
  191. }
  192. } else {
  193. $data['where_id'] = $info['id'];
  194. if ($cur_sku) {
  195. $sku_id = $data['where_id'];
  196. }
  197. $data['state'] = 1;
  198. Dever::db($sku_table)->update($data);
  199. }
  200. }
  201. }
  202. if (!$config['other'] && $min) {
  203. $update = array();
  204. if ($sku_id) {
  205. $update['sku_id'] = $sku_id;
  206. }
  207. foreach ($config['set']['col'] as $k => $v) {
  208. if (isset($min[$k])) {
  209. $update[$k] = $min[$k];
  210. }
  211. }
  212. $update['where_id'] = $config['goods_id'];
  213. Dever::db($table)->update($update);
  214. }
  215. }
  216. if ($config['single_key']) {
  217. if (!is_array($config['single_key'])) {
  218. $config['single_key'] = explode(',', $config['single_key']);
  219. }
  220. foreach ($config['single_key'] as $k => $v) {
  221. $type = 2;
  222. if (strstr($v, '||')) {
  223. $temp = explode('||', $v);
  224. $v = $temp[0];
  225. $type = $temp[1];
  226. }
  227. if (isset($config['single_attr'][$k])) {
  228. $data = $where;
  229. if ($config['other']) {
  230. $sku = Dever::db('goods/info_sku')->one(array('key' => $v, 'info_id' => $config['goods_id']));
  231. if (!$sku) {
  232. continue;
  233. }
  234. $data[$key] = $sku['id'];
  235. $info = Dever::db($sku_table)->one($data);
  236. } else {
  237. $info = Dever::db('goods/info_sku')->one(array('key' => $v, 'info_id' => $config['goods_id']));
  238. $data['attr'] = $config['single_attr'][$k];
  239. $data[$key] = $v;
  240. }
  241. $data['type'] = $type;
  242. foreach ($config['set']['col'] as $k1 => $v1) {
  243. $value = Dever::input('single_' . $k1);
  244. if (isset($value[$k])) {
  245. $data[$k1] = $value[$k];
  246. }
  247. }
  248. Dever::config('base')->hook = false;
  249. if (!$info) {
  250. $temp = Dever::db($sku_table)->insert($data);
  251. } else {
  252. $data['where_id'] = $info['id'];
  253. $data['state'] = 1;
  254. Dever::db($sku_table)->update($data);
  255. }
  256. }
  257. }
  258. }
  259. if ($config['input_key']) {
  260. if (!is_array($config['input_key'])) {
  261. $config['input_key'] = explode(',', $config['input_key']);
  262. }
  263. foreach ($config['input_key'] as $k => $v) {
  264. $type = 3;
  265. if (strstr($v, '||')) {
  266. $temp = explode('||', $v);
  267. $v = $temp[0];
  268. $type = $temp[1];
  269. }
  270. if (isset($config['input_attr'][$k])) {
  271. $data = $where;
  272. if ($config['other']) {
  273. $sku = Dever::db('goods/info_sku')->one(array('key' => $v, 'info_id' => $config['goods_id']));
  274. if (!$sku) {
  275. continue;
  276. }
  277. $data[$key] = $sku['id'];
  278. $info = Dever::db($sku_table)->one($data);
  279. } else {
  280. $info = Dever::db('goods/info_sku')->one(array('key' => $v, 'info_id' => $config['goods_id']));
  281. $data['attr'] = $config['input_attr'][$k];
  282. $data[$key] = $v;
  283. }
  284. $data['type'] = $type;
  285. foreach ($config['set']['col'] as $k1 => $v1) {
  286. $value = Dever::input('input_' . $k1);
  287. if (isset($value[$k])) {
  288. $data[$k1] = $value[$k];
  289. }
  290. }
  291. Dever::config('base')->hook = false;
  292. if (!$info) {
  293. $temp = Dever::db($sku_table)->insert($data);
  294. } else {
  295. $data['where_id'] = $info['id'];
  296. $data['state'] = 1;
  297. Dever::db($sku_table)->update($data);
  298. }
  299. }
  300. }
  301. }
  302. Dever::config('base')->hook = true;
  303. Dever::out('yes');
  304. }
  305. public function table($goods, $other = false, $other_id = false, $set = false, $update = true, $parent_goods = false)
  306. {
  307. if (!$set) {
  308. $set = $this->getSet($other);
  309. }
  310. $info = is_array($goods) ? $goods : Dever::db('goods/info')->one($goods);
  311. $info = Info::init(-1)->info($info, 'view_reorder');
  312. if ($info && $other && isset($set['price_type']) && $set['price_type']) {
  313. $price_type = explode(',', $set['price_type']);
  314. if (in_array($info['price_type'], $price_type)) {
  315. if ($update) {
  316. return '组合商品无法设置库存';
  317. }
  318. if ($info['goods'] && is_array($info['goods'])) {
  319. $html = '';
  320. foreach ($info['goods'] as $k => $v) {
  321. $html .= $this->table($v['id'], $other, $other_id, $set, $update, $v) . '<br />';
  322. }
  323. $html .= '*组合商品的库存为以上商品中的最低库存为准';
  324. return $html;
  325. } else {
  326. return '';
  327. }
  328. }
  329. }
  330. $input = '';
  331. $sku_value = array();
  332. if ($other) {
  333. $other_col = $other . '_id';
  334. $sku_value = Dever::db($other . '/goods_sku')->getData(array('goods_id' => $info['id'], $other_col => $other_id, 'state_1' => 1));
  335. $input = '<input type="hidden" name="goods_id" value="'.$info['id'].'"/><input type="hidden" name="'.$other_col.'" value="'.$other_id.'"/>';
  336. }
  337. $sku = Dever::db('goods/info_sku')->getDataByKeys(array('info_id' => $info['id']));
  338. $group_attr = $single_attr = $input_attr = array();
  339. $head = $single_head = $input_head = '<thead><tr>';
  340. $html = '请先选择属性';
  341. if ($parent_goods) {
  342. $head .= '<th>商品名称</th>';
  343. $single_head .= '<th>商品名称</th>';
  344. $input_head .= '<th>商品名称</th>';
  345. }
  346. if (isset($info['group_attr']) && $info['group_attr']) {
  347. foreach ($info['group_attr'] as $k => $v) {
  348. if (isset($info['attr'][$v]['option'])) {
  349. $group_attr[$k] = $info['attr'][$v]['option'];
  350. $head .= '<th>'.$info['attr'][$v]['name'].'</th>';
  351. }
  352. }
  353. }
  354. if (isset($info['single_attr']) && $info['single_attr']) {
  355. $single_head .= '<th>属性名称</th>';
  356. foreach ($info['single_attr'] as $k => $v) {
  357. if (isset($info['attr'][$v]['option'])) {
  358. $single_attr = array_merge($single_attr, $info['attr'][$v]['option']);
  359. }
  360. }
  361. }
  362. if (isset($info['input_attr']) && $info['input_attr']) {
  363. $input_head .= '<th>属性名称</th>';
  364. $input_head .= '<th>起算</th>';
  365. foreach ($info['input_attr'] as $k => $v) {
  366. if (isset($info['attr'][$v]['option'])) {
  367. $input_attr[$k] = $info['attr'][$v];
  368. }
  369. }
  370. }
  371. $col_num = 0;
  372. foreach ($set['col'] as $k => $v) {
  373. if (!$update && strstr($v, '^')) {
  374. continue;
  375. }
  376. $col_num++;
  377. if (strstr($v, '^')) {
  378. $v = str_replace('^', '', $v);
  379. }
  380. if (strstr($v, '|')) {
  381. $v = str_replace('|', '', $v);
  382. }
  383. $head .= '<th>'.$v.'</th>';
  384. $single_head .= '<th>'.$v.'</th>';
  385. $input_head .= '<th>'.$v.'</th>';
  386. }
  387. $head .= '</tr></thead>';
  388. $single_head .= '</tr></thead>';
  389. $input_head .= '</tr></thead>';
  390. $body = '<tbody>';
  391. $single_body = '<tbody>';
  392. $input_body = '<tbody>';
  393. if (!$group_attr) {
  394. $prefix = '[总价]:';
  395. if (!$update && $col_num <= 1) {
  396. $head = '';
  397. }
  398. if ($update) {
  399. $input .= '<input type="hidden" name="key" value="-1"/>';
  400. }
  401. $body .= '<tr>';
  402. if ($parent_goods) {
  403. $body .= '<td width="10">'.$parent_goods['name'].'</td>';
  404. }
  405. foreach ($set['col'] as $k1 => $v1) {
  406. if (!$update && strstr($v1, '^')) {
  407. continue;
  408. }
  409. $value = $this->getValue($k1, -1, $sku_value, $sku);
  410. if ($update) {
  411. if (strstr($v1, '|')) {
  412. $v1 = str_replace('|', '', $v1);
  413. $body .= '<td width="30">'.$value.'</td>';
  414. } elseif ($k1 == 'unit') {
  415. $select = '';
  416. foreach ($this->unit as $k9 => $v9) {
  417. if ($value == $v9) {
  418. $selected = 'selected';
  419. } else {
  420. $selected = '';
  421. }
  422. $k9 = $v9;
  423. if ($v9 == '请选择') {
  424. $k9 = '';
  425. }
  426. $select .= '<option value="'.$k9.'" '.$selected.'>'.$v9.'</option>';
  427. }
  428. $body .= '<td width="30"><select lay-ignore name="'.$k1.'" >'.$select.'</select></td>';
  429. } else {
  430. $body .= '<td width="30"><input type="text" class="layui-input" name="'.$k1.'" value="'.$value.'"/></td>';
  431. }
  432. } elseif ($col_num > 1) {
  433. $body .= '<td width="30">'.$value.'</td>';
  434. } else {
  435. $body .= $value;
  436. }
  437. }
  438. $body .= '</tr>';
  439. } else {
  440. $prefix = '[组合价格]:';
  441. $group_attr = Dever::cartesian($group_attr);
  442. if ($sku_value) {
  443. foreach ($group_attr as $k => $v) {
  444. $key = array();
  445. foreach ($v['name'] as $k1 => $v1) {
  446. $key[] = $v['info_id'][$k1] . '-' . $v['id'][$k1];
  447. }
  448. $key = implode('_', $key);
  449. if (!isset($sku[$key])) {
  450. unset($group_attr[$k]);
  451. } elseif (isset($sku[$key]) && !isset($sku_value[$sku[$key]['id']])) {
  452. unset($group_attr[$k]);
  453. }
  454. }
  455. }
  456. $show = false;
  457. if ($group_attr) {
  458. foreach ($group_attr as $k => $v) {
  459. $body .= '<tr data-row="' .($k+1). '">';
  460. if ($parent_goods) {
  461. $body .= '<td>'.$parent_goods['name'].'</td>';
  462. }
  463. $key = $id = array();
  464. foreach ($v['name'] as $k1 => $v1) {
  465. $rows = 1;
  466. $body .= '<td width="50" rowspan="'.$rows.'">'.$v1.'</td>';
  467. $id[] = array
  468. (
  469. 'id' => $v['id'][$k1],
  470. 'attr_id' => $v['info_id'][$k1],
  471. );
  472. $key[] = $v['info_id'][$k1] . '-' . $v['id'][$k1];
  473. }
  474. $key = implode('_', $key);
  475. foreach ($set['col'] as $k1 => $v1) {
  476. if (!$update && strstr($v1, '^')) {
  477. continue;
  478. }
  479. $value = $this->getValue($k1, $key, $sku_value, $sku);
  480. if ($update) {
  481. if (strstr($v1, '|')) {
  482. $v1 = str_replace('|', '', $v1);
  483. $body .= '<td width="30">'.$value.'</td>';
  484. } elseif ($k1 == 'unit') {
  485. $select = '';
  486. foreach ($this->unit as $k9 => $v9) {
  487. if ($value == $v9) {
  488. $selected = 'selected';
  489. } else {
  490. $selected = '';
  491. }
  492. $k9 = $v9;
  493. if ($v9 == '请选择') {
  494. $k9 = '';
  495. }
  496. $select .= '<option value="'.$k9.'" '.$selected.'>'.$v9.'</option>';
  497. }
  498. $body .= '<td width="30"><select lay-ignore name="'.$k1.'['.$k.']" >'.$select.'</select></td>';
  499. } else {
  500. $body .= '<td width="30"><input type="text" class="layui-input" name="'.$k1.'['.$k.']" value="'.$value.'"/></td>';
  501. }
  502. } else {
  503. $body .= '<td width="30">'.$value.'</td>';
  504. }
  505. }
  506. if ($update) {
  507. $body .= '<input type="hidden" name="key['.$k.']" value="'.$key.'"/><textarea style="display:none;" name="attr['.$k.']">'.json_encode($id).'</textarea>';
  508. }
  509. $body .= '</tr>';
  510. }
  511. } else {
  512. $prefix = $head = $body = '';
  513. }
  514. }
  515. $body .= $input;
  516. $html = $prefix . $head . $body;
  517. if ($update) {
  518. $html = '<table class="layui-table goods_table" style="width: 100%;">' . $html . '</table>';
  519. } else {
  520. $html = '<table class="layui-table goods_table" style="width: 100%;">' . $html . '</table>';
  521. }
  522. if ($single_attr && $sku_value) {
  523. foreach ($single_attr as $k => $v) {
  524. $key = $v['info_id'] . '-' . $v['id'];
  525. if (!isset($sku[$key])) {
  526. unset($single_attr[$k]);
  527. } elseif (isset($sku[$key]) && !isset($sku_value[$sku[$key]['id']])) {
  528. unset($single_attr[$k]);
  529. }
  530. }
  531. }
  532. if ($single_attr) {
  533. $html = $html;
  534. foreach ($single_attr as $k => $v) {
  535. $id = array();
  536. $single_body .= '<tr data-row="' .($k+1). '">';
  537. if ($parent_goods) {
  538. $single_body .= '<td>'.$parent_goods['name'].'</td>';
  539. }
  540. $rows = 1;
  541. $single_body .= '<td width="100" rowspan="'.$rows.'">'. $v['parent_name'].'->'. $v['name'].'</td>';
  542. $id[] = array
  543. (
  544. 'id' => $v['id'],
  545. 'attr_id' => $v['info_id'],
  546. );
  547. $key = $v['info_id'] . '-' . $v['id'];
  548. foreach ($set['col'] as $k1 => $v1) {
  549. if (!$update && strstr($v1, '^')) {
  550. continue;
  551. }
  552. $value = $this->getValue($k1, $key, $sku_value, $sku);
  553. if ($update) {
  554. if (strstr($v1, '|')) {
  555. $v1 = str_replace('|', '', $v1);
  556. $single_body .= '<td width="30">'.$value.'</td>';
  557. } elseif ($k1 == 'unit') {
  558. $select = '';
  559. foreach ($this->unit as $k9 => $v9) {
  560. if ($value == $v9) {
  561. $selected = 'selected';
  562. } else {
  563. $selected = '';
  564. }
  565. $k9 = $v9;
  566. if ($v9 == '请选择') {
  567. $k9 = '';
  568. }
  569. $select .= '<option value="'.$k9.'" '.$selected.'>'.$v9.'</option>';
  570. }
  571. $body .= '<td width="30"><select lay-ignore name="single_'.$k1.'['.$k.']" >'.$select.'</select></td>';
  572. } else {
  573. $single_body .= '<td width="30"><input type="text" class="layui-input" name="single_'.$k1.'['.$k.']" value="'.$value.'"/></td>';
  574. }
  575. } else {
  576. $single_body .= '<td width="30">'.$value.'</td>';
  577. }
  578. }
  579. if ($update) {
  580. $single_body .= '<input type="hidden" name="single_key['.$k.']" value="'.$key.'"/><textarea style="display:none;" name="single_attr['.$k.']">'.json_encode($id).'</textarea>';
  581. }
  582. $single_body .= '</tr>';
  583. }
  584. $html = $html . '[单选价格]:<table class="layui-table">' . $single_head . $single_body . '</table>';
  585. }
  586. if ($input_attr && $sku_value) {
  587. foreach ($input_attr as $k => $v) {
  588. $key = array();
  589. foreach ($v['option'] as $k1 => $v1) {
  590. $key[] = $v1['price_key'];
  591. }
  592. $key = implode('_', $key);
  593. if (!isset($sku[$key])) {
  594. unset($input_attr[$k]);
  595. } elseif (isset($sku[$key]) && !isset($sku_value[$sku[$key]['id']])) {
  596. unset($input_attr[$k]);
  597. }
  598. }
  599. }
  600. if ($input_attr) {
  601. foreach ($input_attr as $k => $v) {
  602. if ($v['sell_compute'] == 2) {
  603. $v['sell_compute_type'] = '+';
  604. } elseif ($v['sell_compute'] == 3) {
  605. $v['sell_compute_type'] = '-';
  606. } else {
  607. $v['sell_compute_type'] = '*';
  608. }
  609. $id = array();
  610. $input_body .= '<tr data-row="' .($k+1). '">';
  611. if ($parent_goods) {
  612. $input_body .= '<td>'.$parent_goods['name'].'</td>';
  613. }
  614. $rows = 1;
  615. $key = $id = $name = array();
  616. foreach ($v['option'] as $k1 => $v1) {
  617. $id[] = array
  618. (
  619. 'id' => $v1['id'],
  620. 'attr_id' => $v1['info_id'],
  621. );
  622. $key[] = $v1['price_key'];
  623. $name[] = $v1['name'];
  624. }
  625. $key = implode('_', $key);
  626. $input_body .= '<td width="100" rowspan="'.$rows.'">'. $v['name'].'->'. implode($v['sell_compute_type'], $name).'</td>';
  627. $input_body .= '<td width="5"> >='.$v['sell_value'].'</td>';
  628. foreach ($set['col'] as $k1 => $v1) {
  629. if (!$update && strstr($v1, '^')) {
  630. continue;
  631. }
  632. $value = $this->getValue($k1, $key, $sku_value, $sku);
  633. if ($update) {
  634. if (strstr($v1, '|')) {
  635. $v1 = str_replace('|', '', $v1);
  636. $input_body .= '<td width="30">'.$value.'</td>';
  637. } elseif ($k1 == 'unit') {
  638. $select = '';
  639. foreach ($this->unit as $k9 => $v9) {
  640. if ($value == $v9) {
  641. $selected = 'selected';
  642. } else {
  643. $selected = '';
  644. }
  645. $k9 = $v9;
  646. if ($v9 == '请选择') {
  647. $k9 = '';
  648. }
  649. $select .= '<option value="'.$k9.'" '.$selected.'>'.$v9.'</option>';
  650. }
  651. $body .= '<td width="30"><select lay-ignore name="input_'.$k1.'['.$k.']" >'.$select.'</select></td>';
  652. } else {
  653. $input_body .= '<td width="30"><input type="text" class="layui-input" name="input_'.$k1.'['.$k.']" value="'.$value.'"/></td>';
  654. }
  655. } else {
  656. $input_body .= '<td width="30">'.$value.'</td>';
  657. }
  658. }
  659. if ($update) {
  660. $input_body .= '<input type="hidden" name="input_key['.$k.']" value="'.$key.'"/><textarea style="display:none;" name="input_attr['.$k.']">'.json_encode($id).'</textarea>';
  661. }
  662. $input_body .= '</tr>';
  663. }
  664. $html = $html . '[计算价]:<table class="layui-table">' . $input_head . $input_body . '</table>';
  665. }
  666. return $html;
  667. }
  668. private function create_table($head, $body)
  669. {
  670. $html = '<table class="layui-table">';
  671. }
  672. private function getValue($k1, $key, $sku_value, $sku)
  673. {
  674. $value = '';
  675. if ($k1 == 'unit' || $k1 == 'weight') {
  676. $value = '';
  677. } elseif ($k1 == 'min') {
  678. $value = 1;
  679. } else {
  680. $value = 0;
  681. }
  682. if ($key == -1) {
  683. /*
  684. if (isset($sku_value[$sku[$key]['id']]) && isset($sku_value[$sku[$key]['id']][$k1])) {
  685. $value = $sku_value[$sku[$key]['id']][$k1];
  686. }
  687. */
  688. if (isset($sku_value[-1]) && isset($sku_value[-1][$k1])) {
  689. $value = $sku_value[-1][$k1];
  690. } elseif (isset($sku[-1]) && isset($sku[-1][$k1])) {
  691. $value = $sku[-1][$k1];
  692. }
  693. } else {
  694. if (isset($sku[$key])) {
  695. if (isset($sku_value[$sku[$key]['id']][$k1])) {
  696. $value = $sku_value[$sku[$key]['id']][$k1];
  697. } elseif (isset($sku[$key][$k1])) {
  698. $value = $sku[$key][$k1];
  699. }
  700. }
  701. }
  702. return $value;
  703. }
  704. }