thinkphp:在解决join多表联查的时候，解决关联表默认加上前缀的问题

问题:

由上图看出正确的应该是表so_lines_all，而现在变为了fa_so_line_all,故表不存在

 初始代码:

$data=db::table('wip_jobs_all')
        ->alias('a') //设置wip_jobs_all的别名
        ->join('so_lines_all e', 'a.so_header_number=e.order_number AND a.so_line_number=e.line')
        ->join('so_headers_all b', 'b.order_number=e.order_number')
        ->join('sf_item_no c', 'e.stockid=c.item_no')
        ->field('a.status_type as status_type,a.wip_entity_name as wip_entity_name,a.jiagong_type as jiagong_type,
        e.order_number as order_number,b.customer_order_number as customer_order_number,e.stockid as stockid,c.item_name as item_name,e.uom as uom,
        a.start_quantity as start_quantity,a.quantity_completed as quantity_completed,a.touchan_date as touchan_date,a.creation_date as creation_date,a.output_quantity as output_quantity')
        ->where(
          [
            'a.wip_entity_name' => $wip_entity_name_item[$i]['wip_entity_name'],
          ]
        )
        ->find();

其中join('so_lines_all e', 'a.so_header_number=e.order_number AND a.so_line_number=e.line')

这样的写法表示对表“前缀fa_+表名so_lines_all”进行关联

如果要去掉前缀,则需要将'so_lines_all e'改为['so_lines_all' => 'e']

则更改后的代码为

$data =db::table('wip_jobs_all')
        ->alias('a') //设置wip_jobs_all的别名
        ->join(['so_lines_all' => 'e'], 'a.so_header_number=e.order_number AND a.so_line_number=e.line')
        ->join(['so_headers_all' => 'b'], 'b.order_number=e.order_number')
        ->join(['sf_item_no' => 'c'], 'e.stockid=c.item_no')
        ->field('a.status_type as status_type,a.wip_entity_name as wip_entity_name,a.jiagong_type as jiagong_type,
        e.order_number as order_number,b.customer_order_number as customer_order_number,e.stockid as stockid,c.item_name as item_name,e.uom as uom,
        a.start_quantity as start_quantity,a.quantity_completed as quantity_completed,a.touchan_date as touchan_date,a.creation_date as creation_date,a.output_quantity as output_quantity')
        ->where(
          [
            'a.wip_entity_name' => $wip_entity_name_item[$i]['wip_entity_name'],
          ]
        )
        ->find();