{"_id":"@dfeidao/fd-an000047","_rev":"5-c504089da7f5d69426871d0bdc81011d","name":"@dfeidao/fd-an000047","dist-tags":{"latest":"4.6.201910111019"},"versions":{"4.6.201909181136":{"name":"@dfeidao/fd-an000047","version":"4.6.201909181136","description":"复杂查询","scripts":{"test":"../../node_modules/.bin/tsc -w & ../../node_modules/.bin/ava --watch ./test.js","lint":"../../node_modules/.bin/tslint -p tsconfig.json","compile":"../../node_modules/.bin/tsc","build":"npm run lint && npm run compile"},"repository":{"type":"git","url":"https://gitee.com/dfeidao/atom-nodejs"},"keywords":["feidao","01feidao","dfeidao","atom","飞道","原子操作","ai"],"author":{"name":"taoqf","email":"tao_qiufeng@126.com","url":"http://www.01feidao.com/"},"contributors":[{"name":"taoqf","email":"tao_qiufeng@126.com","url":"http://www.01feidao.com/"}],"maintainers":[{"name":"taoqf","email":"tao_qiufeng@126.com"}],"license":"MIT","peerDependencies":{"@dfeidao/send-msg":"*"},"dependencies":{"@dfeidao/fd-an000031":"4.6.201909170957"},"devDependencies":{"@dfeidao/send-msg":"latest"},"_id":"@dfeidao/fd-an000047@4.6.201909181136","_nodeVersion":"12.10.0","_npmVersion":"6.10.3","dist":{"integrity":"sha512-Cbam5WRX+BVKPfa21/yrkDsqsUM/DkHpmXCtqHFbBEIotioOcGtpWSbVKj6P+D1QqVAgIlEMnuGVRiJBlZscfQ==","shasum":"1695f837c82925f61773c2e8c277941ea027beb4","tarball":"https://registry.npmjs.org/@dfeidao/fd-an000047/-/fd-an000047-4.6.201909181136.tgz","fileCount":6,"unpackedSize":27150,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJdgaZPCRA9TVsSAnZWagAAROEQAJgqIVmh9PJnrt/lQeR7\nUJYP+g/wEM7GJEpBg8B/CDZATwV65797VufbBA6fDljEn1PhwGDjJ5e/DZXC\nepiDZ8AN4bgODObkBnyRGDxEbMR52t+oeYw+GsU/dwDQeeQ53r7zLXLkV/nZ\nANNYCPxVFswbEw4AUJZoig/UOxJPpzHOgIDHR4a+5fEdMZxtXx3V21acEaY4\n4DzjNHvS8+d3YqsJzkWDuDxZL7FvCICDk+JWrkrpK0bhHnxB77T7JXPYzmJr\nmj1P+rTfGwlUqntEihImLezYxDXA9Tltg52pU5trOOqtOiSGLkw5aKkIt+7q\nKSkpbXLyJCaiZFwJPbKhQGTq5tMZs4v3s+NkKT5kUKHAndXf6wO5aktaFbwn\neG602kFH27dLRracD1lfsiwzCBNp9/9Qlr5OEBqE8ovuxkCCBC3ov8TyNInC\nKLwu67fKXPBXxpMRurznJna+ofxneAUfL3KdrL9Hl59xKVl/iRUNoMtaUS9H\npNPxHRUlMKBwsiwr+P7l00ZYGyYRt2rx/jJ6i4r218WlPYmRqSO6+aq/RjYo\n8Irv1RhgCrHmVGDqWjjkAG3iIy0llgwuilv9yFQykJaMBlryZ0rJa1NHGhM5\nZPGkPFZ7499ODfdcbXs1xZEoZ2gtNY9gUC4fHInmXVUpZQBm1WKtRhDOI4q/\ns0jh\r\n=9kFt\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQDw42+ivCDDLM4Qll2WZzn+dJXg3nt/CfnC051vktjQrgIgNj0EY7HO6W1INH564oKTvPYw0RXBGzMsAw1WvVgTj18="}]},"_npmUser":{"name":"taoqf","email":"tao_qiufeng@126.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/fd-an000047_4.6.201909181136_1568777807060_0.9745992396824394"},"_hasShrinkwrap":false},"4.6.201909181225":{"name":"@dfeidao/fd-an000047","version":"4.6.201909181225","description":"复杂查询","scripts":{"test":"../../node_modules/.bin/tsc -w & ../../node_modules/.bin/ava --watch ./test.js","lint":"../../node_modules/.bin/tslint -p tsconfig.json","compile":"../../node_modules/.bin/tsc","build":"npm run lint && npm run compile"},"repository":{"type":"git","url":"https://gitee.com/dfeidao/atom-nodejs"},"keywords":["feidao","01feidao","dfeidao","atom","飞道","原子操作","ai"],"author":{"name":"taoqf","email":"tao_qiufeng@126.com","url":"http://www.01feidao.com/"},"contributors":[{"name":"taoqf","email":"tao_qiufeng@126.com","url":"http://www.01feidao.com/"}],"maintainers":[{"name":"taoqf","email":"tao_qiufeng@126.com"}],"license":"MIT","peerDependencies":{"@dfeidao/send-msg":"*"},"devDependencies":{"@dfeidao/send-msg":"latest"},"_id":"@dfeidao/fd-an000047@4.6.201909181225","_nodeVersion":"12.10.0","_npmVersion":"6.10.3","dist":{"integrity":"sha512-t3a9y3+Qi9pneUzbQLY9+3JIa7xn/HiSvhLvLnUhwHjLVWXixIL5VS460rnkT5YsiCLd1V2l0cpZ6X9JIUzqvg==","shasum":"d318db258d53d42b07013201f74c4d3eb6df4eba","tarball":"https://registry.npmjs.org/@dfeidao/fd-an000047/-/fd-an000047-4.6.201909181225.tgz","fileCount":6,"unpackedSize":27098,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJdgbHGCRA9TVsSAnZWagAAgcEP/i0yhODvJmOZttLnGudA\npEqHOPxoFXhsVU9whP4eqaC+bXssrIPMZNgsAOEMMknUl+uJ+c70v44vMfBo\nkC3qeDssZSssH85naRt56bQTYnPyoM1hyeB82xX0LzkXb7nXctS1scJlX1tz\nACY+N34OuFJvSPSd6REvLYrQTnNSxBqAeLi7d34MDPPEvQe3WXLgL5IssAgr\nOfuDukPlYGOqSH5l+asaOA0Plnwenmztb9qar57n946uGi8zH02o7mzXjJYv\n4qRjLCpvj/izeu2jdOWBA/4m0WcS+eXuSRZZDdfJutWhhPhAIqcOfS8mdx7q\nhxMhOrE0ugOBRmE0xHq2x10ywonfU6aKaF34YP9iBV2Ok9GgkrYW9rLOzUgb\nZBoKzZO/5nktfLcuafA2QErQoD80+VBFpd3Tz/i1tthSVjm2UD4vQg0jcaqL\nCwJTiVZQtsQhz7OFMjc/ifDLC1rn8FUjAaCJOwqJV6iSPArhyzJI5QQ5RqHI\nrGO2MtGNR4zK7e8Y1jBS9UuJtUMS41S14+7tIIL2CcXGj5IK3DK5xXTdouEl\n3PQ9fGomHc4eDI3WYXQY73Wgke/F66AuBkHv86Un3i3Koyu7e/Wn8X98CzYa\nSAc1/CZUh8AoKdE4CGgcKY3zBFvGG6xT+UAOnIteBLGSmts+pngwOQ4sqmaX\nc7qc\r\n=mHKz\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIE8SvhaHPbKz+8R0qm49ln4PPOujC3M1mqYEaEVDYT2ZAiApkW8HRTxz7B0N2gnKui8mFxX1vAjS/jkhte0TQuUL0w=="}]},"_npmUser":{"name":"taoqf","email":"tao_qiufeng@126.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/fd-an000047_4.6.201909181225_1568780742059_0.7489946032165538"},"_hasShrinkwrap":false},"4.6.201909261826":{"name":"@dfeidao/fd-an000047","version":"4.6.201909261826","description":"复杂查询","scripts":{"test":"../../node_modules/.bin/tsc -w & ../../node_modules/.bin/ava --watch ./test.js","lint":"../../node_modules/.bin/tslint -p tsconfig.json","compile":"../../node_modules/.bin/tsc","build":"npm run lint && npm run compile"},"repository":{"type":"git","url":"https://gitee.com/dfeidao/atom-nodejs"},"keywords":["feidao","01feidao","dfeidao","atom","飞道","原子操作","ai"],"author":{"name":"taoqf","email":"tao_qiufeng@126.com","url":"http://www.01feidao.com/"},"contributors":[{"name":"taoqf","email":"tao_qiufeng@126.com","url":"http://www.01feidao.com/"}],"maintainers":[{"name":"taoqf","email":"tao_qiufeng@126.com"}],"license":"MIT","peerDependencies":{"@dfeidao/send-msg":"*"},"devDependencies":{"@dfeidao/send-msg":"latest"},"_id":"@dfeidao/fd-an000047@4.6.201909261826","_nodeVersion":"12.10.0","_npmVersion":"6.10.3","dist":{"integrity":"sha512-n9h6NTn+29By7GCn3y+yKLV5ttBQAOYV2LArhFSRfpJD4Ia5FIjMgvGEtYCO/aVgme26wRH09dEU4erVt41f9Q==","shasum":"d56a75a1058a88180680898bc4db6de239cb1d07","tarball":"https://registry.npmjs.org/@dfeidao/fd-an000047/-/fd-an000047-4.6.201909261826.tgz","fileCount":6,"unpackedSize":26967,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJdjJJuCRA9TVsSAnZWagAACrcP/3uif5h1cvxZwye+sArq\n5xY777nYBqKipNSzZLTy7ED6MVGNZiW9rWBiUDzjwUfgNLYs1OadU/rwFKtP\ntfj+hlqPMzsyP5e8Ni6eaXz7b9AIUuJOlsbq4/qY/3makjT62ZOmWBzgaH1/\nPytMPp+M2erwGxbKyH9yEqBio8F3KlHpYn6HGYcp+eIfwN/vMFbqP5HrHAl2\nPtu87Tdn2UF/kCGHCWcnMg5cM3ayqpFKeP1Omqojz5tOPhUa9Hq5bkQ0cUh8\nxyp+oGMhfer/fMtk4zg9vgyKCMN+RTXRZuojeLGVsP+/9gyU/IU3KseYkGkx\nSqS0TtdYaoNh+uaE7vXTJCAle6iijvxZDZYGmEY8uzjX/9XHY1voJYcNxfYt\nLVZ9Q6/3m6Co4WYp67TNCZFqo5219grdblbXFiSLjaJRt3TwekNUYTk993CK\nlv5hHvTeeGoezh7lIeExW2YEY4HufLgwr0Lvf38Nwb/B4WIYMrV86vrIU0Ld\nq1jkeQx3RhymeKZD3+pzNTE/3JyO9qh8QM0BkSWap5UTiYXrshGSelDqZb5b\n7YySFTRFct44DqMFMVq5IrKIkrICJVLPDQQmJepJQczrmoLvVA5UBgQ24Tdq\nstgqWPYvU+8vX7BI0U3ad1qx8OLgPAvQAb2Mh+J/KhbBwsV2PkV5fcIOhk4y\n70eU\r\n=duPK\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIHMttygMqZvyuCSmRmg7eFyp+QiGrjM+NE4KfdVkFYRgAiEA9Xth3X32lO0p1zk7YfGE6qb7N9nfMfcubHihW76vQR4="}]},"_npmUser":{"name":"taoqf","email":"tao_qiufeng@126.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/fd-an000047_4.6.201909261826_1569493613589_0.8512028249225181"},"_hasShrinkwrap":false},"4.6.201909271338":{"name":"@dfeidao/fd-an000047","version":"4.6.201909271338","description":"复杂查询","scripts":{"test":"../../node_modules/.bin/tsc -w & ../../node_modules/.bin/ava --watch ./test.js","lint":"../../node_modules/.bin/tslint -p tsconfig.json","compile":"../../node_modules/.bin/tsc","build":"npm run lint && npm run compile"},"repository":{"type":"git","url":"https://gitee.com/dfeidao/atom-nodejs"},"keywords":["feidao","01feidao","dfeidao","atom","飞道","原子操作","ai"],"author":{"name":"taoqf","email":"tao_qiufeng@126.com","url":"http://www.01feidao.com/"},"contributors":[{"name":"taoqf","email":"tao_qiufeng@126.com","url":"http://www.01feidao.com/"}],"maintainers":[{"name":"taoqf","email":"tao_qiufeng@126.com"}],"license":"MIT","peerDependencies":{"@dfeidao/send-msg":"*"},"devDependencies":{"@dfeidao/send-msg":"latest"},"_id":"@dfeidao/fd-an000047@4.6.201909271338","_nodeVersion":"12.10.0","_npmVersion":"6.10.3","dist":{"integrity":"sha512-x5vJT9ogknavVadIFODNlUx3rtJNW2v0mFXPijU+ZU6MUpavIS15FcA4wEqMwEgLrOnHoikphTJ5/bPH8w+ucw==","shasum":"46bbd0ee4cee897fe9fafc755b81b5be23637bb8","tarball":"https://registry.npmjs.org/@dfeidao/fd-an000047/-/fd-an000047-4.6.201909271338.tgz","fileCount":6,"unpackedSize":26819,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJdjaBACRA9TVsSAnZWagAAgrsP+wU2a8l/zb9OQbDBZv92\n9B1ulKQvSw5OmJ7rmg3x/stJakrhcGoWKMMQZYPTGh7MsgggsWI+WaS0P/Bd\nKsjoIcZDIdJCEItZa+ywA7BbOlIRFdJg9bZxkKth+1ZwLT5AoB0K8hGPepEP\n1/T5M/d3bzrOSlzXBh/kgLM1E2B3dkU4LEG+yO5EdRoyIvAs3rO8iYMXzrPq\nOOKYNIKVmiq0DIPA3GHDFk6TjsIQ36blu6ZAPOjPWb50jBdj5a8ozeTeY7Jm\nZsfF7oPmGqa66kLFZUM2iRg+L03Qn7dhXRSOdbGVaB68XAfZG4BUm/vP0avj\nCeceUMxos7NoYtTMKQ5Xp+A6HBhS2w0QszE7vFm8aJPGc/KOmm9RRr6u82Xn\nxeZF5s5P0U2jDTeAaLm8LC4ZU9jIvrDKZk3OK4dye3gMH/34Thx4UkVTWqge\nFo/NG27OlFBk/x/zaupH03u6DxtDrVkPRLnbjn0QSGKLIFeM9YlyAyuSGBfG\nQP7pbb2EniHH6g0fDHIOoSzpN8UWj7/wN7koJp2pAoxOWKaqfOJU4CE/Y5RI\nWOJQ9DYbXsNIMhHpFSXkZ42GbRxKRCpVxTjneYvdA9xYFUYNDIUOx3F0jhJh\nbqrb8/tEyJRx8nNae1eiJ3/NJI7MEb+HJ7p9VJQekW/joqv/Fvc6tmFfH7d/\nU41f\r\n=ApLA\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQDkivXgCunDdLFsYevEpP6iQgBXQXA79S5UT0P4JapWwQIgdG/U+jAPNf3IwMl2DwHA+mmenhWebtKSUxQ+wzFlec8="}]},"_npmUser":{"name":"taoqf","email":"tao_qiufeng@126.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/fd-an000047_4.6.201909271338_1569562687578_0.17217659344571912"},"_hasShrinkwrap":false},"4.6.201910111019":{"name":"@dfeidao/fd-an000047","version":"4.6.201910111019","description":"复杂查询","scripts":{"test":"../../node_modules/.bin/tsc -w & ../../node_modules/.bin/ava --watch ./test.js","lint":"../../node_modules/.bin/tslint -p tsconfig.json","compile":"../../node_modules/.bin/tsc","build":"npm run lint && npm run compile"},"repository":{"type":"git","url":"https://gitee.com/dfeidao/atom-nodejs"},"keywords":["feidao","01feidao","dfeidao","atom","飞道","原子操作","ai"],"author":{"name":"taoqf","email":"tao_qiufeng@126.com","url":"http://www.01feidao.com/"},"contributors":[{"name":"taoqf","email":"tao_qiufeng@126.com","url":"http://www.01feidao.com/"}],"maintainers":[{"name":"taoqf","email":"tao_qiufeng@126.com"}],"license":"MIT","peerDependencies":{"@dfeidao/send-msg":"*"},"devDependencies":{"@dfeidao/send-msg":"latest"},"_id":"@dfeidao/fd-an000047@4.6.201910111019","_nodeVersion":"12.11.1","_npmVersion":"6.11.3","dist":{"integrity":"sha512-9H7o+B8BdlkkMNlBwNR+ef6uA+TFHVs1mxPzIQpxDcqMnn6JB01e62GOc7SyWHqtz57iNPmO967/Xl6IxoVWvg==","shasum":"342c3af3157f018911f66487e70dea57fd73df21","tarball":"https://registry.npmjs.org/@dfeidao/fd-an000047/-/fd-an000047-4.6.201910111019.tgz","fileCount":6,"unpackedSize":26819,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJdn+bRCRA9TVsSAnZWagAAOQwP/jgdi9SLqGWGlM2Ej35D\nitrSn0Q3uZdvWp60CQlRpX08WeKLBzJclh1o7Z7rZMez7/rSgZ2NaaRA73h5\neFlPKwWgOqvUSBwzS2q50xfwgwcvcp0z52Di4LpDObMRGIz33lbBzZrQrNlw\nsVNBq/15aF4KZbjLDbG5eLOaj0+RXfxoOiH4dK77/Drsnml9xnL5eURdSYh5\nDpfEuWMk5+VxDxioK/rid7I0I5ya31zfOMsHNjrpDnko98bSZGfU1E3b3RRb\n0ylZWrpkJqhh/eyqqDX8jsPUq/CXSkJzI2Wl19feYEl9zBfJ0ADrlGyA8mL1\nBhznGJ7uIcqlm6mOp9ye9zDf3xotoX9J38GPAs2GaF5f19gHzuceqP7W9kZW\nU4zHgWL0Hyoe0pIQsaKWEkn6kU/3LUCqkwTGcPBJ08ZZ5aqKedwyg5v27j5p\nKClCAeUevNQhzE/6Zu4vF27H3TqCR4Z0BBM13GIRYGi+a1sAwL+OKMnvBM92\njQI2kcH/kLCy3eWmxnD0IZJDgAgC4hUoWIoW1HYXBg63uxqh+GFMDCpNnn1z\nUMIm5Si7EW/xdz1oBuCpNEUsZaB8bWSdxqUMGq5zevUe+omhchUmJakvCpZC\nGbV/sxsllKV3cv59j5Oh8D+zhIGuv3hxRQ6nFpD6G2SLJ2OEWgfOO4Uq6EZt\n6ZO6\r\n=iX2J\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIEjZwF0InPhBOKioX9piXQGpiql5b78MkxweqxaLSKVVAiAC5ZCl/Lka1CkLm5YFz/UKW7Gqi46NKIUv9Yfx6gzkwQ=="}]},"_npmUser":{"name":"taoqf","email":"tao_qiufeng@126.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/fd-an000047_4.6.201910111019_1570760400411_0.9368315695705132"},"_hasShrinkwrap":false}},"time":{"created":"2019-09-18T03:36:46.885Z","4.6.201909181136":"2019-09-18T03:36:47.253Z","modified":"2022-04-05T04:15:42.722Z","4.6.201909181225":"2019-09-18T04:25:42.189Z","4.6.201909261826":"2019-09-26T10:26:53.794Z","4.6.201909271338":"2019-09-27T05:38:07.740Z","4.6.201910111019":"2019-10-11T02:20:00.555Z"},"maintainers":[{"name":"taoqf","email":"tao_qiufeng@126.com"}],"description":"复杂查询","keywords":["feidao","01feidao","dfeidao","atom","飞道","原子操作","ai"],"repository":{"type":"git","url":"https://gitee.com/dfeidao/atom-nodejs"},"contributors":[{"name":"taoqf","email":"tao_qiufeng@126.com","url":"http://www.01feidao.com/"}],"author":{"name":"taoqf","email":"tao_qiufeng@126.com","url":"http://www.01feidao.com/"},"license":"MIT","readme":"# 复杂查询\n\n## Installation\n\n```sh\nyarn add --dev @dfeidao/fd-an000047\n```\n\n## Example\n\n```ts\nimport an47 from '@dfeidao/fd-an000047';\n\nconst ran47 = an47(headers, 'systemid');\nconst res = await ran47\n\t// 添加字段\n\t.add_field('commodity', 'commodity_name', 'commodity_name')\n\t// 数量\n\t.add_fun('commodity', 'type_no', 'type_no', 'count')\n\t// 最大值\n\t.add_fun('commodity_price_elements', 'retail_price_value', 'retail_price_value', 'max')\n\t// 分组\n\t.groupby('commodity', 'type_no')\n\t// 不为空\n\t.where_not_null('commodity_price_elements', 'commodityid')\n\t// 模糊查询\n\t.where_like('commodity', 'type_no', '%005%')\n\t// 表1值与表2值相等\n\t.where_eq_tb('commodity_parameter', 'commodityid', 'commodity_price_elements', 'commodityid')\n\t// 表1值与表2值不等\n\t.where_neq_tb('commodity_parameter', 'commodityid', 'commodity_price_elements', 'commodityid')\n\t// 等\n\t.where_eq('commodity', 'type_no', 'TP000005')\n\t// 不等\n\t.where_neq('commodity', 'type_no', 'TP000005')\n\t// 大于\n\t.where_gt('commodity_price_elements', 'retail_price_value', 50)\n\t// 大于等于\n\t.where_gte('commodity_price_elements', 'retail_price_value', 50)\n\t// 小于\n\t.where_lt('commodity_price_elements', 'retail_price_value', 50)\n\t// 小于等于\n\t.where_lte('commodity_price_elements', 'retail_price_value', 50)\n\t// 表1值大于表2\n\t.where_gt_tb('commodity_price_elements', 'retail_price_value', 50)\n\t// 表1值大于等于表2\n\t.where_gte_tb('sales_changebill_stockin', 'price_difference', 'purchase_payable', 'payment')\n\t// 表1值小于表2\n\t.where_lt_tb('commodity_price_elements', 'retail_price_value', 50)\n\t// 表1值小于等于表2\n\t.where_lte_tb('sales_changebill_stockin', 'price_difference', 'purchase_payable', 'payment')\n\t// 内连接\n\t.inner_join('commodity', 'commodity_parameter', ['commodityid', 'commodityid'])\n\t// 左外链接\n\t.outer_left_join('commodity_parameter', 'commodity_price_elements', ['commodityid', 'commodityid'])\n\t// 右外链接\n\t.outer_right_join('commodity_parameter', 'commodity_price_elements', ['commodityid', 'commodityid'])\n\t// 分页\n\t.page(10, 1)\n\t// 结束\n\t.exec();\n```\n","readmeFilename":"readme.md"}