Code Duplication - chamilo/chamilo-lms - Measure and Improve Code Quality continuously with Scrutinizer

Code Duplication Length = 42-42 lines in 3 locations

main/inc/lib/api.lib.php 3 locations


    $set_type = '';

    switch ($lastEditTypeNoFilter) {
        case 'delete':
            // delete = make item only visible for the platform admin.
            $visibility = '2';
            if (!empty($session_id)) {
                // Check whether session id already exist into item_properties for updating visibility or add it.
                $sql = "SELECT session_id FROM $tableItemProperty
                        WHERE
                            c_id = $course_id AND
                            tool = '$tool' AND
                            ref = $item_id AND
                            session_id = $session_id";
                $rs = Database::query($sql);
                if (Database::num_rows($rs) > 0) {
                    $sql = "UPDATE $tableItemProperty
                            SET lastedit_type       = '".str_replace('_', '', ucwords($tool))."Deleted',
                                lastedit_date       = '$time',
                                lastedit_user_id    = $user_id,
                                visibility          = $visibility,
                                session_id          = $session_id $set_type
                            WHERE $filter";
                    $result = Database::query($sql);
                } else {
                    $sql = "INSERT INTO $tableItemProperty (c_id, tool, ref, insert_date, insert_user_id, lastedit_date, lastedit_type, lastedit_user_id, $to_field, visibility, start_visible, end_visible, session_id)
                            VALUES ($course_id, '$tool',$item_id, '$time', $user_id, '$time', '$last_edit_type',$user_id, $toValueCondition, $visibility, $startVisible, $endVisible, $session_id)";
                    $result = Database::query($sql);
                    $id = Database::insert_id();
                    if ($id) {
                        $sql = "UPDATE $tableItemProperty SET id = iid WHERE iid = $id";
                        Database::query($sql);
                    }
                }
            } else {
                $sql = "UPDATE $tableItemProperty
                        SET
                            lastedit_type='".str_replace('_', '', ucwords($tool))."Deleted',
                            lastedit_date='$time',
                            lastedit_user_id = $user_id,
                            visibility = $visibility $set_type
                        WHERE $filter";
                $result = Database::query($sql);
            }
            break;
        case 'visible' : // Change item to visible.
            $visibility = '1';
            if (!empty($session_id)) {

                $result = Database::query($sql);
            }
            break;
        case 'visible' : // Change item to visible.
            $visibility = '1';
            if (!empty($session_id)) {
                // Check whether session id already exist into item_properties for updating visibility or add it.
                $sql = "SELECT session_id FROM $tableItemProperty
                        WHERE
                            c_id = $course_id AND
                            tool = '$tool' AND
                            ref = $item_id AND
                            session_id = $session_id";
                $rs = Database::query($sql);
                if (Database::num_rows($rs) > 0) {
                    $sql = "UPDATE $tableItemProperty
                            SET
                                lastedit_type='".str_replace('_', '', ucwords($tool))."Visible',
                                lastedit_date='$time',
                                lastedit_user_id = $user_id,
                                visibility = $visibility,
                                session_id = $session_id $set_type
                            WHERE $filter";
                    $result = Database::query($sql);
                } else {
                    $sql = "INSERT INTO $tableItemProperty (c_id, tool, ref, insert_date, insert_user_id, lastedit_date, lastedit_type, lastedit_user_id, $to_field, visibility, start_visible, end_visible, session_id)
                            VALUES ($course_id, '$tool', $item_id, '$time', $user_id, '$time', '$last_edit_type', $user_id, $toValueCondition, $visibility, $startVisible, $endVisible, $session_id)";
                    $result = Database::query($sql);
                    $id = Database::insert_id();
                    if ($id) {
                        $sql = "UPDATE $tableItemProperty SET id = iid WHERE iid = $id";
                        Database::query($sql);
                    }
                }
            } else {
                $sql = "UPDATE $tableItemProperty
                        SET
                            lastedit_type='".str_replace('_', '', ucwords($tool))."Visible',
                            lastedit_date='$time',
                            lastedit_user_id = $user_id,
                            visibility = $visibility $set_type
                        WHERE $filter";
                $result = Database::query($sql);
            }
            break;
        case 'invisible' : // Change item to invisible.
            $visibility = '0';
            if (!empty($session_id)) {

                $result = Database::query($sql);
            }
            break;
        case 'invisible' : // Change item to invisible.
            $visibility = '0';
            if (!empty($session_id)) {
                // Check whether session id already exist into item_properties for updating visibility or add it
                $sql = "SELECT session_id FROM $tableItemProperty
                        WHERE
                            c_id = $course_id AND
                            tool = '$tool' AND
                            ref = $item_id AND
                            session_id = $session_id";
                $rs = Database::query($sql);
                if (Database::num_rows($rs) > 0) {
                    $sql = "UPDATE $tableItemProperty
                            SET
                                lastedit_type = '".str_replace('_', '', ucwords($tool))."Invisible',
                                lastedit_date = '$time',
                                lastedit_user_id = $user_id,
                                visibility = $visibility,
                                session_id = $session_id $set_type
                            WHERE $filter";
                    $result = Database::query($sql);
                } else {
                    $sql = "INSERT INTO $tableItemProperty (c_id, tool, ref, insert_date, insert_user_id, lastedit_date, lastedit_type, lastedit_user_id,$to_field, visibility, start_visible, end_visible, session_id)
                            VALUES ($course_id, '$tool', $item_id, '$time', $user_id, '$time', '$last_edit_type', $user_id, $toValueCondition, $visibility, $startVisible, $endVisible, $session_id)";
                    $result = Database::query($sql);
                    $id = Database::insert_id();
                    if ($id) {
                        $sql = "UPDATE $tableItemProperty SET id = iid WHERE iid = $id";
                        Database::query($sql);
                    }
                }
            } else {
                $sql = "UPDATE $tableItemProperty
                        SET
                            lastedit_type = '".str_replace('_', '', ucwords($tool))."Invisible',
                            lastedit_date = '$time',
                            lastedit_user_id = $user_id,
                            visibility = $visibility $set_type
                        WHERE $filter";
                $result = Database::query($sql);
            }
            break;
        default: // The item will be added or updated.
            $set_type = ", lastedit_type = '$last_edit_type' ";
            $visibility = '1';

		@@ 3616-3657 (lines=42) @@
3613		$set_type = '';
3614
3615		switch ($lastEditTypeNoFilter) {
3616		case 'delete':
3617		// delete = make item only visible for the platform admin.
3618		$visibility = '2';
3619		if (!empty($session_id)) {
3620		// Check whether session id already exist into item_properties for updating visibility or add it.
3621		$sql = "SELECT session_id FROM $tableItemProperty
3622		WHERE
3623		c_id = $course_id AND
3624		tool = '$tool' AND
3625		ref = $item_id AND
3626		session_id = $session_id";
3627		$rs = Database::query($sql);
3628		if (Database::num_rows($rs) > 0) {
3629		$sql = "UPDATE $tableItemProperty
3630		SET lastedit_type = '".str_replace('_', '', ucwords($tool))."Deleted',
3631		lastedit_date = '$time',
3632		lastedit_user_id = $user_id,
3633		visibility = $visibility,
3634		session_id = $session_id $set_type
3635		WHERE $filter";
3636		$result = Database::query($sql);
3637		} else {
3638		$sql = "INSERT INTO $tableItemProperty (c_id, tool, ref, insert_date, insert_user_id, lastedit_date, lastedit_type, lastedit_user_id, $to_field, visibility, start_visible, end_visible, session_id)
3639		VALUES ($course_id, '$tool',$item_id, '$time', $user_id, '$time', '$last_edit_type',$user_id, $toValueCondition, $visibility, $startVisible, $endVisible, $session_id)";
3640		$result = Database::query($sql);
3641		$id = Database::insert_id();
3642		if ($id) {
3643		$sql = "UPDATE $tableItemProperty SET id = iid WHERE iid = $id";
3644		Database::query($sql);
3645		}
3646		}
3647		} else {
3648		$sql = "UPDATE $tableItemProperty
3649		SET
3650		lastedit_type='".str_replace('_', '', ucwords($tool))."Deleted',
3651		lastedit_date='$time',
3652		lastedit_user_id = $user_id,
3653		visibility = $visibility $set_type
3654		WHERE $filter";
3655		$result = Database::query($sql);
3656		}
3657		break;
3658		case 'visible' : // Change item to visible.
3659		$visibility = '1';
3660		if (!empty($session_id)) {
		@@ 3658-3699 (lines=42) @@
3655		$result = Database::query($sql);
3656		}
3657		break;
3658		case 'visible' : // Change item to visible.
3659		$visibility = '1';
3660		if (!empty($session_id)) {
3661		// Check whether session id already exist into item_properties for updating visibility or add it.
3662		$sql = "SELECT session_id FROM $tableItemProperty
3663		WHERE
3664		c_id = $course_id AND
3665		tool = '$tool' AND
3666		ref = $item_id AND
3667		session_id = $session_id";
3668		$rs = Database::query($sql);
3669		if (Database::num_rows($rs) > 0) {
3670		$sql = "UPDATE $tableItemProperty
3671		SET
3672		lastedit_type='".str_replace('_', '', ucwords($tool))."Visible',
3673		lastedit_date='$time',
3674		lastedit_user_id = $user_id,
3675		visibility = $visibility,
3676		session_id = $session_id $set_type
3677		WHERE $filter";
3678		$result = Database::query($sql);
3679		} else {
3680		$sql = "INSERT INTO $tableItemProperty (c_id, tool, ref, insert_date, insert_user_id, lastedit_date, lastedit_type, lastedit_user_id, $to_field, visibility, start_visible, end_visible, session_id)
3681		VALUES ($course_id, '$tool', $item_id, '$time', $user_id, '$time', '$last_edit_type', $user_id, $toValueCondition, $visibility, $startVisible, $endVisible, $session_id)";
3682		$result = Database::query($sql);
3683		$id = Database::insert_id();
3684		if ($id) {
3685		$sql = "UPDATE $tableItemProperty SET id = iid WHERE iid = $id";
3686		Database::query($sql);
3687		}
3688		}
3689		} else {
3690		$sql = "UPDATE $tableItemProperty
3691		SET
3692		lastedit_type='".str_replace('_', '', ucwords($tool))."Visible',
3693		lastedit_date='$time',
3694		lastedit_user_id = $user_id,
3695		visibility = $visibility $set_type
3696		WHERE $filter";
3697		$result = Database::query($sql);
3698		}
3699		break;
3700		case 'invisible' : // Change item to invisible.
3701		$visibility = '0';
3702		if (!empty($session_id)) {
		@@ 3700-3741 (lines=42) @@
3697		$result = Database::query($sql);
3698		}
3699		break;
3700		case 'invisible' : // Change item to invisible.
3701		$visibility = '0';
3702		if (!empty($session_id)) {
3703		// Check whether session id already exist into item_properties for updating visibility or add it
3704		$sql = "SELECT session_id FROM $tableItemProperty
3705		WHERE
3706		c_id = $course_id AND
3707		tool = '$tool' AND
3708		ref = $item_id AND
3709		session_id = $session_id";
3710		$rs = Database::query($sql);
3711		if (Database::num_rows($rs) > 0) {
3712		$sql = "UPDATE $tableItemProperty
3713		SET
3714		lastedit_type = '".str_replace('_', '', ucwords($tool))."Invisible',
3715		lastedit_date = '$time',
3716		lastedit_user_id = $user_id,
3717		visibility = $visibility,
3718		session_id = $session_id $set_type
3719		WHERE $filter";
3720		$result = Database::query($sql);
3721		} else {
3722		$sql = "INSERT INTO $tableItemProperty (c_id, tool, ref, insert_date, insert_user_id, lastedit_date, lastedit_type, lastedit_user_id,$to_field, visibility, start_visible, end_visible, session_id)
3723		VALUES ($course_id, '$tool', $item_id, '$time', $user_id, '$time', '$last_edit_type', $user_id, $toValueCondition, $visibility, $startVisible, $endVisible, $session_id)";
3724		$result = Database::query($sql);
3725		$id = Database::insert_id();
3726		if ($id) {
3727		$sql = "UPDATE $tableItemProperty SET id = iid WHERE iid = $id";
3728		Database::query($sql);
3729		}
3730		}
3731		} else {
3732		$sql = "UPDATE $tableItemProperty
3733		SET
3734		lastedit_type = '".str_replace('_', '', ucwords($tool))."Invisible',
3735		lastedit_date = '$time',
3736		lastedit_user_id = $user_id,
3737		visibility = $visibility $set_type
3738		WHERE $filter";
3739		$result = Database::query($sql);
3740		}
3741		break;
3742		default: // The item will be added or updated.
3743		$set_type = ", lastedit_type = '$last_edit_type' ";
3744		$visibility = '1';

chamilo / chamilo-lms

Code Duplication Length = 42-42 lines in 3 locations

main/inc/lib/api.lib.php 3 locations