Subversion Repositories SmartDukaan

                                             @RequestParam(name = "email", defaultValue = "") String email,

                                             @RequestParam(name = "position", defaultValue = "") String position,

        // Position control: place the new/edited contact within its section. A NEW contact defaults

        // to the bottom; an EDIT keeps its place unless the editor explicitly chose a new position.

        String pos = (position == null || position.trim().isEmpty())

                ? (id > 0 ? "KEEP" : "BOTTOM")

                : position.trim().toUpperCase();

        if (!"KEEP".equals(pos)) {

            repositionInSection(section, contact.getId(), pos, afterId);

        }

    @RequestMapping(value = "/contactUs/reorder", method = RequestMethod.POST)

    @ResponseBody

    public Map<String, Object> reorderContactUs(HttpServletRequest request,

                                                @RequestParam(name = "id") int id,

                                                @RequestParam(name = "direction") String direction) throws Exception {

        Map<String, Object> response = new HashMap<>();

        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);

        if (!isContactUsEditor(loginDetails)) {

            response.put("success", false);

            response.put("message", "You are not authorised to edit contacts.");

            return response;

        }

        ContactUs contact = contactUsRepository.selectById(id);

        if (contact == null || !contact.isActive()) {

            response.put("success", false);

            response.put("message", "Contact not found.");

            return response;

        }

        boolean up = "UP".equalsIgnoreCase(direction);

        List<ContactUs> list = contactUsRepository.findActiveBySection(contact.getSection());

        int idx = indexOfContact(list, id);

        int target = up ? idx - 1 : idx + 1;

        if (idx < 0 || target < 0 || target >= list.size()) {

            // Already at the top/bottom edge - nothing to move.

            response.put("success", true);

            return response;

        }

        ContactUs tmp = list.get(idx);

        list.set(idx, list.get(target));

        list.set(target, tmp);

        renumberSequential(list);

        response.put("success", true);

        return response;

    }

    /**

     * Places {@code contactId} within its section per {@code position} (TOP | BOTTOM | AFTER) and

     * renumbers the whole section's sort_order to a clean 10, 20, 30 … sequence, so ordering is

     * always gap-free and deterministic. {@code afterId} is only consulted for AFTER.

     */

    private void repositionInSection(String section, int contactId, String position, int afterId) {

        List<ContactUs> list = contactUsRepository.findActiveBySection(section);

        int movingIdx = indexOfContact(list, contactId);

        if (movingIdx < 0) {

            return; // not found (should not happen immediately after persist)

        }

        ContactUs moving = list.remove(movingIdx);

        int index;

        if ("TOP".equals(position)) {

            index = 0;

        } else if ("AFTER".equals(position)) {

            int anchorIdx = indexOfContact(list, afterId);

            index = (anchorIdx >= 0) ? anchorIdx + 1 : list.size();

        } else { // BOTTOM

            index = list.size();

        }

        list.add(index, moving);

        renumberSequential(list);

    }

    /** Assigns sort_order 10, 20, 30 … in list order, persisting only rows whose order changed. */

    private void renumberSequential(List<ContactUs> orderedContacts) {

        for (int i = 0; i < orderedContacts.size(); i++) {

            ContactUs c = orderedContacts.get(i);

            int newOrder = (i + 1) * 10;

            if (c.getSortOrder() != newOrder) {

                c.setSortOrder(newOrder);

                contactUsRepository.persist(c);

            }

        }

    }

    private int indexOfContact(List<ContactUs> list, int id) {

        for (int i = 0; i < list.size(); i++) {

            if (list.get(i).getId() == id) {

                return i;

            }

        }

        return -1;

    }