cakephp保存拖放列表顺序到数据库

2j4z5cfb  于 2022-11-11  发布在  PHP
关注(0)|答案(1)|浏览(130)

我有一个列表，我想让用户对列表重新排序。对于前端功能，我使用了UIkit。列表可以在前端向上重新排序，但我很难弄清楚如何将列表顺序保存到数据库中。在表中，有一个“排序”行。因此，我尝试根据用户对列表的排序方式更新排序行。
我尝试通过ID获取项目的顺序，然后使用 AJAX 将数据发送到控制器。现在，当我重新排序列表时，响应是200 Ok，有效负载显示项目ID和用户设置的ID顺序。我不知道如何使用这些数据更新数据库。我在想我可以循环遍历id并将“sort”设置为循环的索引，但我不确定如何在CakePHP中完成此操作。
我确定的另一件事是我是否应该使用已经定义的list方法，或者我是否应该创建一个新方法来处理这个功能。
任何帮助都将不胜感激。这是我目前所拥有的。
列表页面Jquery代码：

UIkit.util.on('.uk-sortable', 'stop', function (item) {
    let ids = ""
    $('.uk-sortable tr').each(function() {
        id = $(this).attr('id'); //this is the project id
        if(ids =='') {
            ids = id;
        }else {
            ids = ids + ', '+id ;
        }
    });
    console.log($(this).data('id'));
    $.ajax({
        url:'admin/cost/list',
        type: 'POST',
        dataType: 'json',
        data: {
            'id': $(this).data('id'),
            'ids':'ids='+ids, 
        },
        success:function() {
          UIkit.notification(`sent successfully`, 'success');
        }

    });

}）;
控制器：

public function list($project_id = null)
{
    // ----------------------------------------
    // 初期処理
    // ----------------------------------------
    $now = Chronos::now();

    // ----------------------------------------
    // 検索フォーム設定
    // ----------------------------------------
    $form = new ListForm();

    if (!$project_id) {
        // 施工管理トップの表示
        return $this->redirect(['prefix' => 'Admin', 'controller' => 'Build', 'action' => 'list']);
    }

    try {
        // ----------------------------------------
        // モデル設定
        // ----------------------------------------
        $this->loadModel('Projects');
        $this->loadModel('Costs');
        $this->loadModel('CostUpdates');
        $this->loadModel('Pays');
        $this->loadModel('PayDetails');
        $this->loadModel('Specs');

        //my code so far
        if ($this->request->is('ajax')) {
            $id = $this->request->getQuery('id');//project id
            $ids = $this->request->getQuery('ids');//items ids, ordered by user
            //this is the query to select the items I need to update
            $q_update = $this->Specs->find();
            $q_upddate->where([
                'Specs.project_id' => $project_id,
                'Specs.publish' => Configure::read('CST_APP.MST_FLAG.PUBLISH.OPENED'),
                'Specs.status' => Configure::read('CST_APP.MST_FLAG.STATUS.CLOSED'),
                'Specs.mng_kbn1' => Configure::read('CST_APP.MST_FLAG.COST_TYPE.NORMAL'),
                'Specs.price1 IS NOT' => NULL,
            ]);
            // get separate ids
            $arr = explode(',',$ids);
            //loop and update sort by the index?
            for($i=1;$i<=count($arr);$i++)
            {
               How to update the database in the loop
            }

        }
        // ----------------------------------------
        // プロジェクト情報取得
        // ----------------------------------------
        $query_project = $this->Projects->find();
        $query_project->contain(['Users']);
        $query_project->where([
                'Projects.project_id' => $project_id,
                'Projects.status' => Configure::read('CST_APP.MST_FLAG.STATUS_KBN.VALID'),
                'Users.status' => Configure::read('CST_APP.MST_FLAG.STATUS_KBN.VALID')
        ]);
        $project = $query_project->first();

        // ----------------------------------------
        // 施工費用データ取得
        // ----------------------------------------
        $query = $this->Costs->find();
        $query->where([
                'Costs.project_id' => $project_id
        ]);
        $cost = $query->first();

        // ----------------------------------------
        // お支払いデータ取得
        // ----------------------------------------
        $q_pay = $this->Pays->find();
        $q_pay->where([
            'Pays.project_id' => $project_id
        ]);
        $pay = $q_pay->first();

        // ----------------------------------------
        // 施工費用支払新規登録
        // ----------------------------------------
        if(!$pay){

            // トランザクション開始
            $connection = ConnectionManager::get('default');
            $connection->begin();

            // 新規データの作成
            $pay_new = $this->Pays->newEmptyEntity();

            // ----------------------------------------
            // 施工費用支払データの設定
            // ----------------------------------------
            $data['user_id'] = $project->user_id;
            $data['project_id'] = $project->project_id;
            //$data['cost'] = $cost->etc_cost3;

            $data['sort'] = 1;
            $data['status'] = Configure::read('CST_APP.MST_FLAG.STATUS_KBN.VALID');

            // 更新日時関連
            $data['created_at'] = $now;
            $data['created_by'] = $this->loginUserInfo['admin_id'];

            // ----------------------------------------
            // データの登録＆更新
            // ----------------------------------------
            $this->Pays->patchEntity($pay_new, $data);
            $this->Pays->saveOrFail($pay_new);

            // トランザクションコミット
            $connection->commit();

        }

        // ----------------------------------------
        // 変更費用データ取得
        // ----------------------------------------
        $q_upd = $this->CostUpdates->find();
        $q_upd->where([
                'CostUpdates.project_id' => $project_id
        ]);
        $q_upd->order(['CostUpdates.cost_update_id' => 'ASC']);

        // ----------------------------------------
        // 契約金額内訳データ取得
        // ----------------------------------------
        $q_cost_detail = $this->Specs->find();
        $q_cost_detail->where([
                'Specs.project_id' => $project_id,
                'Specs.publish' => Configure::read('CST_APP.MST_FLAG.PUBLISH.OPENED'),
                'Specs.mng_kbn1' => Configure::read('CST_APP.MST_FLAG.COST_TYPE.PLAN'),
                'Specs.price1 IS NOT' => NULL,
        ]);
        $q_cost_detail->order(['Specs.spec_id' => 'ASC']);
        // ----------------------------------------
        // 変更金額内訳データ取得
        // ----------------------------------------
        $q_upd_detail = $this->Specs->find();
        $q_upd_detail->where([
                'Specs.project_id' => $project_id,
                'Specs.publish' => Configure::read('CST_APP.MST_FLAG.PUBLISH.OPENED'),
                'Specs.status' => Configure::read('CST_APP.MST_FLAG.STATUS.CLOSED'),
                'Specs.mng_kbn1' => Configure::read('CST_APP.MST_FLAG.COST_TYPE.NORMAL'),
                'Specs.price1 IS NOT' => NULL,
        ]);
        $q_upd_detail->order(['Specs.sort' => 'DESC']);

        // ----------------------------------------
        // お支払い内訳データ取得
        // ----------------------------------------
        $q_pay_detail = $this->PayDetails->find();
        $q_pay_detail->where([
            'PayDetails.project_id' => $project_id,
            'PayDetails.sort IS NOT' => NULL
        ]);
        $q_pay_detail->order([
            'PayDetails.limit_date' => 'ASC'
        ]);
        $detail = $q_pay_detail->all();

        $final_pay = 0;
        $detail_total = 0;

        // ----------------------------------------
        // 最終お支払金額計算
        // ----------------------------------------
        if($detail){

            foreach($q_pay_detail as $details){
                $detail_total = $detail_total + $details->payment;
            }
        }

        //最終お支払い金額
        if(!empty($cost->total_cost)){
            $final_pay = $cost->total_cost - $detail_total;
        }

        // ----------------------------------------
        // 最終お支払金額取得
        // ----------------------------------------
        $q_detail_last = $this->PayDetails->find();
        $q_detail_last->where([
            'PayDetails.project_id' => $project_id,
            'PayDetails.sort IS ' => NULL
        ]);
        $q_detail_last->order([
            'PayDetails.limit_date' => 'ASC'
        ]);
        $detail_last = $q_detail_last->first();

        if($detail_last){

            // ----------------------------------------
            // 最終お支払い金額変動時に更新
            // ----------------------------------------
            if($detail_last->payment != $final_pay){

                // トランザクション開始
                $connection = ConnectionManager::get('default');
                $connection->begin();

                $data_p['payment'] = $final_pay;
                $data_p['updated_at'] = $now;
                $data_p['updated_by'] = $this->loginUserInfo['admin_id'];

                // データの登録
                // ----------------------------------------
                $this->PayDetails->patchEntity($detail_last, $data_p);
                $this->PayDetails->saveOrFail($detail_last);

                // トランザクションコミット
                $connection->commit();
            }
        } else {
            // ----------------------------------------
            // 最終お支払い金額登録
            // ----------------------------------------
            // トランザクション開始
            $connection = ConnectionManager::get('default');
            $connection->begin();

            // ----------------------------------------
            // お支払いデータ再取得
            // ----------------------------------------
            $q_pay = $this->Pays->find();
            $q_pay->where([
                'Pays.project_id' => $project_id
            ]);
            $pay = $q_pay->first();

            //新規データの作成
            $detail_new = $this->PayDetails->newEmptyEntity();

            // ----------------------------------------
            // 内訳データの設定
            // ----------------------------------------
            $data_p['pay_id'] = $pay->pay_id;
            $data_p['user_id'] = $project->user_id;
            $data_p['project_id'] = $project->project_id;
            $data_p['pay_name'] = Configure::read('CST_APP.PAY_DETAILS.PAY_NAME.FINAL_PAY');
            $data_p['payment'] = $final_pay;
            $data_p['process_kbn1'] = Configure::read('CST_APP.MST_FLAG.PROCESS_KBN.READY');
            $data_p['process_kbn2'] = Configure::read('CST_APP.MST_FLAG.PROCESS_KBN.READY');
            $data_p['process_kbn3'] = Configure::read('CST_APP.MST_FLAG.PROCESS_KBN.READY');
            $data_p['status'] = Configure::read('CST_APP.MST_FLAG.STATUS.READY');

            $data_p['created_at'] = $now;
            $data_p['created_by'] = $this->loginUserInfo['admin_id'];
            $data_p['updated_at'] = $now;
            $data_p['updated_by'] = $this->loginUserInfo['admin_id'];

            // データの登録
            // ----------------------------------------
            $this->PayDetails->patchEntity($detail_new, $data_p);
            $this->PayDetails->saveOrFail($detail_new);

            // トランザクションコミット
            $connection->commit();
        }

            // ----------------------------------------
            // お支払い内訳表示データ取得
            // ----------------------------------------
            $q_dsp_detail = $this->PayDetails->find();
            $q_dsp_detail->where([
                'PayDetails.project_id' => $project_id,
                //'PayDetails.sort IS NOT ' => NULL
            ]);
            $q_dsp_detail->order([
                'PayDetails.sort IS NULL' => 'ASC',
                'PayDetails.limit_date' => 'ASC'
            ]);

        // ----------------------------------------
        // 画面表示
        // ----------------------------------------
        $this->set('cost', $cost);
        $this->set('cost_upds', $q_upd);
        $this->set('detail_costs', $q_cost_detail);
        $this->set('detail_upds', $q_upd_detail);
        $this->set('pays', $q_dsp_detail);
        $this->set(compact('form', 'project' ));
        // 画面表示
        $this->render('list');

    } catch (Exception $e) {
        throw $e;
    }
}
cakephp

1条答案

按热度按时间
bvn4nwqk

bvn4nwqk1#

我能够解决我的问题。我会把我的解决方案贴出来，谁知道它可能会帮助别人解决问题。Jquery：

UIkit.util.on(".uk-sortable", "stop", function (item) {
  let ids = "";
  $(".uk-sortable tr").each(function () {
    id = $(this).data("id");
if (ids == "") {
  ids = id;
} else {
  ids = ids + ", " + id;
}
   // console.log(ids);
 });
 // console.log($(this).data('id'));
 $.ajax({
url: "/admin/cost/list-update/",
type: "GET",
dataType: "json",
data: {
  ids: "" + ids,
},
timeout: 10000,
 })
.done(function (result) {
  UIkit.notification(`リストの順序が正常に更新されました`, "success");
  //location.reload(true);
})
.fail(function (XMLHttpRequest, textStatus, errorThrown) {
  console.log(textStatus);
  console.log(errorThrown);
 });
});

控制器中的方法

public function listUpdate()
{

    // ----------------------------------------
    // 初期処理
    // ----------------------------------------
    $now = Chronos::now();
    try {
        // ----------------------------------------
        // モデル設定
        // ----------------------------------------
        $this->loadModel('Specs');

        if ($this->request->is('ajax')) {
            // -------------------------------------------
            // リクエストパラメータ取得/ Get request params
            // -------------------------------------------
            $ids = $this->request->getQuery('ids');
            // -------------------------------------------
            // seperate ids/個別のID
            // -------------------------------------------
            $arr = explode(',', $ids);

            for ($i = 1; $i <= count($arr); $i ++) {
                $spec = $this->Specs->find();//get the specs
                $connection = ConnectionManager::get('default');
                $connection->begin();
                //select the spec
                $spec->where([
                    'Specs.spec_id' => $arr[$i - 1],
                ]);
                //update sort column
                $sp = array(
                    'sort' => $i
                );

                //change query to entitiy
                $data = $spec->first();
                //update entity info
                $data['updated_at'] = $now;
                $data['updated_by'] = $this->loginUserInfo['admin_id'];

                $this->Specs->patchEntity($data, $sp);
                $this->Specs->saveOrFail($data);
                $connection->commit();
            }
        }
        $status = true;
        $response = $this->response;
        $response = $response->withType('application/json');
        $response = $response->withStringBody(json_encode(compact('status')));

        return $response;
    } catch (Exception $e) {
        // トランザクションロールバック
        $connection->rollback();

        throw $e;
    }
}
赞(0）分享  回复(0）举报  2022-11-11
我来回答

相关问题

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新问答

    更多
    • 蜀ICP备2022004421号-2 NULL123 https://www.null123.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com