Sku.php 31 KB

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